Table where the association between table AFLS_SERVICES and table AFLS_SKILLS is recorded.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| required* | BIT | Field to check if this skill record is required. |
| service_id* | INT | Identifier of the service to be associated. |
| skill_id* | INT | Identifier of the skill to be associated with the given service. |
| weight* | INT | Calculating the weight associated with the skill |
Primary Key
| PK_AFLS_SERVICES_SKILLS |
|---|
| service_id, skill_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| service_id* | dbo.AFLS_SERVICES | serv_id | FK01_AFLS_SERVICES_SKILLS |
| skill_id* | Bod. AFLS_SKILLS | skll_id | FK02_AFLS_SERVICES_SKILLS |