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