exercise1
Tables (5)
Untitled (PRODUCER)
- Key (producerID) — char — Primary key — NOT NULL
- Field (name) — char(30)
- Field (adress) — text
- Field (phone) — char(11)
- Key (companyID) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (COMPANY)
- Key (companyID) — char(5) — Primary key — NOT NULL
- Field (name) — char(30)
Untitled (PRODUCT)
- Key (productID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Field (price) — char(10)
- Key (companyID) — char(5) — Foreign key → Untitled.Key — NOT NULL
Untitled (COMPONENT)
- Key (componentID) — char(10) — Primary key — NOT NULL
- Field (name) — char(30)
- Key (producerID) — char — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCT COMPONENT)
- Key (productcomponentID) — char(10) — Primary key — NOT NULL
- Field (Amount) — char(20)
- Key (productID) — char(10) — Foreign key → Untitled.Key — NOT NULL
- Key (componentID2) — char(10) — Foreign key → Untitled.Key — NOT NULL