Copyright © Cloud Software Group, Inc. All rights reserved.

user_values

The user_values table holds the values for all attributes defined for all users and groups on the system.

Structure

The user_values table has the following structure:

TABLE user_values (
node_id INTEGER NOT NULL,
user_id INTEGER NOT NULL,
attribute_id INTEGER NOT NULL,
attribute_value VARCHAR(24) NOT NULL,
user_type VARCHAR(1) NOT NULL)

Column	Description
node_id	ID of the node that this attribute is defined on, as defined in the nodes table.
user_id	ID of the (user or group) queue that this attribute value is associated with, as defined in the user_names table.
attribute_id	ID of the attribute that this attribute value is associated with, as defined in the user_attrib table.
attribute_value	Value of this attribute. Note: If an attribute value is longer than 24 characters multiple rows are used to store the value. Each segment of the value is uniquely identified by its attribute_id value, as defined in the user_attrib table.
user_type	Type of the (user or group) queue that this attribute value is associated with, as defined in the user_names table.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_user_values	user_id attribute_id user_type node_id

Foreign Keys

The following foreign keys are defined for this table.

Key Name1	Column(s)	Referenced in Table...
fk_user_values1	node_id user_id user_type	user_names
fk_user_values2	attribute_id node_id	user_attrib

---

1

These keys enforce the DELETE CASCADE referential action.

Indexes

The following indexes are defined for this table.

Index Name	Column(s) Indexed
idx_usrval_fk1	node_id user_id user_type
idx_usrval_fk2	attribute_id node_id
idx_user_values	attribute_id

Table Activity

The user_values table contains one or more rows per assigned attribute per (user or group) queue on the system. If an attribute value’s length is:

•	24 characters or less, one row is created for the attribute value.

•	more than 24 characters, one row is created for each 24 characters of the attribute value.

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 Users data area has been modified. Note: The table is purged and rewritten using the values from the tsys_user_names table.
updated	never.
deleted	a Move System Information is performed, if the flag_table indicates that the Users data area has been modified. Note: The table is purged and rewritten using the values from the tsys_user_names table.

Copyright © Cloud Software Group, Inc. All rights reserved.