Table: email_template

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK email_template_key decimal(15)      
2.   name varchar(50)      
3.   type decimal(3) ((0))    
4.   modifiable char(1) ('N')    
5.   description varchar(250)      
6.   subject varchar(250)      
7.   message varchar(2000)      
8.   enabled char(1)      
Referenced from
Table Column Foreign Key Name
project_invoice email_template_key fk_project_invoice12
Check Constraints
Name Definition
cc_enabled ([enabled]='N' OR [enabled]='Y')
cc_modifiable ([modifiable]='N' OR [modifiable]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_email_template true email_template_key Asc
idx_email_template1 true name Asc
    type