Home > Article > Backend Development > How to design a multi-dimensional cross feed flow (database design, home page display information)
I am currently building a simple Q&A website
Now it has the following four elements
People, topics, questions, answers
How to design a database (MySQL)
People can follow people, topics, questions
Questions can have multiple hashtags
feed Streams (displayed on the home page) can appear mixed:
New questions added to the topics I follow
New answers to questions I’m concerned about
Questions from people I follow
I feel that the database is not easy to design. How should the data on the home page mix and display different information?
I am currently building a simple Q&A website
Now it has the following four elements
People, topics, questions, answers
How to design a database (MySQL)
People can follow people, topics, questions
Questions can have multiple hashtags
feed Streams (displayed on the home page) can appear mixed:
New questions added to the topics I follow
New answers to questions I’m concerned about
Questions from people I follow
I feel that the database is not easy to design. How should the data on the home page mix and display different information?
You can design a special feed flow table. This table can support home page display and can also be used as an information collection table.