Database Schema
-
Posts
- Id
- int
- PostTypeId
- tinyint
- AcceptedAnswerId
- int
- ParentId
- int
- CreationDate
- datetime
- DeletionDate
- 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 (4000)
- AnswerCount
- int
- CommentCount
- int
- FavoriteCount
- int
- ClosedDate
- datetime
- CommunityOwnedDate
- datetime
- ContentLicense
- varchar (30)
-
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
- ProfileImageUrl
- nvarchar (200)
- EmailHash
- varchar (32)
- AccountId
- int
-
Comments
- Id
- int
- PostId
- int
- Score
- int
- Text
- nvarchar (600)
- CreationDate
- datetime
- UserDisplayName
- nvarchar (40)
- UserId
- int
- ContentLicense
- varchar (30)
-
Badges
- Id
- int
- UserId
- int
- Name
- nvarchar (50)
- Date
- datetime
- Class
- tinyint
- TagBased
- bit
-
CloseAsOffTopicReasonTypes
- Id
- smallint
- IsUniversal
- bit
- InputTitle
- nvarchar (100)
- MarkdownInputGuidance
- nvarchar (500)
- MarkdownPostOwnerGuidance
- nvarchar (500)
- MarkdownPublicGuidance
- nvarchar (500)
- MarkdownConcensusDescription
- nvarchar (500)
- CreationDate
- datetime
- CreationModeratorId
- int
- ApprovalDate
- datetime
- ApprovalModeratorId
- int
- DeactivationDate
- datetime
- DeactivationModeratorId
- int
-
CloseReasonTypes
- Id
- tinyint
- Name
- nvarchar (200)
- Description
- nvarchar (500)
-
FlagTypes
- Id
- tinyint
- Name
- nvarchar (50)
- Description
- nvarchar (500)
-
PendingFlags
- Id
- int
- FlagTypeId
- tinyint
- PostId
- int
- CreationDate
- date
- CloseReasonTypeId
- tinyint
- CloseAsOffTopicReasonTypeId
- smallint
- DuplicateOfQuestionId
- int
- BelongsOnBaseHostAddress
- nvarchar (100)
-
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)
- ContentLicense
- varchar (30)
-
PostHistoryTypes
- Id
- tinyint
- Name
- nvarchar (50)
-
PostLinks
- Id
- int
- CreationDate
- datetime
- PostId
- int
- RelatedPostId
- int
- LinkTypeId
- tinyint
-
PostNotices
- Id
- int
- PostId
- int
- PostNoticeTypeId
- int
- CreationDate
- datetime
- DeletionDate
- datetime
- ExpiryDate
- datetime
- Body
- nvarchar (max)
- OwnerUserId
- int
- DeletionUserId
- int
-
PostNoticeTypes
- Id
- int
- ClassId
- tinyint
- Name
- nvarchar (80)
- Body
- nvarchar (max)
- IsHidden
- bit
- Predefined
- bit
- PostNoticeDurationId
- int
-
PostsWithDeleted
- Id
- int
- PostTypeId
- tinyint
- AcceptedAnswerId
- int
- ParentId
- int
- CreationDate
- datetime
- DeletionDate
- 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 (4000)
- AnswerCount
- int
- CommentCount
- int
- FavoriteCount
- int
- ClosedDate
- datetime
- CommunityOwnedDate
- datetime
- ContentLicense
- varchar (30)
-
PostTags
- PostId
- int
- TagId
- int
-
PostTypes
- Id
- tinyint
- Name
- nvarchar (50)
-
RelatedQuestions
- PostId
- int
- RelatedPostId
- int
- Position
- int
- Score
- decimal
-
ReviewRejectionReasons
- Id
- tinyint
- Name
- nvarchar (100)
- Description
- nvarchar (300)
- PostTypeId
- tinyint
-
ReviewTaskResults
- Id
- int
- ReviewTaskId
- int
- ReviewTaskResultTypeId
- tinyint
- CreationDate
- date
- RejectionReasonId
- tinyint
- Comment
- nvarchar (400)
-
ReviewTaskResultTypes
- Id
- tinyint
- Name
- nvarchar (100)
- Description
- nvarchar (300)
-
ReviewTasks
- Id
- int
- ReviewTaskTypeId
- tinyint
- CreationDate
- date
- DeletionDate
- date
- ReviewTaskStateId
- tinyint
- PostId
- int
- SuggestedEditId
- int
- CompletedByReviewTaskId
- int
-
ReviewTaskStates
- Id
- tinyint
- Name
- nvarchar (50)
- Description
- nvarchar (300)
-
ReviewTaskTypes
- Id
- tinyint
- Name
- nvarchar (50)
- Description
- nvarchar (300)
-
SuggestedEdits
- Id
- int
- PostId
- int
- CreationDate
- datetime
- ApprovalDate
- datetime
- RejectionDate
- datetime
- OwnerUserId
- int
- Comment
- nvarchar (800)
- Text
- nvarchar (max)
- Title
- nvarchar (250)
- Tags
- nvarchar (250)
- RevisionGUID
- uniqueidentifier
-
SuggestedEditVotes
- Id
- int
- SuggestedEditId
- int
- UserId
- int
- VoteTypeId
- tinyint
- CreationDate
- datetime
- TargetUserId
- int
- TargetRepChange
- int
-
Tags
- Id
- int
- TagName
- nvarchar (35)
- Count
- int
- ExcerptPostId
- int
- WikiPostId
- int
- IsModeratorOnly
- bit
- IsRequired
- bit
-
TagSynonyms
- Id
- int
- SourceTagName
- nvarchar (35)
- TargetTagName
- nvarchar (35)
- 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
-
17495
anonymous
jan 3 '11 at 5:16