FND_INDEXES (Indexes)
Documentation | Oracle EBS Data Dictionary |
Name | FND_INDEXES |
Title | Indexes |
Module | EBS Data Dictionary Diagram |
Unique and non-unique indexes registered with Oracle Application Object Library.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | APPLICATION_ID | NUMBER(15, 0) | FND_TABLES (Tables) | Application identifier. | ||||
Application identifier. References: FND_TABLES (Tables) |
||||||||
2 | TABLE_ID | NUMBER(15, 0) | FND_TABLES (Tables) | Table identifier. | ||||
Table identifier. References: FND_TABLES (Tables) |
||||||||
3 | INDEX_ID | NUMBER(15, 0) | Index identifier. | |||||
Index identifier. |
||||||||
4 | INDEX_NAME | VARCHAR2(30 BYTE) | Index name. | |||||
Index name. |
||||||||
5 | LAST_UPDATE_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
6 | LAST_UPDATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
7 | CREATION_DATE | DATE | Standard Who column. | |||||
Standard Who column. |
||||||||
8 | CREATED_BY | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
9 | LAST_UPDATE_LOGIN | NUMBER(15, 0) | Standard Who column. | |||||
Standard Who column. |
||||||||
10 | AUTO_SIZE | VARCHAR2(1 BYTE) | Is this index automatically sized during an install? | |||||
Is this index automatically sized during an install? |
||||||||
11 | INI_TRANS | NUMBER(15, 0) | Initial number of transactions. | |||||
Initial number of transactions. |
||||||||
12 | MAX_TRANS | NUMBER(15, 0) | Maximum number of transactions. | |||||
Maximum number of transactions. |
||||||||
13 | INITIAL_EXTENT | NUMBER(15, 0) | Initial extent. | |||||
Initial extent. |
||||||||
14 | NEXT_EXTENT | NUMBER(15, 0) | Next extent. | |||||
Next extent. |
||||||||
15 | MIN_EXTENTS | NUMBER(15, 0) | Minimum extent. | |||||
Minimum extent. |
||||||||
16 | MAX_EXTENTS | NUMBER(15, 0) | Maximum extent. | |||||
Maximum extent. |
||||||||
17 | PCT_FREE | NUMBER(15, 0) | Percent of free space. | |||||
Percent of free space. |
||||||||
18 | PCT_INCREASE | NUMBER(15, 0) | Percent of free space to increase. | |||||
Percent of free space to increase. |
||||||||
19 | UNIQUENESS | VARCHAR2(1 BYTE) | Uniqueness. | |||||
Uniqueness. |
||||||||
20 | DESCRIPTION | VARCHAR2(240 BYTE) | Description. | |||||
Description. |
||||||||
21 | ZD_EDITION_NAME | VARCHAR2(30 BYTE) | Default: 'ORA$BASE' | |||||
Default:
'ORA$BASE' |
||||||||
22 | ZD_SYNC | VARCHAR2(30 BYTE) | Default: 'SYNCED' | |||||
Default:
'SYNCED' |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
FND_INDEXES (Indexes) | FND_TABLES (Tables) | FND_INDEXES.TABLE_ID = FND_TABLES.TABLE_ID FND_INDEXES.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
fk_FND_INDEXES_FND_TABLES | |
FND_INDEXES.TABLE_ID = FND_TABLES.TABLE_ID Name: fk_FND_INDEXES_FND_TABLESFND_INDEXES.APPLICATION_ID = FND_TABLES.APPLICATION_ID |
||||
FND_INDEX_COLUMNS (Index columns) | FND_INDEXES (Indexes) | FND_INDEX_COLUMNS.TABLE_ID = FND_INDEXES.TABLE_ID FND_INDEX_COLUMNS.INDEX_ID = FND_INDEXES.INDEX_ID FND_INDEX_COLUMNS.APPLICATION_ID = FND_INDEXES.APPLICATION_ID |
fk_FND_INDEX_COLUMNS_FND_INDEXES | |
FND_INDEX_COLUMNS.TABLE_ID = FND_INDEXES.TABLE_ID Name: fk_FND_INDEX_COLUMNS_FND_INDEXESFND_INDEX_COLUMNS.INDEX_ID = FND_INDEXES.INDEX_ID FND_INDEX_COLUMNS.APPLICATION_ID = FND_INDEXES.APPLICATION_ID |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
FND_INDEXES_U1 | APPLICATION_ID, ZD_EDITION_NAME, INDEX_ID, TABLE_ID | ||
FND_INDEXES_U2 | INDEX_NAME, ZD_EDITION_NAME, TABLE_ID, APPLICATION_ID |
Uses
Name |
---|
FND_INDEXES (Indexes)
|
Used by
Name |
---|
FND_INDEXES (Indexes)
|
FND_INDEXES#
|
Exported: 2018-10-12 17:11, Last imported: 2018-09-28 10:17