NGS_erd_exe1
Tables (4)
Untitled (Product)
- Key (pdtID) — char(10) — Primary key — NOT NULL
- Field (description) — text
- Field (price) — int(10)
Untitled (Producer)
- Key (pdrID) — char(20) — Primary key — NOT NULL
- Field
Untitled (Components)
- Key (CompID) — char(10) — Primary key — NOT NULL
- Field (description) — text
Untitled (Product-Components)
- Key (PCID) — char(10) — Primary key — NOT NULL
- Key (pdtID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (CompID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Field (compCount) — int(6)