# Chorus schema ERD

Table and field reference for the Fivetran Chorus connector.

## Table & Field Reference

### engagement_participant

| Column | Type | Keys |
| --- | --- | --- |
| person_id | Long | PK |
| engagement_id | String | PK, FK |
| 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 | PK, FK |
| recording_transcription_cluster_index | Unknown | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| length | Unknown |  |
| start | Unknown |  |
| talk_time | Unknown |  |

### recording_transcription_cluster

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| 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 | PK, FK |
| recording_transcription_id | Unknown | PK, FK |

### recording_transcription_metrics

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| name | Unknown |  |
| value | Unknown |  |

### recording_transcription_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| 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 | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| recap | Unknown |  |

### recording_transcription_thumbnail

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| 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 | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| recording_transcription_tracker_index | Unknown | PK, FK |
| offsets | Unknown |  |
| utterance | Unknown |  |

### recording_transcription_team

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| recording_transcription_tracker_index | Unknown | PK, FK |

### recording_transcription_tracker

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| owner_id | Unknown | FK |
| id | Unknown |  |
| name | Unknown |  |
| source | Unknown |  |
| type | Unknown |  |

### recording_transcription_utterance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | String | PK, FK |
| recording_transcription_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

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

## Relationships

- engagement_participant(user_id) → users(id)
- engagement_participant(engagement_id) → engagement(id)
- engagement_tracker_match(engagement_id) → engagement(id)
- engagement(user_id) → users(id)
- recording_transcription_cluster_range(recording_transcription_cluster_index) → recording_transcription_cluster(index)
- recording_transcription_cluster_range(engagement_id) → engagement(id)
- recording_transcription_cluster_range(recording_transcription_id) → recording_transcription(id)
- recording_transcription_cluster(user_id) → users(id)
- recording_transcription_cluster(recording_transcription_id) → recording_transcription(id)
- recording_transcription_cluster(engagement_id) → engagement(id)
- recording_transcription_action_item(recording_transcription_id) → recording_transcription(id)
- recording_transcription_action_item(engagement_id) → engagement(id)
- recording_transcription_metrics(recording_transcription_id) → recording_transcription(id)
- recording_transcription_metrics(engagement_id) → engagement(id)
- recording_transcription_participant(user_id) → users(id)
- recording_transcription_participant(recording_transcription_id) → recording_transcription(id)
- recording_transcription_participant(engagement_id) → engagement(id)
- recording_transcription_recap(recording_transcription_id) → recording_transcription(id)
- recording_transcription_recap(engagement_id) → engagement(id)
- recording_transcription_thumbnail(recording_transcription_id) → recording_transcription(id)
- recording_transcription_thumbnail(engagement_id) → engagement(id)
- recording_transcription_tracker_mention(recording_transcription_tracker_index) → recording_transcription_tracker(index)
- recording_transcription_tracker_mention(recording_transcription_id) → recording_transcription(id)
- recording_transcription_tracker_mention(engagement_id) → engagement(id)
- recording_transcription_team(recording_transcription_tracker_index) → recording_transcription_tracker(index)
- recording_transcription_team(recording_transcription_id) → recording_transcription(id)
- recording_transcription_team(engagement_id) → engagement(id)
- recording_transcription_tracker(owner_id) → users(id)
- recording_transcription_tracker(recording_transcription_id) → recording_transcription(id)
- recording_transcription_tracker(engagement_id) → engagement(id)
- recording_transcription_utterance(recording_transcription_id) → recording_transcription(id)
- recording_transcription_utterance(engagement_id) → engagement(id)
- recording_transcription(engagement_id) → engagement(id)
- user_team(user_id) → users(id)
- users(manager_id) → users(id)
- scorecard_score(scorecard_id) → scorecard(id)
- scorecard(attributes_engagement_id) → engagement(id)
- scorecard(attributes_recipient_user_id) → users(id)
- scorecard(attributes_reviewer_user_id) → users(id)