5주차

테이블 (6)

COMPANY

  • Key (compID) — int(15) — 기본 키 — NOT NULL
  • Field (compName) — char(15)
  • Field (compAddress) — char(15)
  • Field (pdtcompPH) — int(12)

COMPONENT

  • Key (compoID) — int(15) — 기본 키 — NOT NULL
  • Field (compoExpianation) — long text
  • Field (compoName) — char(30)
  • Field (compomodelName) — char(20)
  • Key (categoryID) — int(10) — 외래 키 → COMPONENT CATEGORY.Key — NOT NULL
  • Key (prodID) — int(15) — 외래 키 → PRODUCTOR.Key — NOT NULL

COMPONENT CATEGORY (.)

  • Key (categoryID) — int(10) — 기본 키 — NOT NULL
  • Field (categoryName) — char(20)

MAKE

  • Key (prdNumber) — int(15) — 외래 키 → PRODUCT.Key — NOT NULL
  • Key (compoID) — int(15) — 외래 키 → COMPONENT.Key — NOT NULL
  • Field (amount) — int

PRODUCT

  • Key (prdNumber) — int(15) — 기본 키 — NOT NULL
  • Field (prdtExpianation) — text
  • Field (prdtPrice) — int
  • Field (prdtName) — char(30)
  • Field (prdtmodelName) — char(30)

PRODUCTOR

  • Key (prodID) — int(15) — 기본 키 — NOT NULL
  • Field (prodName) — char(15)
  • Field (prodAddress) — char(15)
  • Field (prodPH) — int(12)
  • Field (prodEmail) — char(30)
  • Field (prodExpianation) — long text