Table: plan_set_name

Previous: plan_set_history

Unanet Data Model

Next: planned_time

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	plan_set_name_key	decimal(15)
2.		plan_set_name	varchar(20)
3.		description	varchar(100)
4.		active	char(1)	('N')
5.		system_default	char(1)	('N')

Referenced from

Table	Column	Foreign Key Name
plan_set	plan_set_name_key	fk_plan_set1

Check Constraints

Name	Definition
cc_p_set_name_system_default	([system_default]='N' OR [system_default]='Y')
cc_plan_set_name_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_plan_set_name	true	plan_set_name_key	Asc
idx_plan_set_name1	true	plan_set_name	Asc