Table: dbo.Firm_Notification_Additional_Contact_Role
This table stores additional contact roles which are applicable to the notification type.
Columns
Name | Type | Constraints | Description
firm_notification_additional_contact_role_KEY | int (4) | NOT NULL | Primary key for this table.
firm_notification_information_KEY | tinyint (1) | NOT NULL | Key of the firm level notification type for which the email row corresponds to.
firm_additional_contact_role_KEY | int (4) | NOT NULL | Key of the firm additional contact role for which we need to send an alert or notification.

Primary key
Name | Columns | Description
PK_Firm_Notification_Additional_Contact_Role | firm_notification_additional_contact_role_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Firm_Notification_Additional_Contact_Role__Firm_Notification_Information__firm_notification_information_KEY | firm_notification_information_KEY | Firm_Notification_Information (firm_notification_information_KEY) |
FK_Firm_Notification_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEY | firm_additional_contact_role_KEY | Firm_Additional_Contact_Role (firm_additional_contact_role_KEY) |