Database Schema - miguelalvinflores/sacTownMunch GitHub Wiki

User

Column Name Data Type Details
id integer not null, primary key
username string not null, unique
email string not null, indexed, unique
profile_pic_url string
hashedPW string not null
created_at datetime not null
updated_at datetime not null
  • index on email, unique : true

Restaurant

Column Name Data Type Details
id integer not null, primary key
restaurant_name string not null, unique
photo_url string
summary string not null,
full_desciption text not null
owner_id integer not null, foreign key
created_at datetime not null
updated_at datetime not null
  • owner_id references users table

Reservation

Column Name Data Type Details
id integer not null, primary key
user_id integer not null, foreign key
restaurant_id integer not null, foreign key
date datetime not null
number_of_people integer not null
created_at datetime not null
updated_at datetime not null
  • user_id references users table
  • restaurant_id references restaurants table

Rating

Column Name Data Type Details
id integer not null, primary key
comment text not null
rating integer default zero, not null
user_id integer not null
restaurant_id integer not null, foreign key
date datetime not null
created_at datetime not null
updated_at datetime not null
  • user_id references users table
  • restaurant_id references restaurants table

Favorite

Column Name Data Type Details
id integer not null, primary key
user_id string not null, foreign key
restaurant_id string not null, foreign key
created_at datetime not null
updated_at datetime not null
  • user_id references users table
  • restaurant_id references restaurants table