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
NameTypeConstraintsDescription
outlook_contact_synchronization_profile_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Program assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
create_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLReference to the staff that owns this filter profile.
enable_automatic_importbitNOT NULLDetermines if contacts added in Outlook? should automatically be added to the database without user intervention.
import_as__contact_type_KEYintNOT NULLDetermines what type of contact is created in the database for contacts imported from Outlook?.
Primary key
NameColumnsDescription
PK_Outlook_Contact_Synchronization_Profile$outlook_contact_synchronization_profile_KEYoutlook_contact_synchronization_profile_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Outlook_Contact_Synchronization_Profile$import_as__contact_type_KEYimport_as__contact_type_KEYIndex supports foreign key FK_Outlook_Contact_Synchronization_Profile__Contact_Type__import_as__contact_type_KEY
IX_Outlook_Contact_Synchronization_Profile$staff_KEYstaff_KEYIndex supports foreign key FK_Outlook_Contact_Synchronization_Profile__Staff__staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Outlook_Contact_Synchronization_Profile__Staff__staff_KEYstaff_KEYStaffon delete cascade;
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Outlook_Contact_Synchronization_Folder__Outlook_Contact_Synchronization_Profile__outlook_contact_synchronization_profile_KEYoutlook_contact_synchronization_profile_KEYOutlook_Contact_Synchronization_Folder

Schema diagram