FND Design Data [Home] [Help]

Table: FND_COLUMNS

Product: FND - Application Object Library
Description: Columns in all the registered application tables
Implementation/DBA Data: TableAPPLSYS.FND_COLUMNS
Primary Key: FND_COLUMNS_PK
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnCOLUMN_ID
Primary Key: FND_COLUMNS_UK1
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnUSER_COLUMN_NAME
Primary Key: FND_COLUMNS_UK2
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnCOLUMN_SEQUENCE
Primary Key: FND_COLUMNS_UK3
  1. ColumnAPPLICATION_ID
  2. ColumnTABLE_ID
  3. ColumnCOLUMN_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
FND_COLUMNS FK Joins to TableFND_TABLES FND_COLUMNS.APPLICATION_ID
FND_COLUMNS.TABLE_ID
TableFND_AUDIT_COLUMNS FK Joins to FND_COLUMNS FND_AUDIT_COLUMNS.TABLE_APP_ID
FND_AUDIT_COLUMNS.TABLE_ID
FND_AUDIT_COLUMNS.COLUMN_ID
TableFND_FOREIGN_KEY_COLUMNS FK Joins to FND_COLUMNS FND_FOREIGN_KEY_COLUMNS.APPLICATION_ID
FND_FOREIGN_KEY_COLUMNS.TABLE_ID
FND_FOREIGN_KEY_COLUMNS.COLUMN_ID
TableFND_INDEX_COLUMNS FK Joins to FND_COLUMNS FND_INDEX_COLUMNS.APPLICATION_ID
FND_INDEX_COLUMNS.TABLE_ID
FND_INDEX_COLUMNS.COLUMN_ID
TableFND_PRIMARY_KEY_COLUMNS FK Joins to FND_COLUMNS FND_PRIMARY_KEY_COLUMNS.APPLICATION_ID
FND_PRIMARY_KEY_COLUMNS.TABLE_ID
FND_PRIMARY_KEY_COLUMNS.COLUMN_ID