# HighLevel schema ERD

Table and field reference for the Fivetran HighLevel connector.

## Table & Field Reference

### calendar_availability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calendar_id | Unknown | PK, FK |
| date | Unknown |  |
| deleted | Unknown |  |
| hours | Json |  |

### calendar_location_configuration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calendar_id | Unknown | PK, FK |
| kind | Unknown |  |
| location | Unknown |  |
| meeting_id | Unknown |  |

### calendar_team_member_location_configuration

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| calendar_id | Unknown | PK, FK |
| calendar_team_member_id | Unknown | PK, FK |
| kind | Unknown |  |
| location | Unknown |  |
| meeting_id | Unknown |  |

### calendar_team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calendar_id | Unknown | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | FK |
| body | Unknown |  |
| date_added | Instant |  |

### calendar_event_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calendar_event_id | Unknown | PK, FK |

### calendar_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calendar_id | Unknown | FK |
| contact_id | Unknown | FK |
| created_by_user_id | Unknown | FK |
| address | Unknown |  |
| appointment_status | Unknown |  |
| assigned_resources | Json |  |
| assigned_user_id | Unknown |  |
| created_by_source | 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 | PK, FK |
| 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 | PK, FK |
| created_by_user_id | Unknown | FK |
| last_updated_by_user_id | Unknown | FK |
| user_id | Unknown | FK |
| body | Unknown |  |
| body_text | Unknown |  |
| company_id | Unknown |  |
| created_by_channel | Unknown |  |
| created_by_source | Unknown |  |
| created_by_time_stamp | 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 |  |
| location_id | Unknown |  |
| relations | Json |  |
| updated_at | Unknown |  |

### opportunity_relation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deleted | Unknown |  |
| email | Unknown |  |
| extension | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| lc_phone_location_id | Unknown |  |
| name | Unknown |  |
| permissions_adwords_reporting_enabled | Unknown |  |
| permissions_affiliate_manager_enabled | Unknown |  |
| permissions_agent_reporting_enabled | Unknown |  |
| permissions_appointments_enabled | Unknown |  |
| permissions_assigned_data_only | Unknown |  |
| permissions_attributions_reporting_enabled | Unknown |  |
| permissions_blogging_enabled | Unknown |  |
| permissions_bot_service | Unknown |  |
| permissions_bulk_requests_enabled | Unknown |  |
| permissions_campaigns_enabled | Unknown |  |
| permissions_campaigns_read_only | Unknown |  |
| permissions_cancel_subscription_enabled | Unknown |  |
| permissions_communities_enabled | Unknown |  |
| permissions_contacts_enabled | Unknown |  |
| permissions_content_ai_enabled | Unknown |  |
| permissions_conversations_enabled | Unknown |  |
| permissions_dashboard_stats_enabled | Unknown |  |
| permissions_export_payments_enabled | Unknown |  |
| permissions_facebook_ads_reporting_enabled | Unknown |  |
| permissions_funnels_enabled | Unknown |  |
| permissions_invoice_enabled | Unknown |  |
| permissions_lead_value_enabled | Unknown |  |
| permissions_marketing_enabled | Unknown |  |
| permissions_membership_enabled | Unknown |  |
| permissions_online_listings_enabled | Unknown |  |
| permissions_opportunities_enabled | Unknown |  |
| permissions_payments_enabled | Unknown |  |
| permissions_phone_call_enabled | Unknown |  |
| permissions_record_payment_enabled | Unknown |  |
| permissions_refunds_enabled | Unknown |  |
| permissions_reviews_enabled | Unknown |  |
| permissions_settings_enabled | Unknown |  |
| permissions_social_planner | Unknown |  |
| permissions_tags_enabled | Unknown |  |
| permissions_triggers_enabled | Unknown |  |
| permissions_websites_enabled | Unknown |  |
| permissions_workflows_enabled | Unknown |  |
| permissions_workflows_read_only | Unknown |  |
| phone | Unknown |  |
| roles_location_ids | Json |  |
| roles_restrict_sub_account | Unknown |  |
| roles_role | Unknown |  |
| roles_type | Unknown |  |
| scope | Unknown |  |

### pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | Instant |  |
| 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 |  |

## Relationships

- calendar_availability(calendar_id) → calendar(id)
- calendar_location_configuration(calendar_id) → calendar(id)
- calendar_team_member_location_configuration(calendar_id) → calendar_team_member(calendar_id)
- calendar_team_member_location_configuration(calendar_team_member_id) → calendar_team_member(id)
- calendar_team_member(calendar_id) → calendar(id)
- calendar(form_id) → form(id)
- note(user_id) → users(id)
- note(contact_id) → contact(id)
- calendar_event_user(calendar_event_id) → calendar_event(id)
- calendar_event(created_by_user_id) → users(id)
- calendar_event(calendar_id) → calendar(id)
- calendar_event(contact_id) → contact(id)
- opportunity_task(opportunity_id) → opportunity(id)
- opportunity_note(user_id) → users(id)
- opportunity_note(created_by_user_id) → users(id)
- opportunity_note(last_updated_by_user_id) → users(id)
- opportunity_note(opportunity_id) → opportunity(id)
- opportunity_relation(opportunity_id) → opportunity(id)
- opportunity_custom_field(opportunity_id) → opportunity(id)
- opportunity(pipeline_id) → pipeline(id)
- opportunity(contact_id) → contact(id)
- pipeline_stage(pipeline_id) → pipeline(id)
- task(contact_id) → contact(id)
- contact_custom_field(contact_id) → contact(id)
- submission(contact_id) → contact(id)
- submission(form_id) → form(id)
- conversation(contact_id) → contact(id)