ex_1
Tables (3)
COMPONENTS (Untitled3)
- componentId (Key) — char(10) — Primary key — NOT NULL
- componentName (Field) — char(8)
- componentExp (Field2) — char(10)
- producerId (Key2) — char(10) — Foreign key → PRODUCER.producerId — NOT NULL
PRODUCER (Untitled4)
- producerId (Key) — char(10) — Primary key — NOT NULL
- producerName (Field) — char(4)
- producerAddress (Field2) — char(8)
- ProducerPhoneNumber (Field3) — char(10)
- producId (Key2) — char(10) — Foreign key → PRODUCT.producId — NOT NULL
- componentId (Key3) — char(10) — Foreign key → COMPONENTS.componentId — NOT NULL
PRODUCT (Untitled)
- producId (Key) — char(10) — Primary key — NOT NULL
- productName (Field) — char(8)
- productPrice (Field2) — char(10)
- producerId (Key2) — char(10) — Foreign key → PRODUCER.producerId — NOT NULL
- componentId (Key3) — char(10) — Foreign key → COMPONENTS.componentId — NOT NULL