Discuz Forum Program You can refer to the data structure here, but it looks dizzy.
Http://www.neter8.com/thread-97856-1-1.html discuz! Forum database structure Reference
First, I searched several mainstream Forum programs using Google, and then looked at them on the official website. I think they have the following features:
The first is the forum homepage, which generally adopts the forum grouping mode. below a forum without the previous Forum list, there are also sub-forums such as XXX, yyyy, and zzzz. You can use any area for grouping.
I thought about how they grouped the forum for a long time. At present, I think grouping is actually a forum, but a forum with no posts, or a forum with sub-forums.
In fact, grouping in the Forum can also be divided by grouping tables, but this increases the number of tables and the number of queries. Now I think grouping is actually a forum.
The Group does not allow posting.
2. currently, the Forum list on the Forum homepage is a group of forums. Instead of directly occupying a cell as before, three sub-forums (usually three) are displayed on each row, displays information such as the Forum title, Moderator, number of topics, number of posts, and number of posts posted today.
3. On the right side of the group bar, you can switch the display mode of the Forum (horizontal single column, and grid), hide/display the group button, and view the information button of the moderator in the area.
4. Forum announcements, links, and online users on the Forum homepage are really rare.
5. Links to the bottom of the forum, such as the graphic version and Text Version, are common.
In addition, it is best to have RSS links at the top of the Forum.
The Design of Forum tables, without considering the user's permissions (posting, deleting posts, etc.), basically I think it can be divided into three tables: Forum table forums and thread table threads, one is post in the reply table.
The three tables can use subordination. Post belongs to threads, and threads belongs to forums.
The considerations here do not currently involve performance issues.
I don't know how to design the website.
DZ data tables are available on the Internet. The key is that if you do so based on Django, you cannot adopt that structure, the design philosophy that does not duplicate the wheel should be figured out before coding. Currently, Django has the user contrib, and the general permission is still handled.
What I want to do now is integration.
The above is what we think for the time being, which makes everyone laugh.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.