Skip to main content
Meta Stack Exchange

Timeline for Database schema documentation for the public data dump and SEDE

Current License: CC BY-SA 4.0

135 events
when toggle format what by license comment
May 19 at 23:10 history edited starball CC BY-SA 4.0
added 280 characters in body
Apr 25 at 7:18 history edited rene CC BY-SA 4.0
added new views and sp for cross-site queries, details from https://meta.stackexchange.com/a/399304 and https://meta.stackexchange.com/a/398996
Apr 7 at 18:32 history edited Aaron BertrandStaff CC BY-SA 4.0
Added some detail to the TIMESTAMPS section.
Jan 24 at 8:16 history edited Shadow Wizard CC BY-SA 4.0
added 2 characters in body
Jan 24 at 8:03 history edited starball CC BY-SA 4.0
https://meta.stackoverflow.com/questions/421038/the-ask-wizard-2022-has-graduated#comment931561_421041
Oct 25, 2023 at 17:32 comment added rene @IvanKleshnin please see meta.stackexchange.com/a/335060/158100 tl;dr: they are not in the schema.
Oct 25, 2023 at 8:13 comment added Ivan Kleshnin Is there an access to Twitter / Github usernames? I don't see such columns but it's a public information...
Aug 30, 2023 at 23:02 history edited zcoop98 CC BY-SA 4.0
Add descriptions to a few fields on the Posts table
Jul 11, 2023 at 20:32 history edited zcoop98 CC BY-SA 4.0
Improve description of PostTypeId 7
Apr 17, 2023 at 18:37 history edited rene CC BY-SA 4.0
added nullable info to tagsynonyms after https://meta.stackexchange.com/a/388415
Nov 20, 2022 at 19:11 comment added rene @desert_ranger see Which Stack Overflow table saves the data for accepted answers?
Nov 20, 2022 at 15:59 comment added desert_ranger What does AcceptedAnswerId mean? I wish there was documentation specifically telling about it.
Oct 28, 2022 at 17:45 history edited Aaron BertrandStaff CC BY-SA 4.0
Updated as it is now a circular reference (see https://meta.stackexchange.com/a/383323)
Oct 23, 2022 at 11:59 history edited rene CC BY-SA 4.0
votetypeid = 5 no longer present due to Saves
Oct 8, 2022 at 18:17 history edited rene CC BY-SA 4.0
added consensus explanation
Oct 8, 2022 at 6:00 history edited rene CC BY-SA 4.0
added functional meaning for closed markdown fields
Jul 6, 2022 at 22:39 history edited zcoop98 CC BY-SA 4.0
Updated name of ReviewTaskResultTypeIds 1 & 11, confirmed by review submission network request https://i.sstatic.net/ktiF4.png
May 24, 2022 at 11:55 history edited Martin CC BY-SA 4.0
ReviewTaskTypeId 12 for First Questions and 13 for First Answer
Apr 27, 2022 at 9:28 comment added rene @BenyaminJafari see How can I query users with a specific Job title?
Apr 27, 2022 at 9:25 comment added Benyamin Jafari I'm looking for Users.Title. Where is it?!
Jun 10, 2021 at 20:09 comment added rene @AlexJ the schema of the production database is more extensive
Jun 10, 2021 at 20:05 comment added Alex J @rene Interesting, what keeps a user from making multiple upvotes on a given comment? How is the vote on a comment related back to the user that makes it?
Jun 10, 2021 at 19:41 comment added rene @AlexJ Comments only have upvotes and those are kept in the field ` Score` . There is no separate table for CommentVotes. So the votes(votetypeid in (2,3)) table has the rows for up and downvotes of posts alone.
Jun 10, 2021 at 19:23 comment added Alex J How can you tell if a vote is for a comment or for a post? It seems like the schema only handles votes for posts.
Jun 1, 2021 at 8:17 comment added rene @chaosifier Username is populated when a User is deleted. So once the Userid or OwnerUserId would be set to null the Usename field gets populated with the last known name (although most of the time the username is reset to default first)
Jun 1, 2021 at 8:09 comment added chaosifier Why is there UserName in Post and Comment? Is it to avoid a join? Are the username entries in posts and comments updated if user updates the username?
Apr 22, 2021 at 16:51 comment added rene @zcoop98 I've run a check and you're right, only 1 site has 0 as classid. I checked but can't find info on what the name of those classid's is. Feel free to open a question to get that name. Here is the answer meta.stackexchange.com/a/278150 that announces the addition of those tables. Surprisingly enough I was the requestor to get those tables added in the first place.
Apr 22, 2021 at 16:30 history edited zcoop98 CC BY-SA 4.0
Fix indentation of "Comment" list in PostHistory
Apr 22, 2021 at 16:20 history edited zcoop98 CC BY-SA 4.0
Rollback unintended changes caused by new editor
Apr 22, 2021 at 16:10 history edited zcoop98 CC BY-SA 4.0
Added note about deleted posts under PostHistory heading
Apr 2, 2021 at 22:42 comment added zcoop98 For PostNoticeTypes, there appears to be two classIds other than the mentioned 1, 2, & 4. Stack Overflow additionally as 8 and 0, it seems most (all?) other sites have just the 8. Is there an official name for this class of notices?
Mar 26, 2021 at 22:00 history edited zcoop98 CC BY-SA 4.0
Mark that "ContentLicense" column is also included in PostsWithDeleted table
Dec 7, 2020 at 14:12 history edited GlorfindelMod CC BY-SA 4.0
added 37 characters in body
Aug 30, 2020 at 7:09 history edited rene CC BY-SA 4.0
added extra meaning for events 52 and 53
Jun 27, 2020 at 10:57 history edited Cody Gray - on strike CC BY-SA 4.0
added 71 characters in body
May 17, 2020 at 19:01 history edited rene CC BY-SA 4.0
ContentLicense added
May 7, 2020 at 21:15 history edited GlorfindelMod CC BY-SA 4.0
added 64 characters in body
Apr 29, 2020 at 13:37 history edited GlorfindelMod CC BY-SA 4.0
added 6 characters in body
Apr 29, 2020 at 1:09 history edited Jeff Schaller CC BY-SA 4.0
updated CloseAsOffTopicReasonTypes based on https://meta.stackexchange.com/a/347162/307535
Jan 7, 2020 at 7:21 history edited rene CC BY-SA 4.0
added 68 characters in body
Jan 7, 2020 at 7:15 history edited GlorfindelMod CC BY-SA 4.0
added 112 characters in body
Jul 6, 2019 at 8:04 history edited rene CC BY-SA 4.0
clarified posts vs postwithdeleted rows
Jul 6, 2019 at 5:18 history edited JJJ CC BY-SA 4.0
added white space to force new line in list
May 4, 2019 at 7:26 history edited GlorfindelMod CC BY-SA 4.0
added 26 characters in body
Apr 5, 2019 at 17:52 history edited rene CC BY-SA 4.0
update tags with explanation to wiki and excerpt postid, fixed postnoticetypes and add postnoticetype values to postnotices
Mar 22, 2019 at 7:22 history edited Martin CC BY-SA 4.0
added 112 characters in body
Feb 25, 2019 at 1:51 history edited iBug says Reinstate Monica CC BY-SA 4.0
🍎
Aug 24, 2018 at 10:09 history edited rene CC BY-SA 4.0
added some FK, added explanation for some reference fields based on observation
Aug 6, 2018 at 20:56 history edited rene CC BY-SA 4.0
creationdate in votes is rounded to a day
Jul 22, 2018 at 11:52 history edited rene CC BY-SA 4.0
aligned postwithdeleted with posts (as suggested earlier by Ashleedawg) and verified and corrected votetypeid values and meaning for suggestededitvotes and postfeedback
Jul 21, 2018 at 14:44 history edited rene CC BY-SA 4.0
hopefully improved the layout struggle in posthistortypeid and applied same layout to sublists in postlinks and postnoticetypes
Jul 14, 2018 at 14:29 history edited rene CC BY-SA 4.0
added query with datatypes per column.
Jul 5, 2018 at 10:10 history edited Erik A CC BY-SA 4.0
Some links to SEDE were still HTTP. Updated to HTTPS
Jul 1, 2018 at 6:46 history edited rene CC BY-SA 4.0
added what users.views means
Jun 29, 2018 at 19:30 history edited rene CC BY-SA 4.0
users.age is removed due to GDPR, fixed bullet list for reviewrejected reason; moved functional text from suggestededits under the table header
Jun 28, 2018 at 21:44 history rollback rene
Rollback to Revision 74
Jun 28, 2018 at 20:20 history rollback ashleedawg
Rollback to Revision 71
May 31, 2018 at 20:44 history edited rene CC BY-SA 4.0
added posthistory back in its old format as I don't fancy digging into XLSM for now.
Apr 19, 2018 at 12:29 history edited ashleedawg CC BY-SA 3.0
fixed image links
Apr 18, 2018 at 9:30 history edited ashleedawg CC BY-SA 3.0
Overhauled for clarity & uniformity. Moved descriptions & reference table values to ToolTips. See comments hidden within edit for further notes about changes. (Tried to preserve as much existing information as possible; it't just located in different spots now... Hope I didn't offend anyone!)
Apr 18, 2018 at 0:34 history edited ashleedawg CC BY-SA 3.0
added explanation of Timestamp fields (with example SQL for timezone conversion sql)
Apr 4, 2018 at 8:53 history edited Cai CC BY-SA 3.0
e.g. should be used for examples; https://english.stackexchange.com/q/1629/
Apr 4, 2018 at 0:32 history edited ashleedawg CC BY-SA 3.0
Improved readability; standardized formatting; fixed grammar. Further changes are required, which I will submit after this edit is approved (please!) and after I confirm facts with SO & in SEDE. This was a 2hr edit w/ more to come, "approve & edit" if necessary but kindly do not reject :)
Feb 27, 2018 at 8:59 history edited rene CC BY-SA 3.0
added 20 characters in body
Oct 17, 2017 at 14:51 history edited rene CC BY-SA 3.0
made the tables are in the datadump
Aug 4, 2017 at 22:00 history edited Shog9 CC BY-SA 3.0
Update info on PostsWithDeleted
May 29, 2017 at 17:34 history edited Jason C CC BY-SA 3.0
added 560 characters in body
May 23, 2017 at 12:36 history edited CommunityBot
replaced http://stackoverflow.com/ with https://stackoverflow.com/
S May 19, 2017 at 6:29 history suggested Ajoy D CC BY-SA 3.0
Added - ProfileImageUrl in Users and Changed ParentID to ParentId
May 19, 2017 at 5:59 review Suggested edits
S May 19, 2017 at 6:29
May 3, 2017 at 5:51 history edited Jason C CC BY-SA 3.0
added 221 characters in body
Apr 29, 2017 at 23:15 history edited Jason C CC BY-SA 3.0
clarify direction of postlinks
Apr 15, 2017 at 1:43 history edited Cai CC BY-SA 3.0
no need for nested brackets
Apr 14, 2017 at 22:28 history edited Jason C CC BY-SA 3.0
removed silly examples, also comment score is never null.
Apr 14, 2017 at 22:21 history edited Jason C CC BY-SA 3.0
added 160 characters in body
Mar 20, 2017 at 10:31 history edited CommunityBot
replaced http://meta.stackexchange.com/ with https://meta.stackexchange.com/
Feb 13, 2017 at 22:24 history edited rene CC BY-SA 3.0
layout fixed
Feb 13, 2017 at 21:30 history edited rene CC BY-SA 3.0
added comment explaining link to postnotice
Feb 13, 2017 at 21:08 history edited rene CC BY-SA 3.0
classid completed and postnoticedurationid
Feb 13, 2017 at 21:01 history edited rene CC BY-SA 3.0
classid completed and postnoticedurationid
Feb 13, 2017 at 20:53 history edited rene CC BY-SA 3.0
added PostNotices and PostNoticesTypes
Apr 16, 2016 at 19:39 history edited rene CC BY-SA 3.0
added the foreignkeys for all tables, add CompletedReviewTaskId explanation from comment
Apr 16, 2016 at 17:25 history edited rene CC BY-SA 3.0
brought in what the difference is for PostFeedback and votes
Apr 16, 2016 at 16:46 history edited rene CC BY-SA 3.0
fixed the layout and added extra info about the text field in posthistory for json encoded voters
Apr 16, 2016 at 16:20 history edited rene CC BY-SA 3.0
linkified the first two foreignkey fields in the Posts table to see if this is useful
Jan 1, 2016 at 12:17 history edited Ciro Santilli OurBigBook.com CC BY-SA 3.0
added 145 characters in body
Dec 7, 2015 at 20:55 history edited Ciro Santilli OurBigBook.com CC BY-SA 3.0
Make DeletionDate clearer.
Dec 7, 2015 at 12:01 history edited Ciro Santilli OurBigBook.com CC BY-SA 3.0
DeletionDate is only non-null for PostsWithDeleted.
Nov 28, 2015 at 8:11 history edited Werner CC BY-SA 3.0
Posts have a DeletionDate.
Nov 21, 2015 at 13:04 history edited Ciro Santilli OurBigBook.com CC BY-SA 3.0
Body is HTML, not markdown.
Nov 21, 2015 at 12:52 history edited Ciro Santilli OurBigBook.com CC BY-SA 3.0
UpMod and DownMod are upvotes and downvotes.
Oct 24, 2015 at 14:34 history edited rene CC BY-SA 3.0
linked all foreignkey types tables, improved formatting in votes table, reduced noise by linkifying SEDE samples
Oct 24, 2015 at 0:06 history edited user163250 CC BY-SA 3.0
Added explanation of why time data is missing from vote data.
Oct 10, 2015 at 9:54 history edited user163250 CC BY-SA 3.0
Added additional information about Posts table, specifically, which columns are nullable.
Sep 8, 2015 at 20:56 history edited rene CC BY-SA 3.0
added postwithdelete table
Jun 4, 2015 at 15:39 history edited rene CC BY-SA 3.0
added explanation on votes.votetypeid for close votes to be found in posthistory
Apr 29, 2015 at 22:46 history edited rene CC BY-SA 3.0
added new columns for the Badge table
Apr 2, 2015 at 18:51 history edited rene CC BY-SA 3.0
added new reviewtypes and explained what accountid is
Dec 4, 2014 at 19:17 history edited rene CC BY-SA 3.0
added votetypeid difference for sugestededitvotes (don't join with the votes table)
Dec 2, 2014 at 20:36 history edited mahemoff CC BY-SA 3.0
Votes - improve consistency
Jul 23, 2014 at 18:48 history edited Ilmari Karonen CC BY-SA 3.0
there are no rows in PostLinks with LinkTypeId = 2; the code for duplicate seems to be 3 instead
Jun 29, 2014 at 11:55 history edited rene CC BY-SA 3.0
added warnings for migration posthistorytypeid codes
Jun 8, 2014 at 16:21 history edited Gilles 'SO- stop being evil' CC BY-SA 3.0
added review-related tables
Jun 8, 2014 at 16:02 history edited Gilles 'SO- stop being evil' CC BY-SA 3.0
added tables CloseAsOffTopicReasonTypes and PendingFlags; added some missing types
Mar 26, 2014 at 11:46 history edited Martijn Pieters CC BY-SA 3.0
deleted 12 characters in body
Mar 26, 2014 at 11:40 history edited rene CC BY-SA 3.0
added postlinks and postlinktypes
Feb 17, 2014 at 15:08 history edited Mark Hurd CC BY-SA 3.0
Add AccountId; mention EmailHash is blanked
Dec 18, 2013 at 14:05 history edited Shadow Wizard CC BY-SA 3.0
Removing vote types that do not exist, can't use numbered list anymore since there are missing numbers
Dec 15, 2013 at 2:52 history edited Alvin Wong CC BY-SA 3.0
added new close reasons
Mar 15, 2013 at 13:13 history edited Mike CC BY-SA 3.0
Added the other two fields that exist for "Tags" table
Mar 10, 2013 at 12:36 history edited Mat CC BY-SA 3.0
Update vote types according to http://data.stackexchange.com/stackoverflow/query/102390/vote-types
Jul 1, 2012 at 0:07 history edited scunliffe CC BY-SA 3.0
nomination typo fix
May 10, 2012 at 21:01 history edited Jeremy CC BY-SA 3.0
added 187 characters in body
May 3, 2012 at 8:21 history edited Volo CC BY-SA 3.0
Reflected recent changes: http://meta.stackoverflow.com/q/110182/158912 and http://meta.stackoverflow.com/q/115855/158912 which added UserId info for BountyStart vote type and BountyAmount info for BountyClose vote type
Feb 8, 2012 at 20:36 history edited a cat CC BY-SA 3.0
added general reference close reason (#10)
Sep 25, 2011 at 8:24 history edited Chris Frederick CC BY-SA 3.0
Numbered lists in Markdown are too smart for their own good
Sep 25, 2011 at 8:14 history edited Chris Frederick CC BY-SA 3.0
Ordered the schema to match what is shown in the Data Explorer, improved formatting (why <pre> tags?), and added missing information
Sep 25, 2011 at 8:09 history edited Chris Frederick CC BY-SA 3.0
Ordered the schema to match what is shown in the Data Explorer, improved formatting (why <pre> tags?), and added missing information
Jan 19, 2011 at 4:08 history edited Jon Seigel CC BY-SA 2.5
added 32 characters in body
Jan 9, 2011 at 19:40 history edited Jon Seigel CC BY-SA 2.5
Explained where to find CloseReasonId
Nov 10, 2010 at 23:54 history edited Jon Seigel CC BY-SA 2.5
added 252 characters in body
Nov 8, 2010 at 23:27 history edited Jon Seigel CC BY-SA 2.5
Added PostHistory information; eliminated horizontal scrolling
Sep 12, 2010 at 20:55 history edited Jon Seigel CC BY-SA 2.5
Added PostTypeId = 3
Apr 19, 2010 at 22:00 history edited Jon Seigel CC BY-SA 2.5
Updated for April 2010
Dec 21, 2009 at 1:40 history edited Jeff Atwood CC BY-SA 2.5
deleted 420 characters in body; deleted 3 characters in body
Nov 2, 2009 at 21:16 history edited perbert CC BY-SA 2.5
added 26 characters in body
Nov 2, 2009 at 11:21 history edited perbert CC BY-SA 2.5
added 40 characters in body
Sep 8, 2009 at 7:57 history edited Stu Thompson CC BY-SA 2.5
added 46 characters in body
Sep 8, 2009 at 7:34 history edited Stu Thompson CC BY-SA 2.5
added comment score
Sep 2, 2009 at 10:14 history edited Espo CC BY-SA 2.5
Changes "wiki'd" to "wikied" to make the syntax-highlighting better
Aug 4, 2009 at 8:10 history edited Stu Thompson CC BY-SA 2.5
updated for august
Jul 26, 2009 at 13:59 history edited Stu Thompson CC BY-SA 2.5
this format should be a little more txt file friendly
Jul 25, 2009 at 16:42 history edited Stu Thompson CC BY-SA 2.5
added 45 characters in body
Jul 24, 2009 at 3:40 history edited DeadHead CC BY-SA 2.5
Removed the (?)'s from the PostTypeId since Jeff stated that that is correct in his blog.
Jul 6, 2009 at 8:48 history answered Stu Thompson CC BY-SA 2.5
toggle format