특화
테이블 (27)
api_call_usage
- api_name — VARCHAR(20) — 기본 키 — NOT NULL
- usage_date — DATE — 기본 키 — NOT NULL
- used_count — INT — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
batch_sync_state
- sync_key — VARCHAR(100) — 기본 키 — NOT NULL
- scope_key — VARCHAR(100) — 기본 키 — NOT NULL
- synced_from — DATE
- synced_to — DATE
- last_cursor — VARCHAR(200)
- last_run_at — DATETIME(6)
- last_status — VARCHAR(20)
- note — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
company
- company_id — BIGINT — 기본 키 — NOT NULL
- dart_corp_code — VARCHAR(8) — NOT NULL
- representative_stock_code — VARCHAR(6) — NOT NULL
- issue_family_key — VARCHAR(8) — NOT NULL
- corp_name — VARCHAR(120) — NOT NULL
- corp_eng_name — VARCHAR(200)
- corp_modify_date — DATE
- corp_full_name — VARCHAR(120)
- corp_full_name_eng — VARCHAR(200)
- stock_name — VARCHAR(60)
- ceo_name — VARCHAR(200)
- corp_cls — VARCHAR(1)
- address — VARCHAR(500)
- homepage_url — VARCHAR(300)
- ir_url — VARCHAR(300)
- phone_no — VARCHAR(40)
- fax_no — VARCHAR(40)
- industry_code — VARCHAR(10)
- established_date — DATE
- account_month — VARCHAR(2)
- detail_synced_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
mock_account
- mock_account_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- seed_amount — DECIMAL(18,2) — NOT NULL
- cash_balance — DECIMAL(18,2) — NOT NULL
- reserved_cash — DECIMAL(18,2) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
mock_account_snapshot
- mock_account_snapshot_id — BIGINT — 기본 키 — NOT NULL
- mock_account_id — BIGINT — 외래 키 → mock_account.mock_account_id — NOT NULL
- snapshot_date — DATE — NOT NULL
- seed_amount — DECIMAL(18,2) — NOT NULL
- cash_balance — DECIMAL(18,2) — NOT NULL
- evaluation_amount — DECIMAL(18,2) — NOT NULL
- total_asset — DECIMAL(18,2) — NOT NULL
- unpriced_holdings — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
mock_cash_ledger
- mock_cash_ledger_id — BIGINT — 기본 키 — NOT NULL
- mock_account_id — BIGINT — 외래 키 → mock_account.mock_account_id — NOT NULL
- type — VARCHAR(12) — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- balance_after — DECIMAL(18,2) — NOT NULL
- mock_trade_id — BIGINT — 외래 키 → mock_trade.mock_trade_id
- occurred_at — DATETIME(6) — NOT NULL
mock_holding
- mock_holding_id — BIGINT — 기본 키 — NOT NULL
- mock_account_id — BIGINT — 외래 키 → mock_account.mock_account_id — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- quantity — BIGINT — NOT NULL
- reserved_quantity — BIGINT — NOT NULL
- avg_price — DECIMAL(18,4) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
mock_order
- mock_order_id — BIGINT — 기본 키 — NOT NULL
- mock_account_id — BIGINT — 외래 키 → mock_account.mock_account_id — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- side — VARCHAR(4) — NOT NULL
- limit_price — DECIMAL(18,4) — NOT NULL
- trigger_direction — VARCHAR(16)
- quantity — BIGINT — NOT NULL
- status — VARCHAR(10) — NOT NULL
- reserved_amount — DECIMAL(18,2)
- placed_at — DATETIME(6) — NOT NULL
- expires_on — DATE — NOT NULL
- matched_through — DATE — NOT NULL
- settled_at — DATETIME(6)
- filled_trade_date — DATE
- mock_trade_id — BIGINT — 외래 키 → mock_trade.mock_trade_id
- notified_at — DATETIME(6)
mock_trade
- mock_trade_id — BIGINT — 기본 키 — NOT NULL
- mock_account_id — BIGINT — 외래 키 → mock_account.mock_account_id — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- side — VARCHAR(4) — NOT NULL
- quantity — BIGINT — NOT NULL
- price — DECIMAL(18,4) — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- realized_pl — DECIMAL(18,2)
- fee — DECIMAL(18,2) — NOT NULL
- tax — DECIMAL(18,2) — NOT NULL
- traded_at — DATETIME(6) — NOT NULL
social_account
- social_account_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(191) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
stock
- stock_id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.company_id
- standard_code — VARCHAR(12) — NOT NULL
- stock_code — VARCHAR(6) — NOT NULL
- issue_family_key — VARCHAR(8) — NOT NULL
- stock_name — VARCHAR(60) — NOT NULL
- stock_short_name — VARCHAR(40) — NOT NULL
- stock_eng_name — VARCHAR(120) — NOT NULL
- market — VARCHAR(10) — NOT NULL
- security_group — VARCHAR(30) — NOT NULL
- section_type — VARCHAR(30)
- stock_kind — VARCHAR(20) — NOT NULL
- listed_date — DATE — NOT NULL
- par_value — DECIMAL(18,4)
- par_value_raw — VARCHAR(20) — NOT NULL
- listed_shares — BIGINT — NOT NULL
- is_common_stock — BOOLEAN — NOT NULL
- is_spac — BOOLEAN — NOT NULL
- is_administrative — BOOLEAN — NOT NULL
- is_alert — BOOLEAN — NOT NULL
- is_foreign — BOOLEAN — NOT NULL
- price_backfilled_from — DATE
- price_backfilled_to — DATE
- delisted_at — DATE
- latest_close — DECIMAL(15,2)
- previous_close — DECIMAL(15,2)
- latest_volume — BIGINT
- latest_trade_date — DATE
- daily_rows — BIGINT
- daily_from — DATE
- summary_updated_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stock_event
- stock_event_id — BIGINT — 기본 키 — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- event_type — VARCHAR(20) — NOT NULL
- event_date — DATE — NOT NULL
- title — VARCHAR(200) — NOT NULL
- source — VARCHAR(30) — NOT NULL
- source_ref — VARCHAR(40)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6)
stock_news
- id — VARCHAR(64) — 기본 키 — NOT NULL
- stock_code — VARCHAR(20) — NOT NULL
- stock_name — VARCHAR(100)
- title — VARCHAR(500)
- summary — VARCHAR(2000)
- source — VARCHAR(255)
- url — VARCHAR(2048) — NOT NULL
- published_at — DATETIME(6)
- collected_at — DATETIME(6) — NOT NULL
stock_price_adjustment
- effective_date — DATE — 기본 키 — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- factor — DECIMAL(20,10) — NOT NULL
- event_type — VARCHAR(20) — NOT NULL
- shares_before — BIGINT — NOT NULL
- shares_after — BIGINT — NOT NULL
- close_before — DECIMAL(18,4) — NOT NULL
- close_after — DECIMAL(18,4) — NOT NULL
- shares_ratio — DECIMAL(20,10) — NOT NULL
- price_ratio — DECIMAL(20,10) — NOT NULL
- detected_by — VARCHAR(20) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- note — VARCHAR(300)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stock_price_daily
- trade_date — DATE — 기본 키 — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- open_price — DECIMAL(15,2)
- high_price — DECIMAL(15,2)
- low_price — DECIMAL(15,2)
- close_price — DECIMAL(15,2) — NOT NULL
- change_price — DECIMAL(15,2) — NOT NULL
- change_rate — DECIMAL(9,2) — NOT NULL
- volume — BIGINT — NOT NULL
- trading_value — BIGINT — NOT NULL
- market_cap — BIGINT — NOT NULL
- listed_shares — BIGINT — NOT NULL
- is_traded — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stock_price_monthly
- month_start — DATE — 기본 키 — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- open_price — DECIMAL(15,2)
- high_price — DECIMAL(15,2)
- low_price — DECIMAL(15,2)
- close_price — DECIMAL(15,2) — NOT NULL
- volume — BIGINT — NOT NULL
- trading_value — BIGINT — NOT NULL
- trading_days — INT — NOT NULL
- traded_days — INT — NOT NULL
- first_trade_date — DATE — NOT NULL
- last_trade_date — DATE — NOT NULL
- is_complete — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
stock_price_weekly
- week_start — DATE — 기본 키 — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- open_price — DECIMAL(15,2)
- high_price — DECIMAL(15,2)
- low_price — DECIMAL(15,2)
- close_price — DECIMAL(15,2) — NOT NULL
- volume — BIGINT — NOT NULL
- trading_value — BIGINT — NOT NULL
- trading_days — INT — NOT NULL
- traded_days — INT — NOT NULL
- first_trade_date — DATE — NOT NULL
- last_trade_date — DATE — NOT NULL
- is_complete — BOOLEAN — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
terms
- term_id — BIGINT — 기본 키 — NOT NULL
- type — VARCHAR(20) — NOT NULL
- version — INT — NOT NULL
- content — LONGTEXT
- required — BOOLEAN — NOT NULL
- effective_from — DATETIME(6) — NOT NULL
- title — VARCHAR(200)
us_mock_account
- us_mock_account_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- initial_cash — DECIMAL(18,2) — NOT NULL
- cash_balance — DECIMAL(18,2) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
us_mock_holding
- us_mock_holding_id — BIGINT — 기본 키 — NOT NULL
- us_mock_account_id — BIGINT — 외래 키 → us_mock_account.us_mock_account_id — NOT NULL
- us_stock_id — BIGINT — 외래 키 → us_stock.us_stock_id — NOT NULL
- quantity — BIGINT — NOT NULL
- avg_price — DECIMAL(18,6) — NOT NULL
us_mock_trade
- us_mock_trade_id — BIGINT — 기본 키 — NOT NULL
- us_mock_account_id — BIGINT — 외래 키 → us_mock_account.us_mock_account_id — NOT NULL
- us_stock_id — BIGINT — 외래 키 → us_stock.us_stock_id — NOT NULL
- side — VARCHAR(4) — NOT NULL
- quantity — BIGINT — NOT NULL
- price — DECIMAL(18,6) — NOT NULL
- price_source — VARCHAR(8) — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- fee — DECIMAL(18,2) — NOT NULL
- regulatory_fee — DECIMAL(18,2) — NOT NULL
- traded_at — DATETIME(6) — NOT NULL
us_stock
- us_stock_id — BIGINT — 기본 키 — NOT NULL
- symbol — VARCHAR(16) — NOT NULL
- exchange_code — VARCHAR(2) — NOT NULL
- name — VARCHAR(128) — NOT NULL
- is_etf — BOOLEAN — NOT NULL
us_stock_price_daily
- trade_date — DATE — 기본 키 — NOT NULL
- us_stock_id — BIGINT — 외래 키 → us_stock.us_stock_id — NOT NULL
- open_price — DECIMAL(18,6) — NOT NULL
- high_price — DECIMAL(18,6) — NOT NULL
- low_price — DECIMAL(18,6) — NOT NULL
- close_price — DECIMAL(18,6) — NOT NULL
- volume — BIGINT — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
us_watchlist
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- us_stock_id — BIGINT — 외래 키 → us_stock.us_stock_id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
user_agreement
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- term_id — BIGINT — 외래 키 → terms.term_id — NOT NULL
- agreed — BOOLEAN — NOT NULL
- agreed_at — DATETIME(6) — NOT NULL
users
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(30) — NOT NULL
- notification_email — VARCHAR(255)
- notification_email_verified — BOOLEAN — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- last_login_at — DATETIME(6)
- withdrawn_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
watchlist_item
- watchlist_item_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- stock_id — BIGINT — 외래 키 → stock.stock_id — NOT NULL
- created_at — DATETIME(6) — NOT NULL