Copyright © Cloud Software Group, Inc. All Rights Reserved

list_names

The list_names table holds the names and definitions of all iProcess lists defined on the system.

Structure

The list_names table has the following structure:

TABLE list_names (
node_id INTEGER NOT NULL,
list_id INTEGER NOT NULL,
list_name VARCHAR(15) NOT NULL,
list_type VARCHAR(1) NOT NULL,
list_length INTEGER NOT NULL,
list_decimals INTEGER NOT NULL)

Column	Description
node_id	ID of the node that this list is stored on, as defined in the nodes table.
list_id	Unique ID for this list.
list_name	Name of this list.
list_type	List type: Either ASCII (A), Numeric (R), Date (D) or Time (T).
list_length	Length of this list, in characters.
list_decimals	Number of characters after the decimal place in this list (relevant only for Numeric lists).

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_list_names	list_id node_id

Foreign Keys

The following foreign key is defined for this table.

Key Name	Column(s)	Referenced in Table...
fk_list_names1	node_id	nodes

---

1

This key enforces the DELETE CASCADE referential action.

Indexes

The following index is defined for this table.

Index Name	Column(s) Indexed
idx_list_names_fk	node_id

Table Activity

The list_names table contains one row for each iProcess list 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_names 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_names table.

Copyright © Cloud Software Group, Inc. All Rights Reserved