corrupshun Posted February 4, 2010 Share Posted February 4, 2010 If not, please tell me ways to improve Thanks! ---Forum--- >>Users ....UserID ....Username ....Date ....IP ....Email ....Password ....Level ....Posts ....Avatar >>Forums ....ForumID ....Forum ....ForumInfo ....ForumSubject ....ForumTopics ....ForumPosts >>Topics ....Username ....TopicID ....Topic ....TopicViews ....TopicReplies ....InForum >>Posts ....Username ....PostID ....Post ....PostDate ....InForum ....InTopic Link to comment https://forums.phpfreaks.com/topic/190864-is-this-a-good-database-structure-for-a-forum/ Share on other sites More sharing options...
roopurt18 Posted February 4, 2010 Share Posted February 4, 2010 I don't understand the meaning of Date or IP in the users table. You don't need separate forums and topics tables. Just one table, called Topics, would suffice. This would be a hierarchical table where topics can contain any number of sub-topics. Any topic without a parent is effectively a board. There is a good article on the MySQL website about hierarchical data organization; a google search should turn it up. Link to comment https://forums.phpfreaks.com/topic/190864-is-this-a-good-database-structure-for-a-forum/#findComment-1006541 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.