Quote:
|
Originally Posted by Kenji I saw appointment table of mailboxX.
appointment table have u_id, item_id, start_time and end_time field.
modified date field is not in appointment table.
Where do modified date field be stored? |
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.