예제 1

테이블 (3)

PRODUCER

  • Key — 기본 키 — NOT NULL
  • Field (고유번호) — char(10)
  • Field (name) — char(30)
  • Field (adress) — char(30)
  • Field (phonenumber) — char(11)

PRODUCT

  • Key — 기본 키 — NOT NULL
  • Field (고유번호) — char(10)
  • Field (description) — text
  • Field (price) — char(10)

Untitled2 (PART)

  • Key — 기본 키 — NOT NULL
  • Field (고유번호) — char(10)
  • Field (description) — text
  • Key (Key2) — 외래 키 → PRODUCT.Key — NOT NULL