UserCategory


Description

User category classification defining categories for organizing and classifying users within the healthcare system. This table provides organizational structure for user management, enabling categorization by role type, employment status, or functional area to support user administration, reporting, and access control management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkUserCategoryID int identity 4 √ null
AccessUser.fkUserCategoryID FK__AccessUser__UserCat R

Primary key - Unique identifier for each user category
UserCategoryName nvarchar 510 √ null

Category name - Name of the user category for classification purposes

Indexes

Constraint Name Type Sort Column(s)
PK_UserCategory Primary key Asc pkUserCategoryID

Relationships

Close relationships within degrees of separation