Table: adhoc_criteria_set

Previous: address

Unanet Data Model

Next: adhoc_criteria_value

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	adhoc_criteria_set_key	decimal(15)
2.		person_key	decimal(15)		person	fk_adhoc_criteria_set1
3.		name	varchar(50)
4.		area_id	varchar(50)
5.		view_id	varchar(50)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_adhoc_criteria_set1

Referenced from

Table	Column	Foreign Key Name
adhoc_criteria_value	adhoc_criteria_set_key	fk_adhoc_criteria_value1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_adhoc_criteria_set	true	adhoc_criteria_set_key	Asc
idx_adhoc_criteria_set1	true	person_key	Asc
		name