UserPermissions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Id int identity 4 null
UserId nvarchar 256 null
AspNetUsers.Id FK_dbo.UserPermissions_dbo.AspNetUsers_UserIdC
CancerSiteId int 4 null
CancerSites.Id FK_dbo.UserPermissions_dbo.CancerSites_CancerSiteIdC
SectionId int 4 null
UserPermissionSections.Id FK_dbo.UserPermissions_dbo.UserPermissionSections_SectionIdC
UserPermissionLevelId int 4 null
UserPermissionLevels.Id FK_dbo.UserPermissions_dbo.UserPermissionLevels_UserPermissionLevelIdR

Indexes

Constraint Name Type Sort Column(s)
PK_dbo.UserPermissions Primary key Asc Id
IX_CancerSiteId Performance Asc CancerSiteId
IX_SectionId Performance Asc SectionId
IX_UserId Performance Asc UserId
IX_UserPermissionLevelId Performance Asc UserPermissionLevelId

Relationships