Database Schema

Users

---

column name	data type	details
id	integer	not null, primary key
userName	string	not null, unique
email	string	not null, unique
hashedassword	string	not null

Comments

---

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
imageId	integer	not null
comment	string	not null

• userId references Users table

Images

---

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
imageUrl	text	not null
title	string	not null

• userId references Users table

Albums

---

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, foreign key
imageId	integer	not null, foreign key
favorited	boolean	not null

• userId references Users table
• imageId references Images table