exercise1
Tables (4)
COMPONENT (Untitled2)
- compoID (Key) — char(5) — Primary key — NOT NULL
- description (Field) — text
- producerID (Key2) — char(5) — Foreign key → PRODUCER.producerID — NOT NULL
- productID (Key3) — char(10) — Foreign key → PRODUCT.productID — NOT NULL
COMPONENT-PRODUCT TYPE (Untitled4)
- compoID (Key) — char(5) — Foreign key → COMPONENT.compoID — NOT NULL
- productID (Key2) — char(10) — Foreign key → PRODUCT.productID — NOT NULL
- quantity (Field) — int(10)
PRODUCER (Untitled)
- producerID (Key) — char(5) — Primary key — NOT NULL
- name (Field) — char(20)
- address (Field2) — char(30)
- phone (Field3) — char(11)
- compoID (Key2) — char(5) — Foreign key → COMPONENT.compoID — NOT NULL
PRODUCT (Untitled3)
- productID (Key) — char(10) — Primary key — NOT NULL
- description (Field) — text
- price (Field2) — char(10)
- compoID (Key2) — char(5) — Foreign key → COMPONENT.compoID — NOT NULL