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