ERD 1번
테이블 (4)
PART
- Key (partID) — 기본 키 — NOT NULL
- Field (partModelNumber)
- Field (partName)
- Field2 (description)
- producerID — 외래 키 → Untitled3.producerID — NOT NULL
PRODUCT
- productModelID — 기본 키 — NOT NULL
- product_Name (productName)
- description
- Field3 (price)
PRODUCT_PART
- Key (partID) — 외래 키 → PART.Key — NOT NULL
- productModelID — 외래 키 → PRODUCT.productModelID — NOT NULL
- qty
Untitled3 (PRODUCER)
- producerID — 기본 키 — NOT NULL
- producerName (productName)
- Field (phone)
- Field2 (address)
- Field3 (email)