BigCommerce schema

22 tables · 8 joins

About the connector Start free

22 tables

Loading diagram…

customer

order

product

refund

brand

10

id

long

name

string

page_title

string

meta_keywords

string

meta_description

string

image_url

string

search_keywords

string

custom_url_url

string

custom_url_is_customized

boolean

_weld_synced

date

category

17

id

long

parent_id

long

name

string

description

string

views

int

sort_order

int

page_title

string

meta_keywords

string

meta_description

string

channel

13

id

long

icon_url

string

is_listable_from_ui

boolean

is_visible

boolean

date_created

date

external_id

string

type

string

platform

string

is_enabled

boolean

date_modified

date

name

string

status

string

_weld_synced

date

currency

18

id

long

is_default

boolean

last_updated

date

country_iso2

string

default_for_country_codes

string

currency_code

string

currency_exchange_rate

double

name

string

token

string

customer

17

id

long

authentication_force_password_reset

boolean

company

string

customer_group_id

long

email

string

first_name

string

last_name

string

notes

string

phone

string

customer_address

15

id

long

customer_id

long

address1

string

address2

string

address_type

string

city

string

company

string

country

string

country_code

string

first_name

string

customer_form_field

4

customer_id

long

name

string

value

string

_weld_synced

date

order

81

id

long

customer_id

long

currency_id

long

channel_id

long

date_created

date

date_modified

date

date_shipped

date

status_id

long

status

string

subtotal_ex_tax

double

subtotal_inc_tax

double

subtotal_tax

double

order_line_item

56

id

long

order_id

long

product_id

long

variant_id

long

order_address_id

long

name

string

name_customer

string

name_merchant

string

sku

string

upc

string

type

string

order_line_item_discount

8

id

string

order_id

long

order_line_item_id

long

name

string

code

string

target

string

amount

double

_weld_synced

date

order_shipping_address

31

id

long

order_id

long

first_name

string

last_name

string

company

string

street_1

string

street_2

string

city

string

zip

string

country

string

order_coupon

8

id

long

order_id

long

coupon_id

long

code

string

amount

double

type

string

discount

double

_weld_synced

date

order_tax

13

id

long

order_id

long

order_address_id

long

tax_rate_id

long

sales_tax_id

string

tax_class_id

long

name

string

class

string

rate

double

priority

int

priority_amount

double

line_amount

double

_weld_synced

date

product

67

id

long

brand_id

long

name

string

type

string

sku

string

description

string

weight

double

width

double

depth

double

height

double

product_category

3

product_id

long

category_id

long

_weld_synced

date

product_variant

28

product_id

long

variant_id

long

sku

string

sku_id

long

price

double

calculated_price

double

sale_price

double

retail_price

double

map_price

double

product_custom_field

5

id

string

product_id

long

name

string

value

string

_weld_synced

date

product_related_product

3

product_id

long

related_product_id

long

_weld_synced

date

product_bulk_pricing_rule

7

product_id

long

rule_id

long

amount

double

quantity_max

int

quantity_min

int

type

string

_weld_synced

date

refund

9

id

long

order_id

long

user_id

long

created

date

reason

string

total_amount

double

total_tax

double

uses_merchant_override_values

boolean

_weld_synced

date

refund_line_item

7

refund_id

long

product_id

long

item_type

string

quantity

int

requested_amount

double

reason

string

_weld_synced

date

refund_payment

8

id

long

refund_id

long

provider_id

string

amount

double

offline

boolean

is_declined

boolean

declined_message

string

_weld_synced

date