Footprints Data Model

Table
Table Name Email Notification
Table Definition An email notification entry.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Email Notification Id The automatically generated primary key of the email_notifn table. LONG Yes
Email Notification Name The name of the Email Notification. VARCHAR(255) No
Email Notification Description A descriptive name of the Email Notification. This descriptive name may be localized. VARCHAR(512) No
From Name From Name. VARCHAR(255) No
Reply Address Reply Address VARCHAR(255) No
To Recipients To Recipients TEXT No
Plain Text Body Plain Text Body TEXT No
HTML Body HTML Body TEXT No
Subject Subject VARCHAR(255) No
Retries Count Retries Count sent. There is a conditional index including this column to optimize sending speed. INTEGER No
Scheduled Date Scheduled Date DATE No
Time Before Break Time Before Break INTEGER No
Messages Per Batch Messages Per Batch INTEGER No
Delay Between Batches Delay Between Batches INTEGER No
Create Date Create Date DATE No
Create User Create User LONG No
Plain Text Auto Plain Text Auto BOOLEAN Yes
Is Completed Is Completed. There is a conditional index including this column to optimize sending speed. BOOLEAN Yes
Sent Recipients Sent Recipients TEXT No
Not Sent Recipients Not Sent Recipients. In the event of failure, these are the bouncebacks. TEXT No
Priority Priority VARCHAR(10) No
Is Selected Recipients Is Selected Recipients BOOLEAN Yes
Selected Recipients Selected Recipients TEXT No
Address Book Address Book identifier. LONG No
Item Type The item definition id LONG No
Selected Field Selected Field LONG No
Email Notification Type Id The unique identifier for an instance of Email Notification Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. INTEGER Yes