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