Contains information on the relationship between a service category and its default time
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Unique identifier of the category, reference the table ASDK_CATEGORY.ctg_index |
| service_id* | INT | Unique identifier of the service, reference the ASDK_SERVICE.id table |
| time_id* | INT | Unique time identifier, reference table ASMS_TIMES.id |
Primary Key
| PK_ASDK_CATEGORY_TIME_DEFAULT |
|---|
| time_id, category_id, service_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | dbo.ASDK_CATEGORY | ctg_index | FK01_ASDK_CATEGORY_TIME_DEFAULT |
| service_id* | dbo.ASDK_SERVICE | id | FK02_ASDK_CATEGORY_TIME_DEFAULT |
| time_id* | dbo.ASMS_TIMES | id | FK03_ASDK_CATEGORY_TIME_DEFAULT |