Exercise7

Tables (5)

SHOES (PRODUCT)

  • Key (productCode) — Primary key — NOT NULL
  • Field (productName)
  • Field (productPrice)
  • Field (description)
  • Field (picture)

Untitled (PROVIDER)

  • Key (provId) — Primary key — NOT NULL
  • Field (provDate)

Untitled (PRODUCT_CATEGORY)

  • Key (productCode) — Foreign key → SHOES.Key — NOT NULL
  • Key (provId) — Foreign key → Untitled.Key — NOT NULL

Untitled (CUSTOMER)

  • Key (customId) — Primary key — NOT NULL
  • Field (customName)
  • Field (customAddress)
  • Field (customPhone)
  • Field (customGender)

Untitled (PRODUCT_PURCHASE)

  • Key (productCode) — Foreign key → SHOES.Key — NOT NULL
  • Key (customId) — Foreign key → Untitled.Key — NOT NULL
  • Field (purchaseDate)
  • Field (purchaseCnt)