sqldb

Tables (3)

Untitled (usertbl)

  • Key (userid) — char(3) — Primary key — NOT NULL
  • Field (addr) — varchar(10)
  • Field2 (height) — int
  • Field (phone) — char(13)

Untitled (producttbl)

  • Key (pid) — char(2) — Primary key — NOT NULL
  • Field2 (name) — varchar(20)
  • Field (price) — int
  • Field (group) — varchar(10)

Untitled (buytbl)

  • Key (userid) — char(3) — Foreign key → Untitled.Key — NOT NULL
  • Key (pid) — char(2) — Foreign key → Untitled.Key — NOT NULL
  • Field (amount) — int