email_template_send_log

Overview

A log of every email sent through the templating system

Object name email_template_send_log
Table name psys_email_template_send_log
Path /preside-objects/email/email_template_send_log.cfc

Properties

property name="email_template" relationship="many-to-one" relatedto="email_template" required=false indexes="template_sent|1,template_opened|1,template_failed|1,template_delivered|1,template_hard_bounced|1,template_marked_as_spam|1,template_unsubscribed|1,template_click_count|1";

property name="website_user_recipient"  relationship="many-to-one" relatedto="website_user"  required=false;
property name="security_user_recipient" relationship="many-to-one" relatedto="security_user" required=false;

property name="content" relationship="many-to-one" relatedto="email_template_send_log_content" required=false feature="emailCenterResend";

property name="recipient" type="string" dbtype="varchar" maxlength=255 required=true;
property name="sender"    type="string" dbtype="varchar" maxlength=255 required=true;
property name="subject"   type="string" dbtype="varchar" maxlength=255;
property name="resend_of" type="string" dbtype="varchar" maxlength=35;
property name="send_args" type="string" dbtype="text" autofilter=false;

property name="sent"           type="boolean" dbtype="boolean" default=false indexes="sent,template_sent|2";
property name="failed"         type="boolean" dbtype="boolean" default=false indexes="failed,template_failed|2" renderer="booleanBadge";
property name="delivered"      type="boolean" dbtype="boolean" default=false indexes="delivered,template_delivered|2";
property name="hard_bounced"   type="boolean" dbtype="boolean" default=false indexes="hard_bounced,template_hard_bounced|2";
property name="opened"         type="boolean" dbtype="boolean" default=false indexes="opened,template_opened|2";
property name="marked_as_spam" type="boolean" dbtype="boolean" default=false indexes="marked_as_spam,template_marked_as_spam|2";
property name="unsubscribed"   type="boolean" dbtype="boolean" default=false indexes="unsubscribed,template_unsubscribed|2";

property name="sent_date"           type="date" dbtype="datetime" indexes="sent_date";
property name="failed_date"         type="date" dbtype="datetime" indexes="failed_date";
property name="delivered_date"      type="date" dbtype="datetime" indexes="delivered_date";
property name="hard_bounced_date"   type="date" dbtype="datetime" indexes="hard_bounced_date";
property name="opened_date"         type="date" dbtype="datetime" indexes="opened_date";
property name="marked_as_spam_date" type="date" dbtype="datetime" indexes="marked_as_spam_date";
property name="unsubscribed_date"   type="date" dbtype="datetime" indexes="unsubscribed_date";

property name="click_count" type="numeric" dbtype="int" default=0 indexes="click_count,template_click_count|2";

property name="failed_reason" type="string"  dbtype="text";
property name="failed_code"   type="numeric" dbtype="int";

property name="activities" relationship="one-to-many" relatedto="email_template_send_log_activity" relationshipkey="message";

property name="activity_type"       formula="activities.activity_type";
property name="activity_ip"         formula="activities.user_ip";
property name="activity_user_agent" formula="activities.user_agent";
property name="activity_link"       formula="activities.link";
property name="activity_link_title" formula="activities.link_title";
property name="activity_link_body"  formula="activities.link_body";
property name="activity_code"       formula="activities.code";
property name="activity_reason"     formula="activities.reason";
property name="activity_date"       formula="activities.datecreated" type="date" dbtype="datetime";