ASDF
Tables (12)
DividendHistory
- id — BIGINT
- stock_id — BIGINT
- account_id — BIGINT
- dividend_amount — DECIMAL(15, 2)
- payment_date — DATETIME
HeldStocks
- id — BIGINT
- account_id — BIGINT
- stock_id — BIGINT
- quantity — INT
- purchase_date — DATETIME
Industry
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
Market
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- country — VARCHAR(50)
Order
- id — BIGINT
- account_id — BIGINT
- stock_id — BIGINT
- order_type_id — BIGINT
- quantity — INT
- price — DECIMAL(15, 2)
- order_date — DATETIME
- status — VARCHAR(50)
SalesHistory
- id — BIGINT
- account_id — BIGINT
- stock_id — BIGINT
- sale_price — DECIMAL(15, 2)
- quantity — INT
- sale_date — DATETIME
Sector
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
Stock
- id — BIGINT
- ticker — VARCHAR(10) — NOT NULL
- company_name — VARCHAR(100)
- market — VARCHAR(50)
- sector — VARCHAR(50)
- industry — VARCHAR(50)
StockAccount
- id — BIGINT
- account_number — VARCHAR(50) — NOT NULL
- owner_name — VARCHAR(100)
- balance — DECIMAL(15, 2)
- creation_date — DATETIME
StockHistory
- id — BIGINT
- stock_id — BIGINT
- price — DECIMAL(15, 2)
- time — DATETIME
- volume — INT
TransactionType
- id — BIGINT
- type_name — VARCHAR(50) — NOT NULL
User
- id — BIGINT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- email — VARCHAR(100)
- full_name — VARCHAR(100)
- registration_date — DATETIME