데이터베이스

테이블 (4)

Untitled (Company)

  • Key (companyID) — int — 기본 키 — NOT NULL
  • Field (companyName) — char
  • Field (companyPNumber) — int(11)
  • Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Producer)

  • Key (ProducerNumber) — int — 기본 키 — NOT NULL
  • Field (producerName) — char
  • Field (producerAddress) — char
  • Field (producerPNumber) — int((11)
  • Key (companyID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Component)

  • Key (componentNumber) — int — 기본 키 — NOT NULL
  • Field (componentExp) — text
  • Key (ProducerNumber) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (productNumber) — int — 외래 키 → Untitled2.Key — NOT NULL

Untitled2 (Product)

  • Key (productNumber) — int — 기본 키 — NOT NULL
  • Field (productExp) — text
  • Field (productPrice) — int
  • Key (companyID) — int — 외래 키 → Untitled.Key — NOT NULL
  • Key (componentNumber) — int — 외래 키 → Untitled.Key — NOT NULL