특화_14기_A503팀_싸피증권

테이블 (12)

account_histories

  • history_id — bigint
  • account_id — bigint — 외래 키 → accounts.account_id — NOT NULL
  • user_id — bigint — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • ticker — varchar(255)
  • stock_name — varchar(255)
  • quantity — int — NOT NULL
  • price — decimal(18,0)
  • fee — decimal(18,0)
  • tax — decimal(18,0)
  • amount — decimal(18,0) — NOT NULL
  • balance_after — decimal(18,0) — NOT NULL
  • executed_at — datetime — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • INDEX — `idx_accountHistory_account_executed`

accounts

  • account_id — bigint
  • user_id — bigint — 외래 키 → users.user_id — NOT NULL
  • account_type — VARCHAR(20) — NOT NULL — AI, USER
  • dnca_tot_amt — decimal(18, 0) — NOT NULL
  • locked_amt — decimal(18, 0) — NOT NULL
  • available_amt — decimal(18, 0) — NOT NULL
  • created_at — datetime
  • updated_at — datetime

daily_rankings

  • daily_ranking_id — bigint
  • rank_date_time — datetime — NOT NULL
  • user_id — bigint — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • roi — decimal(10,4) — NOT NULL
  • rank_order — bigint — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • INDEX — `idx_daily_rankings_date_roi`
  • INDEX — `idx_daily_rankings_nickname_fts`

executions

  • execution_id — bigint
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • execution_price — decimal(18,0) — NOT NULL
  • execution_quantity — int — NOT NULL
  • executed_at — datetime — NOT NULL

holidays

  • holiday_id — bigint
  • holiday_date — date — NOT NULL
  • description — varchar(100)
  • created_at — datetime
  • updated_at — datetime

order_history

  • history_id — bigint
  • account_id — bigint — NOT NULL
  • order_id — bigint — 외래 키 → orders.order_id — NOT NULL
  • user_id — bigint — NOT NULL
  • ticker — varchar(20) — NOT NULL
  • history_type — VARCHAR(20) — NOT NULL
  • quantity — int — NOT NULL
  • price — decimal(18,0)
  • created_at — datetime — NOT NULL
  • INDEX — `idx_orderHistory_account_created`
  • INDEX — `idx_orderHistory_account_ticker_created`

orders

  • order_id — bigint
  • account_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • ticker — varchar(20) — 외래 키 → stocks.ticker — NOT NULL
  • order_type — VARCHAR(20) — NOT NULL
  • price_type — VARCHAR(20) — NOT NULL
  • price — decimal(18,0) — NOT NULL
  • requested_quantity — int — NOT NULL
  • executed_quantity — int — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • locked_amount — decimal(18,0) — NOT NULL
  • released_lock_amount — decimal(18,0) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • INDEX — `idx_orders_account_created`
  • INDEX — `idx_orders_account_ticker_created`

outbox_events

  • outbox_event_id — bigint
  • aggregate_type — varchar(50) — NOT NULL
  • aggregate_id — varchar(50) — NOT NULL
  • topic — varchar(100) — NOT NULL
  • message_key — varchar(100)
  • payload — json — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — datetime — NOT NULL
  • published_at — datetime
  • INDEX — `idx_outbox_events_status_created_at`

positions

  • position_id — bigint
  • account_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • ticker — varchar(20) — 외래 키 → stocks.ticker — NOT NULL
  • quantity — int — NOT NULL
  • locked_quantity — int — NOT NULL
  • available_quantity — int — NOT NULL
  • average_price — decimal(18,0) — NOT NULL
  • total_purchase_amount — decimal(18,0) — NOT NULL
  • updated_at — datetime

stocks

  • ticker — varchar(20)
  • company_name — varchar(100) — NOT NULL
  • market_type — varchar(20) — NOT NULL
  • status — varchar(20) — NOT NULL
  • logo_url — varchar(255)
  • created_at — datetime
  • updated_at — datetime

users

  • user_id — bigint
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • is_email_verified — boolean — NOT NULL
  • investment_style — VARCHAR(20) — NOT NULL — BALANCED, GROWTH, AGGRESSIVE
  • created_at — datetime
  • updated_at — datetime

watchlists

  • watchlist_id — bigint
  • user_id — bigint — NOT NULL
  • ticker — varchar(20) — NOT NULL
  • created_at — datetime
  • updated_at — datetime