It contains the user access information depending on the type and project
Data model
Fields
| Field | Type | Description |
|---|---|---|
| project_id* | INT | Project ID, reference table ASMS_PROJECTS.proj_id |
| type_id* | INT | Access type identifier, reference the ASMS_TYPES.id table |
| user_id* | INT | User ID, reference the AFW_USERS.user_id table |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| project_id* | dbo.ASMS_PROJECTS | proj_id | FK02_ASMS_USER_ACCESS |
| type_id* | dbo.ASMS_TYPES | id | FK03_ASMS_USER_ACCESS |
| user_id* | dbo.AFW_USERS | user_id | FK01_ASMS_USER_ACCESS |