ㅇ

Tables (28)

assistant_goal_types

  • id — UUID — Primary key — NOT NULL
  • session_id — UUID — Foreign key → goal_assistant_sessions.id — NOT NULL — Q1 다중선택 — 행당 1개
  • goal_type — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

cert_verifications

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • status — VARCHAR(10) — NOT NULL — pending|approved|rejected
  • reviewed_by — VARCHAR(100)
  • reviewed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

children

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — VARCHAR(6) — NOT NULL — male|female
  • birth_order — INT — NOT NULL — 몇째
  • securities_account — VARCHAR(20) — NOT NULL — 자녀 증권 계좌번호
  • profile_image_url — VARCHAR(500)
  • created_via — VARCHAR(10) — NOT NULL — onboarding|mypage
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

deleted_parents

  • id — UUID — Primary key — NOT NULL — 삭제된 계정 ID
  • account_number — VARCHAR(20) — NOT NULL — 계좌번호
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL — 삭제일

deposits

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — NOT NULL
  • available_amt — BIGINT — NOT NULL — 사용가능 예수금
  • total_amt — BIGINT — NOT NULL
  • d2_settle_amt — BIGINT — NOT NULL — D+2 결제 후 금액
  • updated_at — TIMESTAMP — NOT NULL

etf_candles_10m

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_1d

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_1m

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_1mo

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_1w

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_30m

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_candles_60m

  • id — BINARY(16) — Primary key — NOT NULL
  • etf_id — BINARY(16) — NOT NULL
  • open_price — BIGINT — NOT NULL
  • high_price — BIGINT — NOT NULL
  • low_price — BIGINT — NOT NULL
  • close_price — BIGINT — NOT NULL
  • volume — BIGINT — NOT NULL
  • candle_time — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

etf_explore_ranks

  • id — UUID — Primary key — NOT NULL
  • etf_id — UUID — Foreign key → etfs.id — NOT NULL
  • age_group — VARCHAR(10) — NOT NULL — 전체|0-2세|3-5세|6-9세|10-13세
  • region — VARCHAR(30) — NOT NULL
  • rank — INT — NOT NULL
  • peer_count — INT — NOT NULL — 또래 보유수
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

etfs

  • id — UUID — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL — 종목코드
  • name — VARCHAR(100) — NOT NULL
  • exchange — VARCHAR(20) — NOT NULL — 상장 거래소
  • nav — BIGINT — NOT NULL — 순자산가치
  • base_index_name — VARCHAR(100) — NOT NULL — 기초지수명
  • price — BIGINT — NOT NULL
  • change_pct — DECIMAL(6, 2) — NOT NULL
  • trading_value — BIGINT — NOT NULL — 거래대금
  • volume — BIGINT — NOT NULL — 거래량
  • market_cap — BIGINT — NOT NULL — 시가총액
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

gift_histories

  • id — UUID — Primary key — NOT NULL
  • gift_transfer_id — UUID — Foreign key → gift_transfers.id — NOT NULL — 증여
  • child_id — UUID — NOT NULL
  • amount — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • transferred_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

gift_transfers

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — NOT NULL
  • child_id — UUID — NOT NULL
  • method — VARCHAR(10) — NOT NULL — periodic|lump_sum
  • total_amount — BIGINT — NOT NULL
  • status — VARCHAR(10) — NOT NULL — active|completed|cancelled
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

goal_assistant_sessions

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — NOT NULL
  • income_bracket — VARCHAR(5) — NOT NULL — 1-2|3-4|5-6|7-8|9-10
  • asset_scale — VARCHAR(10) — NOT NULL — under1억|1-3억|3-5억|5-10억|over10억
  • child_order — VARCHAR(10) — NOT NULL — 첫째|둘째|셋째이상
  • edu_investment_willingness — INT — NOT NULL — Q5 슬라이더 0~10
  • dual_income — BOOLEAN — NOT NULL — Q6 맞벌이 여부
  • recommended_goal_id — UUID — Foreign key → goals.id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

goal_recommendations

  • id — UUID — Primary key — NOT NULL
  • session_id — UUID — Foreign key → goal_assistant_sessions.id — NOT NULL
  • peer_recommended_amt — BIGINT — NOT NULL — 유사사용자 기반 추천금액
  • gov_recommended_amt — BIGINT — NOT NULL — 정부통계 기반 추천금액
  • final_confirmed_amt — BIGINT — 사용자 최종 확정금액
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

goals

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — NOT NULL
  • name — VARCHAR(20) — NOT NULL — 대학등록금|고등등록금|고등사교육비|초등사교육비|custom
  • custom_name — VARCHAR(100)
  • target_amount — BIGINT — NOT NULL
  • target_date — DATE — NOT NULL
  • current_amount — BIGINT — NOT NULL
  • achieved_pct — DECIMAL(5, 2) — NOT NULL
  • possibility_pct — DECIMAL(5, 2) — NOT NULL
  • status — VARCHAR(10) — NOT NULL — active|completed|cancelled
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

holdings

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — NOT NULL
  • etf_id — UUID — NOT NULL
  • hold_qty — INT — NOT NULL
  • avail_qty — INT — NOT NULL — 주문가능 수량
  • sell_qty — INT — NOT NULL — 매도가능 수량
  • avg_buy_price — BIGINT — NOT NULL
  • eval_amount — BIGINT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

lump_sum_gifts

  • id — UUID — Primary key — NOT NULL
  • gift_transfer_id — UUID — Foreign key → gift_transfers.id — NOT NULL
  • amount — BIGINT — NOT NULL
  • transfer_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

order_book_snapshots

  • id — UUID — Primary key — NOT NULL
  • etf_id — UUID — Foreign key → etfs.id — NOT NULL
  • side — VARCHAR(3) — NOT NULL — ask|bid
  • step — INT — NOT NULL — 1~5 호가단계
  • price — BIGINT — NOT NULL
  • qty — BIGINT — NOT NULL
  • snapshot_at — TIMESTAMP — NOT NULL

order_modifications

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → trade_orders.id — NOT NULL
  • before_price — BIGINT — NOT NULL
  • after_price — BIGINT — NOT NULL
  • before_qty — INT — NOT NULL
  • after_qty — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

parents

  • id — UUID — Primary key — NOT NULL — 내부 식별자
  • account_number — VARCHAR(20) — NOT NULL — 로그인용 계좌번호
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • relation — VARCHAR(5) — NOT NULL — mom|dad
  • region — VARCHAR(30) — NOT NULL
  • child_count — INT — NOT NULL
  • profile_image_url — VARCHAR(500)
  • selected_child_id — UUID — Foreign key → children.id — 현재 선택된 자녀 (뷰 전환)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

periodic_gifts

  • id — UUID — Primary key — NOT NULL
  • gift_transfer_id — UUID — Foreign key → gift_transfers.id — NOT NULL
  • monthly_amount — BIGINT — NOT NULL
  • transfer_day — INT — NOT NULL — 1~28일
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • tax_free_limit_amt — BIGINT — NOT NULL — 비과세 한도 계산값
  • discount_rate — DECIMAL(5, 4) — NOT NULL — 유기정기금 3% 할인율
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

refresh_tokens

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP

trade_orders

  • id — UUID — Primary key — NOT NULL
  • child_id — UUID — NOT NULL
  • etf_id — UUID — NOT NULL
  • side — VARCHAR(4) — NOT NULL — buy|sell
  • order_type — VARCHAR(11) — NOT NULL — market|limit|conditional
  • price — BIGINT — NOT NULL
  • qty — INT — NOT NULL
  • remaining_qty — INT — NOT NULL — 미체결 잔량
  • total_amount — BIGINT — NOT NULL
  • fee — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL — pending|partially_executed|executed|cancelled|modified
  • created_at — TIMESTAMP — NOT NULL
  • executed_at — TIMESTAMP — 체결 시간

user_agreements

  • id — UUID — Primary key — NOT NULL
  • parent_id — UUID — Foreign key → parents.id — NOT NULL
  • agreement_type — VARCHAR(10) — NOT NULL — terms|privacy|marketing
  • agreed — BOOLEAN — NOT NULL — 동의 여부
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — 동의 항목 변경시 동의 시점 확인 필요