Go HighLevel schema and ERD

36 tables

Loading diagram…

contact

custom_field

form_submission

fulfillment

invoice

opportunity

pipeline

subscription

transaction

contact

118

string

location_id

string

business_id

string

name

string

contact_name

string

first_name

string

last_name

string

first_name_lower_case

string

last_name_lower_case

string

contact_custom_fields

string

contact_id

string

value

string

_weld_synced

date

contact_opportunities

string

pipeline_id

string

pipeline_stage_id

string

contact_id

string

status

string

monetary_value

double

lost_reason_id

string

_weld_synced

date

contact_tags

contact_id

string

value

string

index

double

_weld_synced

date

contact_additional_phones

contact_id

string

phone

string

phone_label

string

_weld_synced

date

contact_additional_emails

contact_id

string

valid_email

boolean

valid_email_date

date

_weld_synced

date

contact_followers

contact_id

string

value

string

index

double

_weld_synced

date

conversation

string

contact_id

string

location_id

string

date_added

date

date_updated

date

last_message_date

date

last_message_type

string

last_message_body

string

last_outbound_message_action

string

last_message_direction

string

custom_field

string

name

string

field_key

string

placeholder

string

data_type

string

position

double

picklist_image_options

string

is_allowed_custom_option

boolean

is_multi_file_allowed

boolean

custom_field_picklist_options

string

custom_field_id

string

value

string

index

double

label

string

prefill_value

string

_weld_synced

date

form_submission

string

contact_id

string

form_id

string

name

string

created_at

date

external

boolean

location_id

string

pdf_url

string

_weld_synced

date

form_submission_others

form_submission_id

string

key

string

value

string

_weld_synced

date

fulfillment

string

order_id

string

alt_id

string

alt_type

string

created_at

date

updated_at

date

_weld_synced

date

fulfillment_items

string

fulfillment_id

string

order_id

string

name

string

qty

double

product_id

string

product_name

string

product_description

string

product_location_id

string

product_product_type

string

product_available_in_store

boolean

fulfillment_item_price_membership_offers

string

fulfillment_id

string

order_id

string

label

string

value

string

item_id

string

_weld_synced

date

fulfillment_item_product_variants

string

fulfillment_id

string

order_id

string

name

string

item_id

string

_weld_synced

date

fulfillment_item_product_variant_options

string

fulfillment_id

string

name

string

variant_id

string

item_id

string

_weld_synced

date

fulfillment_trackings

fulfillment_id

string

order_id

string

tracking_number

string

shipping_carrier

string

tracking_url

string

location_alt_id

string

_weld_synced

date

invoice

154

string

status

string

live_mode

boolean

amount_paid

double

alt_id

string

alt_type

string

name

string

invoice_number

string

currency

string

invoice_items

string

invoice_id

string

taxes

string

tax_inclusive

boolean

product_id

string

price_id

string

currency

string

name

string

qty

double

amount

double

invoice_reminders

invoice_id

string

reminder_id

string

reminder_name

string

enabled

boolean

email_template

string

email_subject

string

sms_template

string

reminder_time

string

interval_type

string

invoice_late_fees_configuration_meta

invoice_id

string

key

string

value

string

index

double

_weld_synced

date

message

string

contact_id

string

conversation_id

string

status

string

type

int

location_id

string

body

string

content_type

string

date_added

date

date_updated

date

user_id

string

opportunity

string

pipeline_id

string

pipeline_stage_id

string

contact_id

string

name

string

monetary_value

double

pipeline_stage_u_id

string

assigned_to

string

status

string

source

string

last_status_change_at

date

last_stage_change_at

date

opportunity_custom_fields

string

opportunity_id

string

type

string

field_value_string

string

index

double

_weld_synced

date

opportunity_relations

opportunity_id

string

relation_id

string

association_id

string

primary

boolean

object_key

string

record_id

string

full_name

string

contact_name

string

company_name

string

opportunity_notes

opportunity_id

string

value

string

index

double

_weld_synced

date

opportunity_tasks

opportunity_id

string

value

string

index

double

_weld_synced

date

opportunity_calendar_events

opportunity_id

string

value

string

index

double

_weld_synced

date

order

string

contact_id

string

alt_id

string

alt_type

string

contact_name

string

contact_email

string

currency

string

amount

double

subtotal

double

discount

double

pipeline

string

name

string

stages

string

show_in_funnel

boolean

show_in_pie_chart

boolean

location_id

string

use_opportunity_probability

boolean

color_render_mode

string

origin_id

string

date_added

date

date_updated

date

_weld_synced

date

pipeline_stage

string

pipeline_id

string

name

string

position

double

show_in_funnel

boolean

show_in_pie_chart

boolean

stage_win_probability

double

color

string

origin_id

string

_weld_synced

date

subscription

string

contact_id

string

subscription_id

string

alt_id

string

alt_type

string

contact_name

string

contact_email

string

currency

string

amount

double

status

string

live_mode

boolean

subscription_snapshot

subscription_id

string

key

string

value

string

_weld_synced

date

transaction

string

contact_id

string

subscription_id

string

alt_id

string

alt_type

string

merged_from_contact_id

string

contact_name

string

contact_email

string

currency

string

amount

double

status

string

transaction_charge_snapshot

transaction_id

string

key

string

value

string

_weld_synced

date