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
NameTypeConstraintsDescription
firm_additional_contact_role_KEYint (4)NOT NULLPrimary key for this table
descriptionnvarchar (60)NOT NULLDescription of the Additional Contact Role
is_activebit (1)NOT NULLAdditional Contact Role is active or not
Primary key
NameColumnsDescription
PK_Firm_Additional_Contact_Rolefirm_additional_contact_role_KEY
Unique constraints
NameColumnsDescription
UK_Firm_Additional_Contact_Role$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Firm_Notification_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEYfirm_additional_contact_role_KEYFirm_Notification_Additional_Contact_Role
FK_Additional_Contact_Role__Firm_Additional_Contact_Role__firm_additional_contact_role_KEYfirm_additional_contact_role_KEYAdditional_Contact_Role

Schema diagram