2024.04. ex1

Tables (5)

Parts

  • Key (Pa ID) — char(20) — Primary key — NOT NULL
  • Field (descrition) — text
  • Field (name) — char(20)
  • Field (model number) — char(30)
  • Key (sup ID) — int(20) — Foreign key → Supplier.Key — NOT NULL
  • Key (CateID) — int(5) — Foreign key → Untitled.Key — NOT NULL

Product

  • Key (pro ID) — char(10) — Primary key — NOT NULL
  • Field (descrition) — text
  • Field (price) — int(20)
  • Field (proname) — char(20)

Supplier

  • Key (sup ID) — int(20) — Primary key — NOT NULL
  • Field (name) — char(20)
  • Field (add) — char(10)
  • Field (Phone) — char(11)
  • Field (email) — email
  • Field (descrition) — text

Untitled (Category)

  • Key (CateID) — int(5) — Primary key — NOT NULL
  • Field (CateName) — Char(20)
  • Field (Descrition) — text

Untitled4 (Product Parts)

  • Key (Pa ID) — char(20) — Foreign key → Parts.Key — NOT NULL
  • Key (pro ID) — char(10) — Foreign key → Product.Key — NOT NULL
  • Field (quantity) — int(3)