2주차 예제1

테이블 (4)

Copy Of Untitled (PRODUCER)

  • Key (prdcNo) — int — 기본 키 — NOT NULL
  • Field (prdcName) — char(30)
  • Field (address) — char(50)
  • Field (phoneNo) — char(13)

Untitled (COMPONENT)

  • Key (compNo) — int — 기본 키 — NOT NULL
  • Field (compExpln) — char(200)
  • Key (prdcNo) — int — 외래 키 → Copy Of Untitled.Key — NOT NULL

Untitled (PRODUCT)

  • Key (prdtNo) — int — 기본 키 — NOT NULL
  • Field (prdtName) — char(30)
  • Field (prdtExpln) — char(200)
  • Field (prdtPrice) — int

Untitled (COMPINPRODUCT)

  • Key (cpinpdNo) — int — 기본 키 — NOT NULL
  • Field (compAmount) — int
  • Key (prdtNo) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (compNo) — int — 외래 키 → Untitled.Key — NOT NULL