Votes

317439 rows


Description

Votes regarding Posts at StackOverflow

Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ null

ID key column (auto generated)

PostId int 4 null
Posts.Id FK_Vote_Posts R

Post ID (FK to Posts Table)

UserId int 4 √ null
Users.Id FK_Vote_Users R

User ID (FK to Users table)

BountyAmount int 4 √ null

Bounty (reputation) which was set for answering the question

VoteTypeId int 4 null
VoteTypes.Id FK_VoteType R

Type of the vote (FK to VoteTypes table)

CreationDate datetime 16,3 null

DateTime the vote was created

Indexes

Constraint Name Type Sort Column(s)
PK_Votes__Id Primary key Asc Id

Relationships