Database Schema

Users

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

Photos

column name	data type	details
id	integer	not null, primary key
title	string
caption	string
userId	int	not null
albumId	int	not null
createdAt	timestamp	not null
updatedAt	timestamp	not null

• userId references Users table

Albums

column name	data type	details
id	integer	not null, primary key
name	string	not null
userId	int	not null
createdAt	timestamp	not null
updatedAt	timestamp	not null

• userId references Users table

Comments

column name	data type	details
id	integer	not null, primary key
body	string	not null
userId	int	not null
photoId	int	not null
createdAt	timestamp	not null
updatedAt	timestamp	not null

• userId references Users table
• photoId references Photos table

Tags

column name	data type	details
id	integer	not null, primary key
name	string	not null
photoId	int	not null
createdAt	timestamp	not null
updatedAt	timestamp	not null

• photoId references Photos table