The nmemo table stores the case memo data after upgrading to iProcess Engine 11.6. Since iProcess Engine 11.6, all the new case memo data is stored in the
blob(2G) data type in the
nmemo table.
The nmemo table has the following structure:
TABLE nmemo (
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
memo_id INTEGER NOT NULL,
memo_index INTEGER NOT NULL,
memo_size INTEGER NOT NULL,
memo_data BLOB(2G) NOT NULL NOT LOGGED,
array_idx INTEGER NOT NULL)
The nmemo table contains one row for each memo
on the system. Rows are added, updated and deleted in the following situations.