ERD-01
Tables (5)
Copy Of Untitled (COMPONENT)
- Key (componentNo) — int(6) — Primary key — NOT NULL
- Field (componentAcc) — char(50)
Untitled (PRODUCT)
- Key (productNo) — int(6) — Primary key — NOT NULL
- Field (productAcc) — char(50)
- Field (product or) — int(20)
Untitled (MANUFACTURER)
- Key (manufacturerNo) — ini(6) — Primary key — NOT NULL
- Field (manufacturerName) — char(20)
- Field (manufacturerAdd) — char(50)
- Field (manufacturerPhone) — char(15)
Untitled (PRODUCT_COMPONENT)
- Key (productNo) — int(6) — Foreign key → Untitled.Key — NOT NULL
- Key (componentNo) — int(6) — Foreign key → Copy Of Untitled.Key — NOT NULL
Untitled (MANUFACTURER_COMPONENT)
- Key (manufacturerNo) — ini(6) — Foreign key → Untitled.Key — NOT NULL
- Key (componentNo) — int(6) — Foreign key → Copy Of Untitled.Key — NOT NULL