Database Schema

Users

column name	data type	details
id	integer	not null, primary key
firstname	string	not null
lastname	string	not null
username	string	not null, unique
email	string	not null, unique
hashedPassword	string	not null
profilePicture	string
createdAt	datetime	not null
updatedAt	datetime	not null

Followers

column name	data type	details
id	integer	not null, primary key
followerId	integer	not null, unique
followedId	integer	not null, unique
createdAt	datetime	not null
updatedAt	datetime	not null

followerId references Users.id followedId references Users.id

Likes

column name	data type	details
id	integer	not null, primary key
userId	integer	not null, unique
postId	integer	not null, unique
createdAt	datetime	not null
updatedAt	datetime	not null

userId references Users.id postId references Posts.id

Comments

column name	data type	details
id	integer	not null, primary key
userId	integer	not null
postId	integer	not null
description	text	not null
createdAt	datetime	not null
updatedAt	datetime	not null

userId references Users.id postId references Posts.id

Posts

column name	data type	details
id	integer	not null, primary key
userId	integer	not null
description	text
content	text	not null
createdAt	datetime	not null
updatedAt	datetime	not null

userId references Users.id