ex_5
Tables (4)
CUSTOMERS (Untitled2)
- CustomerId (Key) — char(8) — Primary key — NOT NULL
- ShoesCode (Key2) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- SupId (Key22) — char(6) — Foreign key → SHOES.SupId — NOT NULL
- ShoesCode (Key222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- CustomerId (Key3) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- CustomerId (Key24) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- ShoesCode (Key223) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- SupId (Key2223) — char(6) — Foreign key → SHOES.SupId — NOT NULL
- ShoesCode (Key22223) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- CustomerId (Key33) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- SPId (Key4) — char(6) — Foreign key → SALESPERSON.SPId — NOT NULL
- CustomerId (Key23) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
- ShoesCode (Key224) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
- SupId (Key2222) — char(6) — Foreign key → SALESPERSON.SupId — NOT NULL
- ShoesCode (Key22222) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
- CustomerId (Key32) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
- CustomerNumber (Field) — char(6)
- CustomerName (Field2) — char(4)
- ChustomerAddress (Field3) — char(10)
- CustomerPhoneNumber (Field4) — char(8)
- CustomerBuyingHabits (Field5) — char(12)
SALESPERSON (Untitled4)
- SPId (Key) — char(6) — Primary key — NOT NULL
- CustomerId (Key2) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- ShoesCode (Key22) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- SupId (Key222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
- ShoesCode (Key2222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- CustomerId (Key3) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- SPId (Key4) — char(6) — Foreign key → CUSTOMERS.SPId — NOT NULL
- CustomerId (Key23) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- ShoesCode (Key224) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- SupId (Key22222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
- ShoesCode (Key222222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- CustomerId (Key32) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- SalesCommission (Field) — char(4)
- SalesDegree (Field2) — char(4)
- SalesQuota (Field3) — char(8)
SHOES (Untitled)
- ShoesCode (Key) — char(8) — Primary key — NOT NULL
- SupId (Key2) — char(6) — Foreign key → SUPPLIER.SupId — NOT NULL
- ShoesCode (Key22) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
- CustomerId (Key3) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- ShoesCode (Key23) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- SupId (Key222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
- ShoesCode (Key2222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- CustomerId (Key32) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- CustomerId (Key24) — char(8) — Foreign key → SUPPLIER.CustomerId — NOT NULL
- ShoesCode (Key223) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
- SupId (Key2223) — char(6) — Foreign key → SUPPLIER.SupId — NOT NULL
- ShoesCode (Key22223) — char(8) — Foreign key → SUPPLIER.ShoesCode — NOT NULL
- CustomerId (Key33) — char(8) — Foreign key → SUPPLIER.CustomerId — NOT NULL
- SPId (Key4) — char(6) — Foreign key → CUSTOMERS.SPId — NOT NULL
- CustomerId (Key232) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- ShoesCode (Key224) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- SupId (Key22222) — char(6) — Foreign key → CUSTOMERS.SupId — NOT NULL
- ShoesCode (Key222222) — char(8) — Foreign key → CUSTOMERS.ShoesCode — NOT NULL
- CustomerId (Key322) — char(8) — Foreign key → CUSTOMERS.CustomerId — NOT NULL
- ShoeStyle (Field) — char(10)
- ShoeSize (Field2) — char(3)
- ShoeColor (Field3) — char(6)
SUPPLIER (Untitled3)
- SupId (Key) — char(6) — Primary key — NOT NULL
- ShoesCode (Key2) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- SupId (Key22) — char(6) — Foreign key → SHOES.SupId — NOT NULL
- ShoesCode (Key222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- CustomerId (Key3) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- ShoesCode (Key23) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- SupId (Key2222) — char(6) — Foreign key → SHOES.SupId — NOT NULL
- ShoesCode (Key22222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- CustomerId (Key32) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- SPId (Key42) — char(6) — Foreign key → SHOES.SPId — NOT NULL
- CustomerId (Key232) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- ShoesCode (Key224) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- SupId (Key222222) — char(6) — Foreign key → SHOES.SupId — NOT NULL
- ShoesCode (Key2222222) — char(8) — Foreign key → SHOES.ShoesCode — NOT NULL
- CustomerId (Key322) — char(8) — Foreign key → SHOES.CustomerId — NOT NULL
- SPId (Key4) — char(6) — Foreign key → SALESPERSON.SPId — NOT NULL
- CustomerId (Key24) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL
- ShoesCode (Key223) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
- SupId (Key2223) — char(6) — Foreign key → SALESPERSON.SupId — NOT NULL
- ShoesCode (Key22223) — char(8) — Foreign key → SALESPERSON.ShoesCode — NOT NULL
- CustomerId (Key33) — char(8) — Foreign key → SALESPERSON.CustomerId — NOT NULL