Table: plan_set_history

Previous: plan_set

Unanet Data Model

Next: plan_set_name

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	plan_set_history_key	decimal(15)
2.		plan_set_key	decimal(15)		plan_set	fk_plan_set_history1
3.		event	char(1)
4.		modified_by	decimal(15)		person	fk_plan_set_history2
5.		modified_timestamp	datetime
6.		comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
modified_by	person	person_key	fk_plan_set_history2
plan_set_key	plan_set	plan_set_key	fk_plan_set_history1

Check Constraints

Name	Definition
cc_plan_set_history_event	([event]='R' OR [event]='C' OR [event]='L' OR [event]='D' OR [event]='A')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_plan_set_history	true	plan_set_history_key	Asc