asset-manager
Tables (3)
Member (Untitled)
- member_id (PK) — Long — Primary key — NOT NULL
Stock (Untitled2)
- stock_id (PK) — Long — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
- ticker (Field) — VarChar(50)
- quantity (Field2) — int
- price (Field3) — double
TotalAsset (Untitled3)
- Key — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.member_id — NOT NULL
- date (Field) — Date
- asset (Field3) — double