[다시]ERD 연습문제 1
테이블 (4)
Untitled (producer)
- Key (proCode) — char(10) — 기본 키 — NOT NULL
- Field (proName) — char(10)
- Field (proAddress) — char(20)
- Field (proCell) — int(12)
Untitled (part)
- Key (paCode) — char(10) — 기본 키 — NOT NULL
- Field (paDescription) — text
- Field (paName) — char(10)
- Key (proCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
Untitled (product_part)
- Key (paCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Key (pCode) — char(10) — 외래 키 → product.Key — NOT NULL
- Field (paAmount) — int(4)
product
- Key (pCode) — char(10) — 기본 키 — NOT NULL
- Field (pName) — char(10)
- Field (pPrice) — int(3)
- Field (pDesctiption) — text