ERD for Shopify

58 tables

Loading diagram…

abandoned_checkout

long

customer_id

long

name

string

buyer_accepts_marketing

boolean

currency

string

completed_at

date

discount_codes

string

billing_address_id

string

billing_address_phone

string

billing_address_country

string

billing_address_first_name

string

billing_address_name

string

billing_address_latitude

double

billing_address_zip

string

billing_address_last_name

string

billing_address_province

string

billing_address_address2

string

billing_address_address1

string

billing_address_country_code

string

billing_address_city

string

billing_address_company

string

billing_address_province_code

string

billing_address_longitude

double

billing_address_default

boolean

string

customer_locale

string

customer_email

string

customer_first_name

string

customer_last_name

string

created_at

date

updated_at

date

referring_site

string

source_identifier

string

total_weight

long

total_line_items_price

double

total_line_items_price_set_shop_money_amount

double

total_line_items_price_set_shop_money_currency_code

string

total_line_items_price_set_presentment_money_amount

double

total_line_items_price_set_presentment_money_currency_code

string

closed_at

date

device_id

string

phone

string

source_name

string

total_tax

double

total_tax_set_shop_money_amount

double

total_tax_set_shop_money_currency_code

string

total_tax_set_presentment_money_amount

double

total_tax_set_presentment_money_currency_code

string

subtotal_price

double

subtotal_price_set_shop_money_amount

double

subtotal_price_set_shop_money_currency_code

string

subtotal_price_set_presentment_money_amount

double

subtotal_price_set_presentment_money_currency_code

string

source_url

string

total_discounts

double

total_discount_set_shop_money_amount

double

total_discount_set_shop_money_currency_code

string

total_discount_set_presentment_money_amount

double

total_discount_set_presentment_money_currency_code

string

note

string

presentment_currency

string

user_id

long

source

string

shipping_address_id

string

shipping_address_phone

string

shipping_address_country

string

shipping_address_first_name

string

shipping_address_name

string

shipping_address_latitude

double

shipping_address_zip

string

shipping_address_last_name

string

shipping_address_province

string

shipping_address_address2

string

shipping_address_address1

string

shipping_address_country_code

string

shipping_address_city

string

shipping_address_company

string

shipping_address_province_code

string

shipping_address_default

boolean

shipping_address_longitude

double

abandoned_checkout_url

string

landing_site

string

customer_accepts_marketing

boolean

customer_email_marketing_consent_updated_at

date

customer_email_marketing_consent_marketing_opt_in_level

string

customer_email_marketing_consent_marketing_state

string

total_price

double

total_price_set_shop_money_amount

double

total_price_set_shop_money_currency_code

string

total_price_set_presentment_money_amount

double

total_price_set_presentment_money_currency_code

string

total_duties

double

total_duties_set_shop_money_amount

double

total_duties_set_shop_money_currency_code

string

total_duties_set_presentment_money_amount

double

total_duties_set_presentment_money_currency_code

string

cart_token

string

taxes_included

boolean

_weld_synced

date

abandoned_checkout_line

string

product_id

long

checkout_id

long

gift_card

boolean

presentment_title

string

product_title

string

product_type

string

product_is_gift_card

boolean

quantity

int

sku

string

title

string

variant_id

long

variant_title

string

line_price

double

price

double

original_total_price_set_shop_money_amount

double

original_total_price_set_shop_money_currency_code

string

original_total_price_set_presentment_money_amount

double

original_total_price_set_presentment_money_currency_code

string

original_unit_price_set_shop_money_amount

double

original_unit_price_set_shop_money_currency_code

string

original_unit_price_set_presentment_money_amount

double

original_unit_price_set_presentment_money_currency_code

string

discounted_total_price_set_shop_money_amount

double

discounted_total_price_set_shop_money_currency_code

string

discounted_total_price_set_presentment_money_amount

double

discounted_total_price_set_presentment_money_currency_code

string

compare_at_price

double

compare_at_price_range_max_variant_compare_at_price_amount

double

compare_at_price_range_max_variant_compare_at_price_currency_code

string

compare_at_price_range_min_variant_compare_at_price_amount

double

compare_at_price_range_min_variant_compare_at_price_currency_code

string

_weld_synced

date

collection

long

handle

string

sort_order

string

body_html

string

title

string

updated_at

date

template_suffix

string

disjunctive

boolean

type

string

_weld_synced

date

collection_product

collection_id

long

product_id

long

_weld_synced

date

company

string

contact_count

int

created_at

date

customer_since

date

default_role_id

string

default_role_name

string

default_role_note

string

external_id

string

has_timeline_comment

boolean

lifetime_duration

string

main_contact_customer_email

string

main_contact_customer_id

string

main_contact_id

string

main_contact_title

string

name

string

note

string

updated_at

date

main_contact_customer_display_name

string

main_contact_customer_first_name

string

main_contact_customer_last_name

string

main_contact_lifetime_duration

string

_weld_synced

date

company_contact

string

company_id

string

customer_id

string

customer_first_name

string

customer_last_name

string

customer_display_name

string

is_main_contact

boolean

lifetime_duration

string

title

string

updated_at

date

created_at

date

_weld_synced

date

country

long

code

string

name

string

tax

double

_weld_synced

date

country_provinces

long

country_id

long

index

int

tax

double

code

string

name

string

tax_name

string

tax_type

string

tax_percentage

double

customer

long

currency

string

multipass_identifier

string

order_count

long

state

string

verified_email

boolean

total_spent

double

first_name

string

updated_at

date

note

string

phone

string

last_name

string

tax_exempt

boolean

accepts_marketing

boolean

marketing_opt_in_level

string

accepts_marketing_updated_at

date

email_marketing_consent_state

string

email_marketing_consent_opt_in_level

string

email_marketing_consent_updated_at

date

sms_marketing_consent_state

string

sms_marketing_consent_opt_in_level

string

sms_marketing_consent_updated_at

date

sms_marketing_consent_collected_from

string

created_at

date

_weld_synced

date

customer_tag

customer_id

long

index

int

value

string

_weld_synced

date

customer_address

long

customer_id

long

first_name

string

last_name

string

company

string

address1

string

address2

string

city

string

province

string

country

string

zip

string

phone

string

name

string

province_code

string

country_code

string

is_default

boolean

_weld_synced

date

draft_order

long

order_id

long

customer_id

long

subtotal_price

double

name

string

shipping_address_phone

string

shipping_address_country

string

shipping_address_name

string

shipping_address_address1

string

shipping_address_longitude

double

shipping_address_address2

string

shipping_address_last_name

string

shipping_address_first_name

string

shipping_address_province

string

shipping_address_city

string

shipping_address_company

string

shipping_address_latitude

double

shipping_address_country_code

string

shipping_address_province_code

string

shipping_address_zip

string

billing_address_phone

string

billing_address_country

string

billing_address_name

string

billing_address_address1

string

billing_address_longitude

double

billing_address_address2

string

billing_address_last_name

string

billing_address_first_name

string

billing_address_province

string

billing_address_city

string

billing_address_company

string

billing_address_latitude

double

billing_address_country_code

string

billing_address_province_code

string

billing_address_zip

string

note

string

currency

string

invoice_sent_at

date

invoice_url

string

shipping_line_tax_lines

string

shipping_line_phone

string

shipping_line_handle

string

shipping_line_price

double

shipping_line_title

string

shipping_line_discount_allocations

string

shipping_line_delivery_category

string

shipping_line_discounted_price

double

shipping_line_code

string

shipping_line_requested_fulfillment_service_id

string

shipping_line_carrier_identifier

string

shipping_line_carrier

long

shipping_line_source

string

tax_exempt

boolean

tax_lines

string

applied_discount_title

string

applied_discount_value

string

applied_discount_amount

double

applied_discount_value_type

string

applied_discount_description

string

taxes_included

boolean

total_price

double

completed_at

date

created_at

date

updated_at

date

status

string

_weld_synced

date

draft_order_line

long

draft_order_id

long

product_id

long

variant_id

long

title

string

variant_title

string

sku

string

vendor

string

quantity

int

requires_shipping

boolean

taxable

boolean

gift_card

boolean

fulfillment_service

string

grams

int

tax_lines

string

name

string

custom

boolean

price

double

applied_discount_amount

double

applied_discount_value

double

applied_discount_description

string

applied_discount_title

string

applied_discount_value_type

string

_weld_synced

date

draft_order_line_tax_line

draft_order_id

long

draft_order_line_id

long

rate

double

title

string

price

double

index

int

_weld_synced

date

draft_order_tag

draft_order_id

long

index

int

value

string

_weld_synced

date

inventory_item

long

cost

double

country_code_of_origin

string

created_at

date

province_code_of_origin

string

sku

string

tracked

boolean

updated_at

date

requires_shipping

boolean

_weld_synced

date

inventory_level

inventory_item_id

long

location_id

long

available

double

updated_at

date

_weld_synced

date

order

long

customer_id

long

location_id

long

name

string

shipping_address_phone

string

shipping_address_country

string

shipping_address_name

string

shipping_address_address1

string

shipping_address_longitude

double

shipping_address_address2

string

shipping_address_last_name

string

shipping_address_first_name

string

shipping_address_province

string

shipping_address_city

string

shipping_address_company

string

shipping_address_latitude

double

shipping_address_country_code

string

shipping_address_province_code

string

shipping_address_zip

string

billing_address_phone

string

billing_address_country

string

billing_address_name

string

billing_address_address1

string

billing_address_longitude

double

billing_address_address2

string

billing_address_last_name

string

billing_address_first_name

string

billing_address_province

string

billing_address_city

string

billing_address_company

string

billing_address_latitude

double

billing_address_country_code

string

billing_address_province_code

string

billing_address_zip

string

note

string

currency

string

taxes_included

boolean

total_price

double

created_at

date

updated_at

date

source_name

string

source_url

string

source_identifier

string

referring_site

string

reference

string

landing_site

string

landing_site_ref

string

browser_ip

string

cancel_reason

string

cancelled_at

date

cart_token

string

checkout_token

string

token

string

client_details_browser_ip

string

client_details_user_agent

string

client_details_session_hash

string

client_details_browser_width

double

client_details_browser_height

double

client_details_accept_language

string

closed_at

date

app_id

long

buyer_accepts_marketing

boolean

confirmed

boolean

customer_locale

string

device_id

string

financial_status

string

fulfillment_status

string

number

int

order_number

int

presentment_currency

string

processing_method

string

order_status_url

string

test

boolean

processed_at

date

subtotal_price

double

total_discounts

double

total_line_items_price

double

total_price_usd

double

usd_conversion_rate

double

total_tax

double

total_tip_received

double

total_weight

double

current_total_discounts

double

current_subtotal_price

double

current_total_price

double

current_total_tax

double

total_tax_set_shop_money_amount

double

total_tax_set_shop_money_currency_code

string

total_tax_set_presentment_money_amount

double

total_tax_set_presentment_money_currency_code

string

total_shipping_price_set_shop_money_amount

double

total_shipping_price_set_shop_money_currency_code

string

total_shipping_price_set_presentment_money_amount

double

total_shipping_price_set_presentment_money_currency_code

string

total_price_set_shop_money_amount

double

total_price_set_shop_money_currency_code

string

total_price_set_presentment_money_amount

double

total_price_set_presentment_money_currency_code

string

total_line_items_price_set_shop_money_amount

double

total_line_items_price_set_shop_money_currency_code

string

total_line_items_price_set_presentment_money_amount

double

total_line_items_price_set_presentment_money_currency_code

string

total_discounts_set_shop_money_amount

double

total_discounts_set_shop_money_currency_code

string

total_discounts_set_presentment_money_amount

double

total_discounts_set_presentment_money_currency_code

string

subtotal_price_set_shop_money_amount

double

subtotal_price_set_shop_money_currency_code

string

subtotal_price_set_presentment_money_amount

double

subtotal_price_set_presentment_money_currency_code

string

current_total_duties_set_shop_money_amount

double

current_total_duties_set_shop_money_currency_code

string

current_total_duties_set_presentment_money_amount

double

current_total_duties_set_presentment_money_currency_code

string

original_total_duties_set_shop_money_amount

double

original_total_duties_set_shop_money_currency_code

string

original_total_duties_set_presentment_money_amount

double

original_total_duties_set_presentment_money_currency_code

string

current_subtotal_price_set_shop_money_amount

double

current_subtotal_price_set_shop_money_currency_code

string

current_subtotal_price_set_presentment_money_amount

double

current_subtotal_price_set_presentment_money_currency_code

string

current_total_discounts_set_shop_money_amount

double

current_total_discounts_set_shop_money_currency_code

string

current_total_discounts_set_presentment_money_amount

double

current_total_discounts_set_presentment_money_currency_code

string

current_total_price_set_shop_money_amount

double

current_total_price_set_shop_money_currency_code

string

current_total_price_set_presentment_money_amount

double

current_total_price_set_presentment_money_currency_code

string

current_total_tax_shop_money_amount

double

current_total_tax_shop_money_currency_code

string

current_total_tax_presentment_money_amount

double

current_total_tax_presentment_money_currency_code

string

_weld_synced

date

order_tag

order_id

long

index

int

value

string

_weld_synced

date

order_discount_applications

order_id

long

type

string

title

string

value

string

value_type

string

description

string

target_type

string

target_selection

string

allocation_method

string

index

int

code

string

_weld_synced

date

order_shipping_lines

long

order_id

long

index

int

code

string

price

double

title

string

source

string

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

price_set_presentment_money_currency_code

string

discounted_price

double

carrier_identifier

string

discounted_price_set_shop_money_amount

double

discounted_price_set_shop_money_currency_code

string

discounted_price_set_presentment_money_amount

double

discounted_price_set_presentment_money_currency_code

string

requested_fulfillment_service_id

string

phone

string

delivery_category

string

_weld_synced

date

order_shipping_lines_tax_lines

order_id

long

rate

double

price

double

title

string

index

int

order_shipping_line_id

long

_weld_synced

date

order_url_tags

order_id

long

key

string

value

string

index

int

_weld_synced

date

order_line_items

long

order_id

long

product_id

long

index

int

sku

string

name

string

grams

int

price

double

title

string

vendor

string

taxable

boolean

quantity

int

gift_card

boolean

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

price_set_presentment_money_currency_code

string

variant_id

long

variant_title

string

total_discount

double

requires_shipping

boolean

fulfillment_status

string

total_discount_set_shop_money_amount

double

total_discount_set_shop_money_currency_code

string

total_discount_set_presentment_money_amount

double

total_discount_set_presentment_money_currency_code

string

fulfillment_service

string

fulfillable_quantity

int

product_exists

boolean

variant_inventory_management

string

_weld_synced

date

line_items_tax_lines

order_id

long

line_item_id

long

index

int

rate

double

price

double

title

string

price_set_shop_money_amount

double

price_set_shop_money_currency_code

string

price_set_presentment_money_amount

double

price_set_presentment_money_currency_code

string

_weld_synced

date

line_items_properties

order_id

long

line_item_id

long

name

string

value

string

index

int

_weld_synced

date

line_items_discount_allocations

order_id

long

order_line_id

long

index

int

amount

double

amount_set_shop_money_amount

double

amount_set_shop_money_currency_code

string

amount_set_presentment_money_amount

double

amount_set_presentment_money_currency_code

string

discount_application_index

int

_weld_synced

date

order_agreement

string

order_id

string

app_id

string

app_handle

string

happened_at

date

reason

string

_weld_synced

date

order_agreement_sale

string

order_agreement_id

string

order_id

string

line_type

string

action_type

string

quantity

int

taxes

string

total_amount_presentment_money_amount

string

total_amount_presentment_money_currency_code

string

total_amount_shop_money_amount

string

total_amount_shop_money_currency_code

string

total_discount_amount_after_taxes_shop_money_amount

string

total_discount_amount_after_taxes_shop_money_currency_code

string

total_discount_amount_after_taxes_presentment_money_amount

string

total_discount_amount_after_taxes_presentment_money_currency_code

string

total_discount_amount_before_taxes_presentment_money_amount

string

total_discount_amount_before_taxes_presentment_money_currency_code

string

total_discount_amount_before_taxes_shop_money_amount

string

total_discount_amount_before_taxes_shop_money_currency_code

string

total_tax_amount_presentment_money_amount

string

total_tax_amount_presentment_money_currency_code

string

total_tax_amount_shop_money_amount

string

total_tax_amount_shop_money_currency_code

string

_weld_synced

date

order_returns

string

order_id

string

status

string

name

string

total_quantity

double

decline

string

object_type

string

_weld_synced

date

order_return_line_items

string

quantity

double

customer_note

string

refundable_quantity

double

refunded_quantity

double

return_reason

string

return_reason_note

string

object_type

string

return_id

string

fulfillment_line_item_id

string

index

double

_weld_synced

date

order_risk

order_id

long

recommendation

string

_weld_synced

date

order_risk_assessment

order_id

long

risk_level

string

provider_name

string

_weld_synced

date

order_risk_assessment_fact

order_id

long

assessment_provider_name

string

description

string

sentiment

string

index

int

_weld_synced

date

price_rule

long

allocation_method

string

created_at

date

updated_at

date

customer_selection

string

ends_at

date

once_per_customer

boolean

prerequisite_quantity_range

long

prerequisite_shipping_price_range

double

prerequisite_subtotal_range

double

prerequisite_to_entitlement_purchase_prerequisite_amount

double

starts_at

date

target_selection

string

target_type

string

title

string

usage_limit

long

value

string

value_type

string

quantity_ratio_prerequisite_quantity

long

quantity_ratio_entitled_quantity

long

allocation_limit

long

_weld_synced

date

entitled_collection

price_rule_id

long

collection_id

long

_weld_synced

date

product

long

published_at

date

created_at

date

published_scope

string

status

string

vendor

string

updated_at

date

body_html

string

product_type

string

handle

string

template_suffix

string

title

string

_weld_synced

date

product_options

long

product_id

long

name

string

position

int

_weld_synced

date

product_option_values

product_id

long

index

int

product_option_id

long

value

string

_weld_synced

date