Table: resource_request_skill

Previous: resource_request_history

Unanet Data Model

Next: role

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	resource_request_key	decimal(15)		resource_request	fk_resource_request_skill1
2.	PK	skill_key	decimal(15)		skill	fk_resource_request_skill2
3.	PK	proficiency_key	decimal(15)		proficiency	fk_resource_request_skill3

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
proficiency_key	proficiency	proficiency_key	fk_resource_request_skill3
resource_request_key	resource_request	resource_request_key	fk_resource_request_skill1
skill_key	skill	skill_key	fk_resource_request_skill2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_resource_request_skill	true	resource_request_key	Asc
		skill_key
		proficiency_key
idx_resource_request_skill1	false	resource_request_key	Asc