不要从表格开始，而是从基本实体、论坛、主题、回复、成员、关键字、类别等的概念 ER 图开始，并首先表达关系。然后进入逻辑设计模式并定义所需的表格实现功能。按照建议查看 phpBB 表的组织方式。
我喜欢在打印白板或纸上绘制第一个图表，然后使用图表工具进行逻辑设计。
我认为“更好”的论坛还有空间，祝你好运。
Don't start with a table, start with a conceptual ER Diagram of your base entities, forums, threads, replies,members, keywords, categories etc. and express the relationships first.Then get into logical design mode and define the tables needed to implement the functionality. As suggested have a peek at the way phpBB tables are organized.
I like to do my first diagram on a printing whiteboard or on paper then move to a diagramming tool for logical design.
I think there's still some room for a 'better' forum, so good luck.
您的基地的概念 ER 图 实体、论坛、主题、 回复、成员、关键词、类别 等并表达关系 首先，然后进入逻辑设计 模式并定义所需的表 实现功能
这是我见过的此类问题的最佳答案。
问候&祝你好运。
Greetings.
As i previously recommended in comments to your question.
I strongly recommend you to set up local installations of other open source database driven forums in your machine, in order for you to have a strong idea and base of what other developers did when they develop such forum applications, not just looking at the database tables but also to the code, organization and design of the forum. I think it proof it self very useful to open your eyes to possibilities for your own forum application
I usually say the best way to learn is trial and error but let me also point out. Even this forum application your creating, its just for small and private use for your websites.
You should consider that your forum application one day may become popular and you might desire to turn it public like these previous ones mentioned, or you just want to add some new features.
In this case i suggest you plan your Code and Database Architecture very well, planning ahead for future upgrades.
Also you should take MikeAinOz advice very seriously in his answer and start by
Conceptual ER Diagram of your base entities, forums, threads, replies,members, keywords, categories etc. and express the relationships first.Then get into logical design mode and define the tables needed to implement the functionality
Thats the best answer to this kind of question i ever seen.
发布评论
评论（3）
不要从表格开始，而是从基本实体、论坛、主题、回复、成员、关键字、类别等的概念 ER 图开始，并首先表达关系。然后进入逻辑设计模式并定义所需的表格实现功能。按照建议查看 phpBB 表的组织方式。
我喜欢在打印白板或纸上绘制第一个图表，然后使用图表工具进行逻辑设计。
我认为“更好”的论坛还有空间，祝你好运。
Don't start with a table, start with a conceptual ER Diagram of your base entities, forums, threads, replies,members, keywords, categories etc. and express the relationships first.Then get into logical design mode and define the tables needed to implement the functionality. As suggested have a peek at the way phpBB tables are organized.
I like to do my first diagram on a printing whiteboard or on paper then move to a diagramming tool for logical design.
I think there's still some room for a 'better' forum, so good luck.
问候。
正如我之前在对您的问题的评论中所建议的那样。
我强烈建议您在计算机中设置其他开源数据库驱动论坛的本地安装，以便您对其他开发人员在开发此类论坛应用程序时所做的事情有一个强有力的想法和基础，不仅要查看数据库表，还要查看论坛的代码、组织和设计。我认为这证明它非常有用，让您了解自己的论坛应用程序的可能性
一些数据库驱动论坛的示例：
我通常说最好的学习方法是尝试和错误，但我也想指出。即使您创建的这个论坛应用程序也仅供您网站的小型私人用途。
您应该考虑到有一天您的论坛应用程序可能会变得流行，并且您可能希望像前面提到的那样将其公开，或者您只是想添加一些新功能。
在这种情况下，我建议您很好地规划代码和数据库架构，提前规划未来的升级。
另外，您应该非常认真地考虑 MikeAinOz 在他的 答案并从
这是我见过的此类问题的最佳答案。
问候&祝你好运。
Greetings.
As i previously recommended in comments to your question.
I strongly recommend you to set up local installations of other open source database driven forums in your machine, in order for you to have a strong idea and base of what other developers did when they develop such forum applications, not just looking at the database tables but also to the code, organization and design of the forum. I think it proof it self very useful to open your eyes to possibilities for your own forum application
A few examples of database driven forums:
I usually say the best way to learn is trial and error but let me also point out. Even this forum application your creating, its just for small and private use for your websites.
You should consider that your forum application one day may become popular and you might desire to turn it public like these previous ones mentioned, or you just want to add some new features.
In this case i suggest you plan your Code and Database Architecture very well, planning ahead for future upgrades.
Also you should take MikeAinOz advice very seriously in his answer and start by
Thats the best answer to this kind of question i ever seen.
Regards & Good Luck.
我的想法...
str_follow 不应该出现在这个表中。它应该有自己的表，将成员链接到订阅的线程。
如果它是顶级线程，我建议使用parent_id
null，这样更有意义。My thoughts...
str_follow shouldn't be in this table. It should have its own table that links members to subscribed threads.
I'd recommend having parent_id
nullif its a top level thread, it makes more sense.