ERD 연습문제 1번
테이블 (5)
Untitled (COMPANY)
- Key (comID) — int — 기본 키 — NOT NULL
- Field (comName) — char(20)
- Field (comAddress) — char(50)
- Field (comPhone) — int
- Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PRODUCER)
- Key (proID) — int — 기본 키 — NOT NULL
- Field (proName) — char(20)
- Field (proAddress) — char(50)
- Field (proPhone) — int
- Key (comID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (GOODS)
- Key (goodsID) — int — 기본 키 — NOT NULL
- Field (goodsDescription) — char(100)
- Field (goodsPrice) — int
- Key (comID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (PART)
- Key (partID) — int — 기본 키 — NOT NULL
- Field (partDescription) — char(100)
- Key (proID) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (MAKEON)
- Key (goodsID) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (partID) — int — 외래 키 → Untitled.Key — NOT NULL