CategoryGroupAssigned


Description

Category group assignments linking categories to user groups for access control and workflow management. This table manages which user groups have access to specific categories, enabling role-based access control and group-specific category visibility in the healthcare system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
catID int 4 √ null
Category.catID FK__CategoryG__catID__6FFF798F C

Category reference - Links to Category table for the assigned category
GroupID int 4 √ null
UserGroup.GroupID FK__CategoryG__Group__70F39DC8 C

Group reference - Links to UserGroup table for the user group with access
typeID Unknown 0 null

Assignment type - Type or level of access granted to the group for this category

Indexes

Constraint Name Type Sort Column(s)
IX_CatID Performance Asc catID
IX_GroupID Performance Asc GroupID

Relationships

Close relationships within degrees of separation