Represents the relationship between SLAs and locations
Data model
Fields
| Field | Type | Description |
|---|---|---|
| location_id* | INT | Identifier of the associated location, reference the ASMS_LOCATION.id table |
| ser_id* | INT | Associated service ID, reference the ASDK_SERVICE.id table |
| sla_id | INT | Identifier of the associated SLA, reference the table ASDK_SLA. SLA_ID |
Primary Key
| PK_ASDK_SLA_LOCATION |
|---|
| location_id, ser_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| location_id* | dbo.ASMS_LOCATION | id | FK02_ASDK_SLA_LOCATION |
| ser_id* | dbo.ASDK_SERVICE | id | FK03_ASDK_SLA_LOCATION |
| sla_id | dbo.ASDK_SLA | sla_id | FK01_ASDK_SLA_LOCATION |