Stack Exchange Network

Stack Exchange network consists of 175 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
77 of 90 added posthistory back in its old format as I don't fancy digging into XLSM for now.

  • I hope I didn't offend anyone by revamping this. Open to suggestions - I can make changes on request. Contact me here or ashleedawg_at_outlook_dot_com. (or you can Rollback if you hate my changes!)

  • I used this XLSM Template to help generate the markdown including ToolTips: http://s000.tinyupload.com/?file_id=36027958558653296420 Make changes mostly on tab 'SEDE All Tables`, then copy cell [Q1] to Notepad to replace "" with " , then paste in here. Please help improve it! Update the link above with most recent version (maybe save old links too?)

  • Let me know if all the π•Œπ•Ÿπ•šπ•”π• π••π•– is a problem for anyone; I can quickly post an alternate (less cool) version.

TO DO:

- Perhaps add links back in from each table name to: 
  https://data.stackexchange.com/stackoverflow/query/472607/information-schema-for-a-table?table=posts  
...replacing "posts" with the table name

- Add downloadable images (ie., quick references charts) for table list and reference table values.  See tabs [Table Chart] and [Ref Table Values] in XLSM template above.
                                                                    -->

**About this list:**
=
● ***Hover* over *<a href="//" title="ToolTips will provide more information for blue fields.">blue fields</a>* for more info and notes**  
   **β“˜** β€Šβ€‚=  **Reference table** (hover for list of values)  
   **βˆ…** β€Šβ€‚=  **Optional field** (Nullable)   
  β€Šβ€‚**β‹ˆ** β€Šβ€Šβ€‚=  **Joined** (on foreign key)  
● Tables are *mostly* listed alphabetically (common at top, reference at bottom) 

∴ View ['Show All Types' Query][1]  
∴ View ['Table Schema' Query][2]  

[πŸ”—][3] Jump to: [**Stack Exchange Data Explorer**][3] <sub><sup>([Help][4])</sup></sub>  
[πŸ”—][5] Jump to: [**Stack Exchange Data Dump**][5] <sub><sup>([Readme][6])</sup></sub>    
[πŸ”—][7] Jump to: [**Stack Exchange API**][7] <sub><sup>([Support][8])</sup></sub>    


<sub>**Quick Reference Charts**: (PNG images to bookmark/download/print)</sub>  
   [<img src="https://i.stack.imgur.com/jujwU.png" height="150" alt="Image: SEDE Table List" title="Stack Exchange Data Explorer: Table List&#13;&#13;(Click to open, Right-click to save image)"/>][9]   [<img src="https://i.stack.imgur.com/2O1vL.png" height="150" alt="Image: SEDE Reference Table Values" title="Stack Exchange Data Explorer: Reference Table Values&#13;&#13;(Click to open, Right-click to save image)"/>][10]


<!--
-  **foreign key** fields are formatted as [links](https://data.stackexchange.com/stackoverflow/query/472607?table=posts) to their parent table  
- *italic* table names are found in **both** the Data Dump on [Archive.org](https://ia800500.us.archive.org/22/items/stackexchange/readme.txt) as well as in the [SEDE](http://data.stackexchange.com/)  
-->

-----
[<img src="https://i.stack.imgur.com/gj3dc.png" width="500" alt="STACK EXCHANGE DATA EXPLORER: TABLES" />][3]

**Posts <sub><sup>(and PostsWithDeleted)</sup></sub>**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Posts.PostTypeId β‹ˆ PostTypes.Id&#13;β€€πŸ·β€€:β€€πš€πšžπšŽπšœπšπš’πš˜πš—&#13;β€€πŸΈβ€€:β€€π™°πš—πšœπš πšŽπš›&#13;β€€πŸΉβ€€:β€€πš†πš’πš”πš’&#13;β€€πŸΊβ€€:β€€πšƒπšŠπšπš†πš’πš”πš’π™΄πš‘πšŒπšŽπš›πš™πš&#13;β€€πŸ»β€€:β€€πšƒπšŠπšπš†πš’πš”πš’&#13;β€€πŸΌβ€€:β€€π™Όπš˜πšπšŽπš›πšŠπšπš˜πš›π™½πš˜πš–πš’πš—πšŠπšπš’πš˜πš—&#13;β€€πŸ½β€€:β€€πš†πš’πš”πš’π™Ώπš•πšŠπšŒπšŽπš‘πš˜πš•πšπšŽπš›&#13;β€€πŸΎβ€€:β€€π™Ώπš›πš’πšŸπš’πš•πšŽπšπšŽπš†πš’πš”πš’">**`PostTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="Posts.AcceptedAnswerId β‹ˆ Posts.Id&#13;id of accepted answer for this question (when PostTypeId = 1)&#13;βˆ… ">**`AcceptedAnswerId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Posts.ParentId β‹ˆ Posts.Id&#13;id of question for this answer (when PostTypeId = 2)&#13;βˆ… ">**`ParentId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="present when post is closed (so only present in table PostsWithDeleted)&#13;βˆ… ">**`DeletionDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●**`Score`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`ViewCount`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="rendered HTML (not Markdown)&#13;">**`Body`**</a> <sub><sup><sub>nvarchar (-1)</sub></sup></sub>  
●<a href="//" title="Posts.OwnerUserId β‹ˆ Users.Id&#13;-1 = community wiki; Null = user has been deleted&#13;βˆ… ">**`OwnerUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`OwnerDisplayName`**</a> <sub><sup><sub>nvarchar (40)</sub></sup></sub>  
●<a href="//" title="Posts.LastEditorUserId β‹ˆ Users.Id&#13;userid of author of most recent edit&#13;βˆ… ">**`LastEditorUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="author of most recent edit&#13;βˆ… ">**`LastEditorDisplayName`**</a> <sub><sup><sub>nvarchar (40)</sub></sup></sub>  
●<a href="//" title="datetime of most recent edit&#13;βˆ… ">**`LastEditDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="datetime of the post's most recent activity&#13;">**`LastActivityDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="persent when PostTypeId in (1,4)&#13;βˆ… ">**`Title`**</a> <sub><sup><sub>nvarchar (250)</sub></sup></sub>  
●<a href="//" title="present when PostTypeId = 1&#13;βˆ… ">**`Tags`**</a> <sub><sup><sub>nvarchar (250)</sub></sup></sub>  
●<a href="//" title="present when PostTypeId = 1&#13;βˆ… ">**`AnswerCount`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CommentCount`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="present when PostTypeId = 1&#13;βˆ… ">**`FavoriteCount`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="present when post is closed&#13;βˆ… ">**`ClosedDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="present when post is community wiki'd&#13;βˆ… ">**`CommunityOwnedDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  

-----
**Users**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="total user reputation&#13;">**`Reputation`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●**`DisplayName`** <sub><sup><sub>nvarchar (40)</sub></sup></sub>  
●<a href="//" title="Datetime user last loaded a page (updated every 30 min at most)&#13;">**`LastAccessDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`WebsiteUrl`**</a> <sub><sup><sub>nvarchar (200)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Location`**</a> <sub><sup><sub>nvarchar (100)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`AboutMe`**</a> <sub><sup><sub>nvarchar (-1)</sub></sup></sub>  
●**`Views`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="count of upvotes the user has cast&#13;">**`UpVotes`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`DownVotes`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`ProfileImageUrl`**</a> <sub><sup><sub>nvarchar (200)</sub></sup></sub>  
●<a href="//" title="(always empty)&#13;βˆ… ">**`EmailHash`**</a> <sub><sup><sub>varchar (32)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Age`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Users.AccountId β‹ˆ Users.AccountId (Other SE Site)&#13;User's Stack Exchange Network profile ID&#13;βˆ… ">**`AccountId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**Comments**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Comments.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`Score`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="comment body&#13;">**`Text`**</a> <sub><sup><sub>nvarchar (600)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`UserDisplayName`**</a> <sub><sup><sub>nvarchar (30)</sub></sup></sub>  
●<a href="//" title="Comments.UserId β‹ˆ Users.Id&#13;Null = user is anonymous or has been deleted&#13;βˆ… ">**`UserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**Badges**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Badges.UserId β‹ˆ Users.Id&#13;">**`UserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  
●**`Date`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="Badges.Class β‹ˆ 1: Gold  2: Silver  3: Bronze&#13;">**`Class`**</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="True = Tag badge, False = named badge&#13;">**`TagBased`**</a> <sub><sup><sub>bit</sub></sup></sub>  

-----
**CloseAsOffTopicReasonTypes**  
●**`Id`** <sub><sup><sub>smallint (5)</sub></sup></sub>  
●**`IsUniversal`** <sub><sup><sub>bit</sub></sup></sub>  
●<a href="//" title="markdown of the close reason&#13;">**`MarkdownMini`**</a> <sub><sup><sub>nvarchar (500)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="CloseAsOffTopicReasonTypes.CreationModeratorId β‹ˆ Users.Id&#13;">**`CreationModeratorId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`ApprovalDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="CloseAsOffTopicReasonTypes.ApprovalModeratorId β‹ˆ Users.Id&#13;">**`ApprovalModeratorId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`DeactivationDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="CloseAsOffTopicReasonTypes.DeactivationModeratorId β‹ˆ Users.Id&#13;βˆ… ">**`DeactivationModeratorId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**PendingFlags**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PendingFlags.FlagTypeId β‹ˆ FlagTypes.Id&#13;πŸ·πŸΉβ€€:β€€πš€πšžπšŽπšœπšπš’πš˜πš—β€€πšπšŽπšŒπš˜πš–πš–πšŽπš—πšβ€€π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸΊβ€€:β€€πš€πšžπšŽπšœπšπš’πš˜πš—β€€π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸ»β€€:β€€πš€πšžπšŽπšœπšπš’πš˜πš—β€€πšπšŽπš˜πš™πšŽπš—">**`FlagTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="PendingFlags.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>date</sub></sup></sub>  
●<a href="//" title="PendingFlags.CloseReasonTypeId β‹ˆ CloseReasonTypes.Id&#13;βˆ… β€€β€€πŸ·β€€:β€€π™΄πš‘πšŠπšŒπšβ€€π™³πšžπš™πš•πš’πšŒπšŠπšπšŽ&#13;β€€β€€πŸΈβ€€:β€€π™Ύπšπšβ€€πšƒπš˜πš™πš’πšŒ&#13;β€€β€€πŸΉβ€€:β€€π™½πš˜πšβ€€π™²πš˜πš—πšœπšπš›πšžπšŒπšπš’πšŸπšŽ&#13;β€€β€€πŸΊβ€€:β€€π™½πš˜πšβ€€π™°β€€πšπšŽπšŠπš•β€€πš€πšžπšŽπšœπšπš’πš˜πš—&#13;β€€β€€πŸ½β€€:β€€πšƒπš˜πš˜β€€π™»πš˜πšŒπšŠπš•πš’πš£πšŽπš&#13;β€€πŸ·πŸΆβ€€:β€€π™ΆπšŽπš—πšŽπš›πšŠπš•β€€πšπšŽπšπšŽπš›πšŽπš—πšŒπšŽ&#13;β€€πŸΈπŸΆβ€€:β€€π™½πš˜πš’πšœπšŽβ€€π™Ύπšβ€€π™Ώπš˜πš’πš—πšπš•πšŽπšœπšœ&#13;πŸ·πŸΆπŸ·β€€:β€€π™³πšžπš™πš•πš’πšŒπšŠπšπšŽ&#13;πŸ·πŸΆπŸΈβ€€:β€€π™Ύπšπš-πšƒπš˜πš™πš’πšŒ&#13;πŸ·πŸΆπŸΉβ€€:β€€πš„πš—πšŒπš•πšŽπšŠπš›β€€πš†πš‘πšŠπšβ€€πšˆπš˜πšž'πš›πšŽβ€€π™°πšœπš”πš’πš—πš&#13;πŸ·πŸΆπŸΊβ€€:β€€πšƒπš˜πš˜β€€π™±πš›πš˜πšŠπš&#13;πŸ·πŸΆπŸ»β€€:β€€π™Ώπš›πš’πš–πšŠπš›πš’πš•πš’β€€π™Ύπš™πš’πš—πš’πš˜πš—-π™±πšŠπšœπšŽπš">**`CloseReasonTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="PendingFlags.CloseAsOffTopicReasonTypeId β‹ˆ CloseAsOffTopicReasonTypes.Id&#13;present when CloseReasonTypeId = 102&#13;βˆ… ">**`CloseAsOffTopicReasonTypeId`**</a> <sub><sup><sub>smallint (5)</sub></sup></sub>  
●<a href="//" title="PendingFlags.DuplicateOfQuestionId β‹ˆ Posts.Id&#13;present when CloseReasonTypeId in (1, 101)&#13;βˆ… ">**`DuplicateOfQuestionId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`BelongsOnBaseHostAddress`**</a> <sub><sup><sub>nvarchar (100)</sub></sup></sub>  

-----
**PostFeedback**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostFeedback.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`IsAnonymous`** <sub><sup><sub>bit</sub></sup></sub>  
●<a href="//" title="PostFeedback.VoteTypeId β‹ˆ VoteTypes.Id&#13;β€€πŸ·β€€:β€€π™°πšŒπšŒπšŽπš™πšπšŽπšπ™±πš’π™Ύπš›πš’πšπš’πš—πšŠπšπš˜πš›&#13;β€€πŸΈβ€€:β€€πš„πš™π™Όπš˜πš&#13;β€€πŸΉβ€€:β€€π™³πš˜πš πš—π™Όπš˜πš&#13;β€€πŸΊβ€€:β€€π™ΎπšπšπšŽπš—πšœπš’πšŸπšŽ&#13;β€€πŸ»β€€:β€€π™΅πšŠπšŸπš˜πš›πš’πšπšŽ&#13;β€€πŸΌβ€€:β€€π™²πš•πš˜πšœπšŽ&#13;β€€πŸ½β€€:β€€πšπšŽπš˜πš™πšŽπš—&#13;β€€πŸΎβ€€:β€€π™±πš˜πšžπš—πšπš’πš‚πšπšŠπš›πš&#13;β€€πŸΏβ€€:β€€π™±πš˜πšžπš—πšπš’π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸΆβ€€:β€€π™³πšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸ·β€€:β€€πš„πš—πšπšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸΈβ€€:β€€πš‚πš™πšŠπš–&#13;πŸ·πŸ»β€€:β€€π™Όπš˜πšπšŽπš›πšŠπšπš˜πš›πšπšŽπšŸπš’πšŽπš &#13;πŸ·πŸΌβ€€:β€€π™°πš™πš™πš›πš˜πšŸπšŽπ™΄πšπš’πšπš‚πšžπšπšπšŽπšœπšπš’πš˜πš—">**`VoteTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  

---
## *PostHistory*  
- `Id`  
- `PostHistoryTypeId` *(listed in the [`PostHistoryTypes`][4] table)*  
  <sub>1 = Initial Title - initial title *(questions only)*  
  2 = Initial Body - initial post raw body text  
  3 = Initial Tags - initial list of tags *(questions only)*  
  4 = Edit Title - modified title *(questions only)*  
  5 = Edit Body - modified post body (raw markdown)  
  6 = Edit Tags - modified list of tags *(questions only)*  
  7 = Rollback Title - reverted title  *(questions only)*  
  8 = Rollback Body - reverted body (raw markdown)  
  9 = Rollback Tags - reverted list of tags *(questions only)*  
  10 = Post Closed - post voted to be closed  
  11 = Post Reopened - post voted to be reopened  
  12 = Post Deleted - post voted to be removed  
  13 = Post Undeleted - post voted to be restored  
  14 = Post Locked - post locked by moderator  
  15 = Post Unlocked - post unlocked by moderator  
  16 = Community Owned - post now community owned  
  17 = Post Migrated - post migrated - *now replaced by 35/36 (away/here)*  
  18 = Question Merged - question merged with deleted question  
  19 = Question Protected - question was protected by a moderator.  
  20 = Question Unprotected - question was unprotected by a moderator.  
  21 = Post Disassociated - OwnerUserId removed from post by admin  
  22 = Question Unmerged - answers/votes restored to previously merged question  
  24 = Suggested Edit Applied  
  25 = Post Tweeted  
  31 = Comment discussion moved to chat  
  33 = Post notice added - *`comment` contains foreign key to PostNotices*  
  34 = Post notice removed - *`comment` contains foreign key to PostNotices*  
  35 = Post migrated away - *replaces id 17*  
  36 = Post migrated here - *replaces id 17*  
  37 = Post merge source  
  38 = Post merge destination</sub>

 Additionally, in [older dumps][6] *(all guesses, all seem no longer present in the wild):*  
  <sub>23 = Unknown dev related event  
  26 = Vote nullification by dev *(ERM?)*  
  27 = Post unmigrated/hidden moderator migration?  
  28 = Unknown suggestion event  
  29 = Unknown moderator event *(possibly de-wikification?)*  
  30 = Unknown event *(too rare to guess)*</sub>  

- [`PostId`](https://data.stackexchange.com/stackoverflow/query/472607?table=posts)  
- `RevisionGUID`: At times more than one type of history record can be recorded by a single action.  All of these will be grouped using the same RevisionGUID  
- `CreationDate` (e.g. `2009-03-05T22:28:34.823`)  
- [`UserId`](https://data.stackexchange.com/stackoverflow/query/472607?table=users)
- `UserDisplayName`: populated if a user has been removed and no longer referenced by user Id
- `Comment`: This field will contain the comment made by the user who edited a post. 
- If PostHistoryTypeId = 10, this field contains the CloseReasonId of the close reason (listed in `CloseReasonTypes`):  
  <sub>***Old close reasons:***  
  1 = Exact Duplicate  
  2 = Off-topic  
  3 = Subjective and argumentative  
  4 = Not a real question  
  7 = Too localized  
  10 = General reference  
  20 = Noise or pointless (Meta sites only)  
  ***Current close reasons:***  
  101 = Duplicate  
  102 = Off-topic  
  103 = Unclear what you're asking  
  104 = Too broad  
  105 = Primarily opinion-based</sub>  

 <sub>- If `PostHistoryTypeId in (33,34)` this field contains the `PostNoticeId` of the `PostNotice`</sub>  

- `Text`: A raw version of the new value for a given revision  
 <sub>- If `PostHistoryTypeId in (10,11,12,13,14,15,19,20,35)` this column will contain a JSON encoded string with all users who have voted for the `PostHistoryTypeId`</sub>  
 <sub>- If it is a duplicate close vote, the JSON string will contain an array of original questions as `OriginalQuestionIds`</sub>  
 <sub>- If `PostHistoryTypeId = 17` this column will contain migration details of either `from <url>` or `to <url>`</sub>  

-----
**PostLinks**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="PostLinks.PostId β‹ˆ Posts.Id&#13;id of source post&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostLinks.RelatedPostId β‹ˆ Posts.Id&#13;id of target/related post&#13;">**`RelatedPostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostLinks.LinkTypeId β‹ˆ 1: Linked (PostId contains a link to RelatedPostId) 3: Duplicate (PostId is a duplicate of RelatedPostId)&#13;type of link&#13;">**`LinkTypeId`**</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  

-----
**PostNotices**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostNotices.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostNotices.PostNoticeTypeId β‹ˆ PostNoticeTypes.Id&#13;β€€πŸ·β€€:β€€π™²πš’πšπšŠπšπš’πš˜πš—β€€πš—πšŽπšŽπšπšŽπš&#13;β€€πŸΈβ€€:β€€π™²πšžπš›πš›πšŽπš—πšβ€€πšŽπšŸπšŽπš—πš&#13;β€€πŸΉβ€€:β€€π™Έπš—πšœπšžπšπšπš’πšŒπš’πšŽπš—πšβ€€πšŽπš‘πš™πš•πšŠπš—πšŠπšπš’πš˜πš—&#13;πŸ·πŸΆβ€€:β€€π™²πšžπš›πš›πšŽπš—πšβ€€πšŠπš—πšœπš πšŽπš›πšœβ€€πšŠπš›πšŽβ€€πš˜πšžπšπšπšŠπšπšŽπš&#13;πŸ·πŸ·β€€:β€€π™³πš›πšŠπš β€€πšŠπšπšπšŽπš—πšπš’πš˜πš—&#13;πŸ·πŸΈβ€€:β€€π™Έπš–πš™πš›πš˜πšŸπšŽβ€€πšπšŽπšπšŠπš’πš•πšœ&#13;πŸ·πŸΉβ€€:β€€π™°πšžπšπš‘πš˜πš›πš’πšπšŠπšπš’πšŸπšŽβ€€πš›πšŽπšπšŽπš›πšŽπš—πšŒπšŽβ€€πš—πšŽπšŽπšπšŽπš&#13;πŸ·πŸΊβ€€:β€€π™²πšŠπš—πš˜πš—πš’πšŒπšŠπš•β€€πšŠπš—πšœπš πšŽπš›β€€πš›πšŽπššπšžπš’πš›πšŽπš&#13;πŸ·πŸ»β€€:β€€πšπšŽπš πšŠπš›πšβ€€πšŽπš‘πš’πšœπšπš’πš—πšβ€€πšŠπš—πšœπš πšŽπš›&#13;πŸΈπŸΆβ€€:β€€π™²πš˜πš—πšπšŽπš—πšβ€€πšπš’πšœπš™πšžπšπšŽ&#13;πŸΈπŸ·β€€:β€€π™Ύπšπšπšπš˜πš™πš’πšŒβ€€πšŒπš˜πš–πš–πšŽπš—πšπšœ&#13;πŸΈπŸΈβ€€:β€€π™·πš’πšœπšπš˜πš›πš’πšŒπšŠπš•β€€πšœπš’πšπš—πš’πšπš’πšŒπšŠπš—πšŒπšŽ&#13;πŸΈπŸΉβ€€:β€€πš†πš’πš”πš’β€€π™°πš—πšœπš πšŽπš›&#13;πŸ·πŸΆπŸΆπŸΆβ€€:β€€πšπšŽπšπšπš’πšπšπšŽπš">**`PostNoticeTypeId`**β“˜</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`DeletionDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`ExpiryDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="custom text shown with the notice&#13;βˆ… ">**`Body`**</a> <sub><sup><sub>nvarchar (-1)</sub></sup></sub>  
●<a href="//" title="PostNotices.OwnerUserId β‹ˆ Users.Id&#13;">**`OwnerUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostNotices.DeletionUserId β‹ˆ Users.Id&#13;βˆ… ">**`DeletionUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**PostTags**  
●<a href="//" title="PostTags.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostTags.TagId β‹ˆ Tags.Id&#13;">**`TagId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**ReviewTaskResults**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="ReviewTaskResults.ReviewTaskId β‹ˆ ReviewTasks.Id&#13;">**`ReviewTaskId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="ReviewTaskResults.ReviewTaskResultTypeId β‹ˆ ReviewTaskResultTypes.Id&#13;β€€πŸ·β€€:β€€π™½πš˜πšβ€€πš‚πšžπš›πšŽ&#13;β€€πŸΈβ€€:β€€π™°πš™πš™πš›πš˜πšŸπšŽ&#13;β€€πŸΉβ€€:β€€πšπšŽπš“πšŽπšŒπš&#13;β€€πŸΊβ€€:β€€π™³πšŽπš•πšŽπšπšŽ&#13;β€€πŸ»β€€:β€€π™΄πšπš’πš&#13;β€€πŸΌβ€€:β€€π™²πš•πš˜πšœπšŽ&#13;β€€πŸ½β€€:β€€π™»πš˜πš˜πš”πšœβ€€π™Άπš˜πš˜πš&#13;β€€πŸΎβ€€:β€€π™³πš˜β€€π™½πš˜πšβ€€π™²πš•πš˜πšœπšŽ&#13;β€€πŸΏβ€€:β€€πšπšŽπšŒπš˜πš–πš–πšŽπš—πšβ€€π™³πšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸΆβ€€:β€€πšπšŽπšŒπš˜πš–πš–πšŽπš—πšβ€€π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸ·β€€: 𝙸'πš–β€€π™³πš˜πš—πšŽ&#13;πŸ·πŸΈβ€€:β€€πšπšŽπš˜πš™πšŽπš—&#13;πŸ·πŸΉβ€€:β€€π™»πšŽπšŠπšŸπšŽβ€€π™²πš•πš˜πšœπšŽπš&#13;πŸ·πŸΊβ€€:β€€π™΄πšπš’πšβ€€πšŠπš—πšβ€€πšπšŽπš˜πš™πšŽπš—&#13;πŸ·πŸ»β€€:β€€π™΄πš‘πšŒπšŽπš•πš•πšŽπš—πš&#13;πŸ·πŸΌβ€€:β€€πš‚πšŠπšπš’πšœπšπšŠπšŒπšπš˜πš›πš’&#13;πŸ·πŸ½β€€:β€€π™½πšŽπšŽπšπšœβ€€π™Έπš–πš™πš›πš˜πšŸπšŽπš–πšŽπš—πš&#13;πŸ·πŸΎβ€€:β€€π™½πš˜β€€π™°πšŒπšπš’πš˜πš—β€€π™½πšŽπšŽπšπšŽπš&#13;πŸ·πŸΏβ€€:β€€πšπšŽπš“πšŽπšŒπšβ€€πšŠπš—πšβ€€π™΄πšπš’πš&#13;πŸΈπŸΆβ€€:β€€πš‚πš‘πš˜πšžπš•πšβ€€π™±πšŽβ€€π™Έπš–πš™πš›πš˜πšŸπšŽπš&#13;πŸΈπŸ·β€€:β€€πš„πš—πšœπšŠπš•πšŸπšŠπšπšŽπšŠπš‹πš•πšŽ&#13;πŸΈπŸΈβ€€:β€€πš‚πšžπšπšπšŽπšœπšπšŽπšπ™΄πšπš’πšπ™ΎπšŸπšŽπš›πš›πš’πšπšŽπšƒπš˜π™°πš™πš™πš›πš˜πšŸπšŽπš&#13;πŸΈπŸΉβ€€:β€€πš‚πšžπšπšπšŽπšœπšπšŽπšπ™΄πšπš’πšπ™ΎπšŸπšŽπš›πš›πš’πšπšŽπšƒπš˜πšπšŽπš“πšŽπšŒπšπšŽπš">**`ReviewTaskResultTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>date</sub></sup></sub>  
●<a href="//" title="ReviewTaskResults.RejectionReasonId β‹ˆ ReviewRejectionReasons.Id&#13;present for suggested edits&#13;βˆ… β€€β€€πŸ·β€€:β€€πšπšŠπšπš’πšŒπšŠπš•β€€π™²πš‘πšŠπš—πšπšŽ&#13;β€€β€€πŸΈβ€€:β€€πš…πšŠπš—πšπšŠπš•πš’πšœπš–&#13;β€€β€€πŸΉβ€€:β€€πšƒπš˜πš˜β€€π™Όπš’πš—πš˜πš›&#13;β€€β€€πŸΊβ€€:β€€π™Έπš—πšŸπšŠπš•πš’πšβ€€π™΄πšπš’πš&#13;β€€β€€πŸ»β€€:β€€π™²πš˜πš™πš’πšŽπšβ€€π™²πš˜πš—πšπšŽπš—πš&#13;β€€β€€πŸΌβ€€:β€€πš†πš’πš”πš’β€€π™½πš˜πšβ€€π™·πšŽπš•πš™πšπšžπš•&#13;β€€β€€πŸ½β€€:β€€π™΄πš‘πšŒπšŽπš›πš™πšβ€€π™½πš˜πšβ€€π™·πšŽπš•πš™πšπšžπš•&#13;β€€β€€πŸΎβ€€:β€€πš‚πšžπšπšπšŽπšœπšπšŽπšβ€€π™΄πšπš’πšβ€€π™²πš˜πš—πšπš•πš’πšŒπš&#13;β€€β€€πŸΏβ€€:β€€π™²πš›πš’πšπš’πšŒπšŠπš•β€€π™ΈπšœπšœπšžπšŽπšœ&#13;πŸ·πŸΆπŸ·β€€:β€€πš‚πš™πšŠπš–β€€π™Ύπš›β€€πš…πšŠπš—πšπšŠπš•πš’πšœπš–&#13;πŸ·πŸΆπŸΈβ€€:β€€π™½πš˜β€€π™Έπš–πš™πš›πš˜πšŸπšŽπš–πšŽπš—πšβ€€πš†πš‘πšŠπšπšœπš˜πšŽπšŸπšŽπš›&#13;πŸ·πŸΆπŸΉβ€€:β€€π™Έπš›πš›πšŽπš•πšŽπšŸπšŠπš—πšβ€€πšƒπšŠπš&#13;πŸ·πŸΆπŸΊβ€€:β€€π™²πš•πšŽπšŠπš›πš•πš’β€€π™²πš˜πš—πšπš•πš’πšŒπšπšœβ€€πš†πš’πšπš‘β€€π™°πšžπšπš‘πš˜πš›'πš‚β€€π™Έπš—πšπšŽπš—πš&#13;πŸ·πŸΆπŸ»β€€:β€€π™°πšπšπšŽπš–πš™πšβ€€πšƒπš˜β€€πšπšŽπš™πš•πš’&#13;πŸ·πŸΆπŸΌβ€€:β€€π™²πš˜πš™πš’πšŽπšβ€€π™²πš˜πš—πšπšŽπš—πš&#13;πŸ·πŸΆπŸ½β€€:β€€π™»πšŠπšŒπš”πšœβ€€πš„πšœπšŠπšπšŽβ€€π™Άπšžπš’πšπšŠπš—πšŒπšŽ&#13;πŸ·πŸΆπŸΎβ€€:β€€πš‚πšžπšπšπšŽπšœπšπšŽπšβ€€π™΄πšπš’πšβ€€π™²πš˜πš—πšπš•πš’πšŒπš&#13;πŸ·πŸΆπŸΏβ€€:β€€π™²πš›πš’πšπš’πšŒπšŠπš•β€€π™ΈπšœπšœπšžπšŽπšœ&#13;πŸ·πŸ·πŸΆβ€€:β€€π™²πš’πš›πšŒπšžπš•πšŠπš›β€€πšƒπšŠπšβ€€π™³πšŽπšπš’πš—πš’πšπš’πš˜πš—">**`RejectionReasonId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Comment`**</a> <sub><sup><sub>nvarchar (150)</sub></sup></sub>  

-----
**ReviewTasks**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="ReviewTasks.ReviewTaskTypeId β‹ˆ ReviewTaskTypes.Id&#13;β€€πŸΈβ€€:β€€π™²πš•πš˜πšœπšŽβ€€πš…πš˜πšπšŽπšœ&#13;β€€πŸΉβ€€:β€€π™»πš˜πš β€€πš€πšžπšŠπš•πš’πšπš’β€€π™Ώπš˜πšœπšπšœ&#13;β€€πŸΊβ€€:β€€π™΅πš’πš›πšœπšβ€€π™Ώπš˜πšœπš&#13;β€€πŸ»β€€:β€€π™»πšŠπšπšŽβ€€π™°πš—πšœπš πšŽπš›&#13;β€€πŸΌβ€€:β€€πšπšŽπš˜πš™πšŽπš—β€€πš…πš˜πšπšŽ&#13;β€€πŸ½β€€:β€€π™²πš˜πš–πš–πšžπš—πš’πšπš’β€€π™΄πšŸπšŠπš•πšžπšŠπšπš’πš˜πš—&#13;πŸ·πŸΆβ€€:β€€πšƒπš›πš’πšŠπšπšŽ&#13;πŸ·πŸ·β€€:β€€π™·πšŽπš•πš™πšŽπš›">**`ReviewTaskTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>date</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`DeletionDate`**</a> <sub><sup><sub>date</sub></sup></sub>  
●<a href="//" title="ReviewTasks.ReviewTaskStateId β‹ˆ ReviewTaskStates.Id&#13;β€€πŸ·β€€:β€€π™°πšŒπšπš’πšŸπšŽ&#13;β€€πŸΈβ€€:β€€π™²πš˜πš–πš™πš•πšŽπšπšŽπš&#13;β€€πŸΉβ€€:β€€π™Έπš—πšŸπšŠπš•πš’πšπšŠπšπšŽπš">**`ReviewTaskStateId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="ReviewTasks.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="ReviewTasks.SuggestedEditId β‹ˆ SuggestedEdits.Id&#13;present for suggested edits&#13;βˆ… ">**`SuggestedEditId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="ReviewTasks.CompletedByReviewTaskId β‹ˆ ReviewTaskResults.Id&#13;outcome of a completed review&#13;βˆ… ">**`CompletedByReviewTaskId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**SuggestedEdits**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="SuggestedEdits.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="Null = unapproved&#13;βˆ… ">**`ApprovalDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="Null = not rejected.  If this and ApprovalDate are both Null then edit is still in review and will have an active corresponding entry in ReviewTasks&#13;βˆ… ">**`RejectionDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="SuggestedEdits.OwnerUserId β‹ˆ Users.Id&#13;βˆ… ">**`OwnerUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Comment`**</a> <sub><sup><sub>nvarchar (800)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Text`**</a> <sub><sup><sub>nvarchar (-1)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Title`**</a> <sub><sup><sub>nvarchar (250)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Tags`**</a> <sub><sup><sub>nvarchar (250)</sub></sup></sub>  
●<a href="//" title="SuggestedEdits.RevisionGUID β‹ˆ PostHistory.RevisionGUID&#13;">**`RevisionGUID`**</a> <sub><sup><sub>uniqueidentifier</sub></sup></sub>  

-----
**SuggestedEditVotes**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="SuggestedEditVotes.SuggestedEditId β‹ˆ SuggestedEdits.Id&#13;">**`SuggestedEditId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="SuggestedEditVotes.UserId β‹ˆ Users.Id&#13;">**`UserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="SuggestedEditVotes.VoteTypeId β‹ˆ VoteTypes.Id&#13;β€€πŸ·β€€:β€€π™°πšŒπšŒπšŽπš™πšπšŽπšπ™±πš’π™Ύπš›πš’πšπš’πš—πšŠπšπš˜πš›&#13;β€€πŸΈβ€€:β€€πš„πš™π™Όπš˜πš&#13;β€€πŸΉβ€€:β€€π™³πš˜πš πš—π™Όπš˜πš&#13;β€€πŸΊβ€€:β€€π™ΎπšπšπšŽπš—πšœπš’πšŸπšŽ&#13;β€€πŸ»β€€:β€€π™΅πšŠπšŸπš˜πš›πš’πšπšŽ&#13;β€€πŸΌβ€€:β€€π™²πš•πš˜πšœπšŽ&#13;β€€πŸ½β€€:β€€πšπšŽπš˜πš™πšŽπš—&#13;β€€πŸΎβ€€:β€€π™±πš˜πšžπš—πšπš’πš‚πšπšŠπš›πš&#13;β€€πŸΏβ€€:β€€π™±πš˜πšžπš—πšπš’π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸΆβ€€:β€€π™³πšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸ·β€€:β€€πš„πš—πšπšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸΈβ€€:β€€πš‚πš™πšŠπš–&#13;πŸ·πŸ»β€€:β€€π™Όπš˜πšπšŽπš›πšŠπšπš˜πš›πšπšŽπšŸπš’πšŽπš &#13;πŸ·πŸΌβ€€:β€€π™°πš™πš™πš›πš˜πšŸπšŽπ™΄πšπš’πšπš‚πšžπšπšπšŽπšœπšπš’πš˜πš—">**`VoteTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="SuggestedEditVotes.TargetUserId β‹ˆ Users.Id&#13;βˆ… ">**`TargetUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`TargetRepChange`** <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**Tags**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●**`TagName`** <sub><sup><sub>nvarchar (35)</sub></sup></sub>  
●**`Count`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Tags.ExcerptPostId β‹ˆ Posts.Id&#13;βˆ… ">**`ExcerptPostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Tags.WikiPostId β‹ˆ Posts.Id&#13;βˆ… ">**`WikiPostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**TagSynonyms**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●**`SourceTagName`** <sub><sup><sub>nvarchar (35)</sub></sup></sub>  
●**`TargetTagName`** <sub><sup><sub>nvarchar (35)</sub></sup></sub>  
●**`CreationDate`** <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="TagSynonyms.OwnerUserId β‹ˆ Users.Id&#13;">**`OwnerUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●**`AutoRenameCount`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`LastAutoRename`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●**`Score`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="TagSynonyms.ApprovedByUserId β‹ˆ Users.Id&#13;βˆ… ">**`ApprovedByUserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`ApprovalDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  

-----
**Votes**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Votes.PostId β‹ˆ Posts.Id&#13;">**`PostId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="Votes.VoteTypeId β‹ˆ VoteTypes.Id β“˜&#13;β€€πŸ·β€€:β€€π™°πšŒπšŒπšŽπš™πšπšŽπšπ™±πš’π™Ύπš›πš’πšπš’πš—πšŠπšπš˜πš›&#13;β€€πŸΈβ€€:β€€πš„πš™π™Όπš˜πš&#13;β€€πŸΉβ€€:β€€π™³πš˜πš πš—π™Όπš˜πš&#13;β€€πŸΊβ€€:β€€π™ΎπšπšπšŽπš—πšœπš’πšŸπšŽ&#13;β€€πŸ»β€€:β€€π™΅πšŠπšŸπš˜πš›πš’πšπšŽ&#13;β€€πŸΌβ€€:β€€π™²πš•πš˜πšœπšŽ&#13;β€€πŸ½β€€:β€€πšπšŽπš˜πš™πšŽπš—&#13;β€€πŸΎβ€€:β€€π™±πš˜πšžπš—πšπš’πš‚πšπšŠπš›πš&#13;β€€πŸΏβ€€:β€€π™±πš˜πšžπš—πšπš’π™²πš•πš˜πšœπšŽ&#13;πŸ·πŸΆβ€€:β€€π™³πšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸ·β€€:β€€πš„πš—πšπšŽπš•πšŽπšπš’πš˜πš—&#13;πŸ·πŸΈβ€€:β€€πš‚πš™πšŠπš–&#13;πŸ·πŸ»β€€:β€€π™Όπš˜πšπšŽπš›πšŠπšπš˜πš›πšπšŽπšŸπš’πšŽπš &#13;πŸ·πŸΌβ€€:β€€π™°πš™πš™πš›πš˜πšŸπšŽπ™΄πšπš’πšπš‚πšžπšπšπšŽπšœπšπš’πš˜πš—">**`VoteTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●<a href="//" title="Votes.UserId β‹ˆ Users.Id&#13;-1 if user is deleted; present when VoteTypeId in (5,8)&#13;βˆ… ">**`UserId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="date only (time is removed to protect user privacy)&#13;">**`CreationDate`**</a> <sub><sup><sub>datetime</sub></sup></sub>  
●<a href="//" title="present when VoteTypeId in (8,9)&#13;βˆ… ">**`BountyAmount`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
[<img src="https://i.stack.imgur.com/1idoN.png" width="350" alt="STACK EXCHANGE DATA EXPLORER: REFERENCE TABLES" />][3]


**β“˜ CloseReasonTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (200)</sub></sup></sub>  
●<a href="//" title="βˆ… ">**`Description`**</a> <sub><sup><sub>nvarchar (500)</sub></sup></sub>  

-----
**β“˜ FlagTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  
●**`Description`** <sub><sup><sub>nvarchar (500)</sub></sup></sub>  

-----
**β“˜ PostHistoryTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  

-----
**β“˜ PostNoticeTypes**  
●**`Id`** <sub><sup><sub>int (10)</sub></sup></sub>  
●<a href="//" title="PostNoticeTypes.ClassId β‹ˆ 1 = Historical Lock  2 = Bounty  4 = Moderator Notice&#13;">**`ClassId`**</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (80)</sub></sup></sub>  
●<a href="//" title="default notice text&#13;">**`Body`**</a> <sub><sup><sub>nvarchar (-1)</sub></sup></sub>  
●**`IsHidden`** <sub><sup><sub>bit</sub></sup></sub>  
●**`Predefined`** <sub><sup><sub>bit</sub></sup></sub>  
●<a href="//" title="PostNoticeTypes.PostNoticeDurationId β‹ˆ -1: No duration specified    1: 7 days (bounty)&#13;">**`PostNoticeDurationId`**</a> <sub><sup><sub>int (10)</sub></sup></sub>  

-----
**β“˜ PostTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  

-----
**β“˜ ReviewRejectionReasons**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (100)</sub></sup></sub>  
●**`Description`** <sub><sup><sub>nvarchar (300)</sub></sup></sub>  
●<a href="//" title="ReviewRejectionReasons.PostTypeId β‹ˆ PostTypes.Id&#13;βˆ… β€€πŸ·β€€:β€€πš€πšžπšŽπšœπšπš’πš˜πš—&#13;β€€πŸΈβ€€:β€€π™°πš—πšœπš πšŽπš›&#13;β€€πŸΉβ€€:β€€πš†πš’πš”πš’&#13;β€€πŸΊβ€€:β€€πšƒπšŠπšπš†πš’πš”πš’π™΄πš‘πšŒπšŽπš›πš™πš&#13;β€€πŸ»β€€:β€€πšƒπšŠπšπš†πš’πš”πš’&#13;β€€πŸΌβ€€:β€€π™Όπš˜πšπšŽπš›πšŠπšπš˜πš›π™½πš˜πš–πš’πš—πšŠπšπš’πš˜πš—&#13;β€€πŸ½β€€:β€€πš†πš’πš”πš’π™Ώπš•πšŠπšŒπšŽπš‘πš˜πš•πšπšŽπš›&#13;β€€πŸΎβ€€:β€€π™Ώπš›πš’πšŸπš’πš•πšŽπšπšŽπš†πš’πš”πš’">**`PostTypeId`**β“˜</a> <sub><sup><sub>tinyint (3)</sub></sup></sub>  

-----
**β“˜ ReviewTaskResultTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (100)</sub></sup></sub>  
●**`Description`** <sub><sup><sub>nvarchar (300)</sub></sup></sub>  

-----
**β“˜ ReviewTaskStates**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  
●**`Description`** <sub><sup><sub>nvarchar (300)</sub></sup></sub>  

-----
**β“˜ ReviewTaskTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  
●**`Description`** <sub><sup><sub>nvarchar (300)</sub></sup></sub>  

-----
**β“˜ VoteTypes**  
●**`Id`** <sub><sup><sub>tinyint (3)</sub></sup></sub>  
●**`Name`** <sub><sup><sub>nvarchar (50)</sub></sup></sub>  

---
**xxxTypes**  
*Not listed here:*  
- `xxxTypes` tables which list (Id, Name) pairs for `Posts.PostTypeId`, `Votes.VoteTypeId`, etc.  
- See [Show all types][1] for an up-to-date list of all types.

-----
**TIMESTAMPS**:  
- All timestamps are [**`UTC`**][11], default format: `yyyy-MM-dd hh:mm:ss` (stored with milliseconds).  
- **Example of conversion** current time to `PST` (including [DST][12]) using [`At Time Zone`][13]:  
- `SELECT GetDate() At Time Zone 'UTC' At Time Zone 'Pacific Standard Time'`  
- <sub>To **list time zones**: `SELECT * FROM sys.time_zone_info`</sub>





  [1]: http://data.stackexchange.com/stackoverflow/query/36599/show-all-types
  [2]: https://data.stackexchange.com/stackoverflow/query/472607/information-schema-for-a-table
  [3]: https://data.stackexchange.com/
  [4]: https://data.stackexchange.com/help
  [5]: https://archive.org/download/stackexchange
  [6]: https://ia800107.us.archive.org/27/items/stackexchange/readme.txt
  [7]: https://api.stackexchange.com/docs
  [8]: https://stackapps.com/
  [9]: https://i.stack.imgur.com/jujwU.png
  [10]: https://i.stack.imgur.com/2O1vL.png
  [11]: https://www.epochconverter.com/
  [12]: https://www.google.com/search?q=dst
  [13]: https://docs.microsoft.com/sql/t-sql/queries/at-time-zone-transact-sql