sqlDB

Tables (3)

buytbl

  • pid (Key2) — char(2) — Foreign key → producttbl.pid — NOT NULL
  • userid (Key22) — char(3) — Foreign key → usertbl.userid — NOT NULL
  • amount (Field) — int

producttbl

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

usertbl

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