---Posts

Id
PostTypeId

1. Question
   
2. Answer
   
3. Orphaned tag wiki
   
4. Tag wiki excerpt
   
5. Tag wiki
   
6. Moderator nomination
   
7. "Wiki placeholder" (seems to only be the election description)
   
8. Privilege wiki
   AcceptedAnswerId (only present if PostTypeId is 1)
   ParentID (only present if PostTypeId is 2)
   CreationDate
   Score
   ViewCount
   Body
   OwnerUserId (present only if user has not been deleted; always -1 for tag wiki entries (i.e., the community user owns them))
   OwnerDisplayName
   LastEditorUserId
   LastEditorDisplayName="Rich B"
   LastEditDate="2009-03-05T22:28:34.823" - the date and time of the most recent edit to the post
   LastActivityDate="2009-03-11T12:51:01.480" - the date and time of the most recent activity on the post. For a question, this could be the post being edited, a new answer was posted, a bounty was started, etc.
   Title
   Tags
   AnswerCount
   CommentCount
   FavoriteCount
   ClosedDate (present only if the post is closed)
   CommunityOwnedDate (present only if post is community wikied)
   

---Users

Id
Reputation
CreationDate
DisplayName
LastAccessDate
WebsiteUrl
Location
AboutMe
Views
UpVotes
DownVotes
ProfileImageUrl
AccountId
Age

---Comments

Id
PostId
Score (Only present if score > 0)
Text, e.g.: "@Stu Thompson: What a horrible idea, you clueless git!"
CreationDate, e.g.:"2008-09-06T08:07:10.730"
UserDisplayName
UserId (Optional. Absent if user has been deleted?)

---Badges

Id
UserId, e.g.: "420"
Name, e.g.: "Teacher"
Date, e.g.: "2008-09-15T08:55:03.923"

---PostHistory

Id
PostHistoryTypeId
1.Initial Title - The first title a question is asked with.
2.Initial Body - The first raw body text a post is submitted with.
3.Initial Tags - The first tags a question is asked with.
4.Edit Title - A question's title has been changed.
5.Edit Body - A post's body has been changed, the raw text is stored here as markdown.
6.Edit Tags - A question's tags have been changed.
7.Rollback Title - A question's title has reverted to a previous version.
8.Rollback Body - A post's body has reverted to a previous version - the raw text is stored here.
9.Rollback Tags - A question's tags have reverted to a previous version.
10.Post Closed - A post was voted to be closed.
11.Post Reopened - A post was voted to be reopened.
12.Post Deleted - A post was voted to be removed.
13.Post Undeleted - A post was voted to be restored.
14.Post Locked - A post was locked by a moderator.
15.Post Unlocked - A post was unlocked by a moderator.
16.Community Owned - A post has become community owned.
17.Post Migrated - A post was migrated.
18.Question Merged - A question has had another, deleted question merged into itself.
19.Question Protected - A question was protected by a moderator
20.Question Unprotected - A question was unprotected by a moderator
21.Post Disassociated - An admin removes the OwnerUserId from a post
22.Question Unmerged - A previously merged question has had its answers and votes restored.
PostId
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: "2009-03-05T22:28:34.823"
UserId
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:
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)
New close reasons:
101: Duplicate
102: Off-topic
103: Unclear what you're asking
104: Too broad
105: Primarily opinion-based
Text: A raw version of the new value for a given revision

1. If PostHistoryTypeId = 10, 11, 12, 13, 14, or 15 this column will contain a JSON encoded string with all users who have voted for the PostHistoryTypeId
   
2. If it is a duplicate close vote, the JSON string will contain an array of original questions as OriginalQuestionIds
   
3. If PostHistoryTypeId = 17 this column will contain migration details of either from or to
   

---PostLinks

Id
CreationDate when the link was created
PostId id of source post
RelatedPostId id of target/related post
LinkTypeId type of link

1. Linked
   
2. Duplicate
   

---Votes

Id
PostId
VoteTypeId

1. AcceptedByOriginator
   
2. UpMod
   
3. DownMod
   
4. Offensive
   
5. Favorite (if VoteTypeId = 5, UserId will be populated)
   
6. Close
   
7. Reopen
   
8. BountyStart (if VoteTypeId = 8, UserId will be populated)
   
9. BountyClose
   
10. Deletion
    
11. Undeletion
    
12. Spam
    
13. ModeratorReview
    
14. ApproveEditSuggestion
    UserId (only present if VoteTypeId is 5 or 8)
    CreationDate
    BountyAmount (only present if VoteTypeId is 8 or 9)