DB Schema

• https://dbdiagram.io/d/6268779e95e7f23c617b522e

Database Schema

Users

---

column name	data type	details
id	integer	not null, primary key
user_name	string	not null, unique
email	string	not null, unique
hashed_password	string	not null

Photos

---

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

• user_id references Users table

Comments

---

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, foreign key
photo_id	integer	not null, foreign key
comment	string	not null

• user_id references Users table
• photo_id references Photos table

Favorites

---

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, foreign key
photo_id	integer	not null, foreign key

• user_id references Users table
• photo_id references Photos table

Albums

---

column name	data type	details
id	integer	not null, primary key
user_id	integer	not null, foreign key
title	string	not null, foreign key

• user_id references Users table

Photo in Albums

---

column name	data type	details
photo_id	integer	not null, foreign key
album_id	integer	not null, foreign key

• photo_id references Photos table
• album_id references Albums table

Tags

---

column name	data type	details
id	integer	not null, foreign key
tag_name	string	not null, foreign key

Tagged Photos

---

column name	data type	details
tag_id	integer	not null, primary key
photo_id	integer	not null, foreign key

• tag_id references Tags table
• photo_id references Photos table

Follows

---

column name	data type	details
followed_id	integer	not null, foreign key
follower_id	integer	not null, foreign key

• followed_id references Users table
• follower_id references Users table