Exercise1-배미연

테이블 (4)

Part (Untitled2)

  • PartId (Key) — char(4) — 기본 키 — NOT NULL
  • PartName (Field) — char(10)
  • Description (Field2) — longtext
  • Price (Field3) — int
  • Field4
  • SupplierId (Key2) — char(4) — 외래 키 → Supplier.SupplierId — NOT NULL

Product (Untitled)

  • ProductId (Key) — char(4) — 기본 키 — NOT NULL
  • ProductName (Field) — char(10)
  • ProductPrice (Field2) — char(10)
  • ReleaseDate (Field3) — date

Product_Part (Untitled4)

  • PartId (Key2) — char(4) — 외래 키 → Part.PartId — NOT NULL
  • ProductId (Key3) — char(4) — 외래 키 → Product.ProductId — NOT NULL
  • PartId (Field) — char(4)
  • Quantity (Field2) — int(8)

Supplier (Untitled3)

  • SupplierId (Key) — char(4) — 기본 키 — NOT NULL
  • SupplierName (Field) — char(10)
  • address (Field2) — char(30)
  • email (Field3) — char(30)
  • Phone (Field4) — char(10)