특화_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