Skip to content

Database Model: Friendship

Chris Suleiman edited this page Apr 25, 2020 · 1 revision

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)

Clone this wiki locally