Contains relationship information between a service category and an ASMS service
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Unique identifier of the service category, reference the table ASDK_CATEGORY.ctg_index |
| is_visible_home* | BIT | Identifies whether the category is visible on the home console home page, (0 = not visible, 1 = visible) |
| is_visible_user* | BIT | Identifies whether the category is visible to the user (0 = not visible, 1 = visible) |
| service_id* | INT | Related service ID, reference table ASDK_SERVICE.id |
| status_id* | INT | Current status identifier related to the category |
Primary Key
| PK_ASDK_CATEGORY_SERVICE |
|---|
| category_id, service_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | dbo.ASDK_CATEGORY | ctg_index | F01_ASDK_CATEGORY_SERVICE |
| service_id* | dbo.ASDK_SERVICE | id | F02_ASDK_CATEGORY_SERVICE |