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