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)