AspNetUsers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id nvarchar 256 null
AspNetUserClaims.UserId FK_dbo.AspNetUserClaims_dbo.AspNetUsers_UserIdC
AspNetUserLogins.UserId FK_dbo.AspNetUserLogins_dbo.AspNetUsers_UserIdC
AspNetUserRoles.UserId FK_dbo.AspNetUserRoles_dbo.AspNetUsers_UserIdC
DocumentExportMessages.UserId FK_dbo.DocumentExportMessages_dbo.AspNetUsers_UserIdR
ReferenceDataAudit.UserId FK_dbo.ReferenceDataAudit_dbo.AspNetUsers_UserIdR
UserPermissions.UserId FK_dbo.UserPermissions_dbo.AspNetUsers_UserIdC
GivenName nvarchar 100 √ null
FamilyName nvarchar 120 √ null
Deleted bit 1 null
LastLoginDate datetime 16,3 √ null
OrganisationId int 4 √ null
Organisations.Id FK_dbo.AspNetUsers_dbo.Organisations_OrganisationIdR
JobRoleId int 4 √ null
UserJobRoles.Id FK_dbo.AspNetUsers_dbo.UserJobRoles_JobRoleIdR
Email 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
IX_OrganisationId Performance Asc OrganisationId
UserNameIndex Must be unique Asc UserName

Relationships

Close relationships within degrees of separation