ZCX_CUSTOM_INDEXES

This table is to hold the information regarding the indexes created by customer from Appcomposer.

Details

• Schema: FUSION

• Object owner: ZCX

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
ZCX_CUSTOM_INDEXES_PK	CUSTOM_INDEX_ID

Columns

Name	Datatype	Length	Not-null	Comments
CUSTOM_INDEX_ID	NUMBER		Yes	Stores the primary key of zcx_custom_indexes table
INDEX_NAME	VARCHAR2	200	Yes	Contains the name of the index that has been created
OBJECT_NAME	VARCHAR2	200	Yes	Specifies the name of the object the indexed field belongs to
EXTN_TABLE_NAME	VARCHAR2	200	Yes	Specifies the extensibility table the object is mapped to
FIELD_NAME	VARCHAR2	200	Yes	Indicates the API name the custom field is identified by
COLUMN_NAME	VARCHAR2	200	Yes	Indicates the internal column name like 'EXTN_ATTRIBUTE_%'
SANDBOX_NAME	VARCHAR2	200	Yes	The sandbox in which the field was made indexed
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP		Yes	Who column: indicates the date and time of the creation of 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
ZCX_CUSTOM_INDEXES_U1	Unique	Default	CUSTOM_INDEX_ID