Intermediate table to relate roles to categories
Data model
Fields
| Field | Type | Description |
|---|---|---|
| category_id* | INT | Related category identifier. |
| id* | INT | Unique identifier of the table |
| role_id* | INT | Related Role Identifier. |
Primary Key
| PK_ALERTS_PERMISSIONS_EXTENSION |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| category_id* | Bod. AFW_ALERT_CATEGORY | id | FK02_AFLS_ALERTS_PERMISSIONS_EXTENSION |
| role_id* | Bod. AFW_ROLES | role_id | FK01_AFLS_ALERTS_PERMISSIONS_EXTENSION |