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 |