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


Chapter 7 Cases : memo

memo
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.
A copy of a memo is kept in the pack_memo table if the memo is marked on an outstanding form.
Structure
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)
If you have upgraded your system from iProcess Engineone of the following versions, existing memos are divided into 2,000 byte chunks:
(UNIX Oracle) any Version i9.n-o iProcess Engine, or from a pre-Version 9.0-o(0.15) Process Engine.
-1, if the memo is not an array memo field.
Primary Key
The following primary key is defined for this table.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following index is defined for this table.
Storage
The following STORAGE values are defined for this table.
Table Activity
The memo table contains one or more rows 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.