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

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

But why?

share|improve this question
add comment

1 Answer

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
2  
And so begins the overflow... –  random Oct 4 '09 at 11:16
5  
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
1  
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
1  
Ok...At least an answer doesn't have title and tags,right? –  Shore Oct 4 '09 at 11:57
4  
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
1  
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
2  
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
1  
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
add comment

You must log in to answer this question.

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