CaseCategoryInProgramType


Description

Case category program assignments linking case categories to specific program types for program-specific case management. This table manages which case categories are available for each program type, enabling program-specific case classification and workflow management in healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
caseid int 4 √ null
CaseCategory.CaseID FK__CaseCateg__casei__0E8400AF C

Case category reference - Links to CaseCategory table for the case category
ProgramID int 4 √ null

Program reference - Links to the program type that uses this case category

Indexes

Constraint Name Type Sort Column(s)
IX_CaseID Performance Asc caseid
IX_ProgramID Performance Asc ProgramID

Relationships

Close relationships within degrees of separation