과제1
테이블 (4)
Untitled (product part)
- Key (productID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- partID — char(10) — 외래 키 → part.partID — NOT NULL
- Field (quentity) — int(10)
Untitled (producer)
- Key (producerID) — char(10) — 기본 키 — NOT NULL
- Field (name) — char(20)
- Field (address) — char(30)
- Field (phone) — char(11)
Untitled (product)
- Key (productID) — char(10) — 기본 키 — NOT NULL
- Field (explanation) — char(30)
- Field (price) — int(10)
part
- partID — char(10) — 기본 키 — NOT NULL
- (explanation) — char(30) — NOT NULL
- Key (producerID) — char(10) — 외래 키 → Untitled.Key — NOT NULL