sqldb

Tables (3)

Untitled (usertbl)

  • Key (userid) — char3 — Primary key — NOT NULL
  • Field (addr) — varchar(10)
  • Field (height) — int
  • Field (phone) — chan(13)

Untitled (producttbl)

  • Key (pid) — char(2) — Primary key — NOT NULL
  • Key (name2) — char — Foreign key → Untitled.Key — NOT NULL
  • Key (userid) — char3 — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field2 (price) — int
  • Field (_group) — varchar(10)

Untitled

  • Key (name) — char — Primary key — NOT NULL
  • Key (userid) — char3 — Foreign key → Untitled.Key — NOT NULL
  • Field (amount) — int