db

Tables (3)

Market (Untitled2)

  • Stock_code (Key) — CHAR — Primary key — NOT NULL
  • date (Key2) — CHAR — Primary key — NOT NULL
  • Corp_code (Key3) — Foreign key → Untitled3.Corp_code — NOT NULL
  • price (Field) — INT
  • volume (Field2) — INT
  • market_cap (Field3) — INT
  • list (Field4) — INT

Statement (Untitled)

  • Corp_code (Key) — CHAR — Primary key — NOT NULL
  • year (Key2) — CHAR — Primary key — NOT NULL
  • cfs_ofs (Key3) — CHAR — Primary key — NOT NULL
  • Corp_code (Key4) — Foreign key → Untitled3.Corp_code — NOT NULL
  • Json (Field) — TEXT

Untitled3

  • Corp_code (Key) — Primary key — NOT NULL
  • Stock_code (Field2)
  • Stock_name (Field3)
  • Corp_cls (Field4)
  • Acc_mt (Field5)