Table: Outlook_Item | |||
Holds cached Outlook(R) items. "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 |
interaction_KEY | int | NOT NULL | A reference to exactly one of the Interaction rows. |
outlook_store_KEY | int | NOT NULL | A reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item. |
last_modification_time | datetime | NOT NULL | The value of the LastModificationTime property from Outlook(R). |
outlook_item_guid | uniqueidentifier | NOT NULL | The value of a custom property that has been added to the Outlook(R) item. |
entry_id | varbinary (4096) | NOT NULL | Holds the binary value of the Outlook(R) EntryID. Convert to a hexadecimal string without the 0x prefix (2 characters for each byte) the COM interface representation. |
entry_id_checksum | int | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Outlook_Item$interaction_KEY | interaction_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Outlook_Item$entry_id_checksum$outlook_store_KEY | entry_id_checksum, outlook_store_KEY | ||
IX_Outlook_Item$outlook_item_guid | outlook_item_guid | ||
IX_Outlook_Item$outlook_store_KEY | outlook_store_KEY | Index supports foreign key FK_Outlook_Item__Outlook_Store__outlook_store_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Outlook_Item__Interaction__interaction_KEY | interaction_KEY | Interaction | on delete cascade; |
FK_Outlook_Item__Outlook_Store__outlook_store_KEY | outlook_store_KEY | Outlook_Store |