CSO_SCH_CON_PARTOF

This table stores the relationship of Concepts having part of relations (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_CON_PARTOF_PK

CONCEPT_ID, PARENT_CON_ID

Columns

Name Datatype Length Not-null Comments
CONCEPT_ID VARCHAR2 32 Yes ID of the Concept that is the part of another Concept, a foreign key reference to RECORD_ID in CSO_SCH_CON table.
PARENT_CON_ID VARCHAR2 32 Yes ID of the concept that has another Concept as part, a foreign key reference to RECORD_ID in CSO_SCH_CON table.

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_SCH_CON_PARTOF cso_sch_con CONCEPT_ID
CSO_SCH_CON_PARTOF cso_sch_con PARENT_CON_ID

Indexes

Index Uniqueness Columns
CSO_SCH_CON_PARTOF_U1 Unique CONCEPT_ID, PARENT_CON_ID