Database Schema

Users

column name	data type	details
id	integer	not null, primary key
username	string	not null, unique
email	string	not null, unique
icon	string
hashedPassword	string	not null

Restaurants

column name	data type	details
id	integer	not null, primary key
ownerId	integer	not null, foreign key
title	string(100)	not null
phone	string(20)	not null
description	textarea	not null
address	string(100)	not null
city	string(50)	not null
state	string(50)	not null
zipCode	string(20)	not null
lat	decimal
lng	decimal

• ownerId references Users Table, One user can have many restaurants.

Bookings

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
restaurantId	integer	not null, foreign key
size	integer	not null
startDate	integer	not null
startTime	integer	not null

• userId references Users table
• restaurantId references Restaurants table
• many to many relationship, many users can make many reservations.

Reviews

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
restaurantId	integer	not null, foreign key
answer	string	not null
liked	boolean

• userId references Users table
• restaurantId references Restaurants table
• many to many relationship, many users can make many reviews.

bookmarks

column name	data type	details
userId	integer	not null, foreign key
restaurantId	integer	not null, foreign key

• userId references Users table
• restaurantId references Restaurants table
• many to many relationship, many users can bookmark many restaurants.

cuisines

column name	data type	details
id	integer	not null, primary key
cuisineType	string	not null
restaurantId	integer	not null, foreign key

• restaurantId references Restaurants table
• one to many relationship, one restaurant can have many cuisine type

images

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
restaurantId	integer	not null, foreign key
imgUrl	string	not null

• userId references Users table
• restaurantId references Restaurants table
• many to many relationship, many users can post many picture.

ratings

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
restaurantId	integer	not null, foreign key
rating	float	not null

• userId references Users table
• restaurantId references Restaurants table
• many to many relationship, many users can rate many restaurants.