Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 7 Cases : nmemo

nmemo
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 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.
A copy of a memo is kept in the pack_nmemo table if the memo is marked on an outstanding form.
Structure
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 VARBINARY(MAX) NOT NULL,
array_idx INTEGER NOT NULL)
-1, if the memo is not an array memo field.
Primary Key
The following primary key is defined for this table.
Triggers
None.
Indexes
The following index is defined for this table.
Table Activity
The nmemo table contains one row for each memo on the system. Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.