Table: resource_request_history

Previous: resource_request_budget

Unanet Data Model

Next: resource_request_skill

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	resource_request_history_key	decimal(15)
2.		resource_request_key	decimal(15)		resource_request	fk_resource_request_history1
3.		person_key	decimal(15)		person	fk_resource_request_history2
4.		alternate_for_key	decimal(15)		person	fk_resource_request_history3
5.		role_key	decimal(15)		role	fk_resource_request_history4
6.		status	varchar(25)
7.		status_date	datetime
8.		comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_resource_request_history2
alternate_for_key	person	person_key	fk_resource_request_history3
resource_request_key	resource_request	resource_request_key	fk_resource_request_history1
role_key	role	role_key	fk_resource_request_history4

Check Constraints

Name	Definition
cc_rrh_status	([status]='ACCEPTED' OR [status]='REWORK' OR [status]='UNFULFILLED' OR [status]='FULFILLED' OR [status]='FULFILLING' OR [status]='REQUESTED' OR [status]='INUSE')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_resource_request_history	true	resource_request_history_key	Asc
idx_resource_request_history1	false	resource_request_key	Asc
idx_resource_request_history2	false	alternate_for_key	Asc
		role_key