HomeLog InSign Up

Tracking Email Pattern

The TrackingEmailPattern table stores email templates that are used to send emails to contacts. The table includes columns for the email template ID, country ID, tracking event ID, email subject, email content, and the user who created or last modified the record, along with the corresponding date and time.

Table Structure

  • [ID] (bigint, auto-incrementing, primary key): Represents the unique identifier for each email template record.

  • [Country_ID] (bigint, not null): Foreign key referencing the country associated with the tracking email pattern.

  • [Tracking_Event_ID] (bigint, not null): Foreign key referencing the tracking event associated with the pattern.

  • [Subject] (nvarchar(max), nullable): Represents the subject of the email. (e.g., "Your order has been shipped!")

  • [Email_Content] (nvarchar(max), nullable): Represents the content of the email. (e.g., HTML content or plain text).

  • [Modified_By] (bigint, nullable): Represents the user who last modified the pattern.

  • [Modified_Date] (datetime, not null): Represents the date and time when the pattern was last modified.

  • [Created_By] (bigint, nullable): Represents the user who created the pattern.

  • [Created_Date] (datetime, not null): Represents the date and time when the pattern was created.

Constraints

  • [PK_PatternMapping]: Primary key constraint on the [ID] column.

  • [DF_PatternContent_ModifiedDate]: Default constraint to set [Modified_Date] to the current UTC date and time.

  • [DF_PatternContent_CreatedDate]: Default constraint to set [Created_Date] to the current UTC date and time.

Example Data

Country_Code
Tracking_Event_Code
Subject
Email_Content

US

RESET-PASSWORD

Reset your password

<html lang="en"><body><p>Dear {{ user.nick_name }},</p><p>Sorry to hear you're having trouble logging into {{ brand.website_cpanel }}. We got a message that you forgot your password. No change has been made to your account yet.</p><p>You can reset your password by clicking the link below:</p><a href="{{ reset_password_link }}">Reset Password Link</a><p>The link above will be expired in 2 hours.</p><p>If you have any questions or need further assistance, please don't hesitate to contact us: {{ brand.email_support }}</p><p><br>Best regards,<br>{{ brand.email_support_title }}</p></body></html>

PreviousTracking EmailNextTracking Email Read

Last updated

Was this helpful?