Database Model: Friendship

Friendship Model

Properties

• requesterID: ID of user who originally sent friend request
• addresseeID: ID of user who received friend request
• friendshipStatus: integer representing current status of friendship (0 = blocked, 1 = pending, 2 = friends)

Associations/References

Both requesterID and addresseeID are foreign keys referring to userID in Users model.
Primary key of this model is (requesterID, addresseeID)