ERD Exercise 1
Tables (4)
BILL_OF_MATERIALS (Untitled3)
- product_id (INT) — product_id
- part_id (int) — part_id
- quantity (InT) — amount
MANUFACTURER (Untitled4)
- manufacturer_id (INT) — original id
- name (VARCHAR) — Product name
- address (TEXT) — address
- phone (Varchar) — phone
PART (Untitled2)
- part_id (INT) — original id
- description (TEXT) — explain
- manufacturer_id (int) — manufacturer_id
PRODUCT (Untitled)
- product_id (INT) — original id
- name (VARCHAR) — product name
- description (TEXT) — explain
- price (DECIMAL) — price