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.

Possible Duplicate:
Add better descriptions and E/R diagram to Data Explorer’s schema

I was messing around with the Stack Exchange Data Explorer and it appears that not all the tables are present in the database schema. Either that or I don't fully understand how the data is stored. I was wanting to create some queries to gather statistics of the new review system.

What tables is the data stored in when a user does completes a review action in one of the six categories? If the tables are not available, can they be made available for writing queries against?

Also, is there a data diagram available somewhere to look at?

share|improve this question

marked as duplicate by Shadow Wizard, Toon Krijthe, Bo Persson, Lance Roberts, Austin Henley Jan 24 '13 at 17:58

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

    
This data isn't in there... make this a feature request and I'll definitely upvote. The more data the better. –  ben is uǝq backwards Jan 24 '13 at 14:37
    
Looks like the dev team expects us (ordinary mortal users) to build such diagram based on this answer. (Sam no longer works for SE but I'm pretty sure what he said stands still) –  Shadow Wizard Jan 24 '13 at 14:42
    
It is not a duplicate, only the last question about the data diagram is talked about in the link you presented –  Linger Jan 24 '13 at 14:42
    
As far as I could understand this is feature request for such diagram plus some related questions. The "core" is the feature request. –  Shadow Wizard Jan 24 '13 at 14:44
add comment

1 Answer 1

up vote 2 down vote accepted

Indeed, not all tables are present; the schema of the Data Explorer is a filtered view of a Stack Exchange site. For example, who voted is not available, for good reasons.

The new review queue data has simply not been added to the Data Explorer yet; only the votes themselves (close, reopen, etc) are available, you would have to write elaborate queries that can approximate the information.

It could be that those missing tables will be added in a future revision, but no plans to do so have been announced (that I can see).

There is no data diagram available, I don't think. However, the data explorer exposes OData feeds (example: Atom OData feed for SO), so perhaps you could try using a OData consumer tool to create one?

share|improve this answer
add comment

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