Represents the relationship of the additional fields to the sections of the forms
Data model
Fields
| Field | Type | Description |
|---|---|---|
| field_id* | INT | Identifier of the additional field, reference the ASMS_FIELDS.id table |
| field_order* | INT | Display order of additional fields |
| section_id* | INT | Form section identifier, reference the ASMS_FORM_SECTIONS.id table |
Primary Key
| PK_ASMS_SECTION_FIELDS |
|---|
| section_id, field_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| field_id* | dbo.ASMS_FIELDS | id | FK02_ASMS_SECTION_FIELDS |
| section_id* | dbo.ASMS_FORM_SECTIONS | id | FK01_ASMS_SECTION_FIELDS |