ZCA_ES_ENTITY_PREF
This table is used to store the preferences for an entity. These include the default saved search for the entity, and whether its enabled or not. The preferences can be set at levels Public (Site), Role or User.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
ZCA_ES_ENTITY_PREF_PK |
ENTITY_PREF_UUID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTITY_PREF_UUID | VARCHAR2 | 36 | Yes | The primary key for the enity preference | |
| ENTITY_UUID | VARCHAR2 | 36 | Yes | the entity unique identifier | |
| APPLICATION_UUID | VARCHAR2 | 36 | Yes | the application unique identifier | |
| ACCESS_LEVEL_TYPE_NAME | VARCHAR2 | 80 | Yes | The Access Level for this Entity Preference. Values can be Private, Public and Role | |
| ACCESS_LEVEL_TYPE_VALUE | VARCHAR2 | 100 | Yes | The associated value for the Access Level | |
| SAVED_SEARCH_UUID | VARCHAR2 | 36 | the saved search identifier to associate to the access level | ||
| ENABLED_FLAG | VARCHAR2 | 1 | Y if the Entity is enabled at the defined access level | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| USER_LAST_UPDATE_DATE | TIMESTAMP | Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_ES_ENTITY_PREF_N1 | Non Unique | Default | SAVED_SEARCH_UUID |
| ZCA_ES_ENTITY_PREF_PK | Unique | Default | ENTITY_PREF_UUID, ORA_SEED_SET1 |
| ZCA_ES_ENTITY_PREF_PK1 | Unique | Default | ENTITY_PREF_UUID, ORA_SEED_SET2 |
| ZCA_ES_ENTITY_PREF_U1 | Unique | Default | ENTITY_UUID, APPLICATION_UUID, ACCESS_LEVEL_TYPE_NAME, ACCESS_LEVEL_TYPE_VALUE, ORA_SEED_SET1 |
| ZCA_ES_ENTITY_PREF_U11 | Unique | Default | ENTITY_UUID, APPLICATION_UUID, ACCESS_LEVEL_TYPE_NAME, ACCESS_LEVEL_TYPE_VALUE, ORA_SEED_SET2 |