We’re rewarding the question askers & reputations are being recalculated! Read more.
76 of 93 fixed image links

  • 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>  

-----
**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