I'm writing a small forum for my site. I'm having EXTREME issues on the db design for it. Currently I have a Forums table a Topics table and a Threads table.
The way i had originally planned for it to work was the topics table will include the topic description and the body of the first post. Then when you click on the link it takes you to that post and shows all the threaded replies in the threaddb where the topic_id is the same as the topic.
Is this the best way for the forum design layout? Or is their a more effiecient one like only havintg a forum table and a thread table. identifying the topics by setting a field called is_topic in the thread db.