Share this page
ITG_UI_VIEW_SETTINGS
This table stores the UI view settings.
Foreign Keys
There are no foreign keys for this table.
Column Descriptions
| Column Name | Null? | Data Type | Description |
|---|---|---|---|
| ITG_UI_VIEW_SETTINGS_ID | NOT NULL | NUMBER | System-generated identifier |
| USER_ID | NOT NULL | NUMBER | ID of the user who has the settings |
| MODULE_TOKEN | NOT NULL | VARCHAR2 | Module sidentifier for the settings |
| NAME | NOT NULL | VARCHAR2 | Defines name of the settings |
| VALUE | NULLABLE | CLOB | Defines value of the settings |
| ENTITY_ID | NULLABLE | NUMBER | Entity identifier for the settings |
| CREATION_DATE | NOT NULL | DATE | Date when the settings record was created |
| CREATED_BY | NOT NULL | NUMBER | Identifier for the user who created the settings |
| LAST_UPDATE_DATE | NOT NULL | DATE | Date when the settings record is last updated |
| LAST_UPDATED_BY | NOT NULL | NUMBER | Identifier for the user who last updated the settings record |
| VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually. |
Indexes
| Index Name | Index Type | Sequence | Column Name |
|---|---|---|---|
| SYS_C0082942 | UNIQUE | 1 | ITG_UI_VIEW_SETTINGS_ID |
| ITG_UI_VIEW_SETTINGS_U1 | UNIQUE | 1 | MODULE_TOKEN |
| ITG_UI_VIEW_SETTINGS_U1 | UNIQUE | 2 | USER_ID |
| ITG_UI_VIEW_SETTINGS_U1 | UNIQUE | 3 | NAME |
| ITG_UI_VIEW_SETTINGS_U1 | UNIQUE | 4 | ENTITY_ID |
Sequences
| Sequence Name | Sequence Type |
|---|---|
| ITG_UI_VIEW_SETTINGS_S | ID |
