Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [schema]

The tag has no usage guidance.

4
votes
1answer
69 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 ...
3
votes
1answer
82 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 ...
13
votes
1answer
138 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 ...
7
votes
1answer
89 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.) ...
10
votes
1answer
265 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, ...
7
votes
1answer
104 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 ?
3
votes
2answers
149 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 ...
25
votes
2answers
236 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. ...
4
votes
1answer
203 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 ...
5
votes
1answer
104 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, ...
11
votes
1answer
830 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 ...
37
votes
3answers
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 ...
26
votes
4answers
7k views

SO database schema

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.