ProgramCustomForm


Description

Program custom form associations linking healthcare programs to custom forms and documentation templates for program-specific data collection. This junction table manages the relationship between programs and custom forms including form types, supporting program-specific documentation, custom data collection, and tailored form workflows for different healthcare service programs.

Columns

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

Primary key - Unique identifier for each program-custom form association
ProgramId int 4 √ null

Program reference - Links to the healthcare program that uses this custom form
CustomFormId int 4 √ null

Custom form reference - Links to the custom form or template associated with the program
Type nvarchar 40 √ null

Form type - Type or category of the custom form (e.g., ‘Assessment’, ‘Intake’, ‘Progress Note’, ‘Evaluation’)

Indexes

Constraint Name Type Sort Column(s)
PK__ProgramC__3214EC2771722728 Primary key Asc ID

Relationships

Close relationships within degrees of separation