sqldb
Tables (3)
Untitled (userTBL)
- Key (userid) — char(3) — Primary key — NOT NULL
- Field (addr) — varchar(10)
- Field (height) — int
- Field (phone) — char(13)
- Field (name) — char(3)
Untitled (productTBL)
- Key (pid) — char(2) — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (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