# Sierra schema ERD

Table and field reference for the Fivetran Sierra connector.

## Table & Field Reference

### audit_log_target

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| audit_log_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| action | Unknown |  |
| actor_id | Unknown |  |
| actor_name | Unknown |  |
| actor_type | Unknown |  |
| context_location | Unknown |  |
| context_user_agent | Unknown |  |
| metadata | Unknown |  |
| occurred_at | Instant |  |
| version | Unknown |  |

### workspace_simulation_category

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_test_id | Unknown | PK, FK |
| category | Unknown |  |

### workspace_simulation_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_test_id | Unknown | PK, FK |
| message | Unknown |  |

### workspace_simulation_tag_expectation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_test_id | Unknown | PK, FK |
| tag_expectation | Unknown |  |

### workspace_simulation_expected_outcome

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_test_id | Unknown | PK, FK |
| expected_outcome | Unknown |  |

### workspace_simulation_expected_agent_event_attribute_assertion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_expected_agent_event_index | Unknown | PK, FK |
| operator | Unknown |  |
| path | Unknown |  |
| value | Unknown |  |

### workspace_simulation_expected_agent_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_simulation_test_id | Unknown | PK, FK |
| event_name | Unknown |  |
| max_count | Unknown |  |
| min_count | Unknown |  |

### workspace_simulation

| Column | Type | Keys |
| --- | --- | --- |
| test_id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| workspace_workspace_id | Unknown | PK, FK |
| group_description | Unknown |  |
| is_critical | Unknown |  |
| name | Unknown |  |
| origin | Unknown |  |

### release_defaults

| Column | Type | Keys |
| --- | --- | --- |
| hash | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| creation_time | Unknown |  |
| git_branch | Unknown |  |
| git_commit | Unknown |  |
| git_dirty | Unknown |  |
| name | Unknown |  |
| snapshot_label | Unknown |  |
| snapshot_number | Unknown |  |

### release_target_live_release

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| release_target_fivetran_id | Unknown | PK, FK |
| is_fallback | Unknown |  |
| release_hash | Unknown |  |
| snapshot_label | Unknown |  |
| traffic_percent | Unknown |  |

### release_target

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_agent_id | Unknown | PK, FK |
| live_release_hash | Unknown |  |
| live_snapshot_label | Unknown |  |
| live_snapshot_number | Unknown |  |
| name | Unknown |  |

### workspace_environment_variable

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_environment_fivetran_id | Unknown | PK, FK |
| customer_editable | Unknown |  |
| name | Unknown |  |
| value | Unknown |  |

### workspace_environment_secret_name

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_environment_fivetran_id | Unknown | PK, FK |
| secret_name | Unknown |  |

### workspace_environment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_agent_id | Unknown | PK, FK |
| workspace_workspace_id | Unknown | PK, FK |
| name | Unknown |  |

### conversation_search_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| tag_value | Unknown |  |

### conversation_search_developer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| developer_tag | Unknown |  |

### conversation_search_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| conversation_search_message_index | Unknown | PK, FK |

### conversation_search_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| author | Unknown |  |
| external_id | Unknown |  |
| id | Unknown |  |
| message_timestamp | Unknown |  |
| provenance | Unknown |  |
| source_channel | Unknown |  |
| source_identity_key | Unknown |  |
| source_integration | Unknown |  |
| text | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_search_linked_issue_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| issue_id | Unknown |  |

### conversation_search_batch_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| batch_id | Unknown |  |

### conversation_search_personal_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_search_id | Unknown | PK, FK |
| type | Unknown |  |

### conversation_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| agent_handle_time_seconds | Unknown |  |
| bot_id | Unknown |  |
| conversation_created_at | Unknown |  |
| conversation_ended_at | Unknown |  |
| custom_fields | Unknown |  |
| device | Unknown |  |
| duration | Unknown |  |
| end_user_id | Unknown |  |
| forwarded_from_phone_number | Unknown |  |
| last_update_timestamp | Unknown |  |
| message_count | Unknown |  |
| release_id | Unknown |  |
| release_name | Unknown |  |
| review_status | Unknown |  |
| start_timestamp | Unknown |  |
| unredacted | Unknown |  |

### users_assigned_unscoped_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| role | Unknown |  |

### users_effective_unscoped_role

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| role | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| disabled | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |

### agent_snapshot_export

| Column | Type | Keys |
| --- | --- | --- |
| workspace_workspace_id | Unknown | PK, FK |
| snapshot_data | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK |
| archived | Unknown |  |
| is_default | Unknown |  |
| is_qa | Unknown |  |
| name | Unknown |  |

### conversation_privacy_search_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_privacy_search_id | Unknown | PK, FK |
| tag_value | Unknown |  |

### conversation_privacy_search_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_privacy_search_id | Unknown | PK, FK |
| conversation_privacy_search_message_index | Unknown | PK, FK |

### conversation_privacy_search_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_privacy_search_id | Unknown | PK, FK |
| author | Unknown |  |
| message_timestamp | Unknown |  |
| text | Unknown |  |

### conversation_privacy_search_linked_issue_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_privacy_search_id | Unknown | PK, FK |
| issue_id | Unknown |  |

### conversation_privacy_search

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| agent_handle_time_seconds | Unknown |  |
| bot_id | Unknown |  |
| device | Unknown |  |
| duration | Unknown |  |
| message_count | Unknown |  |
| review_status | Unknown |  |
| start_timestamp | Unknown |  |

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| workspace_id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |

### monitor_result_export_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| monitor_result_export_conversation_id | Unknown | PK, FK |
| category | Unknown |  |
| is_system | Unknown |  |
| monitor_id | Unknown |  |
| monitor_version_id | Unknown |  |
| name | Unknown |  |
| reasoning | Unknown |  |

### monitor_result_export

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK |
| conversation_last_update_timestamp | Instant |  |
| conversation_start_timestamp | Unknown |  |

### knowledge_source_content_partition_parameter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| knowledge_source_content_fivetran_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### knowledge_source_content

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| knowledge_source_id | Unknown | PK, FK |
| body | Unknown |  |
| source_url | Unknown |  |
| title | Unknown |  |

### agent_memory_export_fact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_memory_export_recipe_id | Unknown | PK, FK |
| fact | Unknown |  |

### agent_memory_export

| Column | Type | Keys |
| --- | --- | --- |
| conversation_export_end_user_id | Unknown | PK |
| recipe_id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| channel | Unknown |  |
| created_at | Unknown |  |

### issue_linked_conversation_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| conversation_id | Unknown |  |

### issue_linked_simulation_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| message_index | Unknown |  |
| release_hash | Unknown |  |
| result_id | Unknown |  |
| test_id | Unknown |  |

### issue_comment_reaction

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_comment_id | Unknown | PK, FK |
| creation_time | Unknown |  |
| creator_email | Unknown |  |
| creator_name | Unknown |  |
| emoji | Unknown |  |

### issue_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| issue_id | Unknown | PK, FK |
| body | Unknown |  |
| creation_time | Unknown |  |
| creator_email | Unknown |  |
| creator_name | Unknown |  |
| updated_time | Unknown |  |

### issue_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| issue_id | Unknown | PK, FK |
| label | Unknown |  |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_user_email | Unknown |  |
| bot_id | Unknown |  |
| category | Unknown |  |
| creation_time | Instant |  |
| creator_user_email | Unknown |  |
| description | Unknown |  |
| issue_category_id | Unknown |  |
| issue_category_label | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| org_id | Unknown |  |
| resolved_time | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |

### workspace_typedef

| Column | Type | Keys |
| --- | --- | --- |
| filename | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| workspace_workspace_id | Unknown | PK, FK |
| code | Unknown |  |

### knowledge_source_crawl_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| knowledge_source_id | Unknown | PK, FK |
| status | Unknown |  |

### conversation_recording

| Column | Type | Keys |
| --- | --- | --- |
| conversation_export_id | Unknown | PK, FK |
| recording_data | Unknown |  |

### knowledge_source_partition_parameter

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| knowledge_source_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |
| required | Unknown |  |

### knowledge_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| scope | Unknown |  |

### conversation_recording_destination_custom_field_metadata_mapping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_recording_destination_id | Unknown | PK, FK |
| custom_field_name | Unknown |  |
| metadata_key | Unknown |  |

### conversation_recording_destination

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| channels | Unknown |  |
| configuration_bucket | Unknown |  |
| configuration_credentials_configured | Unknown |  |
| configuration_path_prefix | Unknown |  |
| configuration_service_account_email | Unknown |  |
| created_at | Unknown |  |
| enabled | Unknown |  |
| target | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### conversation_detail_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| tag_value | Unknown |  |

### conversation_detail_developer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| developer_tag | Unknown |  |

### conversation_detail_message_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_message_id | Unknown | PK, FK |
| args | Unknown |  |
| result | Unknown |  |
| timestamp_millis | Unknown |  |
| tool_name | Unknown |  |
| type | Unknown |  |

### conversation_detail_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_message_id | Unknown | PK, FK |

### conversation_detail_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| author | Unknown |  |
| external_id | Unknown |  |
| message_timestamp | Unknown |  |
| provenance | Unknown |  |
| source_channel | Unknown |  |
| source_identity_key | Unknown |  |
| source_integration | Unknown |  |
| text | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_detail_agent_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| conversation_id | Unknown |  |
| event_name | Unknown |  |
| event_timestamp | Unknown |  |
| properties | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_detail_event_trace

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_event_index | Unknown | PK, FK |
| duration_ms | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |

### conversation_detail_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| data_first_token_time | Unknown |  |
| data_generated_at_ms | Unknown |  |
| data_message_id | Unknown |  |
| data_start_time | Unknown |  |
| type | Unknown |  |

### conversation_detail_linked_issue_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| issue_id | Unknown |  |

### conversation_detail_batch_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| batch_id | Unknown |  |

### conversation_detail_personal_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_detail_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### conversation_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| conversation_export_id | Unknown | PK, FK |
| agent_handle_time_seconds | Unknown |  |
| bot_id | Unknown |  |
| conversation_created_at | Unknown |  |
| conversation_ended_at | Unknown |  |
| custom_fields | Unknown |  |
| device | Unknown |  |
| duration | Unknown |  |
| end_user_id | Unknown |  |
| external_conversation_id | Unknown |  |
| external_system_id | Unknown |  |
| forwarded_from_phone_number | Unknown |  |
| last_update_timestamp | Unknown |  |
| message_count | Unknown |  |
| release_id | Unknown |  |
| release_name | Unknown |  |
| release_target | Unknown |  |
| review_status | Unknown |  |
| start_timestamp | Unknown |  |
| unredacted | Unknown |  |

### batch_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| batch_id | Unknown | PK, FK |
| label | Unknown |  |

### batch_conversation_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| batch_id | Unknown | PK, FK |
| conversation_id | Unknown |  |

### batch

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| conversation_count | Unknown |  |
| creation_time | Unknown |  |
| is_simulated | Unknown |  |
| name | Unknown |  |
| reviewed_conversation_count | Unknown |  |
| total_issue_count | Unknown |  |

### knowledge_source_article_metadata

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| knowledge_source_article_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### knowledge_source_article

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| knowledge_source_id | Unknown | PK, FK |
| content | Unknown |  |
| title | Unknown |  |

### release_dev_target

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| chat_url | Unknown |  |
| creation_time | Unknown |  |
| creator_email | Unknown |  |
| environment_id | Unknown |  |
| voice_url | Unknown |  |
| workspace_id | Unknown |  |

### simulation_result_assertion

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_result_index | Unknown | PK, FK |
| assertion_type | Unknown |  |
| expected_outcome | Unknown |  |
| is_passing | Unknown |  |
| judge_reasoning | Unknown |  |

### simulation_result_transcript_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_result_index | Unknown | PK, FK |
| author | Unknown |  |
| message_timestamp | Unknown |  |
| text | Unknown |  |
| timestamp_millis | Unknown |  |

### simulation_result_transcript_agent_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_result_index | Unknown | PK, FK |
| event_name | Unknown |  |
| properties | Unknown |  |

### simulation_result_transcript_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_result_index | Unknown | PK, FK |
| tag_value | Unknown |  |

### simulation_result_transcript_developer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_result_index | Unknown | PK, FK |
| developer_tag | Unknown |  |

### simulation_result

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| simulation_id | Unknown | PK, FK |
| status | Unknown |  |
| transcript_bot_id | Unknown |  |
| transcript_duration | Unknown |  |
| transcript_id | Unknown |  |
| transcript_message_count | Unknown |  |
| transcript_start_timestamp | Unknown |  |
| transcript_unredacted | Unknown |  |

### simulation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| release_defaults_hash | Unknown | PK, FK |
| latest_result_set_num_runs | Unknown |  |
| name | Unknown |  |
| url | Unknown |  |

### knowledge_source_article_change

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| knowledge_source_id | Unknown | PK, FK |
| type | Unknown |  |
| updated_at | Unknown |  |

### conversation_export_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| tag_value | Unknown |  |

### conversation_export_developer_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| developer_tag | Unknown |  |

### conversation_export_message_event

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_message_id | Unknown | PK, FK |
| timestamp_millis | Unknown |  |
| type | Unknown |  |

### conversation_export_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_message_id | Unknown | PK, FK |

### conversation_export_message

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| author | Unknown |  |
| external_id | Unknown |  |
| message_timestamp | Unknown |  |
| provenance | Unknown |  |
| source_channel | Unknown |  |
| source_identity_key | Unknown |  |
| source_integration | Unknown |  |
| text | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_export_mcp_turn

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| arguments | Unknown |  |
| result | Unknown |  |
| timestamp_millis | Unknown |  |
| tool_name | Unknown |  |
| turn_timestamp | Unknown |  |

### conversation_export_agent_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| conversation_id | Unknown |  |
| event_name | Unknown |  |
| event_timestamp | Unknown |  |
| properties | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_export_linked_issue_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| issue_id | Unknown |  |

### conversation_export_batch_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| batch_id | Unknown |  |

### conversation_export_personal_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_export_id | Unknown | PK, FK |
| type | Unknown |  |
| value | Unknown |  |

### conversation_export

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_handle_time_seconds | Unknown |  |
| bot_id | Unknown |  |
| conversation_created_at | Unknown |  |
| conversation_ended_at | Unknown |  |
| custom_fields | Unknown |  |
| device | Unknown |  |
| duration | Unknown |  |
| end_user_id | Unknown |  |
| external_conversation_id | Unknown |  |
| external_system_id | Unknown |  |
| forwarded_from_phone_number | Unknown |  |
| last_update_timestamp | Instant |  |
| message_count | Unknown |  |
| release_id | Unknown |  |
| release_name | Unknown |  |
| release_target | Unknown |  |
| review_status | Unknown |  |
| start_timestamp | Unknown |  |
| unredacted | Unknown |  |

### conversation_external_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_id | Unknown | PK, FK |
| tag_value | Unknown |  |

### conversation_external_message_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_message_index | Unknown | PK, FK |

### conversation_external_message

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_id | Unknown | PK, FK |
| author | Unknown |  |
| message_timestamp | Unknown |  |
| text | Unknown |  |
| timestamp_millis | Unknown |  |

### conversation_external_linked_issue_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_id | Unknown | PK, FK |
| issue_id | Unknown |  |

### conversation_external_batch_id

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_id | Unknown | PK, FK |
| batch_id | Unknown |  |

### conversation_external_personal_identifier

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_external_id | Unknown | PK, FK |
| type | Unknown |  |

### conversation_external

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_agent_id | Unknown | PK, FK |
| conversation_export_id | Unknown | PK, FK |
| agent_handle_time_seconds | Unknown |  |
| bot_id | Unknown |  |
| conversation_created_at | Unknown |  |
| conversation_ended_at | Unknown |  |
| custom_fields | Unknown |  |
| device | Unknown |  |
| duration | Unknown |  |
| end_user_id | Unknown |  |
| external_conversation_id | Unknown |  |
| external_system_id | Unknown |  |
| message_count | Unknown |  |
| release_id | Unknown |  |
| release_name | Unknown |  |
| review_status | Unknown |  |
| start_timestamp | Unknown |  |
| unredacted | Unknown |  |

## Relationships

- audit_log_target(audit_log_id) → audit_log(id)
- workspace_simulation_category(workspace_simulation_test_id) → workspace_simulation(test_id)
- workspace_simulation_message(workspace_simulation_test_id) → workspace_simulation(test_id)
- workspace_simulation_tag_expectation(workspace_simulation_test_id) → workspace_simulation(test_id)
- workspace_simulation_expected_outcome(workspace_simulation_test_id) → workspace_simulation(test_id)
- workspace_simulation_expected_agent_event_attribute_assertion(workspace_simulation_expected_agent_event_index) → workspace_simulation_expected_agent_event(index)
- workspace_simulation_expected_agent_event(workspace_simulation_test_id) → workspace_simulation(test_id)
- workspace_simulation(agent_agent_id) → agent(agent_id)
- workspace_simulation(workspace_workspace_id) → workspace(workspace_id)
- release_defaults(agent_agent_id) → agent(agent_id)
- release_target_live_release(release_target_fivetran_id) → release_target(_fivetran_id)
- release_target_live_release(agent_agent_id) → agent(agent_id)
- release_target(agent_agent_id) → agent(agent_id)
- workspace_environment_variable(workspace_environment_fivetran_id) → workspace_environment(_fivetran_id)
- workspace_environment_secret_name(workspace_environment_fivetran_id) → workspace_environment(_fivetran_id)
- workspace_environment(agent_agent_id) → agent(agent_id)
- workspace_environment(workspace_workspace_id) → workspace(workspace_id)
- conversation_search_tag(conversation_search_id) → conversation_search(id)
- conversation_search_developer_tag(conversation_search_id) → conversation_search(id)
- conversation_search_message_attachment(conversation_search_message_index) → conversation_search_message(index)
- conversation_search_message_attachment(conversation_search_id) → conversation_search(id)
- conversation_search_message(conversation_search_id) → conversation_search(id)
- conversation_search_linked_issue_id(conversation_search_id) → conversation_search(id)
- conversation_search_batch_id(conversation_search_id) → conversation_search(id)
- conversation_search_personal_identifier(conversation_search_id) → conversation_search(id)
- conversation_search(agent_agent_id) → agent(agent_id)
- users_assigned_unscoped_role(users_id) → users(id)
- users_effective_unscoped_role(users_id) → users(id)
- agent_snapshot_export(workspace_workspace_id) → workspace(workspace_id)
- conversation_privacy_search_tag(conversation_privacy_search_id) → conversation_privacy_search(id)
- conversation_privacy_search_message_attachment(conversation_privacy_search_message_index) → conversation_privacy_search_message(index)
- conversation_privacy_search_message_attachment(conversation_privacy_search_id) → conversation_privacy_search(id)
- conversation_privacy_search_message(conversation_privacy_search_id) → conversation_privacy_search(id)
- conversation_privacy_search_linked_issue_id(conversation_privacy_search_id) → conversation_privacy_search(id)
- conversation_privacy_search(agent_agent_id) → agent(agent_id)
- workspace(agent_agent_id) → agent(agent_id)
- monitor_result_export_result(monitor_result_export_conversation_id) → monitor_result_export(conversation_id)
- knowledge_source_content_partition_parameter(knowledge_source_content_fivetran_id) → knowledge_source_content(_fivetran_id)
- knowledge_source_content(knowledge_source_id) → knowledge_source(id)
- agent_memory_export_fact(agent_memory_export_recipe_id) → agent_memory_export(recipe_id)
- agent_memory_export(agent_agent_id) → agent(agent_id)
- issue_linked_conversation_id(issue_id) → issue(id)
- issue_linked_simulation_id(issue_id) → issue(id)
- issue_comment_reaction(issue_comment_id) → issue_comment(id)
- issue_comment(issue_id) → issue(id)
- issue_label(issue_id) → issue(id)
- workspace_typedef(agent_agent_id) → agent(agent_id)
- workspace_typedef(workspace_workspace_id) → workspace(workspace_id)
- knowledge_source_crawl_detail(knowledge_source_id) → knowledge_source(id)
- conversation_recording(conversation_export_id) → conversation_export(id)
- knowledge_source_partition_parameter(knowledge_source_id) → knowledge_source(id)
- conversation_recording_destination_custom_field_metadata_mapping(conversation_recording_destination_id) → conversation_recording_destination(id)
- conversation_recording_destination(agent_agent_id) → agent(agent_id)
- conversation_detail_tag(conversation_detail_id) → conversation_detail(id)
- conversation_detail_developer_tag(conversation_detail_id) → conversation_detail(id)
- conversation_detail_message_event(conversation_detail_message_id) → conversation_detail_message(id)
- conversation_detail_message_attachment(conversation_detail_message_id) → conversation_detail_message(id)
- conversation_detail_message(conversation_detail_id) → conversation_detail(id)
- conversation_detail_agent_event(conversation_detail_id) → conversation_detail(id)
- conversation_detail_event_trace(conversation_detail_event_index) → conversation_detail_event(index)
- conversation_detail_event(conversation_detail_id) → conversation_detail(id)
- conversation_detail_linked_issue_id(conversation_detail_id) → conversation_detail(id)
- conversation_detail_batch_id(conversation_detail_id) → conversation_detail(id)
- conversation_detail_personal_identifier(conversation_detail_id) → conversation_detail(id)
- conversation_detail(agent_agent_id) → agent(agent_id)
- conversation_detail(conversation_export_id) → conversation_export(id)
- batch_label(batch_id) → batch(id)
- batch_conversation_id(batch_id) → batch(id)
- batch(agent_agent_id) → agent(agent_id)
- knowledge_source_article_metadata(knowledge_source_article_id) → knowledge_source_article(id)
- knowledge_source_article(knowledge_source_id) → knowledge_source(id)
- release_dev_target(agent_agent_id) → agent(agent_id)
- simulation_result_assertion(simulation_result_index) → simulation_result(index)
- simulation_result_transcript_message(simulation_result_index) → simulation_result(index)
- simulation_result_transcript_agent_event(simulation_result_index) → simulation_result(index)
- simulation_result_transcript_tag(simulation_result_index) → simulation_result(index)
- simulation_result_transcript_developer_tag(simulation_result_index) → simulation_result(index)
- simulation_result(simulation_id) → simulation(id)
- simulation(agent_agent_id) → agent(agent_id)
- simulation(release_defaults_hash) → release_defaults(hash)
- knowledge_source_article_change(knowledge_source_id) → knowledge_source(id)
- conversation_export_tag(conversation_export_id) → conversation_export(id)
- conversation_export_developer_tag(conversation_export_id) → conversation_export(id)
- conversation_export_message_event(conversation_export_message_id) → conversation_export_message(id)
- conversation_export_message_attachment(conversation_export_message_id) → conversation_export_message(id)
- conversation_export_message(conversation_export_id) → conversation_export(id)
- conversation_export_mcp_turn(conversation_export_id) → conversation_export(id)
- conversation_export_agent_event(conversation_export_id) → conversation_export(id)
- conversation_export_linked_issue_id(conversation_export_id) → conversation_export(id)
- conversation_export_batch_id(conversation_export_id) → conversation_export(id)
- conversation_export_personal_identifier(conversation_export_id) → conversation_export(id)
- conversation_external_tag(conversation_external_id) → conversation_external(id)
- conversation_external_message_attachment(conversation_external_message_index) → conversation_external_message(index)
- conversation_external_message(conversation_external_id) → conversation_external(id)
- conversation_external_linked_issue_id(conversation_external_id) → conversation_external(id)
- conversation_external_batch_id(conversation_external_id) → conversation_external(id)
- conversation_external_personal_identifier(conversation_external_id) → conversation_external(id)
- conversation_external(agent_agent_id) → agent(agent_id)
- conversation_external(conversation_export_id) → conversation_export(id)
