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 |