Sierra
Explore the interactive ERD
Table & Field Reference
audit_log_target
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
audit_log_id | Unknown | PKFK |
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 | PKFK |
category | Unknown |
workspace_simulation_message
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_simulation_test_id | Unknown | PKFK |
message | Unknown |
workspace_simulation_tag_expectation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_simulation_test_id | Unknown | PKFK |
tag_expectation | Unknown |
workspace_simulation_expected_outcome
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_simulation_test_id | Unknown | PKFK |
expected_outcome | Unknown |
workspace_simulation_expected_agent_event_attribute_assertion
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_simulation_expected_agent_event_index | Unknown | PKFK |
operator | Unknown | |
path | Unknown | |
value | Unknown |
workspace_simulation_expected_agent_event
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_simulation_test_id | Unknown | PKFK |
event_name | Unknown | |
max_count | Unknown | |
min_count | Unknown |
workspace_simulation
| Column | Type | Keys |
|---|---|---|
test_id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
workspace_workspace_id | Unknown | PKFK |
group_description | Unknown | |
is_critical | Unknown | |
name | Unknown | |
origin | Unknown |
release_defaults
| Column | Type | Keys |
|---|---|---|
hash | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
release_target_fivetran_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
customer_editable | Unknown | |
name | Unknown | |
value | Unknown |
workspace_environment_secret_name
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
workspace_environment_fivetran_id | Unknown | PKFK |
secret_name | Unknown |
workspace_environment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
agent_agent_id | Unknown | PKFK |
workspace_workspace_id | Unknown | PKFK |
name | Unknown |
conversation_search_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
tag_value | Unknown |
conversation_search_developer_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
developer_tag | Unknown |
conversation_search_message_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
conversation_search_message_index | Unknown | PKFK |
conversation_search_message
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
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 | PKFK |
issue_id | Unknown |
conversation_search_batch_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
batch_id | Unknown |
conversation_search_personal_identifier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_search_id | Unknown | PKFK |
type | Unknown |
conversation_search
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
role | Unknown |
users_effective_unscoped_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
tag_value | Unknown |
conversation_privacy_search_message_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_privacy_search_id | Unknown | PKFK |
conversation_privacy_search_message_index | Unknown | PKFK |
conversation_privacy_search_message
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_privacy_search_id | Unknown | PKFK |
author | Unknown | |
message_timestamp | Unknown | |
text | Unknown |
conversation_privacy_search_linked_issue_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_privacy_search_id | Unknown | PKFK |
issue_id | Unknown |
conversation_privacy_search
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
email | Unknown | |
name | Unknown |
monitor_result_export_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
monitor_result_export_conversation_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
value | Unknown |
knowledge_source_content
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
knowledge_source_id | Unknown | PKFK |
body | Unknown | |
source_url | Unknown | |
title | Unknown |
agent_memory_export_fact
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_memory_export_recipe_id | Unknown | PKFK |
fact | Unknown |
agent_memory_export
| Column | Type | Keys |
|---|---|---|
conversation_export_end_user_id | Unknown | PK |
recipe_id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
channel | Unknown | |
created_at | Unknown |
issue_linked_conversation_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
issue_id | Unknown | PKFK |
conversation_id | Unknown |
issue_linked_simulation_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
issue_id | Unknown | PKFK |
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 | PKFK |
creation_time | Unknown | |
creator_email | Unknown | |
creator_name | Unknown | |
emoji | Unknown |
issue_comment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
issue_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
workspace_workspace_id | Unknown | PKFK |
code | Unknown |
knowledge_source_crawl_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
knowledge_source_id | Unknown | PKFK |
status | Unknown |
conversation_recording
| Column | Type | Keys |
|---|---|---|
conversation_export_id | Unknown | PKFK |
recording_data | Unknown |
knowledge_source_partition_parameter
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
knowledge_source_id | Unknown | PKFK |
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 | PKFK |
custom_field_name | Unknown | |
metadata_key | Unknown |
conversation_recording_destination
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
tag_value | Unknown |
conversation_detail_developer_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_detail_id | Unknown | PKFK |
developer_tag | Unknown |
conversation_detail_message_event
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_detail_message_id | Unknown | PKFK |
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 | PKFK |
conversation_detail_message
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_detail_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
issue_id | Unknown |
conversation_detail_batch_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_detail_id | Unknown | PKFK |
batch_id | Unknown |
conversation_detail_personal_identifier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_detail_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
conversation_detail
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
conversation_export_id | Unknown | PKFK |
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 | PKFK |
label | Unknown |
batch_conversation_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
batch_id | Unknown | PKFK |
conversation_id | Unknown |
batch
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
name | Unknown | |
value | Unknown |
knowledge_source_article
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
knowledge_source_id | Unknown | PKFK |
content | Unknown | |
title | Unknown |
release_dev_target
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
agent_agent_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
event_name | Unknown | |
properties | Unknown |
simulation_result_transcript_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
simulation_result_index | Unknown | PKFK |
tag_value | Unknown |
simulation_result_transcript_developer_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
simulation_result_index | Unknown | PKFK |
developer_tag | Unknown |
simulation_result
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
simulation_id | Unknown | PKFK |
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 | PKFK |
release_defaults_hash | Unknown | PKFK |
latest_result_set_num_runs | Unknown | |
name | Unknown | |
url | Unknown |
knowledge_source_article_change
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
knowledge_source_id | Unknown | PKFK |
type | Unknown | |
updated_at | Unknown |
conversation_export_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_id | Unknown | PKFK |
tag_value | Unknown |
conversation_export_developer_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_id | Unknown | PKFK |
developer_tag | Unknown |
conversation_export_message_event
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_message_id | Unknown | PKFK |
timestamp_millis | Unknown | |
type | Unknown |
conversation_export_message_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_message_id | Unknown | PKFK |
conversation_export_message
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
conversation_export_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
issue_id | Unknown |
conversation_export_batch_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_id | Unknown | PKFK |
batch_id | Unknown |
conversation_export_personal_identifier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_export_id | Unknown | PKFK |
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 | PKFK |
tag_value | Unknown |
conversation_external_message_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_external_message_index | Unknown | PKFK |
conversation_external_message
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_external_id | Unknown | PKFK |
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 | PKFK |
issue_id | Unknown |
conversation_external_batch_id
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_external_id | Unknown | PKFK |
batch_id | Unknown |
conversation_external_personal_identifier
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
conversation_external_id | Unknown | PKFK |
type | Unknown |
conversation_external
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_agent_id | Unknown | PKFK |
conversation_export_id | Unknown | PKFK |
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 |