Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | int identity | 4 | √ | null |
|
|
ID key column (auto generated) |
||||||||||||||||
| AboutMe | nvarchar | 2147483647 | √ | null |
|
|
Profile of the user |
||||||||||||||||
| Age | int | 4 | √ | null |
|
|
User Age |
||||||||||||||||
| CreationDate | datetime | 16,3 | null |
|
|
DateTime the user account was created |
|||||||||||||||||
| DisplayName | nvarchar | 80 | null |
|
|
Username to be displayed |
|||||||||||||||||
| DownVotes | int | 4 | null |
|
|
Number of negative votes the user has received |
|||||||||||||||||
| EmailHash | nvarchar | 80 | √ | null |
|
|
hash of the e-mailaddress of the user |
||||||||||||||||
| LastAccessDate | datetime | 16,3 | null |
|
|
DateTIme of the last login of the user |
|||||||||||||||||
| Location | nvarchar | 200 | √ | null |
|
|
Location the user lives at |
||||||||||||||||
| Reputation | int | 4 | null |
|
|
Score the user has achieved at StackOverflow |
|||||||||||||||||
| UpVotes | int | 4 | null |
|
|
Number of positive votes the user has received |
|||||||||||||||||
| Views | int | 4 | null |
|
|
Number of Views of the User’s profile |
|||||||||||||||||
| WebsiteUrl | nvarchar | 400 | √ | null |
|
|
URL of the homepage of the user |
||||||||||||||||
| AccountId | int | 4 | √ | null |
|
|
AccountId of the user |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Users_Id | Primary key | Asc | Id |