Questions tagged [schema]
For questions about the Stack Exchange Data Explorer (SEDE) database schema.
17
questions
6
votes
1
answer
167
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?
- 71
4
votes
0
answers
52
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 ...
- 26.5k
12
votes
1
answer
201
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", ...
- 26.5k
6
votes
1
answer
113
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 ...
- 173
4
votes
1
answer
335
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 ...
- 359
13
votes
1
answer
195
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 ...
- 306
7
votes
1
answer
96
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.)
...
- 3,168
10
votes
1
answer
403
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, ...
- 319
7
votes
1
answer
112
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 ?
- 14.1k
4
votes
2
answers
217
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 ...
- 1,179
26
votes
2
answers
292
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 BertrandStaff
- 34.8k
4
votes
1
answer
234
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 ...
- 945
5
votes
1
answer
106
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, ...
- 945
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 ...
- 213
38
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 ...
- 381
371
votes
2
answers
106k
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
8k
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.
- 463