Table: Outlook_Contact_Synchronization_Folder | |||
A list of Outlook? folders to synchronize contacts with for a particular Staff's contact synchronization profile. The combination of (outlook_contact_synchronization_profile_KEY, outlook_store_KEY, entry_id) is unique. "For the Exchange message entrys, entry id includes the full distinguished name of the mailbox, which is not limited in length AFAIK. Since MAPI starts barking when a property size goes above about 4k (you need to open the property as IStream, not with IMAPIProp::GetProps(...), etc), it would be relatively safe to alllocate 8192 chars for the entry ids - if your code breaks, so would Outlook? itself." -- Dmitry Streblechenko (MVP) http://www.dimastr.com/, http://groups.google.com/group/microsoft.public.outlook.program_vba/browse_frm/thread/f768d385c8dd4a27/1df02bd5c153c6bd%231df02bd5c153c6bd | |||
Columns | |||
Name | Type | Constraints | Description |
outlook_contact_synchronization_folder_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 | |
outlook_contact_synchronization_profile_KEY | int | NOT NULL | Reference to the contact synchronization profile this folder is for. |
enabled | bit | NOT NULL | true if this profile is to be used to export contacts when the Sync button is pushed. |
confirm_changes | bit | NOT NULL | true if this profile should display a confirmation dialog prior to committing sync changes between the database and Outlook?. |
entry_id | varbinary (4096) | NOT NULL | Holds the binary value of the Outlook? EntryID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. |
outlook_store_KEY | int | NOT NULL | A reference to one of the Outlook_Store rows that has the binary value of the Outlook? StoreID of this item. |
filter_KEY | int | Reference to a Contact filter used to define which Contacts to send to Outlook? as part of the synchronization. | |
entry_id_checksum | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Outlook_Contact_Synchronization_Folder$outlook_contact_synchronization_folder_KEY | outlook_contact_synchronization_folder_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Outlook_Contact_Synchronization_Folder$filter_KEY | filter_KEY | Index supports foreign key FK_Outlook_Contact_Synchronization_Folder__Filter__filter_KEY | |
IX_Outlook_Contact_Synchronization_Folder$outlook_contact_synchronization_profile_KEY | outlook_contact_synchronization_profile_KEY | Index supports foreign key FK_Outlook_Contact_Synchronization_Folder__Outlook_Contact_Synchronization_Profile__outlook_contact_synchronization_profile_KEY | |
IX_Outlook_Contact_Synchronization_Folder$outlook_store_KEY | outlook_store_KEY | Index supports foreign key FK_Outlook_Contact_Synchronization_Folder__Outlook_Store__outlook_store_KEY |