주식거래ERD
테이블 (6)
Order
- Key (OrderID) — INT — 기본 키 — NOT NULL
- UserID — INT — 외래 키 → User.UserID — NOT NULL
- Key (StockID) — 외래 키 → Stock.Key — NOT NULL
- OrderType — VARCHAR(10) — NOT NULL
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
- OrderStatus — VARCHAR(20)
- OrderDate — DATETIME
Portfolio
- Key (PortfolioID) — INT — 기본 키 — NOT NULL
- UserID — INT — 외래 키 → User.UserID — NOT NULL
- Key (StockID) — 외래 키 → Stock.Key — NOT NULL
- Quantity — INT — NOT NULL
- AveragePrice — DECIMAL(10, 2) — NOT NULL
- CreatedDate — DATETIME
- LastUpdated — DATETIME
Stock
- Key (StockID) — 기본 키 — NOT NULL
- Symbol — VARCHAR(10) — NOT NULL
- CompanyName — VARCHAR(100) — NOT NULL
- Sector — VARCHAR(50)
- Industry — VARCHAR(50)
- MarketCap — BIGINT
- CurrentPrice — DECIMAL(10, 2)
- LastUpdated — DATETIME
Transaction
- Key (TransactionID) — INT — 기본 키 — NOT NULL
- Key (OrderID) — INT — 외래 키 → Order.Key — NOT NULL
- UserID — INT — 외래 키 → Order.UserID — NOT NULL
- Key (StockID) — 외래 키 → Order.Key — NOT NULL
- TransactionDate — DATETIME
- Quantity — INT — NOT NULL
- Price — DECIMAL(10, 2) — NOT NULL
User
- UserID — INT — 기본 키 — NOT NULL
- Username — VARCHAR(50) — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- FullName — VARCHAR(100)
- Phone — VARCHAR(20)
- Address — VARCHAR(255)
- CreatedDate — DATETIME
- LastLogin — DATETIME
- AccountStatus — VARCHAR(20)
Watchlist
- Key (WatchlistID) — INT — 기본 키 — NOT NULL
- UserID — INT — 외래 키 → User.UserID — NOT NULL
- Key (StockID) — 외래 키 → Stock.Key — NOT NULL
- AddedDate — DATETIME