2023_webDB_ex1
Tables (5)
Untitled (PRODUCER)
- Key (producerSsn) — char(14) — Primary key — NOT NULL
- Field (producerName) — char(10)
- Field (producerAddress) — text
- Field (producerPhoneNumber) — char(13)
Untitled (PRODUCT)
- Key (productId) — int — Primary key — NOT NULL
- Field (productName) — char(30)
- Field (productPrice) — int
- Field (productDescription) — text
Untitled (PRODUCE)
- Key (produceNo) — int — Primary key — NOT NULL
- Key (partsId) — int — Foreign key → Untitled2.Key — NOT NULL
- Key (producerSsn) — char(14) — Foreign key → Untitled.Key — NOT NULL
Untitled (BELONGTO)
- Key (belongNo) — int — Primary key — NOT NULL
- Key (productId) — int — Foreign key → Untitled.Key — NOT NULL
- Key (partsId) — int — Foreign key → Untitled2.Key — NOT NULL
- Field (count) — int
Untitled2 (PARTS)
- Key (partsId) — int — Primary key — NOT NULL
- Field (partsDescription) — text