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)