Project Data Tables Database > td Schema : td.COMMON_SETTINGS Table |
This table is used by ALM to save some user settings from session to session. For user filters and choices of columns to display, see the FAVORITES Table.
This table can also be used to implement data persistency by third party applications using the Open Test Architecture API or WorkFlow module scripts. This practice is recommended over use of external files unless the data to be saved is very large or too complex to be saved in a string.
The table is a two-level list of variables. The CSET_CATEGORY is the name of the list and can be any string. Each category can have any number of variables. The variable name is CSET_NAME.
The CSET_VALUE is the value of the variable. The format of the string is determined by the application using the variable.
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
CSET_ID | The record ID. | int | 4 | ||||
CSET_CATEGORY | The category name. | varchar | 240 | ||||
CSET_NAME | The setting name. | varchar | 240 | ||||
CSET_OWNER | The user name of the user to whom the setting or definition applies. | varchar | 240 | ||||
CSET_VALUE | The value of the setting. | varchar | 16 | ||||
CSET_IS_SYSTEM | For future use. | varchar | 1 |
Index | Description | Primary | Unique |
---|---|---|---|
CS_PRIMARYKEY |