sqldb

Tables (3)

Untitled2

  • pid (Key) — char(2) — Primary key — NOT NULL
  • name (Key2) — char(3) — Foreign key → buytbl.name — NOT NULL
  • Key2 (Key22) — Foreign key → buytbl.Key2 — NOT NULL
  • name (Field) — varchar(20)
  • price (Field2) — int
  • _grouup (Field3) — varchar(10)
  • name (Key3) — char(3) — Foreign key → buytbl.name — NOT NULL
  • Key2 (Key23) — Foreign key → buytbl.Key2 — NOT NULL

buytbl (Untitled3)

  • name (Key) — char(3) — Foreign key → usertbl.name — NOT NULL
  • Key2 — Foreign key → usertbl.userid — NOT NULL
  • amount (Field) — int
  • Field2

usertbl (Untitled)

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