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