20221006 ex1풀이

테이블 (6)

Untitled (PRODUCT)

  • Key (productNO) — CHAR(15) — 기본 키 — NOT NULL
  • Field (menual) — text
  • Field (price) — char(15)
  • Field (releasedDate) — date
  • Field (description) — char(30)
  • Field

Untitled (PRODUCER)

  • Key (modelNO) — char(15) — 기본 키 — NOT NULL
  • Field (name) — char
  • Field (address) — char
  • Field (phone) — char

Untitled (PART)

  • Key (partNO) — char(15) — 기본 키 — NOT NULL
  • Field
  • Key (catID) — char(10) — 외래 키 → Untitled.Key — NOT NULL
  • Key (SUPID) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PROPART)

  • Key (propartID) — char(7) — 기본 키 — NOT NULL
  • Key (partNO) — char(15) — 외래 키 → Untitled.Key — NOT NULL
  • Field (qty) — char

Untitled (CATEGORY)

  • Key (catID) — char(10) — 기본 키 — NOT NULL
  • Field (name) — char(20)
  • Field (description) — text

Untitled (SUPPLIER)

  • Key (SUPID) — char(30) — 기본 키 — NOT NULL
  • Field