개인 ERD 작성문제
테이블 (5)
part (Untitled)
- part_id (Key) — int — 기본 키 — NOT NULL
- name (Field) — char
- description (Field2) — char
- price (Field3) — int
product
- product_id (Key) — int — 기본 키 — NOT NULL
- name (Field) — char
- description (Field2) — char
- price (Field3) — int
product_part (Untitled3)
- product_id (Key) — int — 외래 키 → product.product_id — NOT NULL
- part_id (Key2) — int — 외래 키 → part.part_id — NOT NULL
- quantity_used (Field) — int
supplier (Untitled2)
- supplier_id (Key) — int — 기본 키 — NOT NULL
- name (Field) — char
- address (Field2) — char
- phone_number (Field3) — char
supplier_part (Untitled4)
- part_id (Key) — int — 외래 키 → part.part_id — NOT NULL
- supplier_id (Key2) — int — 외래 키 → supplier.supplier_id — NOT NULL