Table: dbo.Firm_Notification_Additional_Contact_Role
This table stores additional contact roles which are applicable to the notification type.
Columns
NameTypeConstraintsDescription
firm_notification_additional_contact_role_KEYint (4)NOT NULLPrimary key for this table.
firm_notification_information_KEYtinyint (1)NOT NULLKey of the firm level notification type for which the email row corresponds to.
firm_additional_contact_role_KEYint (4)NOT NULLKey of the firm additional contact role for which we need to send an alert or notification.
Primary key
NameColumnsDescription
PK_Firm_Notification_Additional_Contact_Rolefirm_notification_additional_contact_role_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Firm_Notification_Additional_Contact_Role__Firm_Notification_Information__firm_notification_information_KEYfirm_notification_information_KEYFirm_Notification_Information (firm_notification_information_KEY)
FK_Firm_Notification_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEYfirm_additional_contact_role_KEYFirm_Additional_Contact_Role (firm_additional_contact_role_KEY)

Schema diagram