ERD EXE1
Tables (6)
Copy Of Untitled (product_category)
- Key (proCategoryID) — char(10) — Primary key — NOT NULL
- Field (proCategoryName) — char(30)
- Field (description) — text
Product (product)
- Key (productID) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int(10)
- Field (productName) — char(30)
- Field (releaseDate) — date
- Key (proCategoryID) — char(10) — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (part)
- Key (partsID) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (partName) — char(30)
- Field (price) — int(10)
- Key (manuID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (ptCategoryID) — char(10) — Foreign key → Untitled.Key — NOT NULL
Untitled (product_part)
- Key (productID) — char(10) — Foreign key → Product.Key — NOT NULL
- Key (partsID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int(4)
Untitled (manufacturer)
- Key (manuID) — char(10) — Primary key — NOT NULL
- Field (manuName) — char(30)
- Field (phone) — char(11)
- Field (adress) — char(50)
- Field (description) — text
Untitled (part_category)
- Key (ptCategoryID) — char(10) — Primary key — NOT NULL
- Field (ptCategoryName) — char(30)
- Field (description) — text