Contains the information of the additional dependent fields configured for the ASMS suite
Data model
Fields
| Field | Type | Description |
|---|---|---|
| editable | BIT | Define whether the dependent field is editable or not |
| id* | INT | Unique identifier for the dependent field |
| inherit_value* | BIT | Defines whether the dependent field inherits the value of the parent field |
| mandatory | BIT | Define whether the dependent field is required or not |
| order* | INT | Describes the order in which the dependent field is displayed |
| source_id* | INT | Unique value identifier for the additional field |
| target_id* | INT | Unique value identifier for the additional field |
| value | INT | Describes the order in which the Field Values field is displayed |
| visible | BIT | Define whether dependent field is visible or not |
Primary Key
| PK_ASMS_FIELDS_DEPENDENTS |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| source_id* | dbo.ASMS_FIELDS | id | FK01_ASMS_FIELDS_DEPENDENTS |
| target_id* | dbo.ASMS_FIELDS | id | FK02_ASMS_FIELDS_DEPENDENTS |