Represents the relationship between a Service Category and a Case type (Incident, Change, Problem, or Service Call)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id | INT | Associated category identifier |
| cost_model_id | INT | Associated cost model identifier |
| model_id | INT | Associated model identifier |
| script_id | INT | Associated script identifier |
| service_id* | INT | Associated service identifier |
| type_id* | INT | Associated case type identifier |
Primary Key
| PK_ASDK_SERVICE_TYPE |
|---|
| service_id, type_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cost_model_id | dbo.ASDK_MODEL_COST_PRICE | mod_id | FK04_ASDK_SERVICE_TYPE |
| model_id | dbo.ASMS_MODEL | id | FK02_ASDK_SERVICE_TYPE |
| script_id | dbo.ASMS_SCRIPT | id | FK05_ASDK_SERVICE_TYPE |
| service_id* | dbo.ASDK_SERVICE | id | FK01_ASDK_SERVICE_TYPE |
| type_id* | dbo.ASMS_TYPES | id | FK03_ASDK_SERVICE_TYPE |