Table: Outlook_Index_Folder_Firm
A list of Outlook(R) folders to index for firm-specific email. The combination of (firm_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
NameTypeConstraintsDescription
outlook_index_folder_firm_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this row. The natural key would be (firm_KEY, outlook_store_KEY, entry_id) but that exceeds the 900 byte limit.
firm_KEYintNOT NULLA reference to one of the Firm 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.
search_subfoldersbitNOT NULLSpecifies if subfolders should also be searched.
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 NULLSince the entry_id column is wider than 900 bytes, the SQL Server CHECKSUM function is used to compute an indexable column.
Primary key
NameColumnsDescription
PK_Outlook_Index_Folder_Firm$outlook_index_folder_firm_KEYoutlook_index_folder_firm_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Outlook_Index_Folder_Firm$entry_id_checksum$outlook_store_KEYentry_id_checksum, outlook_store_KEY
IX_Outlook_Index_Folder_Firm$firm_KEYfirm_KEYIndex supports foreign key FK_Outlook_Index_Folder_Firm__Firm__firm_KEY
IX_Outlook_Index_Folder_Firm$outlook_store_KEYoutlook_store_KEYIndex supports foreign key FK_Outlook_Index_Folder_Firm__Outlook_Store__outlook_store_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Outlook_Index_Folder_Firm__Firm__firm_KEYfirm_KEYFirm
FK_Outlook_Index_Folder_Firm__Outlook_Store__outlook_store_KEYoutlook_store_KEYOutlook_Store

Schema diagram