Subject Area : 096 - Email Notification
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 096 - Email Notification The email notification system uses table to manage processing of items. Details.. Details..
ER Diagram(s) of Subject Area "096 - Email Notification"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "096 - Email Notification"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 4
. email_notifn Email Notification false An email notification entry. Details..
. email_notifn_attch Email Notification Attachment false A link to an email attachment used for a notification email. Details..
. email_notifn_type Email Notification Type false Details..
. notifn_recipient_status Notification Recipient Status false Manages the sent and received status of the distribution list of contacts for a notification. Details..
Attribute/Column(s) of Entity/Table "Email Notification"
# Physical Name Name Definition Physical Data Type
Total 22
. email_notifn_id Email Notification Id The automatically generated primary key of the email_notifn table. bigint
. from_name From Name From Name. nvarchar(max)
. reply_addr Reply Address Reply Address nvarchar(max)
. plain_text_body Plain Text Body Plain Text Body nvarchar(max)
. html_body HTML Body HTML Body nvarchar(max)
. subject Subject Subject nvarchar(max)
. schdd_date Scheduled Date Scheduled Date of the mass email. datetime
. email_notifn_name Email Notification Name The name of the Email Notification. varchar(255)
. email_notifn_descr Email Notification Description A descriptive name of the Email Notification. This descriptive name may be localized. varchar(512)
. time_before_break Time Before Break Whether to send all emails at once, or send them at specified intervals. int
. msgs_per_batch Messages Per Batch How many messages to send Per Batch. int
. delay_between_batches Delay Between Batches Delay Between Batches int
. create_date Create Date Create Date datetime
. create_user Create User Create User int
. plain_text_auto Plain Text Auto Plain Text Auto bit
. priority Priority Email importance set in the rule ( low-5, normal-3, high-1) varchar(10)
. addr_book Address Book Address Book id used for mass emails. bigint
. item_type Item Type The item definition id, used for mass emails. bigint
. selected_field Selected Field The Selected Field for id lookup, used for mass emails. bigint
. email_notifn_type_id 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
. protocol_id Protocol Id The unique identifier for an instance of Email Notification. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer
. start_mail_sent Start Mail Sent Indicates if Start Mail Sent. bit
Attribute/Column(s) of Entity/Table "Email Notification Attachment"
# Physical Name Name Definition Physical Data Type
Total 3
. email_notifn_attch_id Email Notification Attachment Id The automatically generated primary key of the email_notifn_attch table. bigint
. email_attch_uri Email Attachment URI The value of a Email Notification Attachment, stored as a string. nvarchar(4000)
. email_notifn_id Email Notification Id The automatically generated primary key of the email_notifn table. bigint
Attribute/Column(s) of Entity/Table "Email Notification Type"
# Physical Name Name Definition Physical Data Type
Total 2
. email_notifn_type_id 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
. email_notifn_type_name Email Notification Type Name The unique string identifier for an instance of Email Notification Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
Attribute/Column(s) of Entity/Table "Notification Recipient Status"
# Physical Name Name Definition Physical Data Type
Total 7
. recipient_status_id Recipient Status Id The automatically generated primary key of the notification_recipient_status table. The name is shortened for convenience. bigint
. email_notifn_id Email Notification Id A Foreign Key to the Email Notification table. bigint
. recipient_contact Recipient Contact The value of a Notification Recipient Status, stored as a string. nvarchar(4000)
. retries_ct Retries Ct The value of a Notification Recipient Status stored as boolean. integer
. schdd_date Scheduled Date The date that the Notification Recipient Status was created. datetime
. completed_date Completed Date Completed Date. datetime
. notifn_status_code Notification Status Code The unique identifier for an instance of Notification Recipient Status. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. integer