mock_invest
Tables (4)
ASSET
- asset_id — VARCHAR2(10) — Primary key — NOT NULL
- asset_name — VARCHAR2(50) — NOT NULL
- current_price — NUMBER(15,2) — NOT NULL
- volatility — NUMBER(5,2) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
PORTFOLIO
- user_id (user_id2) — VARCHAR2(20) — Foreign key → USERS.user_id — NOT NULL
- asset_id (asset_id2) — VARCHAR2(10) — Foreign key → ASSET.asset_id — NOT NULL
- quantity — NUMBER — NOT NULL
- avg_price — NUMBER(15,2) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
TRADE_HISTORY
- trade_id — NUMBER — Primary key
- user_id (user_id2) — VARCHAR2(20) — Foreign key → USERS.user_id — NOT NULL
- asset_id (asset_id2) — VARCHAR2(10) — Foreign key → ASSET.asset_id — NOT NULL
- price — NUMBER(15,2) — NOT NULL
- trade_type — VARCHAR2(4) — NOT NULL
- all_price — NUMBER(20,2) — NOT NULL
- quantity — NUMBER — NOT NULL
- trade_time — TIMESTAMP — NOT NULL
USERS
- user_id — VARCHAR2(20) — Primary key — NOT NULL
- password — VARCHAR2(100) — NOT NULL
- name — VARCHAR2(20) — NOT NULL
- balance — NUMBER(15,2) — NOT NULL
- create_at — TIMESTAMP — NOT NULL