증권
테이블 (5)
HeldStocks (보유주식)
- id — BIGINT — 기본 키 — NOT NULL
- id (account_id) — BIGINT — 외래 키 → StockAccount.id — NOT NULL
- id (stock_id) — BIGINT — 외래 키 → Stock.id — NOT NULL
- quantity — INT
- purchase_date — DATETIME
Order (주문)
- id — BIGINT — 기본 키 — NOT NULL
- id (account_id) — BIGINT — 외래 키 → StockAccount.id — NOT NULL
- id (stock_id) — BIGINT — 외래 키 → Stock.id — NOT NULL
- order_type_id
- quantity — INT
- price — DECIMAL(15, 2)
- order_date — DATETIME
- status — VARCHAR(50)
Stock (종목)
- id — BIGINT — 기본 키 — NOT NULL
- ticker — VARCHAR(10) — NOT NULL
- company_name — VARCHAR(100)
- market — VARCHAR(50)
- sector — VARCHAR(50)
- industry — VARCHAR(50)
StockAccount (증권계좌)
- id — BIGINT — 기본 키 — NOT NULL
- account_number — VARCHAR(50) — NOT NULL
- owner_name — VARCHAR(100)
- password — VARCHAR(50)
- balance — DECIMAL(15,2)
- created_date — DATETIME
StockHistory (주가기록)
- id — BIGINT — 기본 키 — NOT NULL
- id (stock_id) — BIGINT — 외래 키 → Stock.id — NOT NULL
- price — DECIMAL(15, 2)
- time — DATETIME
- quantity — INT