ERD 연습문제 5
테이블 (6)
Untitled (producer)
- Key (pCode) — char(10) — 기본 키 — NOT NULL
- Field (pPhone) — int(20)
- Field (pEmail) — char(15)
- Key (sCode) — char(10) — 외래 키 → shoes.Key — NOT NULL
Untitled (customer)
- Key (cCode) — char(10) — 기본 키 — NOT NULL
- Field (cName) — char(5)
- Field (cAddress) — char(30)
- Field (cPhone) — int(20)
- Field
Untitled (shoes_customer)
- Key (sCode) — char(10) — 외래 키 → shoes.Key — NOT NULL
- Key (cCode) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (buyAmount) — int(3)
- Field (buyDay) — date
Untitled (marketer)
- Key (mNum) — char(10) — 기본 키 — NOT NULL
- Field (mPhone) — int(20)
- Field (mFees) — int(3)
- Field (mGoalAchieve) — int(3)
Untitled (shoes_marketer)
- Key (sCode) — char(10) — 외래 키 → shoes.Key — NOT NULL
- Key (mNum) — char(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (salesAmount) — int(3)
shoes
- Key (sCode) — char(10) — 기본 키 — NOT NULL
- Field (sStyle) — char(20)
- Field (sSize) — int(3)
- Field (sColor) — char(20)
- Field (sAmount) — int(4)
- Field (sProducer) — char(10)