Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
ID key column (auto generated) |
||||
| CreationDate | datetime | 16,3 | null |
|
|
DateTime at which the comment was created |
|||||
| PostId | int | 4 | null |
|
|
Post the comment relates to (FK to table Posts) |
|||||
| Score | int | 4 | √ | null |
|
|
Score for the comment: Shows how helpful the comment was regarding to the Post |
||||
| Text | nvarchar | 1400 | null |
|
|
Content/Text of the comment |
|||||
| UserId | int | 4 | √ | null |
|
|
User who wrote the comment (FK to Users table) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Comments__Id | Primary key | Asc | Id |