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