Schema

Users

ColumnName	DataType	Details
id	integer	not null, primary key
Name	string	not null
Email	string	unique, not null, indexed
Bio	text
HashedPassword	string.binary	not null
Avatar	string
createdAt	timestamp	not null
updatedAt	timestamp	not null

Checkins

ColumnName	DataTyoe	Details
id	integer	not null, primary key
userId	integer	foreign key
shopId	integer	foreign key
bagelId	integer	foreign key
review	text
rating	integer
image	varcharacter
createdAt	timestamp
updatedAt	timestamp

BagelShops

Bagels