Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Id | nvarchar | 256 | null |
|
|
|||||||||||||
GivenName | nvarchar | 100 | √ | null |
|
|
||||||||||||
FamilyName | nvarchar | 120 | √ | null |
|
|
||||||||||||
Deleted | bit | 1 | null |
|
|
|||||||||||||
LastLoginDate | datetime | 16,3 | √ | null |
|
|
||||||||||||
OrganisationId | int | 4 | √ | null |
|
|
||||||||||||
JobRoleId | int | 4 | √ | null |
|
|
||||||||||||
nvarchar | 512 | √ | null |
|
|
|||||||||||||
EmailConfirmed | bit | 1 | null |
|
|
|||||||||||||
PasswordHash | nvarchar | 1073741823 | √ | null |
|
|
||||||||||||
SecurityStamp | nvarchar | 1073741823 | √ | null |
|
|
||||||||||||
PhoneNumber | nvarchar | 1073741823 | √ | null |
|
|
||||||||||||
PhoneNumberConfirmed | bit | 1 | null |
|
|
|||||||||||||
TwoFactorEnabled | bit | 1 | null |
|
|
|||||||||||||
LockoutEndDateUtc | datetime | 16,3 | √ | null |
|
|
||||||||||||
LockoutEnabled | bit | 1 | null |
|
|
|||||||||||||
AccessFailedCount | int | 4 | null |
|
|
|||||||||||||
UserName | nvarchar | 512 | null |
|
|
|||||||||||||
InterfaceUser | bit | 1 | ((0)) |
|
|
|||||||||||||
Mobile | nvarchar | 1073741823 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PK_dbo.AspNetUsers | Primary key | Asc | Id |
IX_JobRoleId | Performance | Asc | JobRoleId |
UserNameIndex | Must be unique | Asc | UserName |