2주차 예제1
테이블 (4)
Copy Of Untitled (PRODUCER)
- Key (prdcNo) — int — 기본 키 — NOT NULL
- Field (prdcName) — char(30)
- Field (address) — char(50)
- Field (phoneNo) — char(13)
Untitled (COMPONENT)
- Key (compNo) — int — 기본 키 — NOT NULL
- Field (compExpln) — char(200)
- Key (prdcNo) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL
Untitled (PRODUCT)
- Key (prdtNo) — int — 기본 키 — NOT NULL
- Field (prdtName) — char(30)
- Field (prdtExpln) — char(200)
- Field (prdtPrice) — int
Untitled (COMPINPRODUCT)
- Key (cpinpdNo) — int — 기본 키 — NOT NULL
- Field (compAmount) — int
- Key (prdtNo) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (compNo) — int — 외래 키 → Untitled.Key — NOT NULL