CSO_SCH_INT_PARAM

This table stores Concept parameter that enables Intent to match a range of questions that differ only in a specific detail, using the same IML question pattern (currently not used)

Details

  • Schema: FUSION

  • Object owner: CSO

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CSO_SCH_INT_PARAM_PK

RECORD_ID

Columns

Name Datatype Length Not-null Comments
CONCEPT_ID VARCHAR2 32 Yes Concept ID, a foreign key reference to RECORD_ID in CSO_SCH_CON table.
DESCRIPTION VARCHAR2 4000 Yes This is the description of the config object.
INTENT_ID VARCHAR2 32 Intent ID, a foreign key reference to RECORD_ID in CSO_SCH_INTENT table.
PARAMETERS_ORDER NUMBER The order of this parameter in the list of Concept parameters of the Intent.
RECORD_ID VARCHAR2 32 Yes This is the primary key of the table.
VARIABLE VARCHAR2 64 Yes Global variable defined in IML (In order for Intents to use Concept parameters, the IML pattern must contain a global variable)

Foreign Keys

Table Foreign Table Foreign Key Column
CSO_SCH_INT_PARAM cso_sch_intent INTENT_ID
CSO_SCH_INT_PARAM cso_sch_con CONCEPT_ID

Indexes

Index Uniqueness Columns
CSO_SCH_INT_PARAM_U1 Unique RECORD_ID