Before we can connect to a user as a friend, we need to define the types of relationship our social network will support. Within Dino Space, we should have relationships for:
We may, of course, wish to extend this as the site grows and changes as time goes on.
To facilitate these relationships we are going to need two database tables, one to maintain a list of types of relationships, and one to maintain a list of relationships between users.
To represent the relationship types in the database, we could use the following ...