exercise_5
Tables (10)
CUSTOMER (Untitled3)
- customerCode (Key) — char(15) — Primary key — NOT NULL
- customerName (Field) — char(20)
- customerAddress (Field2) — text
- customerPhone (Field3) — char(15)
- customerDescription (Field4) — text
IS_PURCHASED (Untitled4)
- shoesCode (Key2) — char(10) — Foreign key → SHOES.shoesCode — NOT NULL
- customerCode (Key3) — char(15) — Foreign key → CUSTOMER.customerCode — NOT NULL
- salespersonCode (Key) — char(15) — Foreign key → SALESPERSON.salespersonCode — NOT NULL
- purchasedDate (Field) — date
- purchasedQuantity (Field2) — int
PROVIDER (Untitled2)
- providerCode (Key) — char(15) — Primary key — NOT NULL
- providerName (Field)
SALESPERSON (Untitled5)
- salespersonCode (Key) — char(15) — Primary key — NOT NULL
- salespersonName (Field) — char(20)
- salary (Field2) — char(30)
SHOES (Untitled)
- shoesCode (Key) — char(10) — Primary key — NOT NULL
- shoesStyle (Field) — char(20)
- shoesSize (Field2) — char(2)
- shoesColor (Field3) — char(10)
- shoesStock (Field4) — int
- providerCode (Key2) — char(15) — Foreign key → PROVIDER.providerCode — NOT NULL
SHOES (Untitled6)
- shoesCode (Key) — char(10) — Primary key — NOT NULL
- colorCole (Key2) — char(10) — Foreign key → color.colorCole — NOT NULL
- size (Key3) — int — Foreign key → size.size — NOT NULL
- styleCode (Key4) — char(10) — Foreign key → style.styleCode — NOT NULL
- count (Field) — int
- providerCode (Key5) — char(13) — Foreign key → provider.providerCode — NOT NULL
color (Untitled9)
- colorCole (Key) — char(10) — Primary key — NOT NULL
provider (Untitled10)
- providerCode (Key) — char(13) — Primary key — NOT NULL
size (Untitled8)
- size (Key) — int — Primary key — NOT NULL
style (Untitled7)
- styleCode (Key) — char(10) — Primary key — NOT NULL
- Field