Copyright © Cloud Software Group, Inc. All Rights Reserved

list_values

The list_values table holds the value of every item in every iProcess list on the system.

Structure

The list_values table has the following structure:

TABLE list_values (
node_id number(5) NOT NULL,
list_id number(5) NOT NULL,
record_id number(5) NOT NULL,
list_value varchar2(30) NULL)

Column	Description
node_id	ID of the node that this list item is stored on, as defined in the nodes table.
list_id	ID of the list that this list item is stored in, as defined in the list_names table.
record_id	Unique ID for this list item.
list_value	Value of this list item.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)	Index Tablespace
pk_list_values	list_id record_id node_id	MEDIUMINDEXSPACE

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_list_values1	node_id list_id	list_names

---

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_list_values_fk	list_id node_id	MEDIUMINDEXSPACE

Storage

The following STORAGE values are defined for this table.

Value	Definition
Initial	MEDIUMTABLESIZE
Percentage Increase	MEDIUMTABLEPCTINCREASE
Tablespace	MEDIUMTABLESPACE

Table Activity

The list_values table contains one row for each iProcess list item defined on the system.

Rows are added, updated and deleted in the following situations.

A row is...	When...
added	a Move System Information is performed, if the flag_table indicates that the Lists data area has been modified. Note: The table is purged and rewritten using the values from the tsys_list_values table.
updated	never.
deleted	a Move System Information is performed, if the flag_table indicates that the Lists data area has been modified. Note: The table is purged and rewritten using the values from the tsys_list_values table.

Copyright © Cloud Software Group, Inc. All Rights Reserved