Fivetran documentation

Search the docs

/

HighLevel

Explore the interactive ERD

Table & Field Reference

calendar_availability

Column	Type	Keys
`index`	Unknown	PK
`calendar_id`	Unknown	PKFK
`date`	Unknown
`deleted`	Unknown
`hours`	Json

calendar_location_configuration

Column	Type	Keys
`meeting_id`	Unknown	PK
`calendar_id`	Unknown	PKFK
`kind`	Unknown
`location`	Unknown

calendar_team_member_location_configuration

Column	Type	Keys
`meeting_id`	Unknown	PK
`calendar_id`	Unknown	PKFK
`calendar_team_member_id`	Unknown	PKFK
`kind`	Unknown
`location`	Unknown

calendar_team_member

Column	Type	Keys
`id`	Unknown	PK
`calendar_id`	Unknown	PKFK
`is_primary`	Unknown
`priority`	Unknown

calendar

Column	Type	Keys
`id`	Unknown	PK
`form_id`	Unknown	FK
`alert_email`	Unknown
`allow_booking_after`	Unknown
`allow_booking_after_unit`	Unknown
`allow_booking_for`	Unknown
`allow_booking_for_unit`	Unknown
`allow_cancellation`	Unknown
`allow_reschedule`	Unknown
`appointment_per_day`	Unknown
`appointment_per_slot`	Unknown
`auto_confirm`	Unknown
`availability_type`	Unknown
`calendar_cover_image`	Unknown
`calendar_type`	Unknown
`consent_label`	Unknown
`description`	Unknown
`enable_recurring`	Unknown
`event_color`	Unknown
`event_title`	Unknown
`event_type`	Unknown
`form_submit_redirect_url`	Unknown
`form_submit_thanks_message`	Unknown
`form_submit_type`	Unknown
`google_invitation_emails`	Unknown
`group_id`	Unknown
`guest_type`	Unknown
`is_active`	Unknown
`is_live_payment_mode`	Unknown
`location_id`	Unknown
`look_busy_config_default_value`	Unknown
`look_busy_config_enabled`	Unknown
`look_busy_config_percentage`	Unknown
`name`	Unknown
`notes`	Unknown
`open_hour`	Json
`pixel_id`	Unknown
`pre_buffer`	Unknown
`pre_buffer_unit`	Unknown
`recurring_booking_option`	Unknown
`recurring_booking_overlap_default_status`	Unknown
`recurring_count`	Unknown
`recurring_freq`	Unknown
`should_assign_contact_to_team_member`	Unknown
`should_send_alert_emails_to_assigned_member`	Unknown
`should_skip_assigning_contact_for_existing`	Unknown
`slot_buffer_unit`	Unknown
`slot_duration`	Unknown
`slot_duration_unit`	Unknown
`slot_interval`	Unknown
`slug`	Unknown
`sticky_contact`	Unknown
`widget_slug`	Unknown
`widget_type`	Unknown

note

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`body`	Unknown
`date_added`	Instant
`user_id`	Unknown

calendar_event_user

Column	Type	Keys
`id`	Unknown	PK
`calendar_event_id`	Unknown	PKFK

calendar_event

Column	Type	Keys
`id`	Unknown	PK
`calendar_id`	Unknown	FK
`contact_id`	Unknown	FK
`address`	Unknown
`appointment_status`	Unknown
`assigned_resources`	Json
`assigned_user_id`	Unknown
`created_by_source`	Unknown
`created_by_user_id`	Unknown
`date_added`	Instant
`date_updated`	Instant
`description`	Unknown
`end_time`	Instant
`group_id`	Unknown
`is_recurring`	Unknown
`location_id`	Unknown
`master_event_id`	Unknown
`note`	Unknown
`rrule`	Unknown
`start_time`	Instant
`title`	Unknown

funnel

Column	Type	Keys
`id`	Unknown	PK
`date_added`	Instant
`date_updated`	Instant
`deleted`	Unknown
`domain_id`	Unknown
`fav_icon_url`	Unknown
`global_sections_path`	Unknown
`global_sections_url`	Unknown
`is_store_active`	Unknown
`location_id`	Unknown
`name`	Unknown
`order_form_version`	Unknown
`origin_id`	Unknown
`steps`	Json
`tracking_code_body`	Unknown
`tracking_code_head`	Unknown
`type`	Unknown
`updated_at`	Instant
`url`	Unknown

opportunity_task

Column	Type	Keys
`id`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`body`	Unknown
`business_id`	Unknown
`completed`	Unknown
`created_at`	Instant
`created_by_channel`	Unknown
`created_by_source`	Unknown
`created_by_source_id`	Unknown
`date_added`	Instant
`date_updated`	Instant
`description`	Unknown
`due_date`	Instant
`last_updated_by_channel`	Unknown
`last_updated_by_source`	Unknown
`last_updated_by_source_id`	Unknown
`location_id`	Unknown
`recurring_task_id`	Unknown
`relations`	Json
`title`	Unknown
`updated_at`	Instant

opportunity_note

Column	Type	Keys
`id`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`body`	Unknown
`body_text`	Unknown
`company_id`	Unknown
`created_by_channel`	Unknown
`created_by_source`	Unknown
`created_by_time_stamp`	Unknown
`created_by_user_id`	Unknown
`date_added`	Instant
`date_updated`	Instant
`deleted`	Unknown
`last_updated_by_channel`	Unknown
`last_updated_by_source`	Unknown
`last_updated_by_time_stamp`	Unknown
`last_updated_by_user_id`	Unknown
`location_id`	Unknown
`relations`	Json
`updated_at`	Unknown
`user_id`	Unknown

opportunity_relation

Column	Type	Keys
`index`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`association_id`	Unknown
`attributed`	Unknown
`company_name`	Unknown
`contact_name`	Unknown
`email`	Unknown
`full_name`	Unknown
`is_primary`	Unknown
`object_key`	Unknown
`phone`	Unknown
`record_id`	Unknown
`relation_id`	Unknown
`tags`	Json

opportunity_custom_field

Column	Type	Keys
`id`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`field_value`	Json

opportunity

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`pipeline_id`	Unknown	FK
`assigned_to`	Unknown
`attributions`	Json
`calendar`	Json
`contact_name`	Unknown
`contact_score`	Json
`created_at`	Instant
`followers`	Json
`index_version`	Unknown
`last_action_date`	Instant
`last_stage_change_at`	Instant
`last_status_change_at`	Instant
`location_id`	Unknown
`lost_reason_id`	Unknown
`monetary_value`	Unknown
`name`	Unknown
`pipeline_stage_id`	Unknown
`pipeline_stage_uid`	Unknown
`source`	Unknown
`status`	Unknown
`updated_at`	Instant

pipeline_stage

Column	Type	Keys
`id`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`name`	Unknown
`position`	Unknown
`show_in_funnel`	Unknown
`show_in_pie_chart`	Unknown

pipeline

Column	Type	Keys
`id`	Unknown	PK
`date_added`	Instant
`date_updated`	Instant
`location_id`	Unknown
`name`	Unknown
`show_in_funnel`	Unknown
`show_in_pie_chart`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`assigned_to`	Unknown
`body`	Unknown
`completed`	Unknown
`due_date`	Instant
`title`	Unknown

form

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown
`name`	Unknown

contact_custom_field

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`value`	Json

contact

Column	Type	Keys
`id`	Unknown	PK
`additional_email`	Json
`additional_phones`	Json
`address`	Unknown
`assigned_to`	Unknown
`business_id`	Unknown
`business_name`	Unknown
`city`	Unknown
`company_name`	Unknown
`country`	Unknown
`date_added`	Instant
`date_of_birth`	LocalDate
`date_updated`	Instant
`dnd`	Unknown
`dnd_setting`	Json
`email`	Unknown
`first_name`	Unknown
`followers`	Json
`last_name`	Unknown
`location_id`	Unknown
`phone`	Unknown
`phone_label`	Unknown
`postal_code`	Unknown
`source`	Unknown
`state`	Unknown
`tags`	Json
`type`	Unknown
`valid_email`	Unknown
`website`	Unknown

submission

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`form_id`	Unknown	FK
`created_at`	Instant
`email`	Unknown
`location_id`	Unknown
`name`	Unknown
`others`	Json

conversation

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	FK
`attributed`	Unknown
`company_name`	Unknown
`contact_name`	Unknown
`date_added`	Instant
`date_updated`	Instant
`email`	Unknown
`followers`	Json
`full_name`	Unknown
`is_last_message_internal_comment`	Unknown
`last_message_body`	Unknown
`last_message_date`	Instant
`last_message_type`	Unknown
`location_id`	Unknown
`phone`	Unknown
`profile_photo`	Unknown
`scoring`	Json
`tags`	Json
`type`	Unknown
`unread_count`	Unknown