Table: Outlook_Contact_Synchronization_Profile
Stores a Contact Synchronization Profile, a staff-specific set of Outlook? folders and database contact filters to configure contact syncronization.
Columns
Name | Type | Constraints | Description
outlook_contact_synchronization_profile_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
staff_KEY | int | NOT NULL | Reference to the staff that owns this filter profile.
enable_automatic_import | bit | NOT NULL | Determines if contacts added in Outlook? should automatically be added to the database without user intervention.
import_as__contact_type_KEY | int | NOT NULL | Determines what type of contact is created in the database for contacts imported from Outlook?.

Primary key
Name | Columns | Description
PK_Outlook_Contact_Synchronization_Profile$outlook_contact_synchronization_profile_KEY | outlook_contact_synchronization_profile_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Outlook_Contact_Synchronization_Profile$import_as__contact_type_KEY | import_as__contact_type_KEY | Index supports foreign key FK_Outlook_Contact_Synchronization_Profile__Contact_Type__import_as__contact_type_KEY
IX_Outlook_Contact_Synchronization_Profile$staff_KEY | staff_KEY | Index supports foreign key FK_Outlook_Contact_Synchronization_Profile__Staff__staff_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Outlook_Contact_Synchronization_Profile__Contact_Type__import_as__contact_type_KEY | import_as__contact_type_KEY | Contact_Type | on delete cascade;
FK_Outlook_Contact_Synchronization_Profile__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Outlook_Contact_Synchronization_Folder__Outlook_Contact_Synchronization_Profile__outlook_contact_synchronization_profile_KEY | outlook_contact_synchronization_profile_KEY | Outlook_Contact_Synchronization_Folder |