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

I am looking for some explanation of the schema for the data dump of se sites.

Specifically I'd like to know the values for PostTypeId field (1=Questions?, 2=Answers?, 3=?, etc).

I have tried to look for it, I am sure it must be posted somewhere pretty obvious, but I seem to have a blind spot that I need help with.

share|improve this question
    
I changed my mind about the duplicate, since the documentation is so far behind –  Michael Mrozek Jul 21 '11 at 14:21
    
@MichaelMrozek - In that case, isn't the solution to edit the original, canonical post? It's got 40 upvotes and 24 revisions, I hardly think that we should start a new question for it. –  Kevin Vermeer Jul 26 '12 at 0:02
add comment

2 Answers 2

up vote 11 down vote accepted

Have you tried executing this query:

select * from posttypes

It returns:

Id Name     
-- -------- 
1  Question 
2  Answer   
3  Tag Wiki 

(3 row(s) affected)

Is this what you are looking for?

share|improve this answer
1  
Thanks. Duh, I knew it was obvious. –  Unreason Jul 21 '11 at 14:27
add comment

In theory selecting from PostTypes should be the right way, but it seems to be behind, since I see 1-6 used in the PostTypeId field. The readme.txt file in the data dump is worse; it only lists 1 and 2 for Question and Answer, respectively. I looked at 20 random posts from each ID; they appear to be:

  • 1 -- Questions
  • 2 -- Answers
  • 3 -- Orphan Tag Wikis (tag wikis for tags that have since been deleted. ♦ mods can see these live)
  • 4 -- Tag Wiki Excerpts
  • 5 -- Tag Wiki Bodys
  • 6 -- Election nominations
share|improve this answer
1  
Thank you, interesting... btw, is there somewhere where I can look more directly on the schema, integrity rules, etc... +1 –  Unreason Jul 21 '11 at 14:37
    
There's documentation in the readme.txt that comes with the data dump; it's reproduced here. That's all that's publicly available –  Michael Mrozek Jul 21 '11 at 14:39
add comment

You must log in to answer this question.

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