test
Tables (15)
account
- account_id — BIGINT — Primary key — NOT NULL
- child_id — BIGINT
- parent_id — BIGINT
- account_type — VARCHAR(10) — NOT NULL — PARENT, CHILD
- account_number — VARCHAR(20) — NOT NULL
- available_amt — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
account_cash_histories
- id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- event_type — VARCHAR(20) — NOT NULL — BUY, SELL, GIFT_CASH_OUT, GIFT_CASH_IN
- amount_delta — BIGINT — NOT NULL
- balance_after — BIGINT — NOT NULL
- reference_id — VARCHAR(255)
- reference_type — VARCHAR(20) — GIFT, EXECUTION
- memo — VARCHAR(500)
- occurred_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
account_etf_histories
- id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- event_type — VARCHAR(20) — NOT NULL — BUY, SELL, GIFT_ETF_OUT, GIFT_ETF_IN
- etf_id — BIGINT — NOT NULL
- qty_delta — INT — NOT NULL
- price — BIGINT — NOT NULL
- reference_id — VARCHAR(255)
- reference_type — VARCHAR(20) — GIFT, EXECUTION
- etf_name_snapshot — VARCHAR(100)
- memo — VARCHAR(500)
- occurred_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
account_etf_holdings
- etf_id — BIGINT — Primary key — NOT NULL
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- qty — INT — NOT NULL
- avg_buy_price — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
assistant_goal_name_orders
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — NOT NULL
- goal_id — BIGINT — Foreign key → assistant_goal_names.id — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
assistant_goal_names
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — NOT NULL
- goal_type1 — INT — NOT NULL
- goal_type2 — INT — NOT NULL
- goal_type3 — INT — NOT NULL
- name — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
children
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → parents.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — VARCHAR(10) — NOT NULL — MALE, FEMALE
- birth_order — INT — NOT NULL
- securities_account — VARCHAR(20) — NOT NULL
- profile_image_url — VARCHAR(500)
- customer_segment_code — VARCHAR(50)
- created_via — VARCHAR(20) — NOT NULL — ONBOARDING, MYPAGE
- allowance_linked — TINYINT(1) — NOT NULL
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
email_verification
- email_verification_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(30) — NOT NULL
- verification_code — VARCHAR(6) — NOT NULL
- is_verified — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
execution_goal_links
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — NOT NULL
- child_id — BIGINT
- goal_id — BIGINT
- etf_history_id — BIGINT — Foreign key → account_etf_histories.id — NOT NULL
- qty — INT — NOT NULL
- memo — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- linked_at — DATETIME
gift_contracts
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → parents.id — NOT NULL
- child_id — BIGINT — Foreign key → children.id — NOT NULL
- from_account_id — BIGINT — NOT NULL
- to_account_id — BIGINT — NOT NULL
- external_etf_id — BIGINT
- gift_type — VARCHAR(20) — NOT NULL — ONE_TIME, INSTALLMENT, ETF
- status — VARCHAR(20) — NOT NULL — DRAFT, ACTIVE, COMPLETED, CANCELLED, FAILED
- title — VARCHAR(200)
- qty — INT
- cash_amount — BIGINT — NOT NULL
- transfer_day — INT
- start_date — DATE — NOT NULL
- end_date — DATE
- tax_free_limit_amt — BIGINT — NOT NULL
- discount_rate — DECIMAL(5, 4) — NOT NULL
- valuation_base_date — DATE
- estimated_gift_amount — BIGINT
- final_gift_amount — BIGINT
- cancelled_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
gift_transfers
- id — BIGINT — Primary key — NOT NULL
- gift_contract_id — BIGINT — Foreign key → gift_contracts.id — NOT NULL
- sequence_no — INT — NOT NULL
- scheduled_date — DATE — NOT NULL
- required_cash_amt — BIGINT — NOT NULL
- available_cash_amt — BIGINT — NOT NULL
- required_etf_qty — INT — NOT NULL
- available_etf_qty — INT — NOT NULL
- retry_count — INT — NOT NULL
- check_status — VARCHAR(20) — NOT NULL — UNCHECKED, PASSED, FAILED
- failure_reason — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL — SCHEDULED, COMPLETED, FAILED, CANCELLED, SKIPPED
- transferred_cash_amt — BIGINT — NOT NULL
- transferred_etf_qty — INT — NOT NULL
- completed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
goal_orders
- id — BIGINT — Primary key — NOT NULL
- child_id — BIGINT — NOT NULL
- goal_id — BIGINT — Foreign key → goals.id — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
goals
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → parents.id — NOT NULL
- child_id — BIGINT — Foreign key → children.id — NOT NULL
- goal_type1 — INT — NOT NULL — 1교육 2생활 3결혼 4증여 0직접선택
- goal_type2 — INT
- goal_type3 — INT
- goal_type4 — INT
- level — INT
- name — VARCHAR(100)
- target_amount — BIGINT — NOT NULL
- target_date — DATE — NOT NULL
- achieved_pct — DECIMAL(5, 2) — NOT NULL
- recommended_amount — BIGINT
- recommendation_note — VARCHAR(1000)
- status — VARCHAR(20) — NOT NULL — ACTIVE, CANCELLED, COMPLETED, FAILED
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
parents
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(50) — NOT NULL
- account_number — VARCHAR(20) — NOT NULL
- selected_child_id — BIGINT
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- relation — VARCHAR(10) — NOT NULL
- region — VARCHAR(30) — NOT NULL
- child_count — INT — NOT NULL
- profile_image_url — VARCHAR(500)
- monthly_household_income — INT
- parent_economic_activity — INT
- education_level — INT
- cluster_value — INT
- deleted_at — DATETIME
- cert_file_url — VARCHAR(500) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_agreements
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → parents.id — NOT NULL
- agreement_type — VARCHAR(20) — NOT NULL — terms001/terms002/terms003
- agreed — TINYINT(1) — NOT NULL
- agreed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL