ERD 연습문제 1

테이블 (5)

Category

  • catID — char(10) — 기본 키 — NOT NULL
  • catName — char(20)
  • catDescription — text

Components

  • cno — char(30) — 기본 키 — NOT NULL
  • cDescription — text
  • cName — char(30)
  • producerID — char(10) — 외래 키 → Producer.proID — NOT NULL
  • catID — char(10) — 외래 키 → Category.catID — NOT NULL

PRODUCT_COMPONENTS (Product_Components)

  • pno — char(30) — 외래 키 → Product.pno — NOT NULL
  • cno — char(30) — 외래 키 → Components.cno — NOT NULL
  • quantity — int(10)

Producer

  • proID — char(30) — 기본 키 — NOT NULL
  • proName — char(30)
  • proPhoneNum — char(12)
  • proDescription — text
  • Address — char(12)
  • grade — text
  • email — char(30)

Product

  • pno — char(30) — 기본 키 — NOT NULL
  • pName — char(30)
  • pDescription — text
  • price — int(10)
  • releasedDate — date
  • category — char(30)