5
Tables (6)
Untitled (shoes)
- Key (ID) — char(10) — Primary key — NOT NULL
- Field (quantity) — int(10)
- Field (price) — int(10)
- Key (ID2) — char(10) — Foreign key → subject.Key — NOT NULL
- Key (ID3) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (supplier)
- Key (ID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (phone) — int(13)
- Field (email) — char(30)
- Field (address) — char(30)
- Field (suptype) — char(2)
Untitled (customer)
- Key (ID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — int(13)
- Field (vipmemo) — text
Untitled (sale)
- Key (ID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ID2) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (saledate) — date
- Field (salequantity) — int(1000)
- Field (saletype) — int(3)
- Field (salefee) — int(3)
- Field (description) — text
- Key (ID3) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (salesperson)
- Key (ID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — int(13)
- Field (salary) — char(10)
subject
- Key (ID) — char(10) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (sizeCODE) — char(5)
- Field (colorCODE) — char(1)
- Field (styleCODE) — char(7)