Table: export_template

Previous: export_criteria_value

Unanet Data Model

Next: export_template_data

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	export_template_key	decimal(15)
2.		name	varchar(128)
3.		owner_key	decimal(15)		person	fk_export_template1
4.		created	datetime
5.		last_updated	datetime
6.		file_type	varchar(25)
7.		template_type	varchar(25)
8.		editable	char(1)	('Y')
9.		import_ind	char(1)	('N')
10.		default_filename	varchar(250)
11.		default_email	varchar(250)
12.		user_email	char(1)	('N')
13.		description	varchar(2000)
14.		order_by_list	varchar(4000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
owner_key	person	person_key	fk_export_template1

Referenced from

Table	Column	Foreign Key Name
export_template_data	export_template_key	fk_export_template_data1

Check Constraints

Name	Definition
cc_editable	([editable]='N' OR [editable]='Y')
cc_file_type	([file_type]='Fixed-Formatted' OR [file_type]='Comma Separated Values')
cc_import_ind	([import_ind]='N' OR [import_ind]='Y')
cc_user_email	([user_email]='N' OR [user_email]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_export_template	true	export_template_key	Asc
idx_export_template1	true	name	Asc
idx_export_template2	false	owner_key	Asc