Contains the relationship between an approval and a group
Data model
Fields
| Field | Type | Description |
|---|---|---|
| group_id* | INT | Unique identifier of the group, reference to the AFW_GROUPS.grou_id table |
| process_id* | INT | Unique identifier of the approval, reference to the ASMS_APPROVALS.id table |
Primary Key
| PK_ASMS_APPROVALS_GROUP |
|---|
| process_id, group_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| group_id* | dbo.AFW_GROUPS | grou_id | FK02_ASMS_APPROVALS_GROUP |
| process_id* | dbo.ASMS_APPROVALS | id | FK01_ASMS_APPROVALS_GROUP |