EGP_ES_SEARCH_VIEW_CONFIG
This table stores the meta data that defines the search view. The table contains, the attributes which be searched, the attribute columns that will be displayed in the search results and the smart filter chips that will be used to filter the results.
Details
-
Schema: FUSION
-
Object owner: EGP
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EGP_ES_SEARCH_VIEW_CONFIG_PK |
SEARCH_CONFIG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SEARCH_CONFIG_ID | NUMBER | 18 | Yes | Unique identifier for search configuration. | |
| SEARCH_VIEW_ID | NUMBER | 18 | Yes | Unique identifier of the the search view. Foreign key reference to EGP_ES_SEARCH_VIEWS. | |
| INDEXED_ATTR_ID | NUMBER | 18 | Yes | Unique identifier of the indexed attribute. Foreign key reference to EGP_PM_ES_ATTRS. | |
| REST_ATTR_PATH | VARCHAR2 | 4000 | Path for accessing the object attributes. | ||
| DATA_SOURCE | VARCHAR2 | 250 | Name of the data source for the object attributes. | ||
| ATTRIBUTE_SEQUENCE | NUMBER | 9 | Indicates the order of attribute. | ||
| SEARCH_FLAG | VARCHAR2 | 1 | Flag that indicates the attribute is added to Fields group within the smart search json. Y or N. | ||
| DISPLAY_COL_FLAG | VARCHAR2 | 1 | Flag that indicates the attribute will be a column in the table displayed in the search user interface, initial columns are defined in a csv that the Smart Filter and Search template uses. Y or N. | ||
| FILTER_FLAG | VARCHAR2 | 1 | Flag that indicates the attribute will use filter chip that maybe suggested in the Smart Filter and Search component. Y or N. | ||
| FILTER_TYPE | VARCHAR2 | 250 | Name of search filter type for attribute. | ||
| 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. | |
| 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_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| EGP_ES_SEARCH_VIEW_CONFIG | egp_es_search_views_b | SEARCH_VIEW_ID |
| EGP_ES_SEARCH_VIEW_CONFIG | egp_pm_es_attrs | INDEXED_ATTR_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EGP_ES_SEARCH_VIEW_CONFIG_N1 | Non Unique | Default | SEARCH_VIEW_ID |
| EGP_ES_SEARCH_VIEW_CONFIG_N2 | Non Unique | Default | INDEXED_ATTR_ID |
| EGP_ES_SEARCH_VIEW_CONFIG_U1 | Unique | Default | SEARCH_CONFIG_ID |