Exe1복습

테이블 (5)

Manufacturers (Untitled2)

  • ManufacturerID (Key) — int — 기본 키 — NOT NULL
  • ManufacturerName (Field) — char(30)
  • ManufacturerADD (Field2) — longtext
  • ManufacturerPhone (Field3) — int
  • ManufactuerCredit (Field4) — int(1)
  • ManufactuerEmail (Field5) — char(30)

Parts (Untitled)

  • partID (Key) — int — 기본 키 — NOT NULL
  • partDes (Field) — longtext
  • price (Field2) — int
  • ModelName (Field3) — char(20)
  • PartName (Field4) — char(30)
  • ManufacturerID (Key2) — int — 외래 키 → Manufacturers.ManufacturerID — NOT NULL
  • PartsCategoryID (Key3) — 외래 키 → PartsCategory.PartsCategoryID — NOT NULL

PartsCategory (Untitled5)

  • PartsCategoryID (Key) — 기본 키 — NOT NULL
  • CategoryName (Field)

ProductPart (Untitled4)

  • ProductPartID (Key) — int — 기본 키 — NOT NULL
  • productID (Key4) — int — 외래 키 → Products.productID — NOT NULL
  • partID (Key2) — int — 외래 키 → Parts.partID — NOT NULL
  • Quantity (Field) — int

Products (Untitled3)

  • productID (Key) — int — 기본 키 — NOT NULL
  • ModelName (Field) — char(20)
  • PartName (Field2) — char(20)
  • productDes (Field3) — longtext
  • price (Field4) — int(10)