It represents the relationship that exists between a project and a group
Data model
Fields
Field | Type | Description |
---|---|---|
group_id* | INT | Related group ID, reference table AFW_GROUPS.grou_id |
profile_id* | INT | Related profile identifier, reference table ASMS_MODELPROFILES.id |
project_id* | INT | Related project ID, reference table ASMS_PROJECTS.proj_id |
Primary Key
PK_ASMS_GROUP_PROJECT |
---|
project_id, group_id, profile_id |
References
Column | Referenced Table | Referenced column | Name |
---|---|---|---|
group_id* | dbo.AFW_GROUPS | grou_id | FK03_ASMS_GROUP_PROJECT |
profile_id* | dbo.ASMS_MODELPROFILES | id | FK01_ASMS_GROUP_PROJECT |
project_id* | dbo.ASMS_PROJECTS | proj_id | FK02_ASMS_GROUP_PROJECT |