ProgramAddons


Description

Program addon associations linking healthcare programs to additional features, modules, or services that extend program functionality. This junction table manages the relationship between programs and their available addons including ordering information, supporting program customization, feature management, and modular program configuration for healthcare service delivery.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkProgramAddonID int identity 4 √ null

Primary key - Unique identifier for each program-addon association
fkProgramID int 4 √ null

Program reference - Links to the healthcare program that uses this addon
fkAddonID int 4 √ null

Addon reference - Links to the addon or feature being associated with the program
orderBy int 4 √ null

Display order - Numeric order for displaying or processing addons within the program

Indexes

Constraint Name Type Sort Column(s)
PK_ProgramAddons Primary key Asc pkProgramAddonID

Relationships

Close relationships within degrees of separation