What mysql architecture is required to create a simple social network?

Question

PHP

I am creating a simple social network, and I do not know how to correctly and safely create tables for a simple social network. The social network includes: friends, avatars, user information, posts, likes for posts and avatars.
Thank you Vadim997

Answer 1

Take and create. The main thing is right. And safer. Well, likes can be not very safe. But with friends - very safe! And, most importantly, do it right with everyone!

Answer 2

Not "mysql architecture", but mysql DB structure.
Look at ready-made engines for creating social networks. networks - database dumps must be present there

Answer 3

You have 2 options:
- offer at least here your version of the database architecture for your task
- can you hammer it? Maybe you don't need this social network of yours? Maybe you should start with blogs?

Answer 4

To begin with, it is better to take any book (there are plenty of them), which covers the issues of designing and normalizing the database.
Take a pen and a piece of paper and sketch out an approximate architecture. There is always room for improvement during development.