Chorus
Explore the interactive ERD
Table & Field Reference
engagement_participant
| Column | Type | Keys |
|---|---|---|
person_id | Long | PK |
engagement_id | String | PKFK |
user_id | Long | FK |
company_name | String | |
email | String | |
name | String | |
title | String | |
type | String |
engagement_tracker_match
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
engagement_id | String | FK |
name | String | |
num_matches | Long | |
type | String |
engagement
| Column | Type | Keys |
|---|---|---|
id | String | PK |
user_id | Long | FK |
account_id | String | |
account_name | String | |
call_state | String | |
compliance | String | |
date_time | Double | |
disposition_connected | Boolean | |
disposition_gatekeeper | Boolean | |
disposition_tree | Boolean | |
disposition_voicemail | Boolean | |
duration | Double | |
engagement_type | String | |
initiator | String | |
languages | String | |
no_show | Boolean | |
num_cust_questions | Long | |
num_engaging_questions | Long | |
opportunity_id | String | |
opportunity_name | String | |
processing_state | String | |
subject | String | |
url | String |
recording_transcription_cluster_range
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_cluster_index | Unknown | PKFK |
recording_transcription_id | Unknown | PKFK |
length | Unknown | |
start | Unknown | |
talk_time | Unknown |
recording_transcription_cluster
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
user_id | Unknown | FK |
company_name | Unknown | |
display_name | Unknown | |
id | Unknown | |
match_method | Unknown | |
participant_id | Unknown | |
speaker_name | Unknown | |
title | Unknown | |
type | Unknown |
recording_transcription_action_item
| Column | Type | Keys |
|---|---|---|
action_item | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
recording_transcription_metrics
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
name | Unknown | |
value | Unknown |
recording_transcription_participant
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
user_id | Unknown | FK |
company_name | Unknown | |
is_my_team | Unknown | |
person_id | Unknown | |
picture | Unknown | |
title | Unknown | |
type | Unknown | |
zi_person_id | Unknown |
recording_transcription_recap
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
recap | Unknown |
recording_transcription_thumbnail
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
duration | Unknown | |
id | Unknown | |
keyframe_type | Unknown | |
offset_end | Unknown | |
offset_start | Unknown | |
type | Unknown |
recording_transcription_tracker_mention
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
recording_transcription_tracker_index | Unknown | PKFK |
offsets | Unknown | |
utterance | Unknown |
recording_transcription_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
recording_transcription_tracker_index | Unknown | PKFK |
recording_transcription_tracker
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
owner_id | Unknown | FK |
id | Unknown | |
name | Unknown | |
source | Unknown | |
type | Unknown |
recording_transcription_utterance
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
engagement_id | String | PKFK |
recording_transcription_id | Unknown | PKFK |
date_time | Unknown | |
engaging | Unknown | |
expired | Unknown | |
id | Unknown | |
participant | Unknown | |
snippet | Unknown | |
snippet_length | Unknown | |
snippet_time | Unknown | |
snippet_word_count | Unknown | |
speaker_id | Unknown | |
speaker_name | Unknown | |
speaker_type | Unknown | |
utterance_index | Unknown |
recording_transcription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
engagement_id | String | PKFK |
account_ext_id | Unknown | |
account_id | Unknown | |
account_name | Unknown | |
account_type | Unknown | |
account_zi_company_id | Unknown | |
company_name | Unknown | |
created_at | Unknown | |
custom_questions | Json | |
custom_summaries | Json | |
deal_close_date | Unknown | |
deal_current_stage | Unknown | |
deal_doc_type | Unknown | |
deal_engaged | Unknown | |
deal_follow_up_id | Unknown | |
deal_id | Unknown | |
deal_initial_amount | Unknown | |
deal_initial_stage | Unknown | |
deal_name | Unknown | |
deal_on_stage_since | Unknown | |
deal_size | Unknown | |
deal_size_increased_amount | Unknown | |
deal_stage_advancement | Unknown | |
deal_start_time | Unknown | |
deal_thread_id | Unknown | |
disposition_connected | Unknown | |
disposition_gatekeeper | Unknown | |
disposition_task_call_disposition | Unknown | |
disposition_tree | Unknown | |
disposition_voicemail | Unknown | |
generated_subject | Unknown | |
languages | Unknown | |
meeting_calendar_id | Unknown | |
meeting_ical_uid | Unknown | |
meeting_id | Unknown | |
meeting_meeting_url | Unknown | |
modified_at | Unknown | |
name | Unknown | |
offsets | Unknown | |
owner_email | Unknown | |
owner_name | Unknown | |
owner_person_id | Unknown | |
owner_user_id | Unknown | |
private | Unknown | |
recording_audio_only | Unknown | |
recording_autojoin | Unknown | |
recording_autojoin_reason | Unknown | |
recording_duration | Unknown | |
recording_end_reason | Unknown | |
recording_has_meeting_summary | Unknown | |
recording_recordable | Unknown | |
recording_schedule_end_time | Unknown | |
recording_schedule_start_time | Unknown | |
recording_start_time | Unknown | |
recording_unrecorded_reason | Unknown | |
source | Unknown | |
status | Unknown | |
summary | Unknown | |
summary_error | Unknown | |
tracker_match | Unknown | |
type | Unknown | |
user_company_name | Unknown | |
viewed | Unknown |
user_team
| Column | Type | Keys |
|---|---|---|
team_id | Long | PK |
user_id | Long | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Long | PK |
manager_id | Long | FK |
active | Long | |
autojoin | Long | |
created_on | Unknown | |
email | String | |
first_name | String | |
invalidated | Unknown | |
last_name | String | |
license_type | String | |
name | String | |
onboarding_status | String | |
primary_team | Long | |
provisioning_type | String | |
role | String | |
sync_calendar | Long | |
sync_email | Long | |
title | String |
scorecard_score
| Column | Type | Keys |
|---|---|---|
question_id | Long | PK |
scorecard_id | String | PKFK |
comment_text | String | |
question_text | String | |
score | Long |
scorecard
| Column | Type | Keys |
|---|---|---|
id | String | PK |
attributes_engagement_id | String | FK |
attributes_recipient_user_id | Long | FK |
attributes_reviewer_user_id | Long | FK |
attributes_initiative_description | String | |
attributes_initiative_id | Long | |
attributes_initiative_name | String | |
attributes_initiative_url | String | |
attributes_seen | Boolean | |
attributes_submitted | Unknown | |
attributes_url | String | |
type | String |