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_utc | datetime | NOT NULL | |
create_date_utc | 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__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 |