sqldb
Tables (3)
Untitled (usertbl)
- Key (userid) — char(3) — Primary key — NOT NULL
- Field (addr) — varchar(10)
- Field2 (height) — int
- Field (phone) — char(13)
Untitled (producttbl)
- Key (pid) — char(2) — Primary key — NOT NULL
- Field2 (name) — varchar(20)
- Field (price) — int
- Field (group) — varchar(10)
Untitled (buytbl)
- Key (userid) — char(3) — Foreign key → Untitled.Key — NOT NULL
- Key (pid) — char(2) — Foreign key → Untitled.Key — NOT NULL
- Field (amount) — int