Table: plan_set

Previous: person_time_day_tito

Unanet Data Model

Next: plan_set_history

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	plan_set_key	decimal(15)
2.		plan_set_name_key	decimal(15)		plan_set_name	fk_plan_set1
3.		project_key	decimal(15)		project	fk_plan_set2
4.		version	decimal(3)
5.		description	varchar(2000)
6.		active	char(1)	('N')
7.		locked	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
plan_set_name_key	plan_set_name	plan_set_name_key	fk_plan_set1
project_key	project	project_key	fk_plan_set2

Referenced from

Table	Column	Foreign Key Name
expense_plan	plan_set_key	fk_expense_plan4
plan_set_history	plan_set_key	fk_plan_set_history1
planned_time	plan_set_key	fk_planned_time8
resource_request	plan_set_key	fk_resource_request5

Check Constraints

Name	Definition
cc_plan_set_active	([active]='N' OR [active]='Y')
cc_plan_set_locked	([locked]='N' OR [locked]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_plan_set	true	plan_set_key	Asc
idx_plan_set1	true	project_key	Asc
		plan_set_name_key
		version
idx_plan_set2	false	plan_set_name_key	Asc