| 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 | ||