Store access information through the role
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 |
| roac_grou_id | INT | Group ID |
| roac_grou_parent | INT | Identifier of the group from which you inherit access |
| roac_id* | INT | Assignment ID |
| roac_proj_deny* | INT | Indicates if access to a project is denied |
| roac_proj_id | INT | Project ID |
| roac_role_id | INT | Role ID |
| roac_user_id | INT | User ID |
Primary Key
| PK_AFW_ROLE_ACCESS |
|---|
| roac_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| roac_grou_id | dbo.AFW_GROUPS | grou_id | FK01_AFW_ROLE_ACCES |
| roac_proj_id | dbo.AFW_PROJECTS | proj_id | FK04_AFW_ROLE_ACCES |
| roac_role_id | dbo.AFW_ROLES | role_id | FK03_AFW_ROLE_ACCES |
| roac_user_id | dbo.AFW_USERS | user_id | FK02_AFW_ROLE_ACCES |