INV_CONFIG_VIEW_ATTRIBUTES
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: INV
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
INV_CONFIG_VIEW_ATTRIBUTES_PK |
VIEW_ATTRIBUTE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VIEW_ATTRIBUTE_ID | NUMBER | 18 | Yes | Unique identifier for search configuration. | |
| VIEW_ID | NUMBER | 18 | Yes | Unique identifier of the search view. Foreign key reference to INV_CONFIG_VIEWS_B. | |
| 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. | ||
| FILTER_VALUES | CLOB | Stores metadata for the selected filter. | |||
| 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. | |
| 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. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| INV_CONFIG_VIEW_ATTRIBUTES_N1 | Non Unique | Default | VIEW_ID |
| INV_CONFIG_VIEW_ATTRIBUTES_U1 | Unique | Default | VIEW_ATTRIBUTE_ID, ORA_SEED_SET1 |
| INV_CONFIG_VIEW_ATTRIBUTES_U11 | Unique | Default | VIEW_ATTRIBUTE_ID, ORA_SEED_SET2 |