Database Schema

Tables:

users: name, email, password_hash

restaurants: name, location

openings: restaurant_id, opening_time, closing_time, day_of_week

comments: user_id, restaurant_id, comment

rating: user_id, restaurant_id, rating (1-5)