Table: skill

Previous: shared_document

Unanet Data Model

Next: skill_assignment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	skill_key	decimal(15)
2.		skill_type_key	decimal(15)		skill_type	fk_skill1
3.		skill_name	varchar(50)
4.		description	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
skill_type_key	skill_type	skill_type_key	fk_skill1

Referenced from

Table	Column	Foreign Key Name
resource_request_skill	skill_key	fk_resource_request_skill2
skill_assignment	skill_key	fk_skill_assignment2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_skill	true	skill_key	Asc
idx_skill1	true	skill_name	Asc
		skill_type_key