sqlDB

Tables (3)

Untitled (userTbl)

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

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