AspNetUsers


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 √ 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
MacmillanFileUpload.UserId FK_MacmillanFileUpload_UserIdR
OldId uniqueidentifier 16 null
tblAuditReferenceData.UserId FK_tblAuditReferenceData_AspNetUsersR
UserName nvarchar 512 null
Email nvarchar 512 √ null
EmailConfirmed bit 1 null
PasswordHash nvarchar 200 √ null
SecurityStamp nvarchar 200 √ null
PhoneNumber nvarchar 200 √ null
PhoneNumberConfirmed bit 1 null
TwoFactorEnabled bit 1 null
LockoutEndDateUtc datetime 16,3 √ null
LockoutEnabled bit 1 null
AccessFailedCount int 4 null
IsApproved bit 1 null
CreatedDate datetime 16,3 null
LastLoginDate datetime 16,3 √ null
LastPasswordChangeDate datetime 16,3 √ null
OrganisationCode nvarchar 10 √ null
DepartmentID int 4 √ null
FullName nvarchar 100 √ null
PasswordReset bit 1 √ null
AdminUserID int 4 null
ltblADMIN_USER.ADMIN_USER_ID FK_AspNetUsers_AdminUserIDR
AssociatedCNSId int 4 √ null
ltblCNS_NAME.ID FK_AspNetUsers_AssociatedCNSIdR
LastLockoutDate datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.AspNetUsers Primary key Asc Id
UQ_AspNetUsers_AssociatedCNSId Must be unique Asc AssociatedCNSId
UQ_AspNetUsers_OldId Must be unique Asc OldId

Relationships

Close relationships within degrees of separation