Database Schema
expand
collapse
-
Posts
- Id
- int
- PostTypeId
- tinyint
- AcceptedAnswerId
- int
- ParentId
- int
- CreationDate
- datetime
- Score
- int
- ViewCount
- int
- Body
- nvarchar (max)
- OwnerUserId
- int
- OwnerDisplayName
- nvarchar (40)
- LastEditorUserId
- int
- LastEditorDisplayName
- nvarchar (40)
- LastEditDate
- datetime
- LastActivityDate
- datetime
- Title
- nvarchar (250)
- Tags
- nvarchar (150)
- AnswerCount
- int
- CommentCount
- int
- FavoriteCount
- int
- ClosedDate
- datetime
- CommunityOwnedDate
- datetime
-
Users
- Id
- int
- Reputation
- int
- CreationDate
- datetime
- DisplayName
- nvarchar (40)
- LastAccessDate
- datetime
- WebsiteUrl
- nvarchar (200)
- Location
- nvarchar (100)
- AboutMe
- nvarchar (max)
- Views
- int
- UpVotes
- int
- DownVotes
- int
- EmailHash
- varchar (32)
- Age
- int
-
Comments
- Id
- int
- PostId
- int
- Score
- int
- Text
- nvarchar (600)
- CreationDate
- datetime
- UserDisplayName
- nvarchar (30)
- UserId
- int
-
Badges
- Id
- int
- UserId
- int
- Name
- nvarchar (50)
- Date
- datetime
-
PostFeedback
- Id
- int
- PostId
- int
- IsAnonymous
- bit
- VoteTypeId
- tinyint
- CreationDate
- datetime
-
PostHistory
- Id
- int
- PostHistoryTypeId
- tinyint
- PostId
- int
- RevisionGUID
- uniqueidentifier
- CreationDate
- datetime
- UserId
- int
- UserDisplayName
- nvarchar (40)
- Comment
- nvarchar (400)
- Text
- nvarchar (max)
-
PostHistoryTypes
- Id
- tinyint
- Name
- nvarchar (50)
-
PostTags
- PostId
- int
- TagId
- int
-
PostTypes
- Id
- tinyint
- Name
- nvarchar (50)
-
SuggestedEdits
- Id
- int
- PostId
- int
- CreationDate
- datetime
- ApprovalDate
- datetime
- RejectionDate
- datetime
- OwnerUserId
- int
- Comment
- nvarchar (800)
- Text
- nvarchar (max)
- Title
- nvarchar (250)
- Tags
- nvarchar (150)
- RevisionGUID
- uniqueidentifier
-
SuggestedEditVotes
- Id
- int
- SuggestedEditId
- int
- UserId
- int
- VoteTypeId
- tinyint
- CreationDate
- datetime
- TargetUserId
- int
- TargetRepChange
- int
-
Tags
- Id
- int
- TagName
- nvarchar (25)
- Count
- int
- ExcerptPostId
- int
- WikiPostId
- int
-
TagSynonyms
- Id
- int
- SourceTagName
- nvarchar (25)
- TargetTagName
- nvarchar (25)
- CreationDate
- datetime
- OwnerUserId
- int
- AutoRenameCount
- int
- LastAutoRename
- datetime
- Score
- int
- ApprovedByUserId
- int
- ApprovalDate
- datetime
-
Votes
- Id
- int
- PostId
- int
- VoteTypeId
- tinyint
- UserId
- int
- CreationDate
- datetime
- BountyAmount
- int
-
VoteTypes
- Id
- tinyint
- Name
- nvarchar (50)
Revisions
-
122777
anonymous
mar 6 at 17:45
Hold tight while we fetch your results