Exercise_1_PRODUCT
Tables (4)
Untitled (PART)
- Key (partNo) — int(10) — Primary key — NOT NULL
- Field (price) — int(10)
- Field2 (manual) — text
- Field3 (coperation) — text
- Field4 (description) — tect
- Key (supID) — int(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (SUPPLIER)
- Key (supID) — int(10) — Primary key — NOT NULL
- Field (supName) — char(30)
- Field2 (phon) — char(10)
- Field (address) — char(40)
- Field (fax) — char(10)
- Field (email) — email
- Field (description) — text
Untitled2 (PRODUCT)
- Key (productNo) — int(10) — Primary key — NOT NULL
- Field (price) — int(10)
- Field2 (partID) — int(10)
- Field3 (specificarion) — text
Untitled3 (PRODUCT_PART)
- Field4 (qty) — int(3)
- Key (productNo) — int(10) — Foreign key → Untitled2.Key — NOT NULL
- Key (partNo) — int(10) — Foreign key → Untitled.Key — NOT NULL