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