Intermediate table for associating a skill with a user.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| avai_id* | INT | Primary key of the table with skill ID |
| user_id* | INT | Table primary key with user ID |
Primary Key
| PK_AFLS_USER_AVAILABILITIES |
|---|
| user_id, avai_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| avai_id* | Bod. AFLS_AVAILABILITIES | avai_id | FK01_AFLS_USER_AVAILABILITIES |
| user_id* | dbo.AFLS_USERS_SPECIALISTS | user_id | FK02_AFLS_USER_AVAILABILITIES |