Database Schema

Users

Column Name	Column Type	Constraints
id	integer	primary key, not null,
username	string	not null, unique
firstName	string	not null
lastName	string	not null
email	string	not null, unique
hashedPassword	string	not null
bio	string
profilePic	string
private	boolean	not null
created_at	datetime	not null
updated_at	datetime	not null

Follows

Column Name	Column Type	Constraints
id	integer	primary key, not null
followerId	integer	not null
followedId	integer	not null
created_at	datetime	not null
updated_at	datetime	not null

Images

Column Name	Column Type	Constraints
id	integer	primary key, not null
userId	integer	not null
imageUrl	string	not null
caption	string
created_at	datetime	not null
updated_at	datetime	not null

Comments

Column Name	Column Type	Constraints
id	integer	primary key, not null
userId	integer	not null
imageId	integer	not null
comment	string
created_at	datetime	not null
updated_at	datetime	not null

Likes

Column Name	Column Type	Constraints
id	integer	primary key, not null
imageId	integer
userId	integer
created_at	datetime	not null
updated_at	datetime	not null

Chatrooms

Column Name	Column Type	Constraints
id	integer	primary key, not null
name	string
created_at	datetime	not null
updated_at	datetime	not null

Dms

Column Name	Column Type	Constraints
id	integer	primary key, not null
chatroomId	integer	not null
userId	integer	not null
message	string	not null
created_at	datetime	not null
updated_at	datetime	not null

UsersJoin

Column Name	Column Type	Constraints
id	integer	primary key, not null
userId	integer	not null
chatroomId	integer	not null
created_at	datetime	not null
updated_at	datetime	not null