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 |