CSO_SCH_CON_ISA_HI

This table stores the history of the relationship of Concepts having ISA (type of) relations (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_CON_ISA_HI_PK

CONCEPT_ID, PARENT_CON_ID, ROW_START

Columns

Name Datatype Length Not-null Comments
CONCEPT_ID VARCHAR2 32 Yes This is the Child Concept Id for this record.
PARENT_CON_ID VARCHAR2 32 Yes This is the Parent Concept Id for this record.
ROW_END TIMESTAMP This is the dateime when a specific version of the config object was modified (NULL indicates this version has not been modified and is currently active)
ROW_START TIMESTAMP Yes This is the datetime when a specific version of the config object was added.

Indexes

Index Uniqueness Columns
CSO_SCH_CON_ISA_HI_U1 Unique CONCEPT_ID, PARENT_CON_ID, ROW_START