Exercise1
Tables (5)
Untitled (PRODUCT)
- Key (productModelNum) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (price) — int(10)
- Field (discription) — longtext
Untitled (SUPPLIER)
- Key (supplierID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- phone — char(12)
- Field (address) — char(50)
- Field (email) — email
- Field (discription) — longtext
Untitled (PART)
- Key (partModelNum) — char(30) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (price) — int(10)
- Field (discription) — longtext
- Key (supplierID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (CATEGORY)
- Key (cateNum) — char(30) — Primary key — NOT NULL
- Field (name) — char(100)
- Field (discription) — longtext
- Key (supplierID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (quantity) — int(10) — Foreign key → Untitled.Key — NOT NULL
- Key (productModelNum) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (partModelNum) — char(30) — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCT_PART)
- Key (quantity) — int(10) — Primary key — NOT NULL
- Key (productModelNum) — char(30) — Foreign key → Untitled.Key — NOT NULL
- Key (partModelNum) — char(30) — Foreign key → Untitled.Key — NOT NULL