views:

91

answers:

1

I'm trying to create a site similar to StackOverflow. I just created a SQL schema today and need some feedback on what needs improvement.

Here's a link to the schema (Requires MySQL Workbench)

Here's a picture of the schema:

StackOverflow SQL schema

Is there anything I can do to improve this schema?

+3  A: 

Take a look at the SO data dump and compare for yourself. You'll see that the SO schema is MUCH simpler.

Paul Sasik
Thanks. I guess that greatly simplifies my task.
Exception
Although I think that the data dump does not necessarily match their actual database schema.
Kibbee
@Kibbee: You're right. It's my guess that they remove some data to protect anonymity for certain situations. Like who voted down whom on a particular question, for example.
Paul Sasik