제품데이터

테이블 (4)

Untitled (part)

  • Key (number) — char(30) — 기본 키 — NOT NULL
  • Field (explain) — char(30)
  • Key (number2) — char(30) — 외래 키 → Untitled.Key — NOT NULL

Untitled (PRODUT)

  • Key (ID) — char(30) — 기본 키 — NOT NULL
  • Field (releasedDate) — date
  • Field (price) — int(10)
  • Field (category) — char(30)
  • Field2 (name) — char(30)

Untitled (supplier)

  • Key (number) — char(30) — 기본 키 — NOT NULL
  • Field (name) — char(30)
  • Field (address) — char(30)
  • Field (phone) — char(30)
  • Field (fax) — char(30)
  • Field (grade) — text

Untitled (part-preduct)

  • Key (ID) — char30) — 외래 키 → Untitled.Key — NOT NULL
  • Key (number3) — char(30) — 외래 키 → Untitled.Key — NOT NULL
  • Field (quartity) — int(10)