Forethought
Explore the interactive ERD
Table & Field Reference
metadata
| Column | Type | Keys |
|---|---|---|
context_variable_id | Unknown | PK |
created_date | Unknown | |
display_name | Unknown | |
modified_date | Unknown |
workflow
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
channel | Unknown | |
created_date | Unknown | |
intent_name | Unknown | |
is_active | Unknown | |
last_modified_by | Unknown | |
modified_date | Unknown |
property
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
event_configuration_id | Unknown | PKFK |
property_name | Unknown |
event_configuration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
is_deleted | Unknown | |
name | Unknown |
ticket_reply
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
email_conversation_id | Unknown | PKFK |
body | Unknown | |
helpdesk_author_id | Unknown | |
source_created_date | Instant |
email_conversation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
context_variables_used | Unknown | |
intent_title | Unknown | |
is_autoflows_used | Unknown | |
is_deflected | Unknown | |
is_eligible | Unknown | |
is_response_sent | Unknown | |
last_modified_date | Instant | |
no_response_reason | Unknown | |
ticket_body | Unknown | |
ticket_id | Unknown | |
ticket_title | Unknown | |
user_feedback | Unknown | |
context_variable_** |
ai_qa_insight
| Column | Type | Keys |
|---|---|---|
rubric_name | Unknown | PK |
conversation_history_id | Unknown | PKFK |
label | Unknown | |
reasoning | Unknown | |
score | Unknown |
custom_event
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_history_id | Unknown | PKFK |
event_configuration_id | Unknown | FK |
channel | Unknown | |
event_configuration_name | Unknown | |
event_properties | Json | |
event_timestamp | Instant | |
intent_workflow_id | Unknown | |
intent_workflow_version | Unknown | |
product | Unknown |
conversation_history
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
channel | Unknown | |
chat_duration | Unknown | |
chat_handoff | Unknown | |
chat_start_time | Instant | |
chat_transcript | Json | |
csat_feedback | Json | |
csat_resolve | Unknown | |
csat_score | Unknown | |
detected_workflows | Json | |
dropoff_reasoning | Unknown | |
ending_sentiment_score | Unknown | |
generative_ai_used | Unknown | |
helpdesk_ticket_id | Unknown | |
is_deflected | Unknown | |
is_eligible | Unknown | |
last_executed_intent | Unknown | |
last_executed_intent_user_query | Unknown | |
last_non_handoff_intent | Unknown | |
modified_date | Instant | |
relevance_rating | Unknown | |
relevance_reasoning | Unknown | |
user_engagement | Unknown | |
voice_metric_avg_response_time | Unknown | |
voice_metric_call_duration | Unknown | |
voice_metric_call_end_time | Instant | |
voice_metric_call_start_time | Instant | |
voice_metric_is_outbound | Unknown | |
voice_metric_sentiment | Unknown | |
context_variable_** |