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