Entity Notification Status

DescriptionThe condition or state of a communication.

For example:
Read
Not read
No action
Reviewed

Attributes
Delivery ModeDelivery Mode
Delivery StatusDelivery Status
Delivery Status TsDelivery Status Ts

Relationship
Notification Status _Notification_FKNotification Status _Notification_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Delivery Mode
DescriptionIndicates the method used to deliver a notification.
 
For example:
Email
Telephone call
Instant message
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Delivery Status
DescriptionIndicates the current state of the notification delivery.

For example:
Delivered
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Delivery Status Ts
DescriptionThe date and time the notification was sent to the recipient.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Notification Status _Notification_FK
Is Identifying Relationshiptrue
Child TableNotification Status
Child Role Nameshows customer interaction with
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableNotification
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE