Table: skill_assignment
Columns
| |
Column Name |
Data Type |
Default
Value |
References
Table |
Foreign Key
Name |
| 1. |
PK |
person_key |
decimal(15) |
|
person |
fk_skill_assignment1 |
| 2. |
PK |
skill_key |
decimal(15) |
|
skill |
fk_skill_assignment2 |
| 3. |
PK |
proficiency_key |
decimal(15) |
|
proficiency |
fk_skill_assignment3 |
Foreign Keys
| Column |
References |
Foreign Key Name |
| Table |
Column |
| person_key |
person |
person_key |
fk_skill_assignment1 |
| proficiency_key |
proficiency |
proficiency_key |
fk_skill_assignment3 |
| skill_key |
skill |
skill_key |
fk_skill_assignment2 |
Indices
| Index Name |
Unique |
Column Name |
Asc Or Desc |
| pk_skill_assignment |
true |
person_key |
Asc |
| |
|
skill_key |
|
| |
|
proficiency_key |
|