example_1
Tables (4)
Untitled (Manufacturer)
- Key (mID) — int(6) — Primary key — NOT NULL
- Field (name) — char(10)
- Field (address) — varchar(30)
- Field (phone) — int(11)
Untitled (Product)
- Key (pID) — int(6) — Primary key — NOT NULL
- Field (name) — varchar(30)
- Field (description) — text
- Field (price) — int(7)
Untitled (part)
- Key (p_ID) — int(6) — Primary key — NOT NULL
- Field (partModelNO) — char(10)
- Field (description) — text
- Key (mID) — int(6) — Foreign key → Untitled.Key — NOT NULL
Untitled (Composition)
- Key (pID) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Key (p_ID) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int(3)