Contains relationship information between a service category and a project
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Unique identifier of the service category, reference the table ASDK_CATEGORY.ctg_index |
| project_id* | INT | Related project ID, reference table ASMS_PROJECTS.proj_id |
Primary Key
| PK_ASDK_CATEGORY_PROJECT |
|---|
| category_id, project_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | dbo.ASDK_CATEGORY | ctg_index | F01_ASDK_CATEGORY_PROJECT |
| project_id* | dbo.ASMS_PROJECTS | proj_id | F02_ASDK_CATEGORY_PROJECT |