Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
ID key column (auto generated) |
|||||||||||||||||||
| AcceptedAnswerId | int | 4 | √ | null |
|
|
Post ID with the answer that was accepted for the question (FK to Posts table) |
|||||||||||||||||||
| AnswerCount | int | 4 | √ | null |
|
|
Number of Answers for the post |
|||||||||||||||||||
| Body | nvarchar | 2147483647 | null |
|
|
Content of the post |
||||||||||||||||||||
| ClosedDate | datetime | 16,3 | √ | null |
|
|
DateTime the post was closed |
|||||||||||||||||||
| CommentCount | int | 4 | √ | null |
|
|
Number of comments for the post |
|||||||||||||||||||
| CommunityOwnedDate | datetime | 16,3 | √ | null |
|
|
? |
|||||||||||||||||||
| CreationDate | datetime | 16,3 | null |
|
|
DateTime the post was created |
||||||||||||||||||||
| FavoriteCount | int | 4 | √ | null |
|
|
Number of times the post was added as a favorite |
|||||||||||||||||||
| LastActivityDate | datetime | 16,3 | null |
|
|
DateTime of the last activity regarding the post |
||||||||||||||||||||
| LastEditDate | datetime | 16,3 | √ | null |
|
|
DateTime of the last edit of the post |
|||||||||||||||||||
| LastEditorDisplayName | nvarchar | 80 | √ | null |
|
|
Display name of the user who edited the post recently |
|||||||||||||||||||
| LastEditorUserId | int | 4 | √ | null |
|
|
ID (FK to Users table) of the user who edited the post recently |
|||||||||||||||||||
| OwnerUserId | int | 4 | √ | null |
|
|
ID (FK to Users table) of the user who owns the post |
|||||||||||||||||||
| ParentId | int | 4 | √ | null |
|
|
Post which serves as the parent of this post (FK to Posts table) |
|||||||||||||||||||
| PostTypeId | int | 4 | null |
|
|
Type of the post (FK to PostTypes table) |
||||||||||||||||||||
| Score | int | 4 | null |
|
|
Score for the post: Shows how helpful the post was |
||||||||||||||||||||
| Tags | nvarchar | 300 | √ | null |
|
|
Tags / Keywords which are added to the Post |
|||||||||||||||||||
| Title | nvarchar | 500 | √ | null |
|
|
Title of the post |
|||||||||||||||||||
| ViewCount | int | 4 | null |
|
|
Number of times the post was viewed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Posts__Id | Primary key | Asc | Id |