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

But why?


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?
  • 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

You must log in to answer this question.

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