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