2025_5(1)
Tables (4)
Untitled (PRODUCT)
- Key (productId) — int — Primary key — NOT NULL
- Field (description) — text
- Field (price) — float
Untitled (PART)
- Key (partId) — int — Primary key — NOT NULL
- Field (description) — text
- Key (supplierId) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (SUPPLIER)
- Key (supplierId) — int — Primary key — NOT NULL
- Field (name) — char
- Field (address) — char
- Field (phone) — char(11)
Untitled (COMPOSITION)
- Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
- Key (partId) — int — Foreign key → Untitled.Key — NOT NULL
- Field (quantity) — int