Table to determine and associate the skill associated with a user
Data model
Fields
| Field | Type | Description |
|---|---|---|
| aus_required* | BIT | Column to identify whether the corresponding skill is in the enabled or disabled state. |
| aus_score* | DECIMAL | Column for recording the score of the skill associated with the user. |
| aus_skll_id* | INT | Primary Table Key with User Skill ID |
| aus_user_id* | INT | Table primary key with user ID |
Primary Key
| PK_AFLS_USER_SKILLS |
|---|
| aus_user_id, aus_skll_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| aus_skll_id* | Bod. AFLS_SKILLS | skll_id | FK02_AFLS_USER_SKILLS |
| aus_user_id* | dbo.AFLS_USERS_SPECIALISTS | user_id | FK01_AFLS_USER_SKILLS |