증권

테이블 (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