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
NameTypeConstraintsDescription
interaction_KEYintNOT NULLA reference to exactly one of the Interaction rows.
outlook_store_KEYintNOT NULLA reference to one of the Outlook_Store rows that has the binary value of the Outlook(R) StoreID of this item.
last_modification_timedatetimeNOT NULLThe value of the LastModificationTime property from Outlook(R).
outlook_item_guiduniqueidentifierNOT NULLThe value of a custom property that has been added to the Outlook(R) item.
entry_idvarbinary (4096)NOT NULLHolds 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_checksumintNOT NULL
Primary key
NameColumnsDescription
PK_Outlook_Item$interaction_KEYinteraction_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Outlook_Item$entry_id_checksum$outlook_store_KEYentry_id_checksum, outlook_store_KEY
IX_Outlook_Item$outlook_item_guidoutlook_item_guid
IX_Outlook_Item$outlook_store_KEYoutlook_store_KEYIndex supports foreign key FK_Outlook_Item__Outlook_Store__outlook_store_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Outlook_Item__Interaction__interaction_KEYinteraction_KEYInteractionon delete cascade;
FK_Outlook_Item__Outlook_Store__outlook_store_KEYoutlook_store_KEYOutlook_Store

Schema diagram