# BigCommerce schema ERD

Table and field reference for the Fivetran BigCommerce connector.

## Table & Field Reference

### consignment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| consignment_id | String | PK, FK |

### consignment_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| consignment_id | String | PK, FK |

### consignment_coupon_discount

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| consignment_id | String | PK, FK |
| amount | Double |  |

### consignment_shipping_option

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| consignment_id | String | PK, FK |
| 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 | PK, FK |
| field_value | Unknown |  |

### consignment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| checkout_id | String | PK, FK |
| 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 | PK, FK |
| field_value | Unknown |  |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| checkout_id | String | PK, FK |
| amount | Double |  |

### applied_coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| checkout_id | String | PK, FK |
| code | String |  |
| coupon_type | Int |  |
| discounted_amount | Double |  |
| display_name | String |  |

### applied_gift_certificate

| Column | Type | Keys |
| --- | --- | --- |
| code | String | PK |
| checkout_id | String | PK, FK |
| 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 | PK, FK |
| product_id | Long | PK, FK |

### price_list_bulk_pricing

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

### 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 | PK, FK |
| 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 | PK, FK |
| channel_id | Long | PK, FK |
| enabled_filter_id | String | PK, FK |

### 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 | PK, FK |
| matching | String |  |
| route | String |  |
| type | String |  |

### cart_coupon

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cart_id | String | PK, FK |
| code | String |  |
| coupon_type | Long |  |
| discounted_amount | Double |  |

### cart_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cart_id | String | PK, FK |
| discounted_amount | Double |  |

### cart_custom_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cart_id | String | PK, FK |
| 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 | PK, FK |
| name | String |  |
| value | String |  |
| value_id | Long |  |

### digital_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| digital_item_id | String | PK, FK |
| discounted_amount | Double |  |

### cart_digital_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cart_id | String | PK, FK |
| 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 | PK, FK |
| name | String |  |
| value | String |  |
| value_id | Long |  |

### physical_line_item_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| physical_item_id | String | PK, FK |
| discounted_amount | Double |  |

### cart_physical_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cart_id | String | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| state | String |  |
| state_abbreviation | String |  |

### category_tree_meta_keyword

| Column | Type | Keys |
| --- | --- | --- |
| meta_keyword_id | String | PK |
| category_id | Long | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |

### customer_group_discount_rule

| Column | Type | Keys |
| --- | --- | --- |
| type | String | PK |
| customer_group_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### channel_currency_assignment

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Long | PK, FK |
| default_currency | String |  |

### catalog_variant_metafield

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| catalog_variant_id | Long | PK, FK |
| 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 | PK, FK |
| quantity | Long |  |
| reason | String |  |
| requested_amount | Double |  |

### order_refund_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_refund_id | Long | PK, FK |
| amount | Double |  |
| declined_message | String |  |
| is_declined | Boolean |  |
| offlines | Boolean |  |
| provider_id | String |  |

### order_refund

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| 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 | PK, FK |
| coupon_id | Long | PK, FK |

### coupon_state_restriction

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| coupon_id | Long | PK, FK |
| country | String |  |
| state | String |  |

### coupon_zip_restriction

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| coupon_id | Long | PK, FK |
| 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 | PK, FK |
| value | Json |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| customer_id | Long | PK, FK |
| 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 | PK, FK |
| value | Json |  |

### customer_store_credit

| Column | Type | Keys |
| --- | --- | --- |
| index | Long | PK |
| customer_id | Long | PK, FK |
| amount | Double |  |

### customer_channel

| Column | Type | Keys |
| --- | --- | --- |
| channel_id | Long | PK, FK |
| customer_id | Long | PK, FK |

### customer_attribute_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| customer_id | Long | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| amount | Long |  |
| quantity_max | Long |  |
| quantity_min | Long |  |
| type | String |  |

### product_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | PK, FK |
| name | String |  |
| value | String |  |

### product_modifier_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_modifier_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |

### related_product

| Column | Type | Keys |
| --- | --- | --- |
| related_product_id | Long | PK |
| product_id | Long | PK, FK |

### product_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | PK, FK |
| 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 | PK, FK |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| category_id | Long | PK, FK |
| product_id | Long | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| amount | String |  |
| code | String |  |
| name | String |  |
| target | String |  |

### order_product_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_product_id | Long | PK, FK |
| 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 | PK, FK |
| product_id | Long | PK, FK |
| 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 | PK, FK |
| order_product_id | Long | FK |
| product_id | Long | FK |
| quantity | Long |  |

### order_shipment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| value | Json |  |

### order_shipping_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| 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 | PK, FK |
| coupon_id | Long | FK |
| amount | Double |  |
| code | String |  |
| discount | Double |  |
| type | Long |  |

### order_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| order_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| product_id | Long | FK |
| is_default | Boolean |  |
| label | String |  |
| sort_order | Long |  |

### product_variant_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| channel_listing_id | Long | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| active_theme_version_uuid | String | FK |
| active_theme_configuration_uuid | String |  |
| saved_theme_configuration_uuid | String |  |

## Relationships

- consignment_line_item(consignment_id) → consignment(id)
- consignment_discount(consignment_id) → consignment(id)
- consignment_coupon_discount(consignment_id) → consignment(id)
- consignment_shipping_option(consignment_id) → consignment(id)
- consignment_billing_address_custom_field(consignment_id) → consignment(id)
- consignment(checkout_id) → checkout(id)
- checkout_billing_address_custom_field(checkout_id) → checkout(id)
- tax(checkout_id) → checkout(id)
- applied_coupon(checkout_id) → checkout(id)
- applied_gift_certificate(checkout_id) → checkout(id)
- checkout(order_id) → orders(id)
- checkout(cart_id) → cart(id)
- product_channel_assignment(channel_id) → channel(id)
- product_channel_assignment(product_id) → product(id)
- price_list_bulk_pricing(price_list_record_fivetran_id) → price_list_record(_fivetran_id)
- price_list_record(product_id) → product(id)
- price_list_record(variant_id) → product_variant(id)
- price_list_record(id) → price_list(id)
- store_blog_tag(post_id) → store_blog_post(id)
- wishlist_item(product_id) → product(id)
- wishlist_item(variant_id) → product_variant(id)
- wishlist_item(wishlist_id) → wishlist(id)
- wishlist(customer_id) → customer(id)
- contextual_filter(enabled_filter_id) → enabled_filter(id)
- contextual_filter(category_id) → category_tree(category_id)
- contextual_filter(channel_id) → channel(id)
- placement(channel_id) → channel(id)
- placement(widget_id) → widget(uuid)
- site_route(site_id) → site(id)
- cart_coupon(cart_id) → cart(id)
- cart_discount(cart_id) → cart(id)
- cart_custom_item(cart_id) → cart(id)
- digital_line_item_option(digital_item_id) → cart_digital_item(id)
- digital_line_item_discount(digital_item_id) → cart_digital_item(id)
- cart_digital_item(product_id) → product(id)
- cart_digital_item(variant_id) → product_variant(id)
- cart_digital_item(cart_id) → cart(id)
- physical_line_item_option(physical_item_id) → cart_physical_item(id)
- physical_line_item_discount(physical_item_id) → cart_physical_item(id)
- cart_physical_item(product_id) → product(id)
- cart_physical_item(variant_id) → product_variant(id)
- cart_physical_item(cart_id) → cart(id)
- cart_gift_certificate_item(cart_id) → cart(id)
- cart(channel_id) → channel(id)
- cart(currency_code) → currency(currency_code)
- cart(customer_id) → customer(id)
- email_template_translation(email_template_type_id) → email_template(type_id)
- category_metafield(category_id) → category_tree(category_id)
- site_url(site_id) → site(id)
- site(channel_id) → channel(id)
- theme_variation(theme_id) → theme(uuid)
- shipping_zone_location(shipping_zone_id) → shipping_zone(id)
- country_state(country_id) → country(id)
- category_tree_meta_keyword(category_id) → category_tree(category_id)
- price_list_assignment(price_list_id) → price_list(id)
- price_list_assignment(channel_id) → channel(id)
- price_list_assignment(customer_group_id) → customer_group(id)
- gift_certificate(order_id) → orders(id)
- gift_certificate(customer_id) → customer(id)
- brand_metafield(brand_id) → brand(id)
- brand_meta_keyword(brand_id) → brand(id)
- product_custom_information(product_id) → product(id)
- customer_group_category_access(category_id) → category_tree(category_id)
- customer_group_discount_rule(price_list_id) → price_list(id)
- customer_group_discount_rule(customer_group_id) → customer_group(id)
- shipping_zone_method(shipping_zone_id) → shipping_zone(id)
- redirect(site_id) → site(id)
- catalog_variant_option_value(variant_id) → catalog_variant(id)
- catalog_variant(product_id) → product(id)
- channel_enabled_currency(channel_id) → channel_currency_assignment(channel_id)
- channel_currency_assignment(channel_id) → channel(id)
- catalog_variant_metafield(catalog_variant_id) → catalog_variant(id)
- order_refund_item(order_refund_id) → order_refund(id)
- order_refund_payment(order_refund_id) → order_refund(id)
- order_refund(order_id) → orders(id)
- custom_template_association(channel_id) → channel(id)
- widget(channel_id) → channel(id)
- coupon_country_restriction(country_id) → country(id)
- coupon_country_restriction(coupon_id) → coupon(id)
- coupon_state_restriction(coupon_id) → coupon(id)
- coupon_zip_restriction(coupon_id) → coupon(id)
- customer_address_form_field(customer_address_id) → customer_address(id)
- customer_address(customer_id) → customer(id)
- customer_form_field(customer_id) → customer(id)
- customer_store_credit(customer_id) → customer(id)
- customer_channel(channel_id) → channel(id)
- customer_channel(customer_id) → customer(id)
- customer_attribute_value(customer_id) → customer(id)
- customer(customer_group_id) → customer_group(id)
- customer(origin_channel_id) → channel(id)
- channel_app(channel_id) → channel(id)
- subscriber(channel_id) → channel(id)
- subscriber(order_id) → orders(id)
- product_image(product_id) → product(id)
- product_bulk_pricing_rule(product_id) → product(id)
- product_custom_field(product_id) → product(id)
- product_modifier_value(product_id) → product(id)
- product_modifier_value(product_modifier_id) → product_modifier(id)
- product_modifier(product_id) → product(id)
- product_variant(product_id) → product(id)
- product_video(product_id) → product(id)
- product_meta_keyword(product_id) → product(id)
- related_product(product_id) → product(id)
- product_option(product_id) → product(id)
- product_gift_wrapping_option(product_id) → product(id)
- product_category(category_id) → category_tree(category_id)
- product_category(product_id) → product(id)
- product(tax_class_id) → tax_class(id)
- product(base_variant_id) → product_variant(id)
- product(brand_id) → brand(id)
- order_billing_address_form_field(order_id) → orders(id)
- orders(currency_id) → currency(id)
- orders(channel_id) → channel(id)
- orders(payment_provider_id) → order_transaction(gateway_transaction_id)
- orders(cart_id) → cart(id)
- orders(status_id) → order_status(id)
- orders(customer_id) → customer(id)
- order_product_discount(order_product_id) → order_product(id)
- order_product_option(order_product_id) → order_product(id)
- order_product(product_id) → product(id)
- order_product(variant_id) → product_variant(id)
- order_product(order_address_id) → order_shipping_address(id)
- order_product(order_id) → orders(id)
- order_shipment_item(order_product_id) → order_product(id)
- order_shipment_item(product_id) → product(id)
- order_shipment_item(shipment_id) → order_shipment(id)
- order_shipment(customer_id) → customer(id)
- order_shipment(order_address_id) → order_shipping_address(id)
- order_shipment(order_id) → orders(id)
- order_shipping_address_quote(shipping_address_id) → order_shipping_address(id)
- order_shipping_address_form_field(shipping_address_id) → order_shipping_address(id)
- order_shipping_address(shipping_zone_id) → shipping_zone(id)
- order_shipping_address(order_id) → orders(id)
- order_coupon(coupon_id) → coupon(id)
- order_coupon(order_id) → orders(id)
- order_transaction(order_id) → orders(id)
- payment_method_stored_instrument(payment_method_id) → payment_method(id)
- payment_method_supported_instrument(payment_method_id) → payment_method(id)
- order_metafield(order_id) → orders(id)
- order_tax(tax_class_id) → tax_class(id)
- order_tax(order_product_id) → order_product(id)
- order_tax(order_address_id) → order_shipping_address(id)
- order_tax(order_id) → orders(id)
- order_message(customer_id) → customer(id)
- order_message(order_id) → orders(id)
- product_review(product_id) → product(id)
- product_metafield(product_id) → product(id)
- product_variant_options_value(product_variant_option_id) → product_variant_option(id)
- product_variant_options_value(product_id) → product_variant_option(product_id)
- product_variant_option(product_id) → product(id)
- product_complex_rule_condition(modifier_id) → product_modifier(id)
- product_complex_rule_condition(modifier_value_id) → product_modifier_value(id)
- product_complex_rule_condition(variant_id) → product_variant(id)
- product_complex_rule_condition(product_complex_rule_id) → product_complex_rule(id)
- product_complex_rule(product_id) → product(id)
- product_variant_metafield(product_variant_id) → product_variant(id)
- product_variant_metafield(product_id) → product(id)
- channel_variant(product_id) → product(id)
- channel_variant(channel_id) → channel(id)
- channel_variant(variant_id) → product_variant(id)
- channel_variant(channel_listing_id) → channel_listing(listing_id)
- channel_listing(product_id) → product(id)
- channel_listing(channel_id) → channel(id)
- customer_setting_per_channel(channel_id) → channel(id)
- channel_active_theme(active_theme_version_uuid) → theme_variation(uuid)
- channel_active_theme(channel_id) → channel(id)