todayEat

Tables (5)

Locations (locations)

  • location Id (location_id) — INT — Primary key — NOT NULL
  • restaurant Id (restaurant_id) — INT — Primary key — NOT NULL
  • address — VARCHAR(255)
  • latitude — FLOAT
  • longitude — FLOAT

Menus (menus)

  • restaurant Id (restaurant_id) — INT — Primary key — NOT NULL
  • menu Id (menu_id) — INT — Primary key — NOT NULL
  • menu Name (menu_name) — VARCHAR(255)
  • price — INT(100000)
  • description — VARCHAR(255)

Ratings (ratings)

  • user Id (user_id) — INT — Primary key — NOT NULL
  • restaurant Id (restaurant_id) — INT — Primary key — NOT NULL
  • rating — FLOAT
  • review — VARCHAR(255)

Restaurants (restaurants)

  • restaurant Id (restaurant_id) — INT — Primary key
  • restaurant Name (restaurant_name) — VARCHAR(255)
  • Location (location) — VARCHAR(255)
  • operating Hours (operating_hours) — TIME
  • average Rating (average_rating) — FLOAT

User Preferences (user_preferences)

  • user Id (user_id) — INT — Primary key — NOT NULL
  • cuisine Type (cuisine_type) — VARCHAR(255)
  • meal Time (meal_time) — TIME
  • price Range (price_range) — INT(100000)