연습 1번문제

테이블 (4)

PRODUCER (PART)

  • Key (partNumber) — char(30) — 기본 키 — NOT NULL
  • Field (specifcation) — text
  • Field (partName) — char(30)
  • Field2 (partProducer) — char(20)
  • Field2 (description) — text
  • Key (supID) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (SUPPLIER)

  • Key (supID) — int(10) — 기본 키 — NOT NULL
  • Field (supName) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(10)
  • Field (fax) — char(10)
  • Field (email) — email
  • Field (description) — text

Untitled (PRODUCTPART)

  • Key (partNumber) — char(30) — 외래 키 → PRODUCER.Key — NOT NULL
  • Key (proNumber) — char(20) — 외래 키 → Untitled2.Key — NOT NULL
  • Field (qty) — int(3)

Untitled2 (PRODUCT)

  • Key (proNumber) — char(20) — 기본 키 — NOT NULL
  • Field (price) — char(20)
  • Field (partVolume) — char(10)
  • Field (proName) — char(30)
  • Field (specifcation) — text