wallet3

Tables (13)

advice_pool

  • id — BIGINT — Primary key — NOT NULL
  • pattern_type — VARCHAR(30) — NOT NULL
  • target — VARCHAR(10) — NOT NULL — CHILD / PARENT
  • content — VARCHAR(300) — NOT NULL

article

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — RSS description 또는 기사 요약
  • original_url — VARCHAR(500) — NOT NULL
  • mission_type — VARCHAR(30) — NOT NULL — FUTURE_NEWS / FAMILY_ASK / FAKE_NEWS / DEBATE / WORD_SORT
  • published_at — DATETIME — NOT NULL
  • collected_at — DATETIME — NOT NULL

article_response

  • id — BIGINT — Primary key — NOT NULL
  • article_id — BIGINT — Foreign key → article.id — NOT NULL
  • child_id — BIGINT — Foreign key → users.id — NOT NULL
  • content — TEXT — 아이가 작성한 독후감 또는 미션 활동 글
  • is_completed — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • completed_at — DATETIME

consumption_report

  • id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → users.id — NOT NULL
  • year_month — VARCHAR(7) — NOT NULL — YYYY-MM
  • pattern_type — VARCHAR(30)
  • total_amount — BIGINT — NOT NULL
  • diff_amount — BIGINT
  • transaction_count — INT — NOT NULL
  • merchant_breakdown — TEXT — 가맹점별 지출 Top5 JSON 문자열
  • generated_at — DATETIME — NOT NULL
  • is_read_parent — BOOLEAN — NOT NULL
  • is_read_child — BOOLEAN — NOT NULL

goal

  • id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → users.id — NOT NULL
  • purpose — VARCHAR(50) — NOT NULL
  • target_amount — BIGINT — NOT NULL
  • current_amount — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — IN_PROGRESS / COMPLETED / CANCELLED
  • created_at — DATETIME — NOT NULL
  • first_deposit_at — DATETIME
  • target_reached_at — DATETIME
  • interest_type — VARCHAR(10) — PERCENT / FIXED
  • interest_value — DECIMAL(10, 2)
  • completed_at — DATETIME
  • interest_status — VARCHAR(10) — PENDING / PAID
  • interest_notified_at — DATETIME
  • interest_paid_at — DATETIME
  • is_favorite — BOOLEAN — NOT NULL

ledger

  • id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.id
  • parent_account_id — BIGINT — Foreign key → parent_account.id
  • amount — BIGINT — NOT NULL
  • direction — VARCHAR(3) — NOT NULL — IN / OUT
  • type — VARCHAR(20) — NOT NULL — PAYMENT / PAYMENT_CANCEL / ALLOWANCE / GOAL_DEPOSIT / GOAL_REFUND / INTEREST_PAID
  • merchant_id — BIGINT — Foreign key → merchant.id
  • goal_id — BIGINT — Foreign key → goal.id
  • original_ledger_id — BIGINT — Foreign key → ledger.id
  • balance_after — BIGINT — NOT NULL
  • created_at — DATETIME — NOT NULL

merchant

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_restricted — BOOLEAN — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • related_type — VARCHAR(20)
  • related_id — BIGINT
  • created_at — DATETIME — NOT NULL

parent_account

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • bank_name — VARCHAR(30)
  • masked_account_number — VARCHAR(30)
  • balance — BIGINT — NOT NULL

parent_feedback

  • id — BIGINT — Primary key — NOT NULL
  • parent_id — BIGINT — Foreign key → users.id — NOT NULL
  • goal_id — BIGINT — Foreign key → goal.id — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL

transaction_attempt_log

  • id — BIGINT — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallet.id
  • parent_account_id — BIGINT — Foreign key → parent_account.id
  • type — VARCHAR(20) — NOT NULL — PAYMENT / ALLOWANCE / GOAL_DEPOSIT / GOAL_REFUND / INTEREST_PAID
  • amount — BIGINT — NOT NULL
  • merchant_id — BIGINT — Foreign key → merchant.id
  • goal_id — BIGINT — Foreign key → goal.id
  • fail_reason_code — VARCHAR(30) — NOT NULL
  • attempted_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • login_type — VARCHAR(10) — NOT NULL — KAKAO / LOCAL
  • social_id — VARCHAR(100) — 카카오 로그인 고유 식별값
  • email — VARCHAR(100) — 로컬 로그인 이메일
  • password — VARCHAR(200) — 암호화된 비밀번호
  • name — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(300)
  • role — VARCHAR(10) — PARENT / CHILD
  • parent_id — BIGINT — Foreign key → users.id — 아이와 연결된 부모 users.id
  • invite_code — VARCHAR(10) — 부모 초대코드
  • status — VARCHAR(10) — NOT NULL — ACTIVE / INACTIVE
  • created_at — DATETIME — NOT NULL

wallet

  • id — BIGINT — Primary key — NOT NULL
  • child_id — BIGINT — Foreign key → users.id — NOT NULL
  • balance — BIGINT — NOT NULL
  • updated_at — DATETIME — NOT NULL