Entity that maps the relationship between groups and users
Data model
Fields
| Field | Type | Description |
|---|---|---|
| grou_id* | INT | Group ID, reference to AFW_GROUPS |
| user_id* | INT | User ID, reference to AFW_USERS |
Primary Key
| PK_AFW_GROUP_USER |
|---|
| grou_id, user_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| grou_id* | dbo.AFW_GROUPS | grou_id | FK02_AFW_GROUP_USER |
| user_id* | dbo.AFW_USERS | user_id | FK01_AFW_GROUP_USER |