[SOLVED]forum db implementation
Posted: Sun Feb 05, 2006 10:24 am
Hi,
I'm workign on a project that requires a private 'forum' style communications between two users.
I was just wondering what is that standard database table design for forums? Im only asking about the way that posts are handled not all of the user data.
Is there just one table where the posts are identified by an id number and then reply posts are linked to this id number but differentiated by their order number?
IE
Original post (new thread) - POST ID, AUTHOR etc
Reply - POST ID, AUTHOR, REPLY NUMBER (1)
Reply - POST ID, AUTHOR, REPLY NUMBER (2)
...and so on.
Or is it more complicated than this?
Thanks
rj
I'm workign on a project that requires a private 'forum' style communications between two users.
I was just wondering what is that standard database table design for forums? Im only asking about the way that posts are handled not all of the user data.
Is there just one table where the posts are identified by an id number and then reply posts are linked to this id number but differentiated by their order number?
IE
Original post (new thread) - POST ID, AUTHOR etc
Reply - POST ID, AUTHOR, REPLY NUMBER (1)
Reply - POST ID, AUTHOR, REPLY NUMBER (2)
...and so on.
Or is it more complicated than this?
Thanks
rj