Contains relationship information between a service category and a timer
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Unique identifier of the service category |
| service_id* | INT | Related Service Identifier |
| time_id* | INT | Timer ID |
| type | INT | Identifies the behavior of the category on a specific timer (1 = exclusive to the category, 2 = included) |
Primary Key
| PK_ASDK_CATEGORY_TIME |
|---|
| category_id, time_id, service_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | dbo.ASDK_CATEGORY | ctg_index | FK01_ASDK_CATEGORY_TIME |
| service_id* | dbo.ASDK_SERVICE | id | F03_ASDK_CATEGORY_TIME |
| time_id* | dbo.ASMS_TIMES | id | FK02_ASDK_CATEGORY_TIME |