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)