SnackSpotter
Tables (7)
EventDiscount
- EventDiscountID — Integer — Primary key — NOT NULL
- Title — String
- Description — Text
- StartDate — Date
- ExpiryDate — Date
- SnackID — Integer — Foreign key → Snack.SnackID — NOT NULL
Order
- OrderID — Integer — Primary key — NOT NULL
- Quantity — Integer
- TotalPrice — Decimal
- OrderDate — Date
- DeliveryStatus — String
- UserID — Integer — Foreign key → User.UserID — NOT NULL
- SnackID — Integer — Foreign key → Snack.SnackID — NOT NULL
Recommendation
- RecommendationID — Integer — Primary key — NOT NULL
- RecommendationScore — Integer
- UserID — Integer — Foreign key → User.UserID — NOT NULL
- SnackID — Integer — Foreign key → Snack.SnackID — NOT NULL
Review
- ReviewID — Integer — Primary key — NOT NULL
- Username — String
- UserID — Integer — Foreign key → User.UserID — NOT NULL
- SnackID — Integer — Foreign key → Snack.SnackID — NOT NULL
- Rating — Integer
- Comment — Text
- Date — Date
Snack
- SnackID — Integer — Primary key — NOT NULL
- Name — String
- Description — Text
- Image — String
- Price — Decimal
- StoreID — Integer — Foreign key → Store.StoreID — NOT NULL
Store
- StoreID — Integer — Primary key — NOT NULL
- Name — String
- Location — String
- InventoryStatus — ENUM
- SnackID — Integer — Foreign key → Snack.SnackID — NOT NULL
User
- UserID — Integer — Primary key — NOT NULL
- Username — String
- Email — String
- Password — String
- Gender — ENUM
- Birthday — Date