We use cookies on this site to enhance your user experience

By clicking the Accept button, you agree to us doing so. More info on our cookie policy

Create a social network with 4 models

Published: Jul 25, 2020 by C.S. Rhymes

When you think about defining the database for a social network you will probably think it’s going to involve hundreds of tables and complex relationships. This doesn’t have to be the case. This article explains how you can create a social network with just 4 models.

The 4 models we are going to use are User, Post, Follower and Like.

Post

The post model will contain the content the user wants to share or post on the social network. What type of content you want to store will affect what fields you need, but for this example we just want to store some text.

The post needs to belong to a user, so we will store the user id in the post as well.

A post can have many replies or comments so you may think we need another model to store comments, but if your social network was like twitter, then a comment or reply is also a tweet in its own right so you could then get away with having 4 models. We could store a reply as a post, but also store a parent id to define the relationship to the original post. This also means that by using the same logic, a reply can also have a reply.

Post relationships

  • A post belongs to a user.
  • A post has many comments/replies.
  • A post can belong to another post

Follower

A user can follow other users. This will determine what content is displayed in their feed. If you follow another user, you then become one of their followers.

We can create a Follower model which can be used to store both the follower and following relationship at the same time. This can be done with a many to many relationship that goes from the User model to the Followers model and back to the User model. The follower table will store a user_id and a follower_id, but both will point to the users table.

Follower relationships

  • A user has many followers
  • A user follows many users

Like

A user creates a post and you see it in your feed and you want to say you like the post to give some positive feedback to the user. Likes are similar to followers in that they have an inverse of the relationship too. A post has likes from users, but a user also has posts they like.

We can create a Likes model which can be used to store the post_id and the user_id. This will be the pivot table between the User and Post models in the many to many relationship. If you want to store different types of likes, such as thumbs up or a heart, then this can be stored on the pivot as well.

Like relationships

  • A user likes many posts
  • A post is liked by many users

User

We have touched on the user relationships already as all the other relationships involve the user in some way.

User relationships

  • A user has many posts
  • A user has many followers
  • A user follows many users
  • A user likes many posts

Summary

Sometimes it pays to keep your database as simple as possible by using effective relationships. By spending a little time organising your thoughts

laravel eloquent database php

Latest Blog Posts

Coding with Laravel Boost and Kiro AI

Coding with Laravel Boost and Kiro AI

Published: Oct 24, 2026

I recently built a Laravel app using Laravel Boost along with Kiro, Amazon’s AI service, and wanted to share what I discovered. This is more of an opinion piece as...

Updating my website's theme

Updating my website's theme

Published: Sep 15, 2026

As a web developer, your own website can act as a portfolio for your work, showcasing all of your other work and projects, but sometimes it is the last thing...

First impressions of Flux UI

First impressions of Flux UI

Published: Apr 21, 2026

Recently I had the opportunity to work on a new side project. I had already decided I wanted to use Laravel and Livewire, but I wasn’t sure about the frontend...

Trouble at the church book cover

The Little-Astwick Mysteries - Trouble at the Church

A fast paced crime mystery set in the fictional English village of Little-Astwick. David Morgan, a Community Support Officer, new to the area, gets plunged in at the deep end with a new acquaintance, Evelyn McKenzie, trying to figure out what has been going on at the village church.

Available on Kindle, Kindle Unlimited and Paperback.

Stay updated