실습과제2

테이블 (4)

PART (Untitled2)

  • partNo (Key) — int(10) — 기본 키 — NOT NULL
  • explain (Field) — char(50)
  • product No (Key2) — int(6) — 외래 키 → PRODUCT.product No — NOT NULL

PRODUCER (Untitled3)

  • producerNo (Key) — int(5) — 기본 키 — NOT NULL
  • name (Field) — char(15)
  • address (Field2) — char(30)
  • phone (Field3) — int(11)
  • partNo (Field4) — int(10)

PRODUCER_PART (Untitled4)

  • partNo (Key3) — int(10) — 외래 키 → PART.partNo — NOT NULL
  • producerNo (Key4) — int(5) — 외래 키 → PRODUCER.producerNo — NOT NULL

PRODUCT (Untitled)

  • product No (Key) — int(6) — 기본 키 — NOT NULL
  • explain (Field) — char(50)
  • price (Field2) — int(20)
  • partNo (Field3) — int(10)
  • partNo (Key2) — int(10) — 외래 키 → PART.partNo — NOT NULL
  • product No (Key3) — int(6) — 외래 키 → PRODUCT.product No — NOT NULL