Contains the relationship between an interface and a state
Data model
Fields
| Field | Type | Description |
|---|---|---|
| console_id* | INT | Identifies the type of console to which you apply the status settings, (1 = specialist, 2 = client, 3 = administrator, 4 = cmdb) |
| editable | BIT | Indicates whether the interface is editable, (0 = read-only, 1 = editable) |
| interface_id* | INT | Unique interface identifier, reference table ASMS_INTERFACE.id |
| mandatory | BIT | Indicates whether the interface is mandatory, (0 = not mandatory, 1 = mandatory) |
| status_id* | INT | Unique status identifier, reference table ASMS_STATUS.stat_id |
| visible | BIT | Indicates whether the interface is visible, (0 = not visible, 1 = visible) |
Primary Key
| PK_ASMS_INTERFACE_STATUS |
|---|
| interface_id, status_id, console_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| interface_id* | dbo.ASMS_INTERFACE | id | FK01_ASMS_INTERFACE_STATUS |
| status_id* | dbo.ASMS_STATUS | stat_id | FK02_ASMS_INTERFACE_STATUS |