특화

테이블 (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