20230306_2주차_과제
테이블 (5)
Untitled (PRODUCT)
- Key (prodNo) — int — 기본 키 — NOT NULL
- Field (prodName) — char(100)
- Field (prodExplain) — char(200)
- Field (prodPrice) — int
- Field (priceUnit) — char(3)
Untitled (PART)
- Key (partNo) — int — 기본 키 — NOT NULL
- Field (partName) — char(100)
- Field (partExplain) — char(200)
Untitled (COMPONENT)
- Key (prodNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (partNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (quantity) — int
- Field (unit) — char(3)
Untitled (PRODUCER)
- Key (producerNo) — int — 기본 키 — NOT NULL
- Field (producerName) — char(50)
- Field (producerAddress) — char(100)
- Field (producerPhone) — char(13)
Untitled (PART PRODUCER PRICE)
- Key (partNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (producerNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (partPrice) — int
- Field (priceUnit) — char(3)