StackOverflow Download Data Schema

Recently the StackOverflow team released a download of their data.

Unfortunately, a schema was not included. Here it is in full:

Users

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

Badges

• UserId
• Name
• Date

Comments

• Id
• PostId
• Text
• CreationDate
• UserId
• UserDisplayName

Posts

• Id
• PostTypeId
• CreationDate
• Score
• ViewCount
• Body
• OwnerUserId
• OwnerDisplayName
• LastEditorUserId
• LastEditDate
• LastActivityDate
• Title
• Tags
• AnswerCount
• CommentCount
• FavoriteCount
• ClosedDate

Votes

• Id
• PostId
• VoteTypeId
• CreationDate