Represents the relationship between a group of users and a specific user
Data model
Fields
| Field | Type | Description |
|---|---|---|
| group_id* | INT | Related group ID, reference table AFW_GROUPS.grou_id |
| project_id | INT | Related project ID, reference table ASMS_PROJECTS.proj_id |
| type_id | INT | Related type identifier, reference table ASMS_TYPES.id |
| user_id* | INT | Related user ID, reference the AFW_USERS.user_id table |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| project_id | dbo.ASMS_PROJECTS | proj_id | FK01_ASMS_GROUP_USER |
| type_id | dbo.ASMS_TYPES | id | FK02_ASMS_GROUP_USER |