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 |