Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

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

But why?

share|improve this question

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: answer doesn't have title,tags,viewed times 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. – 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: – 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 .