Table: dbo.Firm_Additional_Contact_Role
This table is used to save various roles to the Additional Contacts they set up on their clients
Columns
Name | Type | Constraints | Description
firm_additional_contact_role_KEY | int (4) | NOT NULL | Primary key for this table
description | nvarchar (60) | NOT NULL | Description of the Additional Contact Role
is_active | bit (1) | NOT NULL | Additional Contact Role is active or not

Primary key
Name | Columns | Description
PK_Firm_Additional_Contact_Role | firm_additional_contact_role_KEY |
Unique constraints
Name | Columns | Description
UK_Firm_Additional_Contact_Role$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Firm_Notification_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEY | firm_additional_contact_role_KEY | Firm_Notification_Additional_Contact_Role |
FK_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEY | firm_additional_contact_role_KEY | Additional_Contact_Role |