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