What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 150 Stack Exchange communities.

This is what I concluded from the id of questions and answers.

But why?

share|improve this question

1 Answer 1

Since you enjoy asking questions so much, I will answer your questions with more questions.

  • What's the difference between a question and an answer?
  • What fields does question have, that answer does not?
  • Should similar items be stored together?
share|improve this answer
And so begins the overflow... – random Oct 4 '09 at 11:16
Since you like asking me questions,I'll just answer you here: 1.an answer doesn't have title,tags,viewed times 2.as above 3.the two objects have so many difference,how can store together?It'll spawn a lot of null. – Shore Oct 4 '09 at 11:25
An answer has a view count. You can see that by going to your profile and sort your answers by view count. – Ólafur Waage Oct 4 '09 at 11:52
Ok...At least an answer doesn't have title and tags,right? – Shore Oct 4 '09 at 11:57
What if a stackexchange customer asks for tagging of answers? or titles in questions? IMHO they are similar enough to warrant the same table. – Ólafur Waage Oct 4 '09 at 12:44
The tags must be stored in a thired table anyway.I can see there are huge amount of NULL for answer's title in the SAME table. – Shore Oct 4 '09 at 13:15
Nothing wrong with NULL values. The only thing I'd do differently is that since they're using sql server 2008, they could use the new hierarchal data features. technet.microsoft.com/en-us/library/bb677290.aspx – Joel Coehoorn Oct 4 '09 at 13:47
So, you would create a separate and identical table with all duplicated columns minus one, because one type doesn't use that one column? – Rex M Oct 4 '09 at 16:14
To sum up,an answer doesn't have tags,title,accepted answer,accepted time.How different will you think it's really different? – Shore Oct 5 '09 at 8:36
@Shore: the answer would be to normalize the data, not split it up arbitrarily. However, SO may well have a good reason for keeping their data somewhat denormalized. See: codinghorror.com/blog/archives/001152.html – Shog9 Oct 5 '09 at 20:48

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .