ㅇ
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 — 동의 항목 변경시 동의 시점 확인 필요