CSO_SCH_INT_HIERND_RES

This table stores localized values of the nodes in the Intent Hierarchy (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_INT_HIERND_RES_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
DATE_ADDED TIMESTAMP Yes This is the datetime when the record was added.
DATE_MODIFIED TIMESTAMP Yes This is the datetime when the record was last modified.
DESCRIPTION VARCHAR2 4000 This is the description of the config object.
LOCALE_ID VARCHAR2 32 Yes Locale ID, a foreign key reference to RECORD_ID in CSO_LOCALE table (e.g. en_US)
NAME VARCHAR2 255 This is the Localized name of the config object.
NEEDS_TRANSLATION VARCHAR2 255 This column is not currently being used and may go away.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
RESOURCE_ID VARCHAR2 32 Yes Resource ID, a foreign key reference to RECORD_ID in CSO_SCH_INT_HIERNODE table.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_SCH_INT_HIERND_RES cso_locale LOCALE_ID
CSO_SCH_INT_HIERND_RES cso_sch_int_hiernode RESOURCE_ID

Indexes

Index Uniqueness Columns
CSO_SCH_INT_HIERND_RES_U1 Unique RECORD_ID