This article outlines the database structure for the MMv4 sys_email_us_english database table. This table contains the data for system-generated email messages. 

• id
  Primary Key of admins table.
  int(10) | unsigned | auto increment | primary key | indexed
  
• name
  The name of the email message.
  varchar(255) | indexed
  
• description
  The description of the email message, displayed only to admins.
  varchar(255) | indexed
  
• content_html
  The contents of the HTML version of the email message.
  text
  
• content_text
  The contents of the plain-text version of the email message.
  text