# Fireflies schema ERD

Table and field reference for the Fivetran Fireflies connector.

## Table & Field Reference

### user_integration

| Column | Type | Keys |
| --- | --- | --- |
| integration_id | Unknown | PK |
| users_id | Unknown | PK, FK |

### user_group_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_group_id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |

### user_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| handle | Unknown |  |
| name | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email | Unknown |  |
| is_admin | Boolean |  |
| minutes_consumed | Unknown |  |
| name | Unknown |  |
| recent_meeting | Unknown |  |

### transcript_sentence

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| ai_filters_date_and_time | Unknown |  |
| ai_filters_metric | Unknown |  |
| ai_filters_pricing | Unknown |  |
| ai_filters_question | Unknown |  |
| ai_filters_sentiment | Unknown |  |
| ai_filters_task | Unknown |  |
| ai_filters_text_cleanup | Unknown |  |
| end_time | Unknown |  |
| raw_text | Unknown |  |
| speaker_id | Unknown |  |
| speaker_name | Unknown |  |
| start_time | Unknown |  |
| text | Unknown |  |

### transcript_app_preview_output

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| app_id | Unknown |  |
| created_at | Unknown |  |
| prompt | Unknown |  |
| response | Unknown |  |
| title | Unknown |  |

### transcript_meeting_attendee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| display_name | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |

### transcript_meeting_attendance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| join_time | Instant |  |
| leave_time | Instant |  |
| name | Unknown |  |

### transcript_speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| name | Unknown |  |

### transcript_analytics_speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| duration | Unknown |  |
| duration_pct | Unknown |  |
| filler_words | Unknown |  |
| longest_monologue | Unknown |  |
| monologues_count | Unknown |  |
| name | Unknown |  |
| questions | Unknown |  |
| word_count | Unknown |  |
| words_per_minute | Unknown |  |

### transcript

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| audio_url | Unknown |  |
| cal_id | Unknown |  |
| calendar_id | Unknown |  |
| calendar_type | Unknown |  |
| channels | Json |  |
| created_date | Instant |  |
| date_times | Unknown |  |
| duration | Unknown |  |
| fireflies_users | Json |  |
| meeting_date | Instant |  |
| meeting_info_is_bot_joined | Boolean |  |
| meeting_info_is_silent_meeting | Boolean |  |
| meeting_info_summary_status | Unknown |  |
| meeting_link | Unknown |  |
| metrics | Unknown |  |
| negative_pct | Unknown |  |
| neutral_pct | Unknown |  |
| organizer_email | Unknown |  |
| participants | Json |  |
| positive_pct | Unknown |  |
| privacy | Unknown |  |
| questions | Unknown |  |
| summary_action_items | Unknown |  |
| summary_bullet_gist | Unknown |  |
| summary_extended_sections | Json |  |
| summary_gist | Unknown |  |
| summary_keywords | Json |  |
| summary_meeting_type | Unknown |  |
| summary_notes | Unknown |  |
| summary_outline | Unknown |  |
| summary_overview | Unknown |  |
| summary_short_overview | Unknown |  |
| summary_short_summary | Unknown |  |
| summary_shorthand_bullet | Unknown |  |
| summary_topics_discussed | Json |  |
| summary_transcript_chapters | Json |  |
| tasks | Unknown |  |
| title | Unknown |  |
| transcript_url | Unknown |  |
| video_url | Unknown |  |

### bite_caption

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bite_id | Unknown | PK, FK |
| end_time | Instant |  |
| speaker_id | Unknown |  |
| speaker_name | Unknown |  |
| start_time | Instant |  |
| text | Unknown |  |

### bite_source

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| bite_id | Unknown | PK, FK |
| src | Unknown |  |
| type | Unknown |  |

### bite_privacy

| Column | Type | Keys |
| --- | --- | --- |
| privacy_id | Unknown | PK |
| bite_id | Unknown | PK, FK |

### bite

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transcript_id | Unknown | PK, FK |
| created_from_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Instant |  |
| created_from_description | Unknown |  |
| created_from_duration | Unknown |  |
| created_from_name | Unknown |  |
| created_from_type | Unknown |  |
| end_time | Unknown |  |
| media_type | Unknown |  |
| name | Unknown |  |
| preview | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| summary | Unknown |  |
| summary_status | Unknown |  |
| thumbnail | Unknown |  |

## Relationships

- user_integration(users_id) → users(id)
- user_group_member(user_group_id) → user_group(id)
- user_group_member(users_id) → user_group(users_id)
- user_group(users_id) → users(id)
- transcript_sentence(transcript_id) → transcript(id)
- transcript_app_preview_output(user_id) → users(id)
- transcript_app_preview_output(transcript_id) → transcript(id)
- transcript_meeting_attendee(transcript_id) → transcript(id)
- transcript_meeting_attendance(transcript_id) → transcript(id)
- transcript_speaker(transcript_id) → transcript(id)
- transcript_analytics_speaker(transcript_id) → transcript(id)
- transcript(user_id) → users(id)
- bite_caption(bite_id) → bite(id)
- bite_source(bite_id) → bite(id)
- bite_privacy(bite_id) → bite(id)
- bite(user_id) → users(id)
- bite(created_from_id) → transcript(id)
- bite(transcript_id) → transcript(id)