[New feature] Friends and Friendship System

[xXPinkmagicXx]

It would be very nice if you could have friends in Zeeguu.

The features could include

• See and add friends
• Sending articles to friends (in a language they are learning)
• Send new words to a friend
• See a friends progress/points/score. Possibly also a friends leaderboard.

[xXPinkmagicXx]

Option 1

classDiagram

class Single_Table {
    id: int
    requester_id
    addressee_id
    status : enum
    created_at : Datetime
    updated_at : Datetime
}

Loading

Option 2

classDiagram
class Denormalized_Friends_Table {
    user_id
    friend_id
    created_at
}

class friend_requests {
    id
    sender_id
    receiver_id
    status
    created_at
    responded_at
}

Loading

[gabortodor]

For this feature to work, we’ll also need to introduce usernames (possibly auto-generated) and consider what data can and cannot be shown on a public ‘profile’ page