sqldb

Tables (3)

Untitled (usertbl)

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

Untitled (productTbl)

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

Untitled (buytbl)

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