Close
Explore the interactive ERD
Table & Field Reference
form_submission
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
form_configuration_id | Unknown | |
form_id | Unknown | |
form_name | Unknown | |
ip_address | Unknown | |
organization_id | Unknown | |
origin | Unknown | |
responses | Json | |
source_url | Unknown | |
type | Unknown | |
users | Json | |
values_by_name | Json | |
custom_values_** |
dialer_user
| Column | Type | Keys |
|---|---|---|
dialer_id | Unknown | PKFK |
user_id | Unknown | PKFK |
is_active | Unknown | |
state | Unknown |
dialer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
caller_id | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
is_user_dependent | Unknown | |
music_preference | Unknown | |
organization_id | Unknown | |
ring_mode | Unknown | |
source_type | Unknown | |
source_value | Unknown | |
status | Unknown | |
type | Unknown |
shared_association
| Column | Type | Keys |
|---|---|---|
object_type | Unknown | PK |
shared_custom_field_id | Unknown | FK |
custom_activity_type_id | Unknown | |
editable_with_roles | Json | |
required | Unknown |
shared_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
accepts_multiple_values | Unknown | |
choices | Json | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
name | Unknown | |
organization_id | Unknown | |
type | Unknown |
bulk_delete
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
n_leads | Unknown | |
n_leads_processed | Unknown | |
organization_id | Unknown | |
query | Unknown | |
send_done_email | Unknown | |
status | Unknown |
contact_email
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
contact_id | Unknown | PKFK |
type | Unknown |
contact_phone
| Column | Type | Keys |
|---|---|---|
phone | Unknown | PK |
contact_id | Unknown | PKFK |
country | Unknown | |
phone_formatted | Unknown | |
type | Unknown |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
display_name | Unknown | |
integration_links | Json | |
name | Unknown | |
organization_id | Unknown | |
title | Unknown |
lead_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
label | Unknown | |
organization_id | Unknown |
note_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
attachment | Json | |
date_created | Unknown | |
date_updated | Unknown | |
note | Unknown | |
note_mention | Json | |
organization_id | Unknown | |
pinned_at | Unknown | |
title | Unknown | |
type | Unknown |
opportunity_status_change_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
new_status_id | Unknown | FK |
old_status_id | Unknown | FK |
opportunity_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
contact_id | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
lead_id | Unknown | |
organization_id | Unknown | |
type | Unknown |
opportunity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
status_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
annualized_expected_value | Unknown | |
annualized_value | Unknown | |
confidence | Unknown | |
date_created | Unknown | |
date_lost | Unknown | |
date_updated | Instant | |
date_won | Unknown | |
expected_value | Unknown | |
integration_links | Json | |
note | Unknown | |
organization_id | Unknown | |
status_display_name | Unknown | |
value | Unknown | |
value_currency | Unknown | |
value_formatted | Unknown | |
value_period | Unknown |
bulk_edit
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
lead_status_id | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
n_leads | Unknown | |
n_leads_processed | Unknown | |
organization_id | Unknown | |
query | Unknown | |
send_done_email | Unknown | |
status | Unknown | |
type | Unknown |
custom_activity_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom_activity_id | Unknown | FK |
accepts_multiple_values | Unknown | |
back_reference_is_visible | Unknown | |
converting_to_type | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
is_shared | Unknown | |
name | Unknown | |
referenced_custom_type_id | Unknown | |
required | Unknown | |
type | Unknown |
custom_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
api_create_only | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
name | Unknown | |
organization_id | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_created | Unknown | |
date_updated | Unknown | |
email | Unknown | |
email_verification_token_generated_at | Unknown | |
email_verified_at | Unknown | |
first_name | Unknown | |
image | Unknown | |
last_name | Unknown | |
last_used_timezone | Unknown | |
organizations | Json |
sequence_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
email_template_id | Unknown | FK |
sequence_id | Unknown | FK |
updated_by_id | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
delay | Unknown | |
required | Unknown | |
step_allowed_delay | Unknown | |
step_type | Unknown | |
threading | Unknown |
sequence
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by_id | Unknown | FK |
updated_by_id | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
name | Unknown | |
organization_id | Unknown | |
schedule_id | Unknown | |
status | Unknown | |
timezone | Unknown |
opportunity_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
pipeline_id | Unknown | FK |
label | Unknown | |
organization_id | Unknown | |
type | Unknown |
task_email
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
task_id | Unknown | PKFK |
task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_to | Unknown | FK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
date | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
is_complete | Unknown | |
object_id | Unknown | |
object_type | Unknown | |
opportunity_note | Unknown | |
opportunity_value | Unknown | |
opportunity_value_formatted | Unknown | |
opportunity_value_period | Unknown | |
organization_id | Unknown | |
type | Unknown | |
view | Unknown |
custom_activity_instance
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
custom_activity_type_id | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
organization_id | Unknown | |
status | Unknown | |
type | Unknown | |
user_name | Unknown | |
users | Json |
phone_number
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
forward_to | Unknown | |
forward_to_enabled | Unknown | |
forward_to_formatted | Unknown | |
is_group_number | Unknown | |
label | Unknown | |
number | Unknown | |
number_formatted | Unknown | |
organization_id | Unknown | |
participants | Json | |
phone_numbers | Json | |
phone_numbers_formatted | Json | |
sms_enabled | Unknown | |
supports_sms_to_countries | Json | |
type | Unknown | |
voicemail_greeting_url | Unknown |
opportunity_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
accepts_multiple_values | Unknown | |
choices | Json | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
name | Unknown | |
organization_id | Unknown | |
type | Unknown |
email_template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
attachments | Json | |
body | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
is_archived | Unknown | |
is_shared | Unknown | |
name | Unknown | |
organization_id | Unknown | |
subject | Unknown |
task_completed_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
task_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
organization_id | Unknown | |
task_text | Unknown | |
type | Unknown |
activity_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
accepts_multiple_values | Unknown | |
choices | Json | |
custom_activity_type_id | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
name | Unknown | |
organization_id | Unknown | |
referenced_custom_type_id | Unknown | |
type | Unknown |
integration_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
name | Unknown | |
organization_id | Unknown | |
type | Unknown | |
url | Unknown |
contact_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
accepts_multiple_values | Unknown | |
choices | Json | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
name | Unknown | |
organization_id | Unknown | |
type | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
date_created | Unknown | |
date_updated | Unknown | |
editable | Unknown | |
name | Unknown | |
organization_id | Unknown | |
permission | Json |
whatsapp_message_activity_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
whatsapp_message_activity_id | Unknown | PKFK |
content_type | Unknown | |
filename | Unknown | |
size | Unknown | |
thumbnail_url | Unknown | |
url | Unknown |
whatsapp_message_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
external_whatsapp_message_id | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
attachments | Json | |
created_by_name | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
direction | Unknown | |
integration_link | Unknown | |
integration_name | Unknown | |
local_phone | Unknown | |
local_phone_formatted | Unknown | |
message_html | Unknown | |
message_markdown | Unknown | |
organization_id | Unknown | |
remote_phone | Unknown | |
remote_phone_formatted | Unknown | |
response_to_id | Unknown | |
sequence_id | Unknown | |
sequence_name | Unknown | |
sequence_subscription_id | Unknown | |
source | Unknown | |
text | Unknown | |
type | Unknown | |
updated_by_name | Unknown |
email_activity_attachment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_activity_id | Unknown | FK |
content_type | Unknown | |
filename | Unknown | |
size | Unknown | |
url | Unknown |
email_activity_to
| Column | Type | Keys |
|---|---|---|
receiver | Unknown | PK |
email_activity_id | Unknown | PKFK |
email_body_text
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_activity_id | Unknown | FK |
expand | Unknown | |
text | Unknown |
email_envelope_sender
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
email_activity_id | Unknown | PKFK |
name | Unknown |
email_envelope_to
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
email_activity_id | Unknown | PKFK |
name | Unknown |
email_envelope_from
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
email_activity_id | Unknown | PKFK |
name | Unknown |
email_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
followup_sequence_id | Unknown | FK |
lead_id | Unknown | FK |
sequence_id | Unknown | FK |
sequence_subscription_id | Unknown | FK |
template_id | Unknown | FK |
thread_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
attachments | Json | |
bcc | Json | |
bulk_email_action_id | Unknown | |
cc | Json | |
date_created | Unknown | |
date_scheduled | Unknown | |
date_sent | Unknown | |
date_updated | Unknown | |
direction | Unknown | |
email_account_id | Unknown | |
envelope_bcc | Json | |
envelope_cc | Json | |
envelope_date | Unknown | |
envelope_in_reply_to | Unknown | |
envelope_is_autoreply | Unknown | |
envelope_message_id | Unknown | |
envelope_subject | Unknown | |
followup_sequence_delay | Unknown | |
has_reply | Unknown | |
in_reply_to_id | Unknown | |
message_ids | Json | |
need_smtp_credentials | Unknown | |
opens | Json | |
opens_summary | Unknown | |
organization_id | Unknown | |
reference | Json | |
send_as_id | Unknown | |
send_attempts | Json | |
sender | Unknown | |
status | Unknown | |
subject | Unknown | |
type | Unknown | |
users | Json |
lead_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
accepts_multiple_values | Unknown | |
back_reference_is_visible | Unknown | |
choices | Json | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
editable_with_roles | Json | |
is_shared | Unknown | |
name | Unknown | |
organization_id | Unknown | |
referenced_custom_type_id | Unknown | |
type | Unknown |
send_as
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
allowed_user_id | Unknown | FK |
allowing_user_id | Unknown | FK |
organization_id | Unknown |
bulk_sequence_subscription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
sequence_id | Unknown | FK |
updated_by | Unknown | FK |
action_type | Unknown | |
contact_preference | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
n_leads | Unknown | |
n_leads_processed | Unknown | |
organization_id | Unknown | |
query | Unknown | |
send_done_email | Unknown | |
sender_account_id | Unknown | |
sender_email | Unknown | |
sender_name | Unknown | |
status | Unknown |
bulk_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
template_id | Unknown | FK |
updated_by | Unknown | FK |
contact_preference | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
n_leads | Unknown | |
n_leads_processed | Unknown | |
organization_id | Unknown | |
query | Unknown | |
send_done_email | Unknown | |
status | Unknown |
connected_account_identity
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
connected_account_id | Unknown | PKFK |
name | Unknown |
connected_account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
imap | Unknown | |
organization_id | Unknown | |
smtp_host | Unknown | |
smtp_port | Unknown | |
smtp_use_ssl | Unknown | |
smtp_username | Unknown | |
synced_calendars | Json | |
type | Unknown |
lead_status_change_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
new_status_id | Unknown | FK |
old_status_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
organization_id | Unknown | |
users | Json |
created_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
import_id | Unknown | |
organization_id | Unknown | |
source | Unknown | |
users | Json |
outcome_applies_to
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
outcome_id | Unknown | PKFK |
applies_to | Unknown |
outcome
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
name | Unknown | |
organization_id | Unknown | |
type | Unknown |
sms_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sms_activity_id | Unknown | PKFK |
content_type | Unknown | |
filename | Unknown | |
media_id | Unknown | |
size | Unknown | |
url | Unknown |
sms_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
cost | Unknown | |
date_created | Unknown | |
date_sent | Unknown | |
date_updated | Unknown | |
direction | Unknown | |
local_country_iso | Unknown | |
local_phone | Unknown | |
organization_id | Unknown | |
remote_country_iso | Unknown | |
remote_phone | Unknown | |
remote_phone_formatted | Unknown | |
status | Unknown | |
text | Unknown | |
type | Unknown |
group_member
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
organization_id | Unknown |
lead_address
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
lead_id | Unknown | FK |
address_1 | Unknown | |
address_2 | Unknown | |
city | Unknown | |
country | Unknown | |
label | Unknown | |
state | Unknown | |
zipcode | Unknown |
lead
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
first_communication_user_id | Unknown | FK |
last_activity_user_id | Unknown | FK |
last_communication_user_id | Unknown | FK |
next_task_user_id | Unknown | FK |
primary_opportunity_pipeline_id | Unknown | FK |
primary_opportunity_status | Unknown | FK |
primary_opportunity_user_id | Unknown | FK |
status_id | Unknown | FK |
updated_by | Unknown | FK |
active_opportunity_value_summary | Unknown | |
contacts_summary | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
description | Unknown | |
display_name | Unknown | |
first_call_created | Unknown | |
first_call_note | Unknown | |
first_communication_date | Unknown | |
first_communication_summary | Unknown | |
first_communication_type | Unknown | |
first_source | Unknown | |
html_url | Unknown | |
integration_links | Json | |
last_activity_date | Unknown | |
last_activity_type | Unknown | |
last_call_created | Unknown | |
last_call_duration | Unknown | |
last_call_note | Unknown | |
last_communication_date | Unknown | |
last_communication_summary | Unknown | |
last_communication_type | Unknown | |
last_email_date | Unknown | |
last_email_subject | Unknown | |
last_incoming_email_date | Unknown | |
last_lead_status_change_date | Unknown | |
last_note_created | Unknown | |
last_outgoing_call_date | Unknown | |
local_time | Unknown | |
name | Unknown | |
next_task_date | Unknown | |
next_task_due_date | Unknown | |
next_task_text | Unknown | |
organization_id | Unknown | |
primary_address_summary | Unknown | |
primary_email | Unknown | |
primary_email_type | Unknown | |
primary_phone | Unknown | |
primary_phone_country | Unknown | |
primary_phone_formatted | Unknown | |
primary_phone_type | Unknown | |
times_communicated | Unknown | |
url | Unknown | |
won_opportunity_value_summary | Unknown |
email_thread_participant
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
email_thread_activity_id | Unknown | PKFK |
name | Unknown |
email_thread_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
latest_normalized_subject | Unknown | |
n_emails | Unknown | |
organization_id | Unknown | |
type | Unknown | |
users | Json |
pipline_status
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
pipeline_id | Unknown | FK |
label | Unknown | |
type | Unknown |
pipeline
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
name | Unknown | |
organization_id | Unknown |
call_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
sequence_id | Unknown | FK |
sequence_subscription_id | Unknown | FK |
transferred_from_user_id | Unknown | FK |
transferred_to_user_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
activity_at | Unknown | |
call_method | Unknown | |
coach_legs | Json | |
cost | Double | |
date_answered | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
dialer_id | Unknown | |
dialer_saved_search_id | Unknown | |
direction | Unknown | |
disposition | Unknown | |
duration | Unknown | |
forwarded_to | Unknown | |
has_recording | Unknown | |
is_forwarded | Unknown | |
is_joinable | Unknown | |
is_to_group_number | Unknown | |
local_country_iso | Unknown | |
local_phone | Unknown | |
local_phone_formatted | Unknown | |
note | Unknown | |
organization_id | Unknown | |
phone | Unknown | |
recording_expires_at | Unknown | |
recording_url | Unknown | |
remote_country_iso | Unknown | |
remote_phone | Unknown | |
remote_phone_formatted | Unknown | |
source | Unknown | |
status | Unknown | |
type | Unknown | |
users | Json | |
voicemail_duration | Unknown | |
voicemail_url | Unknown |
form_field_definition_choice
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
form_field_definition_id | Unknown | PKFK |
form_id | Unknown | PKFK |
label | Unknown | |
value | Unknown |
form_field_definition
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
form_id | Unknown | PKFK |
name | Unknown | |
type | Unknown |
form
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
updated_by | Unknown | FK |
date_created | Unknown | |
date_updated | Unknown | |
is_archived | Unknown | |
name | Unknown | |
organization_id | Unknown |
meeting_attendee
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
meeting_activity_id | Unknown | PKFK |
contact_id | Unknown | FK |
user_id | Unknown | FK |
is_organizer | Unknown | |
status | Unknown |
meeting_activity_transcript_utterance
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
meeting_activity_id | Unknown | PKFK |
meeting_activity_transcript_index | Unknown | PKFK |
ends | Unknown | |
speaker_label | Unknown | |
speaker_side | Unknown | |
start | Unknown | |
text | Unknown |
meeting_activity_transcript
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
meeting_activity_id | Unknown | PKFK |
summary_html | Unknown | |
summary_text | Unknown |
meeting_activity
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
connected_account_id | Unknown | FK |
contact_id | Unknown | FK |
created_by | Unknown | FK |
lead_id | Unknown | FK |
updated_by | Unknown | FK |
user_id | Unknown | FK |
calendar_event_link | Unknown | |
date_created | Unknown | |
date_updated | Unknown | |
duration | Unknown | |
ends_at | Unknown | |
is_recurring | Unknown | |
location | Unknown | |
note | Unknown | |
organization_id | Unknown | |
source | Unknown | |
starts_at | Unknown | |
status | Unknown | |
title | Unknown | |
users | Json |