ANSWERING schema reference

This is for:

In this article

ANSWERS
ANSWER_INTERACTIONS

This article provides a reference to the views found in the ANSWERING schema of the CORE data model.

ANSWERS

The ANSWERS view consists of comprehensive details about Relevance Generative Answering (RGA) query responses within an organization. Each row represents a unique query response, whether an answer was generated, and includes information about its origin, generation time, and key identifiers.

Column name Description

Column name	Description
`ANSWER`	The content of the generated answer.
`ANSWER_ID`	Unique identifier of this answer, used as primary key. References `INSIGHT_ID` in the `INSIGHTS` view. Each answer is modeled as an insight and this view provides extended information specific to answers.
`ANSWER_XID`	External identifier for this answer. Typically, the platform’s `answerid` for Coveo Platform-generated answers.
`ANSWER_DATE`	UTC date of when the answer occurred.
`ANSWER_TIMESTAMP`	UTC timestamp of when the answer occurred.
`IS_COMPLETELY_STREAMED`	Boolean indicating whether the answer was completely streamed.
`IS_QUERY_ANSWERED`	Boolean indicating whether the answer was generated.
`IS_RECEIVED`	Boolean indicating whether the answer was received by the client.
`ORGANIZATION_ID`	Organization identifier for the record.
`RELATED_INSIGHT_ID`	Identifier of a related insight. Used when the answer is linked to another insight (for example, when a search and an answer are returned for the same query). Keys into `INSIGHTS`.
`VISIT_ID`	Reference to the visit in which this answer happened. Keys into `VISITS`.

ANSWER

The content of the generated answer.

ANSWER_ID

Unique identifier of this answer, used as primary key. References INSIGHT_ID in the INSIGHTS view. Each answer is modeled as an insight and this view provides extended information specific to answers.

ANSWER_XID

External identifier for this answer. Typically, the platform’s answerid for Coveo Platform-generated answers.

ANSWER_DATE

UTC date of when the answer occurred.

ANSWER_TIMESTAMP

UTC timestamp of when the answer occurred.

IS_COMPLETELY_STREAMED

Boolean indicating whether the answer was completely streamed.

IS_QUERY_ANSWERED

Boolean indicating whether the answer was generated.

IS_RECEIVED

Boolean indicating whether the answer was received by the client.

ORGANIZATION_ID

Organization identifier for the record.

RELATED_INSIGHT_ID

Identifier of a related insight. Used when the answer is linked to another insight (for example, when a search and an answer are returned for the same query). Keys into INSIGHTS.

VISIT_ID

Reference to the visit in which this answer happened. Keys into VISITS.

ANSWER_INTERACTIONS

The ANSWER_INTERACTIONS view consists of detailed records of how users interact with specific answers within an organization. Each row represents a unique interaction event that provides insights into user engagement and feedback.

Column name Description

Column name	Description
`ANSWER_ID`	Reference to the related answer record. Keys into ANSWERS.
`ANSWER_INTERACTION_ID`	Unique identifier of the answer interaction, used as primary key.
`INTERACTION_TIMESTAMP`	Timestamp of the answer interaction in UTC.
`INTERACTION_DATA`	Contains data specific to the interaction type.
`INTERACTION_TYPE`	The action type performed on the answer, such as `like`, `dislike`, or `expand`.
`ORGANIZATION_ID`	Organization identifier for the record.

ANSWER_ID

Reference to the related answer record. Keys into ANSWERS.

ANSWER_INTERACTION_ID

Unique identifier of the answer interaction, used as primary key.

INTERACTION_TIMESTAMP

Timestamp of the answer interaction in UTC.

INTERACTION_DATA

Contains data specific to the interaction type.

INTERACTION_TYPE

The action type performed on the answer, such as like, dislike, or expand.

ORGANIZATION_ID

Organization identifier for the record.