CSO_SCH_INTENT

This table stores Intents, defined by the language patterns for similar queries.

Details

• Schema: FUSION

• Object owner: CSO

• Object type: TABLE

• Tablespace: REFERENCE

Primary Key

Name	Columns
CSO_SCH_INTENT_PK	RECORD_ID

Columns

Name	Datatype	Length	Not-null	Comments
CONFIG_CREATE_DATE	TIMESTAMP			This is the datetime when the config object was created (This value can be initially set by the user)
CONFIG_UPDATE_DATE	TIMESTAMP			This is the datetime when the config object was last modified (This value can be initially set by the user)
CREATE_USER_LOGIN	VARCHAR2	255		This is the user that created the record.
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.
DOMAIN_ID	VARCHAR2	32		A foreign key reference to RECORD_ID in CSO_SCH_DOM table.
ENABLED	NUMBER		Yes	A boolean flag indicating whether the config object is enabled.
IML	VARCHAR2	4000	Yes	Oracle Knowledge Match Language expressions that define the language pattern of the Intent.
NOTES	VARCHAR2	4000		These are the Notes for the config object.
RECORD_ID	VARCHAR2	32	Yes	This is the primary key of the table.
REFERENCE_KEY	VARCHAR2	255		Non localized reference key for the config object.
SAVE_MESSAGE	VARCHAR2	255		This is the Commentary for saving the record.
UPDATE_USER_LOGIN	VARCHAR2	255		This is the user that updated the record.
VERSION	NUMBER			This is the revision number for this record.
CREATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64	Yes	Who column: indicates the user who last updated the row.
SEED_DATA_SOURCE	VARCHAR2	512		Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1	Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1	Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CSO_SCH_INTENT	cso_sch_dom	DOMAIN_ID
cso_sch_man_ans	cso_sch_intent	INTENT_ID
cso_sch_int_nonmatch_ex	cso_sch_intent	INTENT_ID
cso_sch_int_param	cso_sch_intent	INTENT_ID
cso_sch_int_match_ex	cso_sch_intent	INTENT_ID
cso_sch_int_hiernode	cso_sch_intent	INTENT_ID
cso_sch_int_res	cso_sch_intent	RESOURCE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_SCH_INTENT_U1	Unique	Default	RECORD_ID, ORA_SEED_SET1
CSO_SCH_INTENT_U11	Unique	Default	RECORD_ID, ORA_SEED_SET2