exercise5
Tables (6)
CUSTOMER (Untitled5)
- customerId (Key) — char(5) — Primary key — NOT NULL
- customerName (Field) — char(30)
- customerAddress (Field2) — text
- customerPhone (Field3) — char(11)
SALESMAN (Untitled6)
- employeeNumber (Key) — char(5) — Primary key — NOT NULL
- salesCommission (Field) — float(2.1)
- salesQuota (Field2) — char(5)
SHOESLIST (Untitled2)
- shoesProductCode (Key) — char(5) — Primary key — NOT NULL
- deliveryDate (Field) — date
- availableStock (Field3) — int(5)
SUPPLIER (Untitled)
- supplierId (Key) — char(5) — Primary key — NOT NULL
- supplydata (Field) — date
ShoesSales (Untitled4)
- buyingHabitsType (Field) — char(1)
- salesDate (Field2) — date
- salesQuantity (Field3) — char(3)
- transactionType (Field4) — char(1)
- customerId (Key) — char(5) — Foreign key → CUSTOMER.customerId — NOT NULL
- shoesProductCode (Key2) — char(5) — Foreign key → SHOESLIST.shoesProductCode — NOT NULL
- employeeNumber (Key3) — char(5) — Foreign key → SALESMAN.employeeNumber — NOT NULL
ShoesSupply (Untitled3)
- shoesStyle (Field) — char(10)
- shoesSize (Field2) — char(3)
- shoesColor (Key) — char(10) — NOT NULL
- shoesamount (Field3) — int(5)
- supplierId (Key2) — char(5) — Foreign key → SUPPLIER.supplierId — NOT NULL
- shoesProductCode (Key3) — char(5) — Foreign key → SHOESLIST.shoesProductCode — NOT NULL