es(5)

Tables (7)

customer (Untitled7)

  • customerNumber (Key) — Primary key — NOT NULL
  • name (Field)
  • adress (Field2)
  • phone (Field3)

customersales (Untitled6)

  • customerId (Key) — Primary key — NOT NULL
  • shoesId (Field)
  • salespersonId (Field2)
  • purchaseDate (Field3)
  • purchaseQuantity (Field4)
  • productCode (Key2) — Foreign key → shoes.productCode — NOT NULL
  • employeeNumber (Key3) — Foreign key → salesPerson.employeeNumber — NOT NULL
  • customerNumber (Key4) — Foreign key → customer.customerNumber — NOT NULL

department (Untitled2)

  • smployeeNumber (Key) — Primary key — NOT NULL
  • stockQuantity (Field)
  • shoesStyle (Field2)
  • shoesSize (Field3)
  • shoesColor (Field4)
  • productCode (Key2) — Foreign key → supplies.productCode — NOT NULL

quota (Untitled4)

  • employeeNumber (Key) — Primary key — NOT NULL
  • salesCommisson (Field)
  • employeeNumber (Key2) — Foreign key → salesPerson.employeeNumber — NOT NULL

salesPerson (Untitled3)

  • employeeNumber (Key) — Primary key — NOT NULL
  • salesPersonID (Field)
  • smployeeNumber (Key2) — Foreign key → department.smployeeNumber — NOT NULL

shoes (Untitled5)

  • productCode (Key) — Primary key — NOT NULL
  • shoesStyle (Field)
  • shoesSize (Field2)
  • shoesColor (Field3)
  • productCode (Key2) — Foreign key → supplies.productCode — NOT NULL

supplies (Untitled)

  • productCode (Key) — Primary key — NOT NULL
  • supplierCode (Field)