database_assignment

Tables (4)

Portfolio (Untitled4)

  • name — INT — Primary key — NOT NULL
  • portfolio_id (INT) — INT
  • user_id (INT(20)) — INT
  • stock_id (INT(10)) — INT
  • quantity (INT(5)) — INT
  • avg_price (DECIMAL(15, 2)) — DECIMAL(15, 2)

Stock (Untitled2)

  • name — Primary key — NOT NULL
  • stock_id (INT)
  • ticker (VARCHAR(10))
  • company_name (VARCHAR(100))
  • current_price (DECIMAL(15, 2))
  • market (VARCHAR)

Transaction (Untitled3)

  • name (type) — Primary key — NOT NULL
  • transaction_id — INT
  • user_id (INT(20))
  • stock_id (INT(10))
  • trade_date (DATE)
  • quantity (INT(5))
  • price (DECIMAL(15, 2))
  • trade_type (ENUM('buy', 'sell'))

User (Untitled)

  • name (type) — Primary key — NOT NULL
  • user_id — INT
  • username (VARCHAR(50))
  • password (VARCHAR(100))
  • email (VARCHAR)