Table: shared_criteria_set

Previous: sequence_number

Unanet Data Model

Next: shared_criteria_value

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	shared_criteria_set_key	decimal(15)
2.		name	varchar(50)
3.		target_path	varchar(128)
4.		manager_path	varchar(128)
5.		criteria_class	varchar(256)
6.		chart	char(1)	('N')
7.		modified_by	decimal(15)		person	fk_shared_criteria_set1
8.		modified_date	datetime	(getdate())

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
modified_by	person	person_key	fk_shared_criteria_set1

Referenced from

Table	Column	Foreign Key Name
shared_criteria_value	shared_criteria_set_key	fk_shared_criteria_value1

Check Constraints

Name	Definition
cc_shared_cs_chart	([chart]='N' OR [chart]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_shared_criteria_set	true	shared_criteria_set_key	Asc
idx_shared_criteria_set1	true	name	Asc