Store the information on the relationship between roles and permissions
Data model
Fields
| Field | Type | Description |
|---|---|---|
| is_audit* | INT | Identify if a permission in a role is auditable |
| modification_date | DATETIME | Date of last modification |
| modified_by | INT | Identifier of the last user who modified the record |
| perm_id* | INT | Permit ID |
| role_id* | INT | Role ID |
Primary Key
| PK_AFW_ROLE_PERMISSION |
|---|
| perm_id, role_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| perm_id* | dbo.AFW_PERMISSIONS | perm_id | FK01_AFW_ROLE_PERMISSION |
| role_id* | dbo.AFW_ROLES | role_id | FK02_AFW_ROLE_PERMISSION |