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)