I am doing a design for a database using SQL Server 2008 R2, basically it is a simple database design for a forum (just like games fans forums). Fortunately I am struggling with it as I didn't find any free samples to compare my work to it.
As some people requested in the comments, this is what I did so far: For a Forum, I considered a User (Table), each user have a post (Table) and each post can start a topic (Table).
Table User : UserID (PK), Nickname, Email, Password, AvatarImage.
Table post : PostID (PK), UserID (FK), DateTime, Description.
The question that I don't have an answer for:-
- How can I provide the possibility that a post can start a topic? Should I make a new table? what columns? or something can be done with the post table with the help maybe of stored procedures?
- How can I make a topic after a topic (like answering a question)?