Footprints Data Model

Table
Name email_notifn
Comment An email notification entry.

Column
Name Datatype Comment Is PK Is FK
email_notifn_id bigint The automatically generated primary key of the email_notifn table. Yes No
email_notifn_name varchar(255) The name of the Email Notification. No No
email_notifn_descr varchar(512) A descriptive name of the Email Notification. This descriptive name may be localized. No No
from_name varchar(255) From Name. No No
reply_addr varchar(255) Reply Address No No
to_recipients varchar(max) To Recipients No No
plain_text_body varchar(max) Plain Text Body No No
html_body varchar(max) HTML Body No No
subject varchar(255) Subject No No
retries_ct int Retries Count sent. There is a conditional index including this column to optimize sending speed. No No
schdd_date datetime Scheduled Date No No
time_before_break int Time Before Break No No
msgs_per_batch int Messages Per Batch No No
delay_between_batches int Delay Between Batches No No
create_date datetime Create Date No No
create_user bigint Create User No No
plain_text_auto bit Plain Text Auto No No
is_completed bit Is Completed. There is a conditional index including this column to optimize sending speed. No No
sent_recipients varchar(max) Sent Recipients No No
not_sent_recipients varchar(max) Not Sent Recipients. In the event of failure, these are the bouncebacks. No No
priority varchar(10) Priority No No
is_selected_recipients bit Is Selected Recipients No No
selected_recipients varchar(max) Selected Recipients No No
addr_book bigint Address Book identifier. No No
item_type bigint The item definition id No No
selected_field bigint Selected Field No No
email_notifn_type_id integer 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. No Yes