ex5

Tables (8)

color (Untitled6)

  • colorid (Key) — char(5)_ — Primary key — NOT NULL
  • description (Field) — text

customer (Untitled3)

  • customerid (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(13)
  • phone (Field2) — char(11)
  • address (Field3) — text
  • gender (Field4) — char(5)
  • birth (Field5) — date
  • description (Field6) — text

employee (Untitled4)

  • employeeid (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(13)
  • phone (Field2) — char(11)

sale (Untitled8)

  • saleid (Key) — char(10) — Primary key — NOT NULL
  • shoesid (Key2) — char(5) — Foreign key → shoes.shoesid — NOT NULL
  • sizeid (Key22) — char(5) — Foreign key → shoes.sizeid — NOT NULL
  • styleid (Key3) — char(5) — Foreign key → shoes.styleid — NOT NULL
  • colorid (Key4) — char(5) — Foreign key → shoes.colorid — NOT NULL
  • employeeid (Key5) — char(10) — Foreign key → employee.employeeid — NOT NULL
  • customerid (Key6) — char(10) — Foreign key → customer.customerid — NOT NULL
  • date (Field) — date
  • quantity (Field2) — integer

shoes (Untitled)

  • shoesid (Key) — char(5) — Primary key — NOT NULL
  • sizeid (Key2) — char(5) — Foreign key → size.sizeid — NOT NULL
  • styleid (Key3) — char(5) — Foreign key → style.styleid — NOT NULL
  • colorid (Key4) — char(5)_ — Foreign key → color.colorid — NOT NULL
  • supplierid (Key5) — char(10) — Foreign key → supplier.supplierid — NOT NULL
  • stock (Field) — integer

size (Untitled5)

  • sizeid (Key) — char(5) — Primary key — NOT NULL
  • description (Field) — text

style (Untitled7)

  • styleid (Key) — char(5) — Primary key — NOT NULL
  • description (Field) — text

supplier (Untitled2)

  • supplierid (Key) — char(10) — Primary key — NOT NULL
  • name (Field) — char(13)
  • phone (Field2) — char(11)
  • quality (Field3) — char(5)
  • description (Field4) — text