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

user_id references users table

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

user_id references users table post_id references posts table

Photos

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

post_id references posts table

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

user_id references users table post_id references posts table

Followers

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

user_id references users table follower references users table