Contains the behavior information of an additional field per state in the console
Data model
Fields
| Field | Type | Description |
|---|---|---|
| console_id* | INT | Associated console type (specialist, client, administrator, CMDB) |
| editable | BIT | Identifies if the field is editable in this state, (0 = non-editable, 1 = editable) |
| field_id* | INT | Identifier of the associated additional field, reference the ASMS_FIELDS.id table |
| mandatory | BIT | Identifies if the field is required in this state, (0 = not required, 1 = required) |
| status_id* | INT | Associated state identifier, reference the ASMS_STATUS.stat_id table |
| visible | BIT | Identifies whether the field is visible in this state, (0 = not visible, 1 = visible) |
Primary Key
| PK_ASMS_FIELDS_STATUS |
|---|
| field_id, status_id, console_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| field_id* | dbo.ASMS_FIELDS | id | FK01_ASMS_FIELDS_STATUS |
| status_id* | dbo.ASMS_STATUS | stat_id | FK02_ASMS_FIELDS_STATUS |