연습

테이블 (3)

component (PRODUCT)

  • identification number (prdtNo) — int — 기본 키 — NOT NULL
  • identification number (cpinpdNo) — int — 외래 키 → product.identification number — NOT NULL
  • explanation (prdtName) — char(20)
  • price (prdtExpln) — char(30)
  • identification number (Key2) — 외래 키 → producer.identification number — NOT NULL

producer (PRODUCER)

  • identification number (prdcNo) — 기본 키 — NOT NULL
  • name (prdcName) — char(20)
  • domicile (address) — chat(30)
  • identification number (Key2) — int — 외래 키 → component.identification number — NOT NULL
  • identification number (cpinpdNo) — int — 외래 키 → component.identification number — NOT NULL

product (COMPINPRODUCT)

  • identification number (cpinpdNo) — int — 기본 키 — NOT NULL
  • explanation (compAmount) — int
  • Field (prdtNo)