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?

  • 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 The Princess 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 The Princess Wizard Jan 24 '13 at 14:44

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?

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