The memo table stores the case memo data before upgrading to iProcess Engine 11.6. Since iProcess Engine 11.6, all the new case memo data is stored in the BLOB data type in the
nmemo table.
You can migrate case memo data in the memo table to the
nmemo table when upgrading to iProcess Engine 11.6 or migrate them by using the
swutil MIGRATEMEMOS command after the upgrades.
The memo table has the following structure:
TABLE memo (
node_id number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
memo_id number(4) NOT NULL,
memo_index number(10) NOT NULL,
memo_size number(10) NOT NULL,
memo_data blob NOT NULL,
array_idx number(6) NOT NULL)
The memo table contains one or more rows for each memo
on the system. Rows are added, updated and deleted in the following situations.