db

Tables (3)

Dessert

  • dessert_id — INT — Primary key
  • dessert_name — VARCHAR(100)
  • description — TEXT
  • price — DECIMAL(10, 2)

DessertSale

  • DessertSale_id (dessert_id) — INT — Primary key
  • store_id — INT — Foreign key → Store.store_id
  • dessert_id (dessert_id2) — INT — Foreign key → Dessert.dessert_id
  • stock_quantity — INT

Store

  • store_id — INT — Primary key
  • store_name — VARCHAR(100)
  • location — VARCHAR(255)