BigCommerce

Explore the interactive ERD

Table & Field Reference

consignment_line_item

Column	Type	Keys
`id`	String	PK
`consignment_id`	String	PKFK

consignment_discount

Column	Type	Keys
`id`	String	PK
`consignment_id`	String	PKFK

consignment_coupon_discount

Column	Type	Keys
`code`	String	PK
`consignment_id`	String	PKFK
`amount`	Double

consignment_shipping_option

Column	Type	Keys
`id`	String	PK
`consignment_id`	String	PKFK
`cost`	Double
`description`	String
`image_url`	String
`is_recommended`	Boolean
`transit_time`	String
`type`	String

consignment_billing_address_custom_field

Column	Type	Keys
`field_id`	Unknown	PK
`consignment_id`	String	PKFK
`field_value`	Unknown

consignment

Column	Type	Keys
`id`	String	PK
`checkout_id`	String	PKFK
`address_1`	String
`address_2`	String
`city`	String
`company`	String
`country`	String
`country_code`	String
`email`	String
`first_name`	String
`handling_cost`	Double
`last_name`	String
`phone`	String
`postal_code`	String
`selected_shipping_option_cost`	Double
`selected_shipping_option_description`	String
`selected_shipping_option_id`	String
`selected_shipping_option_image_url`	String
`selected_shipping_option_transit_time`	String
`selected_shipping_option_type`	String
`shipping_cost`	Double
`state_or_province`	String
`state_or_province_code`	String

checkout_billing_address_custom_field

Column	Type	Keys
`field_id`	Unknown	PK
`checkout_id`	String	PKFK
`field_value`	Unknown

tax

Column	Type	Keys
`name`	String	PK
`checkout_id`	String	PKFK
`amount`	Double

applied_coupon

Column	Type	Keys
`id`	String	PK
`checkout_id`	String	PKFK
`code`	String
`coupon_type`	Int
`discounted_amount`	Double
`display_name`	String

applied_gift_certificate

Column	Type	Keys
`code`	String	PK
`checkout_id`	String	PKFK
`balance`	Double
`purchase_date`	Instant
`remaining`	Double
`used`	Double

checkout

Column	Type	Keys
`id`	String	PK
`cart_id`	String	FK
`order_id`	String	FK
`billing_address_address_1`	String
`billing_address_address_2`	String
`billing_address_city`	String
`billing_address_company`	String
`billing_address_country`	String
`billing_address_country_code`	String
`billing_address_email`	String
`billing_address_first_name`	String
`billing_address_id`	String
`billing_address_last_name`	String
`billing_address_phone`	String
`billing_address_postal_code`	String
`billing_address_state_or_province`	String
`billing_address_state_or_province_code`	String
`billing_addressaddress_1`	String
`billing_addressaddress_2`	String
`billing_addresscity`	String
`billing_addresscompany`	String
`billing_addresscountry`	String
`billing_addresscountry_code`	String
`billing_addressemail`	String
`billing_addressfirst_name`	String
`billing_addressid`	String
`billing_addresslast_name`	String
`billing_addressphone`	String
`billing_addresspostal_code`	String
`billing_addressstate_or_province`	String
`billing_addressstate_or_province_code`	String
`created_time`	String
`customer_message`	String
`gift_wrapping_cost_total`	Double
`grand_total`	Double
`handling_cost_total`	Double
`is_store_credit_applied`	Boolean
`outstanding_balance`	Int
`shipping_cost_total`	Double
`sub_total`	Double
`tax_total`	Double
`updated_time`	String

tax_class

Column	Type	Keys
`id`	String	PK
`date_created`	Instant
`date_modified`	Instant
`name`	String

product_channel_assignment

Column	Type	Keys
`channel_id`	Long	PKFK
`product_id`	Long	PKFK

price_list_bulk_pricing

Column	Type	Keys
`index`	Long	PK
`price_list_record_fivetran_id`	Unknown	PKFK
`amount`	Long
`quantity_max`	Long
`quantity_min`	Long
`type`	String

price_list_record

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Unknown	FK
`product_id`	Long	FK
`variant_id`	Long	FK
`calculated_price`	Double
`currency`	String
`date_created`	Instant
`date_modified`	Instant
`map_price`	Double
`price`	Double
`price_list_id`	Long
`retail_price`	Double
`sale_price`	Double
`sku`	String

store_blog_tag

Column	Type	Keys
`tags`	String	PK
`post_id`	Long	PKFK

store_blog_post

Column	Type	Keys
`id`	Long	PK
`author`	String
`body`	String
`date`	LocalDateTime
`is_published`	Boolean
`meta_description`	String
`meta_keywords`	String
`preview_url`	String
`published_date_iso_8601`	Instant
`summary`	String
`thumbnail_path`	String
`timezone`	String
`timezone_type`	String
`title`	String

wishlist_item

Column	Type	Keys
`id`	Long	PK
`wishlist_id`	Long	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK

wishlist

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`is_public`	Boolean
`name`	String
`token`	String

contextual_filter

Column	Type	Keys
`category_id`	Long	PKFK
`channel_id`	Long	PKFK
`enabled_filter_id`	String	PKFK

category_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`category_tree_depth`	Int
`default_product_sort`	String
`listing_mode`	String

placement

Column	Type	Keys
`uuid`	String	PK
`channel_id`	Long	FK
`widget_id`	String	FK
`date_created`	Instant
`date_modified`	Instant
`entity_id`	String
`region`	String
`sort_order`	Long
`status`	String
`template_file`	String

customer_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`ask_shopper_for_tracking_consent`	Boolean
`default_customer_group_id`	Long
`guest_customer_group_id`	Long
`policy_url`	String

site_route

Column	Type	Keys
`id`	Long	PK
`site_id`	Long	PKFK
`matching`	String
`route`	String
`type`	String

cart_coupon

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`code`	String
`coupon_type`	Long
`discounted_amount`	Double

cart_discount

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`discounted_amount`	Double

cart_custom_item

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`extended_list_price`	Long
`list_price`	Long
`name`	String
`quantity`	Long
`sku`	String

digital_line_item_option

Column	Type	Keys
`name_id`	Long	PK
`digital_item_id`	String	PKFK
`name`	String
`value`	String
`value_id`	Long

digital_line_item_discount

Column	Type	Keys
`id`	Long	PK
`digital_item_id`	String	PKFK
`discounted_amount`	Double

cart_digital_item

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK
`brand`	String
`coupon_amount`	Long
`discount_amount`	Double
`extended_list_price`	Long
`extended_sale_price`	Long
`image_url`	String
`is_taxable`	Boolean
`list_price`	Long
`name`	String
`parent_id`	String
`quantity`	Long
`sale_price`	Long
`sku`	String
`url`	String

physical_line_item_option

Column	Type	Keys
`name_id`	Long	PK
`physical_item_id`	String	PKFK
`name`	String
`value`	String
`value_id`	Long

physical_line_item_discount

Column	Type	Keys
`id`	String	PK
`physical_item_id`	String	PKFK
`discounted_amount`	Double

cart_physical_item

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK
`brand`	String
`coupon_amount`	Long
`discount_amount`	Double
`extended_list_price`	Long
`extended_sale_price`	Long
`gift_wrapping_amount`	Double
`gift_wrapping_message`	String
`gift_wrapping_name`	String
`image_url`	String
`is_shipping_required`	Boolean
`is_taxable`	Boolean
`list_price`	Long
`name`	String
`parent_id`	Long
`quantity`	Long
`sale_price`	Long
`sku`	String
`url`	String

cart_gift_certificate_item

Column	Type	Keys
`id`	String	PK
`cart_id`	String	PKFK
`amount`	Long
`is_taxable`	Boolean
`message`	String
`name`	String
`recipient_email`	String
`recipient_name`	String
`sender_email`	String
`sender_name`	String

cart

Column	Type	Keys
`id`	String	PK
`channel_id`	Long	FK
`currency_code`	String	FK
`customer_id`	Long	FK
`base_amount`	Double
`cart_amount`	Double
`created_time`	Instant
`discount_amount`	Double
`email`	String
`locale`	String
`parent_id`	String
`tax_included`	Boolean
`updated_time`	Instant

store_profile_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`store_address`	String
`store_address_type`	String
`store_email`	String
`store_name`	String
`store_phone`	String

email_template_translation

Column	Type	Keys
`index`	Long	PK
`email_template_type_id`	String	PKFK
`keys`	Json
`locale`	String

email_template

Column	Type	Keys
`type_id`	String	PK
`body`	String
`subject`	String

category_metafield

Column	Type	Keys
`id`	Long	PK
`category_id`	Long	PKFK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`key`	String
`namespace`	String
`permission_set`	String
`resource_id`	Long
`resource_type`	String
`value`	String

search_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`content_product_sort`	String
`default_product_sort`	String
`product_filtering_enabled`	Boolean
`search_suggest`	Boolean

site_url

Column	Type	Keys
`url`	String	PK
`site_id`	Long	PKFK
`created_at`	Instant
`type`	String
`updated_at`	Instant

site

Column	Type	Keys
`id`	Long	PK
`channel_id`	Long	FK
`created_at`	Instant
`is_checkout_url_customized`	Boolean
`ssl_status`	String
`updated_at`	Instant
`url`	String

theme_variation

Column	Type	Keys
`uuid`	String	PK
`theme_id`	String	PKFK
`description`	String
`external_id`	String
`name`	String

theme

Column	Type	Keys
`uuid`	String	PK
`is_private`	Boolean
`name`	String

banner

Column	Type	Keys
`id`	Long	PK
`content`	String
`date_created`	Instant
`date_from`	String
`date_to`	String
`date_type`	String
`item_id`	String
`location`	String
`name`	String
`page`	String
`visible`	String

store

Column	Type	Keys
`id`	String	PK
`account_uuid`	String
`address`	String
`admin_email`	String
`checkout_type`	String
`control_panel_base_url`	String
`country`	String
`currency`	String
`currency_symbol`	String
`currency_symbol_location`	String
`decimal_places`	Int
`decimal_separator`	String
`default_channel_id`	Long
`default_site_id`	Long
`dimension_decimal_places`	Int
`dimension_decimal_token`	String
`dimension_thousands_token`	String
`dimension_units`	String
`domain`	String
`facebook_catalog_id`	String
`first_name`	String
`graphql_storefront_api_enabled`	Boolean
`industry`	String
`is_price_entered_with_tax`	Boolean
`languages`	String
`last_name`	String
`logo_url`	String
`multi_storefront_enabled`	Boolean
`name`	String
`order_email`	String
`phone`	String
`plan_is_trial`	Boolean
`plan_level`	String
`plan_name`	String
`secure_url`	String
`shopper_consent_tracking_enabled`	Boolean
`sitewidehttps_enabled`	Boolean
`status`	String
`stencil_enabled`	Boolean
`store_id`	Long
`thousands_separator`	String
`timezone_display`	String
`timezone_dst_correction`	Boolean
`timezone_dst_offset`	Int
`timezone_export`	String
`timezone_extended_display`	String
`timezone_name`	String
`timezone_raw_offset`	Int
`weight_units`	String
`wishlists_enabled`	Boolean

shipping_zone_location

Column	Type	Keys
`id`	Long	PK
`shipping_zone_id`	Long	PKFK
`country_iso_2`	String
`state_iso_2`	String
`zip`	String

shipping_zone

Column	Type	Keys
`id`	Long	PK
`enabled`	Boolean
`free_shipping_enabled`	Boolean
`free_shipping_exclude_fixed_shipping_products`	Boolean
`free_shipping_minimum_sub_total`	Double
`handling_fees_display_separately`	Boolean
`handling_fees_fixed_surcharge`	Double
`handling_fees_percentage_surcharge`	Double
`name`	String
`type`	String

price_list

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`date_created`	Instant
`date_modified`	Instant
`name`	String

security_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`csp_header_enabled`	String
`csp_header_value`	Boolean
`hsts_enabled`	Boolean
`hsts_include_preload`	Boolean
`hsts_include_subdomains`	Boolean
`hsts_max_age`	String
`x_frame_options_header_allowed_url`	String
`x_frame_options_header_enabled`	Boolean
`x_frame_options_header_setting`	String

enabled_filter

Column	Type	Keys
`id`	String	PK
`collapsed_by_default`	Boolean
`display_name`	String
`display_product_count`	Boolean
`is_enabled`	Boolean
`items_to_show`	Int
`sort_by`	String
`type`	String

country_state

Column	Type	Keys
`id`	Long	PK
`country_id`	Long	PKFK
`state`	String
`state_abbreviation`	String

category_tree_meta_keyword

Column	Type	Keys
`meta_keyword_id`	String	PK
`category_id`	Long	PKFK

category_tree

Column	Type	Keys
`category_id`	Long	PK
`category_uuid`	String
`default_product_sort`	String
`description`	String
`image_url`	String
`is_customized`	Boolean
`is_visible`	Boolean
`layout_file`	String
`meta_description`	String
`name`	String
`page_title`	String
`parent_id`	Long
`path`	String
`search_keywords`	String
`sort_order`	Long
`tree_id`	Long
`views`	Long

price_list_assignment

Column	Type	Keys
`id`	Long	PK
`price_list_id`	Long	PKFK
`channel_id`	Long	FK
`customer_group_id`	Long	FK

country

Column	Type	Keys
`id`	Long	PK
`country`	String
`country_iso_2`	String
`country_iso_3`	String
`state_resource`	String
`state_url`	String

locale_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`default_shopper_language`	String
`shopper_language_selection_method`	String
`store_country`	String

email_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`abandoned_cart_email`	Boolean
`account_details_changed_email`	Boolean
`combined_order_status_email`	Boolean
`create_account_email`	Boolean
`create_guest_account_email`	Boolean
`gift_certificate_email`	Boolean
`invoice_email`	Boolean
`order_message_notification_email`	Boolean
`product_review_email`	Boolean
`return_confirmation_email`	Boolean
`return_statuschange_email`	Boolean

gift_certificate

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`order_id`	Long	FK
`amount`	Double
`balance`	Double
`code`	String
`expiry_date`	Instant
`from_email`	String
`from_name`	String
`message`	String
`purchase_date`	Instant
`status`	String
`template`	String
`to_email`	String
`to_name`	String

robot_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`robots_txt_ssl`	String

brand_metafield

Column	Type	Keys
`id`	Long	PK
`brand_id`	Long	PKFK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`key`	String
`namespace`	String
`permission_set`	String
`resource_id`	Long
`resource_type`	String
`value`	String

brand_meta_keyword

Column	Type	Keys
`meta_keyword_id`	String	PK
`brand_id`	Long	PKFK

brand

Column	Type	Keys
`id`	Long	PK
`custom_url`	String
`custom_url_is_customized`	Boolean
`image_url`	String
`meta_description`	String
`name`	String
`page_title`	String
`search_keywords`	String

storefront_product_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`default_preorder_message`	String
`show_add_to_cart_link`	Boolean
`show_add_to_cart_qty_box`	Boolean
`show_add_to_wishlist`	Boolean
`show_breadcrumbs_product_pages`	String
`show_product_brand`	Boolean
`show_product_price`	Boolean
`show_product_rating`	Boolean
`show_product_shipping`	Boolean
`show_product_sku`	Boolean
`show_product_weight`	Boolean

product_custom_information

Column	Type	Keys
`product_id`	Long	PKFK
`commodity_description`	String
`country_of_origin`	String
`hs_codes`	Json
`international_shipping`	Boolean

customer_group_category_access

Column	Type	Keys
`customer_group_id`	Long	PK
`type`	String	PK
`category_id`	Long	PKFK

customer_group_discount_rule

Column	Type	Keys
`type`	String	PK
`customer_group_id`	Long	PKFK
`price_list_id`	Long	FK
`amount`	String
`method`	String

customer_group

Column	Type	Keys
`id`	Long	PK
`is_default`	Boolean
`is_group_for_guests`	Boolean
`name`	String

shipping_zone_method

Column	Type	Keys
`id`	Long	PK
`shipping_zone_id`	Long	PKFK
`enabled`	Boolean
`fixed_surcharge`	Long
`is_fallback`	Boolean
`name`	String
`settings`	Json
`type`	String

status_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`down_for_maintenance_message`	String
`prelaunch_message`	String
`prelaunch_password`	String

redirect

Column	Type	Keys
`id`	Long	PK
`site_id`	Long	FK
`from_path`	String
`to_entity_id`	Long
`to_type`	String
`to_url`	String

catalog_variant_option_value

Column	Type	Keys
`id`	Long	PK
`variant_id`	Long	PKFK
`label`	String
`option_display_name`	String
`option_id`	Long

catalog_variant

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	FK
`bin_picking_number`	String
`calculated_price`	Double
`cost_price`	Double
`depth`	Double
`fixed_cost_shipping_price`	Double
`height`	Double
`inventory_level`	Long
`inventory_warning_level`	Long
`is_free_shipping`	Boolean
`price`	Double
`purchasing_disabled`	Boolean
`purchasing_disabled_message`	String
`retail_price`	Double
`sale_price`	Double
`sku`	String
`sku_id`	Long
`upc`	String
`weight`	Double
`width`	Double

channel_enabled_currency

Column	Type	Keys
`enabled_currency`	String	PK
`channel_id`	Long	PKFK

channel_currency_assignment

Column	Type	Keys
`channel_id`	Long	PKFK
`default_currency`	String

catalog_variant_metafield

Column	Type	Keys
`id`	Long	PK
`catalog_variant_id`	Long	PKFK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`key`	String
`namespace`	String
`owner_client_id`	Unknown
`permission_set`	String
`product_id`	Long
`resource_id`	Long
`resource_type`	String
`value`	String

order_status

Column	Type	Keys
`id`	Long	PK
`custom_label`	String
`name`	String
`order_id`	Long
`system_description`	String
`system_label`	String

order_refund_item

Column	Type	Keys
`item_id`	Long	PK
`item_type`	String	PK
`order_refund_id`	Long	PKFK
`quantity`	Long
`reason`	String
`requested_amount`	Double

order_refund_payment

Column	Type	Keys
`id`	Long	PK
`order_refund_id`	Long	PKFK
`amount`	Double
`declined_message`	String
`is_declined`	Boolean
`offlines`	Boolean
`provider_id`	String

order_refund

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`created`	Instant
`reason`	String
`total_amount`	Double
`total_tax`	Long
`user_id`	Long
`uses_merchant_override_values`	Boolean

custom_template_association

Column	Type	Keys
`id`	Long	PK
`channel_id`	Long	FK
`date_created`	Instant
`date_modified`	Instant
`entity_id`	Long
`entity_type`	String
`file_name`	String
`is_valid`	Boolean

widget

Column	Type	Keys
`uuid`	String	PK
`channel_id`	String	FK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`icon_name`	String
`name`	String
`version_uuid`	String
`widget_configuration`	Json
`widget_template_id`	String

currency

Column	Type	Keys
`id`	Int	PK
`auto_update`	Boolean
`country_iso_2`	String
`currency_code`	String
`currency_exchange_rate`	Double
`decimal_places`	Int
`decimal_token`	String
`enabled`	Boolean
`is_default`	Boolean
`is_transactional`	Boolean
`last_updated`	Instant
`name`	String
`thousands_token`	String
`token`	String
`token_location`	String

seo_setting

Column	Type	Keys
`_fivetran_id`	String	PK
`meta_description`	String
`meta_keywords`	String
`page_title`	String
`www_redirect`	String

widget_template

Column	Type	Keys
`uuid`	String	PK
`current_version_uuid`	String
`date_created`	Instant
`date_modified`	Instant
`icon_name`	String
`kind`	String
`name`	String
`storefront_api_query`	String
`template`	String

coupon_entity

Column	Type	Keys
`coupon_id`	Long	PK
`entity_id`	Long	PK
`entity_type`	String

coupon_country_restriction

Column	Type	Keys
`country_id`	String	PKFK
`coupon_id`	Long	PKFK

coupon_state_restriction

Column	Type	Keys
`index`	Long	PK
`coupon_id`	Long	PKFK
`country`	String
`state`	String

coupon_zip_restriction

Column	Type	Keys
`index`	Long	PK
`coupon_id`	Long	PKFK
`country`	String
`zip`	String

coupon

Column	Type	Keys
`id`	Long	PK
`amount`	String
`code`	String
`date_created`	Instant
`enabled`	Boolean
`expires`	String
`max_uses`	Long
`max_uses_per_customer`	Long
`min_purchase`	String
`name`	String
`num_uses`	Long
`type`	String

available_filter

Column	Type	Keys
`id`	String	PK
`name`	String
`product_count`	Long
`type`	String

customer_address_form_field

Column	Type	Keys
`name`	String	PK
`customer_address_id`	String	PKFK
`value`	Json

customer_address

Column	Type	Keys
`id`	String	PK
`customer_id`	Long	PKFK
`address_1`	String
`address_2`	String
`address_type`	String
`city`	String
`company`	String
`country`	String
`country_code`	String
`first_name`	String
`last_name`	String
`phone`	String
`postal_code`	String
`state_or_province`	String

customer_form_field

Column	Type	Keys
`name`	String	PK
`customer_id`	Long	PKFK
`value`	Json

customer_store_credit

Column	Type	Keys
`index`	Long	PK
`customer_id`	Long	PKFK
`amount`	Double

customer_channel

Column	Type	Keys
`channel_id`	Long	PKFK
`customer_id`	Long	PKFK

customer_attribute_value

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`attribute_id`	Long
`attribute_value`	String
`date_created`	Instant
`date_modified`	Instant

customer

Column	Type	Keys
`id`	Long	PK
`customer_group_id`	Long	FK
`origin_channel_id`	Long	FK
`accepts_product_review_abandoned_cart_emails`	Boolean
`address_count`	Long
`attribute_count`	Long
`company`	String
`date_created`	Instant
`date_modified`	Instant
`email`	String
`first_name`	String
`force_password_reset`	Boolean
`last_name`	String
`notes`	String
`phone`	String
`registration_ip_address`	String
`tax_exempt_category`	String

channel_app

Column	Type	Keys
`id`	Long	PK
`channel_id`	Long	PKFK

channel

Column	Type	Keys
`id`	Long	PK
`date_created`	Instant
`date_modified`	Instant
`external_id`	String
`icon_url`	String
`is_enabled`	Boolean
`is_listable_from_ui`	Boolean
`is_visible`	Boolean
`name`	String
`platform`	String
`status`	String
`type`	String

subscriber

Column	Type	Keys
`id`	Long	PK
`channel_id`	Long	FK
`order_id`	Long	FK
`date_created`	Instant
`date_modified`	Instant
`email`	String
`first_name`	String
`last_name`	String
`source`	String

product_image

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`date_created`	Instant
`description`	String
`image_file`	String
`is_thumbnail`	Boolean
`sort_order`	Long
`standard_url`	String
`thumbnail_url`	String
`tiny_url`	String

product_bulk_pricing_rule

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`amount`	Long
`quantity_max`	Long
`quantity_min`	Long
`type`	String

product_custom_field

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`name`	String
`value`	String

product_modifier_value

Column	Type	Keys
`id`	Long	PK
`product_modifier_id`	Long	PKFK
`product_id`	Long	FK
`image_url`	String
`is_default`	Boolean
`label`	String
`option_id`	Long
`price_adjuster`	String
`price_adjuster_value`	Long
`purchasing_disabled_message`	String
`purchasing_disabled_status`	Boolean
`sort_order`	Long
`weight_adjuster`	String
`weight_adjuster_value`	Long

product_modifier

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`config`	Json
`display_name`	String
`name`	String
`required`	Boolean
`sort_order`	Long
`type`	String

product_variant

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`bin_picking_number`	String
`calculated_price`	Double
`calculated_weight`	Long
`cost_price`	Double
`depth`	Double
`fixed_cost_shipping_price`	Double
`height`	Double
`inventory_level`	Long
`inventory_warning_level`	Long
`is_free_shipping`	Boolean
`mpn`	String
`price`	Double
`purchasing_disabled`	Boolean
`purchasing_disabled_message`	String
`retail_price`	Double
`sale_price`	Long
`sku`	String
`sku_id`	Long
`upc`	String
`weight`	Double
`width`	Double

product_video

Column	Type	Keys
`id`	String	PK
`product_id`	Long	PKFK
`description`	String
`length`	String
`sort_order`	Long
`title`	String
`type`	String

product_meta_keyword

Column	Type	Keys
`meta_keyword_id`	String	PK
`product_id`	Long	PKFK

related_product

Column	Type	Keys
`related_product_id`	Long	PK
`product_id`	Long	PKFK

product_option

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`display_name`	String
`option_value_id`	Long
`option_value_is_default`	Boolean
`option_value_label`	String
`option_value_sort_order`	Long
`sort_order`	Long
`type`	String

product_gift_wrapping_option

Column	Type	Keys
`gift_wrapping_option_id`	Long	PK
`product_id`	Long	PKFK

product_category

Column	Type	Keys
`category_id`	Long	PKFK
`product_id`	Long	PKFK

product

Column	Type	Keys
`id`	Long	PK
`base_variant_id`	Long	FK
`brand_id`	Long	FK
`tax_class_id`	Long	FK
`availability`	String
`availability_description`	String
`bin_picking_number`	String
`brand_name`	String
`calculated_price`	Double
`condition`	String
`cost_price`	Double
`custom_url`	String
`custom_url_is_customized`	Boolean
`date_created`	Instant
`date_modified`	Instant
`depth`	Double
`description`	String
`fixed_cost_shipping_price`	Double
`gift_wrapping_options_type`	String
`gtin`	String
`height`	Double
`inventory_level`	Long
`inventory_tracking`	String
`inventory_warning_level`	Long
`is_condition_shown`	Boolean
`is_featured`	Boolean
`is_free_shipping`	Boolean
`is_preorder_hidden`	Boolean
`is_preorder_only`	Boolean
`is_price_hidden`	Boolean
`is_visible`	Boolean
`layout_file`	String
`map_price`	Double
`meta_description`	String
`mpn`	String
`name`	String
`open_graph_description`	String
`open_graph_title`	String
`open_graph_type`	String
`open_graph_use_image`	Boolean
`open_graph_use_meta_description`	Boolean
`open_graph_use_product_name`	Boolean
`option_set_display`	String
`option_set_id`	Long
`order_quantity_maximum`	Long
`order_quantity_minimum`	Long
`page_title`	String
`preorder_message`	String
`preorder_release_date`	String
`price`	Double
`price_hidden_label`	String
`product_tax_code`	String
`retail_price`	Double
`reviews_count`	Long
`reviews_rating_sum`	Double
`sale_price`	Double
`search_keywords`	String
`sku`	String
`sort_order`	Long
`total_sold`	Long
`type`	String
`upc`	String
`view_count`	Long
`warranty`	String
`weight`	Double
`width`	Double

order_billing_address_form_field

Column	Type	Keys
`name`	String	PK
`order_id`	Long	PKFK
`value`	Json

orders

Column	Type	Keys
`id`	Long	PK
`cart_id`	String	FK
`channel_id`	Long	FK
`currency_id`	Long	FK
`customer_id`	Long	FK
`payment_provider_id`	String	FK
`status_id`	Long	FK
`base_handling_cost`	Double
`base_shipping_cost`	Double
`base_wrapping_cost`	Double
`city`	String
`company`	String
`country`	String
`country_iso_2`	String
`coupon_discount`	Double
`coupon_resource`	String
`coupon_url`	String
`currency_code`	String
`currency_exchange_rate`	Double
`customer_locale`	String
`customer_message`	String
`date_created`	Instant
`date_modified`	Instant
`date_shipped`	Instant
`default_currency_code`	String
`default_currency_id`	Long
`discount_amount`	Double
`ebay_order_id`	String
`email`	String
`external_id`	String
`external_merchant_id`	String
`external_source`	String
`first_name`	String
`geoip_country`	String
`geoip_country_iso_2`	String
`gift_certificate_amount`	Double
`handling_cost_ex_tax`	Double
`handling_cost_inc_tax`	Double
`handling_cost_tax`	Double
`handling_cost_tax_class_id`	Long
`ip_address`	String
`ip_address_v_6`	String
`is_deleted`	Boolean
`is_email_opt_in`	Boolean
`items_shipped`	Long
`items_total`	Long
`last_name`	String
`order_is_digital`	Boolean
`order_source`	String
`payment_method`	String
`payment_status`	String
`phone`	String
`product_resource`	String
`product_url`	String
`refunded_amount`	Double
`shipping_address_count`	Long
`shipping_addressresource`	String
`shipping_addressurl`	String
`shipping_cost_ex_tax`	Double
`shipping_cost_inc_tax`	Double
`shipping_cost_tax`	Double
`shipping_cost_tax_class_id`	Long
`staff_notes`	String
`state`	String
`status`	String
`store_credit_amount`	Double
`store_default_currency_code`	String
`store_default_to_transactional_exchange_rate`	String
`street_1`	String
`street_2`	String
`subtotal_ex_tax`	Double
`subtotal_inc_tax`	Double
`subtotal_tax`	Double
`tax_provider_id`	String
`total_ex_tax`	Double
`total_inc_tax`	Double
`wrapping_cost_ex_tax`	Double
`wrapping_cost_inc_tax`	Double
`wrapping_cost_tax`	Double
`wrapping_cost_tax_class_id`	Long
`zip`	String

order_product_discount

Column	Type	Keys
`id`	String	PK
`order_product_id`	Long	PKFK
`amount`	String
`code`	String
`name`	String
`target`	String

order_product_option

Column	Type	Keys
`id`	Long	PK
`order_product_id`	Long	PKFK
`display_name`	String
`display_name_customer`	String
`display_name_merchant`	String
`display_style`	String
`display_value`	String
`display_value_customer`	String
`display_value_merchant`	String
`name`	String
`option_id`	Long
`product_option_id`	Long
`type`	String
`value`	String

order_product

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`product_id`	Long	PKFK
`order_address_id`	Long	FK
`variant_id`	Long	FK
`base_cost_price`	String
`base_price`	String
`base_total`	String
`base_wrapping_cost`	String
`bin_picking_number`	String
`cost_price_ex_tax`	Double
`cost_price_inc_tax`	Double
`cost_price_tax`	Double
`ebay_item_id`	String
`ebay_transaction_id`	String
`event_date`	Instant
`event_name`	String
`external_id`	String
`fixed_shipping_cost`	String
`is_bundled_product`	Boolean
`is_refunded`	Boolean
`name`	String
`name_customer`	String
`name_merchant`	String
`option_set_id`	Long
`parent_order_product_id`	Long
`price_ex_tax`	Double
`price_inc_tax`	Double
`price_tax`	Double
`quantity`	Long
`quantity_shipped`	Long
`refunded_amount`	String
`return_id`	Long
`sku`	String
`total_ex_tax`	Double
`total_inc_tax`	Double
`total_tax`	Double
`type`	String
`upc`	String
`weight`	String
`wrapping_cost_ex_tax`	Double
`wrapping_cost_inc_tax`	Double
`wrapping_cost_tax`	Double
`wrapping_message`	String
`wrapping_name`	String

order_shipment_item

Column	Type	Keys
`index`	Long	PK
`shipment_id`	Long	PKFK
`order_product_id`	Long	FK
`product_id`	Long	FK
`quantity`	Long

order_shipment

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`customer_id`	Long	FK
`order_address_id`	Long	FK
`city`	String
`comments`	String
`company`	String
`country`	String
`country_iso_2`	String
`date_created`	Instant
`email`	String
`first_name`	String
`last_name`	String
`phone`	String
`shipping_method`	String
`shipping_provider`	String
`state`	String
`street_1`	String
`street_2`	String
`tracking_carrier`	String
`tracking_link`	String
`tracking_number`	String
`zip`	String

order_shipping_address_quote

Column	Type	Keys
`id`	Long	PK
`shipping_address_id`	Long	PKFK
`carrier_code`	String
`method_id`	Long
`provider_code`	String
`rate_code`	String
`rate_id`	String
`shipping_provider_id`	String
`timestamps`	String
`uuid`	String

order_shipping_address_form_field

Column	Type	Keys
`name`	String	PK
`shipping_address_id`	Long	PKFK
`value`	Json

order_shipping_address

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`shipping_zone_id`	Long	FK
`base_cost`	Double
`base_handling_cost`	Double
`city`	String
`company`	String
`cost_ex_tax`	Double
`cost_inc_tax`	Double
`cost_tax`	Double
`cost_tax_class_id`	Long
`country`	String
`country_iso_2`	String
`email`	String
`first_name`	String
`handling_cost_ex_tax`	Double
`handling_cost_inc_tax`	Double
`handling_cost_tax`	Double
`handling_cost_tax_class_id`	Long
`items_shipped`	Long
`items_total`	Long
`last_name`	String
`phone`	String
`shipping_method`	String
`shipping_quotes_resource`	String
`shipping_quotes_url`	String
`shipping_zone_name`	String
`state`	String
`street_1`	String
`street_2`	String
`zip`	String

order_coupon

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`coupon_id`	Long	FK
`amount`	Double
`code`	String
`discount`	Double
`type`	Long

order_transaction

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`amount`	Double
`avs_result_code`	String
`avs_result_message`	String
`avs_result_postal_match`	String
`avs_result_street_match`	String
`card_expiry_month`	Int
`card_expiry_year`	Int
`card_iin`	String
`card_last_4`	String
`card_type`	String
`currency`	String
`custom_payment_method`	String
`cvv_result_code`	String
`cvv_result_message`	String
`date_created`	Instant
`display_name`	String
`event`	String
`fraud_review`	Boolean
`gateway`	String
`gateway_transaction_id`	String
`gift_certificate_code`	String
`gift_certificate_original_balance`	Double
`gift_certificate_remaining_balance`	Double
`gift_certificate_starting_balance`	Double
`gift_certificate_status`	String
`method`	String
`payment_instrument_token`	String
`payment_method_id`	String
`reference_transaction_id`	Long
`status`	String
`store_credit_remaining_balance`	Double
`test`	Boolean

payment_method_stored_instrument

Column	Type	Keys
`index`	Long	PK
`payment_method_id`	Unknown	PKFK
`brand`	String
`expiry_month`	Int
`expiry_year`	Int
`is_default`	Boolean
`issuer_identification_number`	Int
`last_4`	String
`type`	String

payment_method_supported_instrument

Column	Type	Keys
`index`	Unknown	PK
`payment_method_id`	Unknown	PKFK
`instrument_type`	Unknown
`verification_value_required`	Unknown

payment_method

Column	Type	Keys
`id`	Unknown	PK
`name`	String
`test_mode`	Boolean
`type`	String

order_metafield

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`created_at`	Instant
`description`	String
`key`	String
`namespace`	String
`permission_set`	String
`resource_id`	String
`resource_type`	String
`updated_at`	Instant
`value`	String

order_tax

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`order_address_id`	Long	FK
`order_product_id`	Long	FK
`tax_class_id`	Long	FK
`class`	String
`line_amount`	Double
`line_item_type`	String
`name`	String
`priority`	Long
`priority_amount`	Double
`rate`	Double
`tax_rate_id`	Long

order_message

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`customer_id`	Long	FK
`date_created`	Instant
`is_flagged`	Boolean
`message`	String
`staff_id`	Long
`status`	String
`subject`	String
`type`	String

customer_allow_consent

Column	Type	Keys
`customer_id`	Long	PK
`index`	Long	PK
`allow`	String
`updated_at`	Instant

customer_deny_consent

Column	Type	Keys
`customer_id`	Long	PK
`index`	Long	PK
`deny`	String
`updated_at`	Instant

product_review

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`date_created`	Instant
`date_modified`	Instant
`date_reviewed`	Instant
`email`	String
`name`	String
`rating`	Int
`status`	String
`text`	String
`title`	String

product_metafield

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`key`	String
`namespace`	String
`permission_set`	String
`resource_id`	Long
`resource_type`	String
`value`	String

product_variant_options_value

Column	Type	Keys
`id`	Long	PK
`product_variant_option_id`	Long	PKFK
`product_id`	Long	FK
`is_default`	Boolean
`label`	String
`sort_order`	Long

product_variant_option

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`config_checkbox_label`	String
`config_checked_by_default`	Boolean
`config_date_earliest_value`	String
`config_date_latest_value`	String
`config_date_limit_mode`	String
`config_date_limited`	Boolean
`config_default_value`	String
`config_file_max_size`	Int
`config_file_types_mode`	String
`config_number_highest_value`	Int
`config_number_integers_only`	Boolean
`config_number_limit_mode`	String
`config_number_limited`	Boolean
`config_number_lowest_value`	Int
`config_product_list_adjusts_inventory`	Boolean
`config_product_list_adjusts_pricing`	Boolean
`config_product_list_shipping_calc`	String
`config_text_characters_limited`	Boolean
`config_text_lines_limited`	Boolean
`config_text_max_length`	Int
`config_text_max_lines`	Int
`config_text_min_length`	Int
`display_name`	String
`name`	String
`option_id`	Long
`option_is_default`	Boolean
`option_label`	String
`option_sort_order`	Long
`sort_order`	Long
`type`	String

product_complex_rule_condition

Column	Type	Keys
`index`	Long	PK
`product_complex_rule_id`	Long	PKFK
`modifier_id`	Long	FK
`modifier_value_id`	Long	FK
`variant_id`	Long	FK
`combination_id`	Long
`id`	Long

product_complex_rule

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`enabled`	Boolean
`image_url`	String
`price_adjuster`	String
`price_adjuster_value`	Long
`purchasing_disabled`	Boolean
`purchasing_disabled_message`	String
`purchasing_hidden`	Boolean
`sort_order`	Long
`stop`	Boolean
`weight_adjuster`	String
`weight_adjuster_value`	Long

product_variant_metafield

Column	Type	Keys
`id`	Long	PK
`product_variant_id`	Long	PKFK
`product_id`	Long	FK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`key`	String
`namespace`	String
`permission_set`	String
`resource_id`	Long
`resource_type`	String
`value`	String

channel_variant

Column	Type	Keys
`channel_id`	Long	PKFK
`channel_listing_id`	Long	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`external_id`	String
`name`	String
`state`	String

channel_listing

Column	Type	Keys
`listing_id`	Long	PK
`channel_id`	Long	PKFK
`product_id`	Long	FK
`date_created`	Instant
`date_modified`	Instant
`description`	String
`external_id`	String
`name`	String
`state`	String

customer_setting_per_channel

Column	Type	Keys
`_fivetran_id`	String	PK
`channel_id`	Long	FK
`allow_global_logins`	Unknown
`ask_shopper_for_tracking_consent`	Boolean
`default_customer_group_id`	Long
`guest_customer_group_id`	Long
`policy_url`	String

channel_active_theme

Column	Type	Keys
`active_theme_uuid`	String	PK
`channel_id`	Long	PKFK
`active_theme_version_uuid`	String	FK
`active_theme_configuration_uuid`	String
`saved_theme_configuration_uuid`	String