DB Schema

Link to Database: dbdiagram

Users

column name	data type	details
id	integer	not null, primary key
username	string	not null, unique
email	string	not null, unique
hashed_password	string	not null
first_name	string	not null
last_name	string	not null
profile_pic	string	not null

Posts

column name	data type	details
id	integer	not null, primary key
user_id	int	not null, foreign key
caption	text

Post_likes

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

Photos

column name	data type	details
id	integer	not null, primary key
photo	string	not null
post_id	integer	not null, foreign key

Comments

column name	data type	details
id	integer	not null, primary key
comment	text	not null
user_id	integer	not null, foreign key
post_id	integer	not null, foreign key