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

WBOY
Release: 2023-03-02 06:40:01
Original
1377 people have browsed it

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.

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template