ISA 포트폴리오

테이블 (3)

Members (Untitled)

  • memberId (Key) — UUID — 기본 키 — NOT NULL
  • account — String
  • password — String
  • name — String
  • phone_number (phoneNumber) — String
  • email — String
  • Field

PortFolio (Untitled2)

  • port_id (Key) — UUID — 기본 키 — NOT NULL
  • memberId (Key2) — String — 외래 키 → Members.memberId — NOT NULL
  • stock_id (stockId) — Long — 외래 키 → Stock.stock_id — NOT NULL
  • port_name (portName) — String
  • stock_sequence (stockSequence) — Integer

Stock (Untitled3)

  • stock_id (stockId) — Long — 기본 키 — NOT NULL
  • stock_name (stockName) — String
  • stock_code (stockCode) — Long