Questions tagged [schema]
For questions about the Stack Exchange Data Explorer (SEDE) database schema.
Why are there values of 1 and 3 for LinkTypeId and no value of 2? (Stack Exchange data dump)
I have found an explanation for LinkTypeId 1 and 3 here. Why was the second type skipped?
Add the ability to increase width of Database Schema SEDE
At SEDE, you can increase the height of the Database Schema with this button: And with the whole thing, including the area where you make your queries. But you can't increase the width, which would ...
Overlapping text in Database Schema SEDE
Over at SEDE, there is overlapping text in the Database Schema under Close-As-Off-Topic-Reason-Types: that makes it really hard to read. This is also happening underneath "Pending Flags", ...
Does Stack Exchange track the edit history of a user's `Location` field?
If I want to compare how many posts per location are asked by users over a period of N years, I would want to know how many users have changed locations during the period that I want to query. Is ...
What is LastAccessDate in the Database schema? [duplicate]
I have a doubt regarding the meaning of LastAccessDate in the StackExchange database under the User table. Is it the last date on which the user have performed some activity on the site(like asking ...
Information about database indexes in the Data Explorer
Some days ago I discovered the Stack Exchange Data Explorer (SEDE) which provides already lots of interesting queries out of the box (thanks to the contributors). After a while I noticed that some of ...
What is the distinction between Votes with VoteTypeId = 16 (ApproveEditSuggestion) and SuggestedEditVotes?
I apologize for the influx of data explorer questions, lately. (This time though, I have a feeling I'm more confused about how suggested edits work in general, rather than the uploaded data itself.) ...
Where can I find all the closed questions?
I have downloaded the data dump which has several files like posts.xml, posthistory.xml, although I cannot find the compete version of the closed questions: for example, its title, owner user id, ...
What do these attributes refer to in the SEDE Schema?
In the SEDE Schema under Votes -> VoteTypeId, there are Upmod DownMod InformModerator (Probably refers to the Inform Moderator Flag ?) ModeratorReview What do each of these atttributes refer to ?
Is there a Data Dictionary for the data.stackexchange tables?
Is there a data dictionary showing the relations between tables? If so, where can I find this? I'd like to become more familiar with the schema :) is this related question the best/official post to ...
Can we expose class for badges in Data Explorer?
According to this answer the following metadata is exposed for badges: Id UserId Name Date Why isn't class exposed in some way? It's obviously in the schema, since we can sort / filter in the UI. ...
Why are badges and tags handled differently in the database schema?
I would expect that user badges would be stored with a schema similar to this: UserBadges(@id, @userId, @badgeId, @creationDate) Instead, according to this explanation and the datadump, there is no ...
What advantages are derived from the revisions schema in its current form?
Why does the revisions schema not store an entire post's contents in a single record, rather creating three records, one for each component of a post? For example, if the post is of a type question, ...
Documentation for Stack Exchange Data Explorer Schema? [duplicate]
Maybe I'm missing something obvious, but is there documentation on the SEDE schema anywhere? As listed here http://odata.stackexchange.com/stackoverflow/query/new, it's not obvious what all the fields ...
Stack Overflow database design join issues
There are many questions already on meta-stackoverflow regarding the database schema, but here is another, that I don't think is a duplicate, so please read on. I read a description of the schema ...
Database schema documentation for the public data dump and SEDE
Stack Exchange releases "data dumps" of all its publicly available content roughly every three months via archive.org, and also makes that information queryable over the Internet at the ...
SO database schema [duplicate]
Has the database schema for Stack Overflow been made publicly available? If not, could it be? If not the whole schema, how about a list of the tables used? I want this as a learning resource.