Copyright © Cloud Software Group, Inc. All Rights Reserved

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 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 long raw NOT NULL,
array_idx number(6) NOT NULL)

Column	Description
node_id	ID of the node that this memo is hosted on, as defined in the nodes table.
proc_id	ID of the procedure that this memo belongs to, as defined in the proc_index table.
casenum	Case number that this memo belongs to, as defined in the case_information table.
memo_id	Unique (for this case) ID of this memo.
memo_index	Index number into the set of rows that make up this memo. If a memo is longer than 30,000 bytes multiple rows (in 30,000 byte chunks) are used to store the memo data. Each segment of the memo data is uniquely identified by its memo_index value. Note: • 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. − (Windows Oracle) any Version 9.0-o Process Engine. • However, if a memo is modified, the existing rows are deleted and then re-added using 30,000 byte chunks.
memo_size	Size (in bytes) of the memo data for this row.
memo_data	Memo data.
array_idx	Either: • The array element index number of the memo. • -1, if the memo is not an array memo field.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_memo	casenum memo_id memo_index proc_id node_id array_idx	HUGEINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_memo1	node_id proc_id casenum	case_information

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed	Tablespace
idx_memo_fk	casenum proc_id node_id	HUGEINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	HUGETABLESIZE
Percentage Increase	HUGETABLEPCTINCREASE
Tablespace	HUGETABLESPACE

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.

A row is...	When...
added	either: • a memo field is first assigned. • a memo field is modified. (All rows for the memo are deleted and then re-added.)
updated	never.
deleted	either: • a memo field is modified. (All rows for the memo are deleted and then re-added.) • a case is purged.

Copyright © Cloud Software Group, Inc. All Rights Reserved