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)