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