3
Tables (4)
Part
- part_id — INT — NOT NULL
- description — VARCHAR(255) — NOT NULL
- supplier_id — INT — NOT NULL
Product
- product_id — INT — NOT NULL
- description — VARCHAR(255) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
Product_Part
- product_id — INT — Primary key — NOT NULL
- part_id — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
Supplier
- supplier_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- phone_number — VARCHAR(20)