# Fathom schema ERD

Table and field reference for the Fivetran Fathom connector.

## Table & Field Reference

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_at | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| created_at | Unknown |  |
| name | Unknown |  |

### meeting_calendar_invite

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| email | Unknown |  |
| email_domain | Unknown |  |
| is_external | Unknown |  |
| matched_speaker_display_name | Unknown |  |
| name | Unknown |  |

### meeting_action_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| assignee_email | Unknown |  |
| assignee_name | Unknown |  |
| assignee_team | Unknown |  |
| completed | Unknown |  |
| description | Unknown |  |
| recording_playback_url | Unknown |  |
| recording_timestamp | Unknown |  |
| user_generated | Unknown |  |

### meeting_action_transcript

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| speaker_display_name | Unknown |  |
| speaker_matched_calendar_invitee_email | Unknown |  |
| text | Unknown |  |
| time_stamp | Unknown |  |

### meeting_crm_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| record_url | Unknown |  |

### meeting_crm_company

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| name | Unknown |  |
| record_url | Unknown |  |

### meeting_crm_deal

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_recording_id | Unknown | PK, FK |
| amount | Unknown |  |
| name | Unknown |  |
| record_url | Unknown |  |

### meeting

| Column | Type | Keys |
| --- | --- | --- |
| recording_id | Unknown | PK |
| calendar_invitees_domains_type | Unknown |  |
| created_at | Unknown |  |
| crm_match_error | Unknown |  |
| default_summary_markdown_formatted | Unknown |  |
| default_summary_template_name | Unknown |  |
| meeting_title | Unknown |  |
| recorded_by_email | Unknown |  |
| recorded_by_email_domain | Unknown |  |
| recorded_by_name | Unknown |  |
| recorded_by_team | Unknown |  |
| recording_end_time | Unknown |  |
| recording_start_time | Unknown |  |
| scheduled_end_time | Unknown |  |
| scheduled_start_time | Unknown |  |
| share_url | Unknown |  |
| title | Unknown |  |
| transcript_language | Unknown |  |
| url | Unknown |  |

## Relationships

- meeting_calendar_invite(meeting_recording_id) → meeting(recording_id)
- meeting_action_item(meeting_recording_id) → meeting(recording_id)
- meeting_action_transcript(meeting_recording_id) → meeting(recording_id)
- meeting_crm_contact(meeting_recording_id) → meeting(recording_id)
- meeting_crm_company(meeting_recording_id) → meeting(recording_id)
- meeting_crm_deal(meeting_recording_id) → meeting(recording_id)