ex1
Tables (5)
Part (Untitled3)
- part_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
Part_Supplier (Untitled5)
- part_id (Key) — Primary key — NOT NULL
- Field
Product (Untitled)
- Key — Primary key — NOT NULL
- part_id (Key2) — Foreign key → Part.part_id — NOT NULL
- product_id (Field)
- name (Field2)
- description (Field3)
- price (Field4)
- Key (Key3) — Foreign key → Product.Key — NOT NULL
- part_id (Key22) — Foreign key → Product.part_id — NOT NULL
Product_Part (Untitled4)
- product_id (Key) — Primary key — NOT NULL
- part_id (Key2) — Foreign key → Part.part_id — NOT NULL
- part_id (Field)
- quantity (Field2)
Supplier (Untitled2)
- supplier_id (Key) — Primary key — NOT NULL
- part_id (Key2) — Foreign key → Part.part_id — NOT NULL
- part_id (Key3) — Foreign key → Part_Supplier.part_id — NOT NULL
- Key (Key4) — Foreign key → Product.Key — NOT NULL
- part_id (Key22) — Foreign key → Product.part_id — NOT NULL
- name (Field)
- address (Field2)
- phone (Field3)