Entity Subscription Notification Preference

DescriptionA set of details that describe the preferred notification process.

For example:
Email
Telephone call
Instant message

Attributes
Delivery ModeDelivery Mode
Notification Preference Start DateNotification Preference Start Date
Notification Preference Stop DateNotification Preference Stop Date

Relationship
Subscription Notification Preference_Subscription_FKSubscription Notification Preference_Subscription_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



 Notification Preference Start Date
DescriptionThe first date when a notification can be sent to the subscriber using the preferred delivery method.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Notification Preference Stop Date
DescriptionThe last date when a notification can be sent to the subscriber using the preferred delivery method.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Subscription Notification Preference_Subscription_FK
Is Identifying Relationshiptrue
Child TableSubscription Notification Preference
Child Role Namemultiple delivery preferences for
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableEvent Subscription
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE