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