Table: export_template

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(2000)      
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