ex1
Tables (4)
Untitled (SUPPLIER)
- Key2 (supID) — Int — Primary key — NOT NULL
- Field2 (supNAME) — char(30)
- Field (email) — char(30)
- Field (phone) — char(11)
- Field (address) — char(50)
Untitled (COMMODITY)
- Key (comID) — char(30) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int
- Key2 (supID) — Int — Foreign key → Untitled.Key2 — NOT NULL
Untitled (PART-COMMODITY LINK)
- Key (partID) — char(25) — Foreign key → Untitled2.Key — NOT NULL
- Key (comID) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled2 (PART)
- Key (partID) — char(25) — Primary key — NOT NULL
- Field (partNAME) — char(30)
- Field (description) — text
- Field (modelNumber) — char(30)
- Key2 (supID) — Int — Foreign key → Untitled.Key2 — NOT NULL