email_template_send_log_activity
Overview
A log of interactions with sent emails
| Object name | email_template_send_log_activity |
|---|---|
| Table name | psys_email_template_send_log_activity |
| Path | /preside-objects/email/email_template_send_log_activity.cfc |
Properties
property name="message" relationship="many-to-one" relatedto="email_template_send_log" required=true indexes="message,logdatecreated|1,logactivitytype|1";
property name="datecreated" indexes="datecreated,logdatecreated|2";
property name="activity_type" type="string" dbtype="varchar" maxlength=15 required=true enum="emailActivityType" indexes="activitytype,logactivitytype|2";
property name="classification" type="string" dbtype="varchar" maxlength=15 required=false indexes="classification";
property name="bot_score" type="numeric" dbtype="int" required=false;
property name="bot_signals" type="string" dbtype="varchar" maxlength=500 required=false;
property name="user_ip" type="string" dbtype="varchar" maxLength=255 required=true;
property name="user_agent" type="string" dbtype="text" required=false;
property name="extra_data" type="string" dbtype="longtext";
property name="link" type="string" dbtype="varchar" maxlength=750 indexes="link";
property name="link_title" type="string" dbtype="text";
property name="link_body" type="string" dbtype="text";
property name="code" type="string" dbtype="varchar" maxlength=20 indexes="errorcode";
property name="reason" type="string" dbtype="text";
property name="link_summary" formula="case when ${prefix}link_title is null and ${prefix}link_body is null then ${prefix}link else concat( coalesce( ${prefix}link_title, ${prefix}link_body ), ' (', ${prefix}link, ')' ) end";