Stock
Tables (3)
Player
- 아이디 (playerId) — Integer — Primary key — NOT NULL
- 이름 (playerName) — String
- 재산 (playerMoney) — Integer
- 보유주식 (playerStocks) — Stock
- 생성시간 (createdTime) — Date
PlayerStock
- 아이디 (playerStockId) — Integer — Primary key — NOT NULL
- 아이디 (playerId) — Integer — Foreign key → Player.아이디 — NOT NULL
- 아이디 (stockId) — Integer — Foreign key → Stock.아이디 — NOT NULL
- 보유자 (player) — Player
- 주식 (stock) — Stock
- 주식 수량 (stockQuantity) — int
- 생성시간 (createdTime) — Date
Stock
- 아이디 (stockId) — Integer — Primary key — NOT NULL
- 주식이름 (stockName) — String
- 주식가격 (stockPrice) — int
- 생성시간 (createdTime) — Date