Copyright © Cloud Software Group, Inc. All Rights Reserved

user_settings

The user_settings table holds the settings that a given user has defined in the iProcess Workspace (Browser). This enables a user to keep the same settings when working on any machine.

Structure

The user_settings table has the following structure:

TABLE user_settings (
node_id INTEGER NOT NULL,
user_name VARCHAR(64) NOT NULL
setting_key VARCHAR(64) NOT NULL,
setting_value VARCHAR(2048) NOT NULL

Column	Description
node_id	ID of the node that this attribute is defined on, as defined in the nodes table.
user_name	The name of the user whose preferences these are, as defined in the user_names table.
setting_key	The key to identify a particular setting.
setting_value	The value of the particular setting identified by setting_key.

Primary Key

The following primary key is defined for this table.

Key Name	Column(s)
pk_user_values	node_id user_name setting_key setting_value

 

Copyright © Cloud Software Group, Inc. All Rights Reserved