Fireflies
Explore the interactive ERD
Table & Field Reference
user_integration
| Column | Type | Keys |
|---|---|---|
integration_id | Unknown | PK |
users_id | Unknown | PKFK |
user_group_member
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_group_id | Unknown | PKFK |
users_id | Unknown | PKFK |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown |
user_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
display_name | Unknown | |
email | Unknown | |
name | Unknown | |
phone_number | Unknown |
transcript_meeting_attendance
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
transcript_id | Unknown | PKFK |
join_time | Instant | |
leave_time | Instant | |
name | Unknown |
transcript_speaker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transcript_id | Unknown | PKFK |
name | Unknown |
transcript_analytics_speaker
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transcript_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
src | Unknown | |
type | Unknown |
bite_privacy
| Column | Type | Keys |
|---|---|---|
privacy_id | Unknown | PK |
bite_id | Unknown | PKFK |
bite
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
transcript_id | Unknown | PKFK |
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 |