Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved


Chapter 7 Cases : memo

memo
The memo table stores the case memo data.
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 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(30K) NOT NULL NOT LOGGED,
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.
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.
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 © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved