Followers and Follow Requests

[LeoBorai]

Users must be able to choose who is able to access their posts and follow
other users whose content is of interest. To achieve this a Followers system
with a Follow Request could be provided which enables support to send
Follow Requests which the Followee must approve, decline or ignore.

A first version could be a table which holds follower, followee and a flag
for request confirmation.

Is important to note that a notification system would be required at some
point to provide better UX.

Database Diagram

-- https://app.quickdatabasediagrams.com/#/

User
-
id PK UUID
name VARCHAR(60)
last_name VARCHAR(60)
email VARCHAR(254) UNIQUE
username VARCHAR(120) UNIQUE
password_hash VARCHAR(120)
followers INTEGER
following INTEGER
gender GENDER
pronoun PRONOUN
custom_gender NULLABLE VARCHAR
birthdate TIMESTAMPTZ
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ

Followers
-
id PK UUID
follower_id UUID FK - User.id
followee_id UUID FK - User.id
request_state REQUEST_STATE
created_at TIMESTAMPTZ
updated_at TIMESTAMPTZ

[LeoBorai]

@Dave136 your comments here would be appreciated!

[Dave136]

@EstebanBorai which is the difference between follower_id and followee_id ?

[LeoBorai]

@EstebanBorai which is the difference between follower_id and followee_id ?

follower_id is the UUID belonging to the user who follows another user (Followee).
followee_id is the UUID belonging to the user who is being followed.

In an example, if I send a request to follow you, then I would be the Follower and the follower_id
would be my user id, by the same token you would be the Followee who's ID will remain as the followee_id.

[Dave136]

Good, i undertand.

I agree with this feature! 😄