Home  >  Article  >  Backend Development  >  How to design a multi-dimensional cross feed flow (database design, home page display information)

How to design a multi-dimensional cross feed flow (database design, home page display information)

WBOY
WBOYOriginal
2016-12-01 00:56:461344browse

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:

  1. New questions added to the topics I follow

  2. New answers to questions I’m concerned about

  3. 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?

Reply content:

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:

  1. New questions added to the topics I follow

  2. New answers to questions I’m concerned about

  3. 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.

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn