Quote:
|
Originally Posted by dkarp There's a foreign key mapping the ITEM_ID column in the APPOINTMENT table to the ID column in the MAIL_ITEM table. The "last modified time" is stored in the CHANGE_DATE column of the corresponding row of the MAIL_ITEM table. |
The other value you might be interested in is MAIL_ITEM.DATE. MAIL_ITEM.CHANGE_DATE is the last time anything about the appointment changed (including its folder, whether it's flagged/tagged, etc.). MAIL_ITEM.DATE is the last time the appointment itself was modified.