Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AssociationId | Unknown | 0 | null |
|
|
Primary key - FormInProgType unique identifier for each form-program association |
|||||
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Order in which forms are presented to users |
|||||
| fkFormID | int | 4 | √ | null |
|
|
Form reference - Reference to the form template |
||||
| fkProgramID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Program table for data relationships |
||||
| fkProgramTypeID | Unknown | 0 | null |
|
|
Program type reference - Reference to the program type |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this form is mandatory for this program type |