This article outlines the database structure for the MMv4 em_template database table.

• id
  Primary key of the em_template table.
  int(10) | unsigned | auto increment | primary key| indexed
  
• active
  Signifies if this email template is active or not.
  int(10) | unsigned | indexed | 0/timestamp
  
• from_email
  The email address in which the email template will be addressed from.
  varchar(255) | indexed
• from_name
  The name in which the email template will be addressed from.
  varchar(255) | indexed
• subject
  The subject that will be associated with all emails that use this email template.
  varchar(255) | indexed
• text_msg
  The text email message for this email template.
  varchar(255) | indexed
• html_msg
  The HTML rendered email message for this email template.
  varchar(255) | indexed
• track_links
  Specifies if html links will be tracked for this specific email template.
  int(10) | unsigned | indexed | 0/timestamp
• track_reads
  Specifies if the emails opened will be tracked for this specific email template.
  int(10) | unsigned | indexed | 0/timestamp
• bcc_email
  Email address that will be Blind Carbon Copied for this email template.
  varchar(255) | indexed