PDA

View Full Version : forum database structural setup


giants10
04-29-2008, 04:12 PM
if you are going to have a number of forums on your database, lets just say in a group. do you think this would be a proper way to structure it

FORUMS
_______

ID
GROUPID
THREADID
THREADTITLE
THREADTEXT

when you have this setup, how would you make a framed forum out of this?

Fumigator
04-29-2008, 05:39 PM
Still at it I see. If I were doing a forum database I would have one table to store categories, one table to store threads and one table to store posts.

category ID stored in threads_table

thread ID stored in posts_table

This doesn't incorporate sub-categories but you need to keep it as simple as possible given your skill level.

mr e
04-30-2008, 09:08 AM
Have you thought of taking a look at how some of the free forums structure their db's?