Table: proficiency

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK proficiency_key decimal(15)      
2.   proficiency_name varchar(50)      
3.   description varchar(2000)      
4.   sort_order decimal(15) ((0))    
Referenced from
Table Column Foreign Key Name
resource_request_skill proficiency_key fk_resource_request_skill3
skill_assignment proficiency_key fk_skill_assignment3
Indices
Index Name Unique Column Name Asc Or Desc
pk_proficiency true proficiency_key Asc
idx_proficiency1 true proficiency_name Asc