Store the relationship between user groups and self-service portal categories
Data model
Fields
| Field | Type | Description |
|---|---|---|
| creation_date* | DATETIME | Date of creation of the relationship |
| group_id* | INT | Group ID, reference to AFW_GROUPS.grou_id table |
| id* | INT | Registry ID |
| portal_category_id* | INT | Category identifier, reference to table ASD_PORTAL_CATEGORY. Id |
Primary Key
| PK_ASD_CATEGORY_USERGROUP |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| group_id* | dbo.AFW_GROUPS | grou_id | FK02_ASD_CATEGORY_USERGROUP |
| portal_category_id* | dbo.ASD_PORTAL_CATEGORY | id | FK01_ASD_CATEGORY_USERGROUP |