# Forethought schema ERD

Table and field reference for the Fivetran Forethought connector.

## 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 | PK, FK |
| 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 | PK, FK |
| 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_** |  |  |

### error_analytics

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_id | Unknown | FK |
| workflow_id | Unknown | FK |
| channel | Unknown |  |
| error_message | Unknown |  |
| error_type | Unknown |  |
| http_status_code | Unknown |  |
| is_muted | Unknown |  |
| product | Unknown |  |
| severity | Unknown |  |
| step_id | Unknown |  |
| timestamp | Instant |  |
| trace_id | Unknown |  |
| user_impact | Unknown |  |

### ai_qa_insight

| Column | Type | Keys |
| --- | --- | --- |
| rubric_name | Unknown | PK |
| conversation_history_id | Unknown | PK, FK |
| label | Unknown |  |
| reasoning | Unknown |  |
| score | Unknown |  |

### custom_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_history_id | Unknown | PK, FK |
| 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_** |  |  |

## Relationships

- property(event_configuration_id) → event_configuration(id)
- ticket_reply(email_conversation_id) → email_conversation(id)
- error_analytics(conversation_id) → conversation_history(id)
- error_analytics(workflow_id) → workflow(id)
- ai_qa_insight(conversation_history_id) → conversation_history(id)
- custom_event(event_configuration_id) → event_configuration(id)
- custom_event(conversation_history_id) → conversation_history(id)