Stores role access information per object
Data model
Fields
| Field | Type | Description |
|---|---|---|
| modification_date | DATETIME | Date of last modification |
| modified_by | INT | Identifier of the last user who modified the record |
| roao_id* | INT | Identifier of the relationship between the role access and the object |
| roao_object_id* | INT | Object Identifier |
| roao_object_type_id* | INT | Object Type Identifier |
| roao_role_access_id* | INT | Role Access Assignment ID |
Primary Key
| PK_AFW_ROLE_ACCESS_OBJECT |
|---|
| roao_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| roao_object_type_id* | dbo.AFW_CONCEPT | id | FK02_AFW_ROLE_ACCESS_OBJECT |
| roao_role_access_id* | dbo.AFW_ROLE_ACCESS | roac_id | FK01_AFW_ROLE_ACCESS_OBJECT |