주식거래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