Questions tagged [schema]

For questions about the Stack Exchange Data Explorer (SEDE) database schema.

Filter by
Sorted by
Tagged with
6 votes
1 answer
174 views

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?
Ivan Pavlov's user avatar
4 votes
0 answers
53 views

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 ...
Ollie's user avatar
  • 26.8k
12 votes
1 answer
204 views

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", ...
Ollie's user avatar
  • 26.8k
6 votes
1 answer
116 views

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 ...
Zach Smith's user avatar
4 votes
1 answer
384 views

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 ...
arman's user avatar
  • 359
13 votes
1 answer
203 views

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 ...
Trinimon's user avatar
  • 306
7 votes
1 answer
98 views

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.) ...
Andrew Cheong's user avatar
10 votes
1 answer
409 views

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, ...
Qiongjie's user avatar
  • 309
7 votes
1 answer
115 views

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 ?
asheeshr's user avatar
  • 14k
4 votes
2 answers
234 views

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 ...
d-_-b's user avatar
  • 1,169
26 votes
2 answers
299 views

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. ...
Aaron Bertrand's user avatar
  • 39.7k
4 votes
1 answer
246 views

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 ...
Mohamad's user avatar
  • 959
5 votes
1 answer
107 views

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, ...
Mohamad's user avatar
  • 959
11 votes
1 answer
1k views

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 ...
Richard's user avatar
  • 213
37 votes
3 answers
2k views

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 ...
Steg's user avatar
  • 371
379 votes
2 answers
120k views

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 ...
28 votes
4 answers
9k views

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.
JonnyBoats's user avatar