7

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?

4
  • This data isn't in there... make this a feature request and I'll definitely upvote. The more data the better. Commented Jan 24, 2013 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) Commented Jan 24, 2013 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
    Commented Jan 24, 2013 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. Commented Jan 24, 2013 at 14:44

1 Answer 1

2

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 .