Intermediate table of association between groups and skills
Data model
Fields
| Field | Type | Description |
|---|---|---|
| grou_id* | INT | Associated group identifier. |
| required* | BIT | Marking to determine if the particular skill-group association is marked as required |
| score* | INT | Record skill score associated with the given group |
| skll_id* | INT | Associated skill identifier. |
Primary Key
| PK_AFLS_GROUP_SKILLS |
|---|
| grou_id, skll_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| grou_id* | dbo.AFW_GROUPS | grou_id | FK01_AFLS_GROUP_SKILLS |
| skll_id* | Bod. AFLS_SKILLS | skll_id | FK02_AFLS_GROUP_SKILLS |