Table: dbo.Additional_Contact_Role
This table allows user to assign defined firm level additional contact roles to additional contact for a client.
Columns
Name | Type | Constraints | Description
additional_contact_role_KEY | int (4) | NOT NULL | Primary key for this table.
additional_contact_KEY | int (4) | NOT NULL | Additional Contact key for additional_contact_KEY column
firm_additional_contact_role_KEY | int (4) | NOT NULL | Firm Additional Contact Role key for firm_additional_contact_role_KEY column

Primary key
Name | Columns | Description
PK_Additional_Contact_Role | additional_contact_role_KEY |
Unique constraints
Name | Columns | Description
UK_Additional_Contact_Role$additional_contact_KEY$firm_additional_contact_role_KEY | additional_contact_KEY, firm_additional_contact_role_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Additional_Contact_Role__Additional_Contact__additional_contact_KEY | additional_contact_KEY | Additional_Contact (additional_contact_KEY) |
FK_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) |