29 of 93 Add AccountId; mention EmailHash is blanked

May 2012

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
  • EmailHash (now always blank)
  • 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"

PostFeedback

  • Id
  • PostId
  • IsAnonymous
  • VoteTypeId
  • CreationDate

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
    • 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
    • If it is a duplicate close vote, the JSON string will contain an array of original questions as OriginalQuestionIds
    • If PostHistoryTypeId = 17 this column will contain migration details of either from <url> or to <url>

PostHistoryTypes

  • Id
  • Name

PostTags

  • PostId
  • TagId

PostTypes

  • Id
  • Name

SuggestedEdits

  • Id
  • PostId
  • CreationDate
  • ApprovalDate
  • RejectionDate
  • OwnerUserId
  • Comment
  • Text
  • Title
  • Tags
  • RevisionGUID

SuggestedEditVotes

  • Id
  • SuggestedEditId
  • UserId
  • VoteTypeId
  • CreationDate
  • TargetUserId
  • TargetRepChange

Tags

  • Id
  • TagName
  • Count
  • ExcerptPostId
  • WikiPostId

TagSynonyms

  • Id
  • SourceTagName
  • TargetTagName
  • CreationDate
  • OwnerUserId
  • AutoRenameCount
  • LastAutoRename
  • Score
  • ApprovedByUserId
  • ApprovalDate

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
    15 - ModeratorReview  
    16 - ApproveEditSuggestion
    
  • UserId (only present if VoteTypeId is 5 or 8)
  • CreationDate
  • BountyAmount (only present if VoteTypeId is 8 or 9)

VoteTypes

  • Id
  • Name