Shopify

Explore the interactive ERD

Table & Field Reference

return_line_item

Column	Type	Keys
`id`	Long	PK
`return_id`	Long	PKFK
`order_line_id`	Long	FK
`customer_note`	String
`quantity`	Int
`refundable_quantity`	Int
`refunded_quantity`	Int
`restocking_fee_amount_set_pres_amount`	Double
`restocking_fee_amount_set_pres_currency_code`	String
`restocking_fee_amount_set_shop_amount`	Double
`restocking_fee_amount_set_shop_currency_code`	String
`restocking_fee_id`	Long
`restocking_fee_percentage`	Double
`return_reason`	String
`return_reason_note`	String

order_url_tag

Column	Type	Keys
`key`	String	PK
`order_id`	Long	PKFK
`value`	String

price_rule_prereq_customer

Column	Type	Keys
`customer_id`	Long	PKFK
`price_rule_id`	Long	PKFK

sales_agreement

Column	Type	Keys
`id`	Long	PK
`app_id`	Long	FK
`order_id`	Long	FK
`refund_id`	Long	FK
`return_id`	Long	FK
`user_id`	Long	FK
`happened_at`	Instant
`reason`	String

shop

Column	Type	Keys
`id`	Long	PK
`address_1`	String
`address_2`	String
`auto_configure_tax_inclusivity`	Boolean
`checkout_api_supported`	Boolean
`city`	String
`cookie_consent_level`	String
`country`	String
`country_code`	String
`country_name`	String
`county_taxes`	Boolean
`created_at`	Instant
`currency`	String
`customer_email`	String
`domain`	String
`eligible_for_card_reader_giveaway`	Boolean
`eligible_for_payments`	Boolean
`email`	String
`enabled_presentment_currencies`	Json
`force_ssl`	Boolean
`google_apps_domain`	String
`google_apps_login_enabled`	Boolean
`has_discounts`	Boolean
`has_gift_cards`	Boolean
`has_storefront`	Boolean
`iana_timezone`	String
`latitude`	Double
`longitude`	Double
`money_format`	String
`money_in_emails_format`	String
`money_with_currency_format`	String
`money_with_currency_in_emails_format`	String
`multi_location_enabled`	Boolean
`myshopify_domain`	String
`name`	String
`password_enabled`	Boolean
`phone`	String
`plan_display_name`	String
`plan_name`	String
`pre_launch_enabled`	Boolean
`primary_locale`	String
`primary_location_id`	Long
`province`	String
`province_code`	String
`requires_extra_payments_agreement`	Boolean
`setup_required`	Boolean
`shop_owner`	String
`source`	String
`tax_shipping`	Boolean
`taxes_included`	Boolean
`timezone`	String
`updated_at`	Instant
`visitor_tracking_consent_preference`	String
`weight_unit`	String
`zip`	String

market_condition_location

Column	Type	Keys
`location_id`	Long	PKFK
`market_id`	Long	PKFK

discount_code

Column	Type	Keys
`id`	Long	PK
`price_rule_id`	Long	FK
`code`	String
`created_at`	Instant
`updated_at`	Instant
`usage_count`	Double

product_added_to_cart_event

Column	Type	Keys
`event_id`	String	PK
`merchandise_id`	Unknown	FK
`cost_amount`	Double
`cost_currency_code`	String
`event_client_id`	String
`event_timestamp`	Instant
`quantity`	Int

catalog_app

Column	Type	Keys
`app_id`	Long	PKFK
`catalog_id`	Long	PKFK

metafield

Column	Type	Keys
`id`	Long	PK
`owner_id`	Long	PK
`created_at`	Instant
`description`	String
`key`	String
`namespace`	String
`owner_resource`	String
`type`	String
`updated_at`	Instant
`value`	String

order_tag

Column	Type	Keys
`index`	Long	PK
`order_id`	Long	PKFK
`value`	String

inventory_transfer

Column	Type	Keys
`id`	Long	PK
`destination_location_id`	Long	FK
`origin_location_id`	Long	FK
`date_created`	Instant
`destination_name`	String
`destination_snapshotted_at`	Instant
`name`	String
`note`	String
`origin_name`	String
`origin_snapshotted_at`	Instant
`received_quantity`	Int
`reference_name`	String
`status`	String
`total_quantity`	Int

price_rule

Column	Type	Keys
`id`	Long	PK
`allocation_limit`	Long
`allocation_method`	String
`created_at`	Instant
`customer_selection`	String
`ends_at`	Instant
`once_per_customer`	Boolean
`prerequisite_quantity_range`	Double
`prerequisite_shipping_price_range`	Double
`prerequisite_subtotal_range`	Double
`prerequisite_to_entitlement_purchase_prerequisite_amount`	Double
`quantity_ratio_entitled_quantity`	Long
`quantity_ratio_prerequisite_quantity`	Long
`starts_at`	Instant
`target_selection`	String
`target_type`	String
`title`	String
`updated_at`	Instant
`usage_limit`	Long
`value`	Double
`value_type`	String

draft_order_note_attribute

Column	Type	Keys
`name`	String	PK
`draft_order_id`	Long	PKFK
`value`	String

translatable_resource_translatable_content

Column	Type	Keys
`key`	String	PK
`resource_type`	String	PK
`resource_id`	Long	PKFK
`digest`	String
`locale`	String
`type`	String
`value`	String

market_catalog

Column	Type	Keys
`catalog_id`	Long	PKFK
`market_id`	Long	PKFK

discount_customer_segment_selection

Column	Type	Keys
`discount_id`	Long	PK
`discount_type`	String	PK
`index`	Int	PK
`segment_id`	Long	FK

order_shipping_tax_line

Column	Type	Keys
`index`	Long	PK
`order_shipping_line_id`	Long	PKFK
`price`	Double
`price_set`	Json
`rate`	Double
`title`	String

discount_customer_buys_product_variant

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`product_variant_id`	Long	PKFK

product_viewed_event

Column	Type	Keys
`event_id`	String	PK
`product_variant_id`	Long	FK
`event_client_id`	String
`event_timestamp`	Instant

adjustment_order_transaction

Column	Type	Keys
`balance_transaction_id`	Long	PKFK
`id`	Long	PKFK
`order_id`	Long	FK
`amount`	Double
`order_name`	String

inventory_level

Column	Type	Keys
`id`	Long	PK
`inventory_item_id`	Long	PKFK
`location_id`	Long	PKFK
`can_deactivate`	Boolean
`created_at`	Instant
`deactivation_alert`	String
`updated_at`	Instant

checkout_discount_application_event

Column	Type	Keys
`index`	Long	PK
`event_id`	String	PKFK
`allocation_method`	String
`target_selection`	String
`target_type`	String
`title`	String
`type`	String
`value_amount`	Double
`value_currency_code`	String
`value_percentage`	Double

discount_destination_selection_country

Column	Type	Keys
`discount_id`	Long	PK
`discount_type`	String	PK
`index`	Int	PK
`country_code`	String

dispute

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	FK
`amount`	Double
`currency`	String
`evidence_due_by`	Instant
`evidence_sent_on`	Instant
`finalized_on`	Instant
`network_reason_code`	String
`reason`	String
`status`	String
`type`	String

company_contact

Column	Type	Keys
`id`	Long	PK
`company_id`	Long	FK
`customer_id`	Long	FK
`created_at`	Instant
`is_main_contact`	Boolean
`locale`	String
`title`	String
`updated_at`	Instant

translatable_resource

Column	Type	Keys
`resource_id`	Long	PK
`resource_type`	String	PK

catalog

Column	Type	Keys
`id`	Long	PK
`status`	String
`title`	String
`price_list_`

draft_order

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`order_id`	Long	FK
`admin_graphql_api_id`	String
`completed_at`	Instant
`created_at`	Instant
`currency`	String
`email`	String
`invoice_sent_at`	Instant
`invoice_url`	String
`name`	String
`note`	String
`status`	String
`subtotal_price`	Double
`subtotal_price_set`	Json
`tax_exempt`	Boolean
`tax_lines`	Json
`taxes_included`	Boolean
`total_price`	Double
`total_price_set`	Json
`total_tax`	Double
`total_tax_set`	Json
`updated_at`	Instant
`applied_discount_`
`billing_address_`
`shipping_address_`
`shipping_line_`

order_line_refund

Column	Type	Keys
`id`	Long	PK
`location_id`	Long	FK
`order_line_id`	Long	FK
`refund_id`	Long	FK
`quantity`	Double
`restock_type`	String
`subtotal`	Double
`subtotal_set`	Json
`total_tax`	Double
`total_tax_set`	Json

discount_allocation

Column	Type	Keys
`index`	Long	PK
`order_line_id`	Long	PKFK
`discount_application_index`	Long	FK
`amount`	Double
`amount_set_presentment_money_amount`	Double
`amount_set_presentment_money_currency_code`	String
`amount_set_shop_money_amount`	Double
`amount_set_shop_money_currency_code`	String

abandoned_checkout_line

Column	Type	Keys
`index`	Long	PK
`checkout_id`	Long	PKFK
`destination_location_id`	Long	FK
`origin_location_id`	Long	FK
`product_id`	Long	FK
`variant_id`	Long	FK
`compare_at_price`	Double
`gift_card`	Boolean
`grams`	Long
`id`	String
`key`	String
`line_price`	Double
`price`	Double
`properties`	Json
`quantity`	Long
`requires_shipping`	Boolean
`sku`	String
`tax_code`	String
`taxable`	Boolean
`title`	String
`variant_title`	String
`vendor`	String

order_adjustment

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	FK
`refund_id`	Long	FK
`amount`	Double
`amount_set`	Json
`kind`	String
`reason`	String
`tax_amount`	Double
`tax_amount_set`	Json

price_rule_ent_variant

Column	Type	Keys
`price_rule_id`	Long	PKFK
`variant_id`	Long	PKFK

fulfillment_order_line

Column	Type	Keys
`order_line_id`	Long	PK
`fulfillment_id`	Long	PKFK
`order_id`	Long	FK
`product_id`	Long	FK
`variant_id`	Long	FK
`fulfillable_quantity`	Long
`gift_card`	Boolean
`grams`	Long
`name`	String
`price`	Double
`price_set`	Json
`properties`	Json
`quantity`	Long
`requires_shipping`	Boolean
`sku`	String
`taxable`	Boolean
`title`	String
`variant_title`	String
`vendor`	String

product_variant

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	PKFK
`inventory_item_id`	Long	FK
`available_for_sale`	Boolean
`barcode`	String
`compare_at_price`	String
`created_at`	Instant
`display_name`	String
`inventory_policy`	String
`inventory_quantity`	Int
`legacy_resource_id`	Long
`metafield`	Json
`position`	Int
`price`	Double
`requires_components`	Boolean
`sellable_online_quantity`	Int
`sku`	String
`tax_code`	String
`taxable`	Boolean
`title`	String
`updated_at`	Instant

draft_order_line

Column	Type	Keys
`index`	Long	PK
`draft_order_id`	Long	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK
`custom`	Boolean
`fulfillable_quantity`	Long
`gift_card`	Boolean
`grams`	Long
`name`	String
`price`	Double
`price_set`	Json
`properties`	Json
`quantity`	Long
`requires_shipping`	Boolean
`sku`	String
`taxable`	Boolean
`title`	String
`variant_title`	String
`vendor`	String
`applied_discount_`

product_variant_option_value

Column	Type	Keys
`option_value_id`	Long	PKFK
`variant_id`	Long	PKFK

customer_tax_exemption

Column	Type	Keys
`index`	Long	PK
`customer_id`	Long	PKFK
`tax_exemption`	String

checkout_transaction_event

Column	Type	Keys
`index`	Long	PK
`event_id`	String	PKFK
`amount`	Double
`currency_code`	String
`gateway`	String
`payment_method_name`	String
`payment_method_type`	String

company_location

Column	Type	Keys
`id`	Long	PK
`company_id`	Long	FK
`created_at`	Instant
`currency`	String
`external_id`	String
`has_timeline_comment`	Boolean
`locale`	String
`name`	String
`note`	String
`phone`	String
`tax_settings_tax_exempt`	Boolean
`tax_settings_tax_registration_id`	String
`total_spent_amount`	Double
`total_spent_currency_code`	String
`updated_at`	Instant
`billing_address_`
`buyer_exp_config_`
`shipping_address_`

media_warning

Column	Type	Keys
`index`	Int	PK
`media_id`	Long	PKFK
`code`	String
`message`	String

discount_customer_buys_product

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`product_id`	Long	PKFK

price_list_price

Column	Type	Keys
`index`	Int	PK
`price_list_id`	Long	PKFK
`variant_id`	Long	FK
`compare_at_price_amount`	Double
`compare_at_price_currency_code`	String
`origin_type`	String
`price_amount`	Double
`price_currency_code`	String

order_payment_term

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`draft_order_id`	Long	FK
`due`	Boolean
`due_in_days`	Int
`overdue`	Boolean
`payment_terms_name`	String
`payment_terms_type`	String
`translated_name`	String

company

Column	Type	Keys
`id`	Long	PK
`main_contact_id`	Long	FK
`created_at`	Instant
`default_role_id`	Long
`default_role_name`	String
`default_role_note`	String
`external_id`	String
`has_timeline_comment`	Boolean
`name`	String
`note`	String
`updated_at`	Instant

refund

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`note`	String
`processed_at`	Instant
`restock`	Boolean
`total_duties_set`	Json

return_exchange_line_item

Column	Type	Keys
`id`	Long	PK
`return_id`	Long	PKFK
`order_id`	Long	FK
`variant_id`	Long	FK
`processable_quantity`	Int
`processed_quantity`	Int
`quantity`	Int
`unprocessed_quantity`	Int

customer_visit

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	FK
`landing_page`	String
`landing_page_html`	String
`occurred_at`	Instant
`referral_code`	String
`referral_info_html`	String
`referrer_url`	String
`source`	String
`source_description`	String
`source_type`	String
`type`	String
`utm_parameters_`

bundle_component_option_selection

Column	Type	Keys
`index`	Long	PK
`bundle_component_index`	Long	PKFK
`product_id`	Long	PKFK
`component_option_id`	Long	FK
`parent_option_id`	Long	FK
`values`	Json

order_line

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`product_id`	Long	FK
`variant_id`	Long	FK
`fulfillable_quantity`	Long
`fulfillment_status`	String
`gift_card`	Boolean
`grams`	Long
`index`	Long
`name`	String
`price`	Double
`price_set`	Json
`product_exists`	Boolean
`properties`	Json
`quantity`	Long
`requires_shipping`	Boolean
`sku`	String
`tax_code`	String
`taxable`	Boolean
`title`	String
`total_discount`	Double
`total_discount_set`	Json
`variant_inventory_management`	String
`variant_title`	String
`vendor`	String

cart_line_event

Column	Type	Keys
`index`	Long	PK
`event_id`	String	PKFK
`merchandise_id`	Unknown	FK
`cost_amount`	Double
`cost_currency_code`	String
`quantity`	Int

collection

Column	Type	Keys
`id`	Long	PK
`body_html`	String
`disjunctive`	Boolean
`handle`	String
`published_at`	Instant
`published_scope`	String
`rules`	Json
`sort_order`	String
`template_suffix`	String
`title`	String
`updated_at`	Instant

discount_code_basic

Column	Type	Keys
`id`	Long	PK
`applies_once_per_customer`	Boolean
`async_usage_count`	Int
`codes_count`	Int
`codes_precision`	String
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`customer_selection_all_customers`	Boolean
`discount_class`	String
`ends_at`	Instant
`has_timeline_comment`	Boolean
`minimum_requirement_greater_than_or_equal_to_quantity`	Int
`minimum_requirement_gte_subtotal_amount`	Double
`minimum_requirement_gte_subtotal_currency_code`	String
`recurring_cycle_limit`	Int
`short_summary`	String
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`total_sales_amount`	Double
`total_sales_currency_code`	String
`updated_at`	Instant
`usage_limit`	Long
`customer_gets_`

draft_order_line_tax_line

Column	Type	Keys
`draft_order_id`	Long	PK
`index`	Long	PK
`draft_order_line_index`	Long	PKFK
`price`	Double
`price_set`	Json
`rate`	Double
`title`	String

inventory_transfer_line_item

Column	Type	Keys
`id`	Long	PK
`inventory_transfer_id`	Long	PKFK
`inventory_item_id`	Long	FK
`picked_for_shipment_quantity`	Int
`processable_quantity`	Int
`shippable_quantity`	Int
`shipped_quantity`	Int
`title`	String
`total_quantity`	Int

product_tag

Column	Type	Keys
`index`	Long	PK
`product_id`	Long	PKFK
`value`	String

media_error

Column	Type	Keys
`index`	Int	PK
`media_id`	Long	PKFK
`code`	String
`details`	String
`message`	String

product_media

Column	Type	Keys
`media_id`	Long	PKFK
`product_id`	Long	PKFK

discount_code_app

Column	Type	Keys
`id`	Long	PK
`app_discount_type_app_id`	Long	FK
`app_discount_type_app_bridge_create_path`	String
`app_discount_type_app_bridge_details_path`	String
`app_discount_type_app_key`	String
`app_discount_type_description`	String
`app_discount_type_discount_class`	String
`app_discount_type_function_id`	String
`app_discount_type_target_type`	String
`app_discount_type_title`	String
`applies_on_one_time_purchase`	Boolean
`applies_on_subscription`	Boolean
`applies_once_per_customer`	Boolean
`async_usage_count`	Long
`codes_count_count`	Int
`codes_count_precision`	String
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`customer_selection_all_customers`	Boolean
`discount_class`	String
`discount_id`	Long
`ends_at`	Instant
`has_timeline_comment`	Boolean
`recurring_cycle_limit`	Long
`starts_at`	Instant
`status`	String
`title`	String
`total_sales_amount`	Double
`total_sales_currency_code`	String
`updated_at`	Instant
`usage_limit`	Long
`error_history_`

bundle_component_variant

Column	Type	Keys
`bundle_component_index`	Long	PKFK
`component_variant_id`	Long	PKFK
`product_id`	Long	PKFK

checkout_line_item_event

Column	Type	Keys
`id`	String	PK
`event_id`	String	PKFK
`final_line_price_amount`	Double
`final_line_price_currency_code`	String
`quantity`	Int
`selling_plan_allocation_id`	Long
`selling_plan_allocation_name`	String
`title`	String
`variant_id`	Long

order_risk_summary

Column	Type	Keys
`order_id`	Long	PKFK
`recommendation`	String

alert_displayed_event

Column	Type	Keys
`event_id`	String	PK
`event_client_id`	String
`event_timestamp`	Instant
`message`	String
`target`	String
`type`	String
`value`	String

order_payment_schedule

Column	Type	Keys
`id`	Long	PK
`order_payment_term_id`	Long	PKFK
`balance_due_amount`	Double
`balance_due_currency_code`	String
`completed_at`	Instant
`due`	Boolean
`due_at`	Instant
`issued_at`	Instant
`total_balance_amount`	Double
`total_balance_currency_code`	String

market

Column	Type	Keys
`id`	Long	PK
`currency_settings_base_currency_currency_code`	String
`currency_settings_local_storefront_currency_enabled`	Boolean
`currency_settings_rounding_enabled`	Boolean
`handle`	String
`market_type`	String
`name`	String
`price_inclusions_inclusive_duties_pricing_strategy`	String
`price_inclusions_inclusive_tax_pricing_strategy`	String
`status`	String

discount_customer_gets_collection

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`collection_id`	Long	PKFK

inventory_item

Column	Type	Keys
`id`	Long	PK
`country_code_of_origin`	String
`created_at`	Instant
`duplicate_sku_count`	Int
`harmonized_system_code`	String
`inventory_history_url`	String
`legacy_resource_id`	Long
`measurement_id`	Long
`measurement_weight_unit`	String
`measurement_weight_value`	Float
`province_code_of_origin`	String
`requires_shipping`	Boolean
`sku`	String
`tracked`	Boolean
`tracked_editable_locked`	Boolean
`tracked_editable_reason`	String
`unit_cost_amount`	Double
`unit_cost_currency_code`	String
`updated_at`	Instant

transaction

Column	Type	Keys
`id`	Long	PK
`location_id`	Long	FK
`order_id`	Long	FK
`parent_id`	Long	FK
`refund_id`	Long	FK
`user_id`	String	FK
`amount`	Double
`authorization`	String
`authorization_expires_at`	Instant
`created_at`	Instant
`currency`	String
`device_id`	String
`error_code`	String
`extended_authorization_extended_authorization_expires_at`	Instant
`extended_authorization_standard_authorization_expires_at`	Instant
`gateway`	String
`kind`	String
`message`	String
`processed_at`	Instant
`receipt`	Json
`source_name`	String
`status`	String
`test`	Boolean
`currency_exchange_`
`payment_`

discount_code_bxgy

Column	Type	Keys
`id`	Long	PK
`applies_once_per_customer`	Boolean
`async_usage_count`	Int
`codes_count`	Int
`codes_precision`	String
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`customer_selection_all_customers`	Boolean
`discount_class`	String
`ends_at`	Instant
`has_timeline_comment`	Boolean
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`total_sales_amount`	Double
`total_sales_currency_code`	String
`updated_at`	Instant
`usage_limit`	Long
`uses_per_order_limit`	Int
`customer_buys_`
`customer_gets_`

product_option_value

Column	Type	Keys
`id`	Long	PK
`product_option_id`	Long	PKFK
`has_variants`	Boolean
`linked_metafield_value`	String
`name`	String

price_list

Column	Type	Keys
`id`	Long	PK
`currency`	String
`name`	String
`parent_adjustment_type`	String
`parent_adjustment_value`	Double
`parent_settings_compare_at_mode`	String

discount_automatic_bxgy

Column	Type	Keys
`id`	Long	PK
`async_usage_count`	Long
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`discount_class`	String
`ends_at`	Instant
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`updated_at`	Instant
`uses_per_order_limit`	Long
`customer_buys_`
`customer_gets_`

customer_segment_member

Column	Type	Keys
`customer_id`	Long	PKFK
`segment_id`	Long	PKFK

product_publication

Column	Type	Keys
`product_id`	Long	PKFK
`publication_id`	Long	PKFK

ui_extension_errored_event

Column	Type	Keys
`event_id`	String	PK
`api_version`	String
`app_id`	Long
`app_name`	String
`app_version`	String
`event_client_id`	String
`event_timestamp`	Instant
`extension_name`	String
`extension_target`	String
`message`	String
`placement_reference`	String
`trace`	String
`type`	String

abandoned_checkout_url_tag

Column	Type	Keys
`key`	String	PK
`checkout_id`	Long	PKFK
`value`	String

page_viewed_event

Column	Type	Keys
`event_id`	String	PK
`context_document_location_href`	String
`context_document_location_search`	String
`event_client_id`	String
`event_timestamp`	Instant

return_exchange_line_item_order_line

Column	Type	Keys
`order_line_item_id`	Long	PKFK
`return_exchange_line_item_id`	Long	PKFK

inventory_quantity

Column	Type	Keys
`id`	Long	PK
`name`	String	PK
`inventory_item_id`	Long	PKFK
`inventory_level_id`	Long	PKFK
`quantity`	Int
`updated_at`	Instant

market_region

Column	Type	Keys
`id`	Long	PK
`code`	String
`currency_code`	String
`name`	String

tax_line

Column	Type	Keys
`index`	Long	PK
`order_line_id`	Long	PKFK
`price`	Double
`price_set`	Json
`rate`	Double
`title`	String

market_condition

Column	Type	Keys
`application_level`	String	PK
`condition_type`	String	PK
`market_id`	Long	PKFK

fulfillment_order_fulfillment_hold

Column	Type	Keys
`index`	Long	PK
`fulfillment_order_id`	Long	PKFK
`reason`	String
`reason_notes`	String

payout

Column	Type	Keys
`id`	Long	PK
`amount`	Double
`currency`	String
`date`	LocalDate
`status`	String

checkout_line_item_property_event

Column	Type	Keys
`key`	String	PK
`checkout_line_item_id`	String	PKFK
`event_id`	String	PKFK
`value`	String

market_condition_region

Column	Type	Keys
`market_id`	Long	PKFK
`region_id`	Long	PKFK

fulfillment

Column	Type	Keys
`id`	Long	PK
`location_id`	Long	FK
`order_id`	Long	FK
`created_at`	Instant
`name`	String
`receipt_authorization`	String
`service`	String
`shipment_status`	String
`status`	String
`tracking_company`	String
`tracking_number`	String
`tracking_numbers`	Json
`tracking_urls`	Json
`updated_at`	Instant

discount_customer_buys_collection

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`collection_id`	Long	PKFK

media_file_error

Column	Type	Keys
`index`	Int	PK
`media_id`	Long	PKFK
`code`	String
`details`	String
`message`	String

price_rule_prereq_variant

Column	Type	Keys
`price_rule_id`	Long	PKFK
`variant_id`	Long	PKFK

applied_gift_card

Column	Type	Keys
`id`	Long	PK
`checkout_id`	Long	FK
`amount_used`	Double

discount_shareable_url

Column	Type	Keys
`discount_id`	Long	PK
`discount_type`	String	PK
`index`	Int	PK
`target_type`	String
`title`	String
`url`	String
`target_item_image_`

product_variant_media

Column	Type	Keys
`media_id`	Long	PKFK
`product_variant_id`	Long	PKFK

discount_automatic_free_shipping

Column	Type	Keys
`id`	Long	PK
`applies_on_one_time_purchase`	Boolean
`applies_on_subscription`	Boolean
`async_usage_count`	Long
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`destination_selection_all_countries`	Boolean
`destination_selection_include_rest_of_world`	Boolean
`discount_class`	String
`ends_at`	Instant
`has_timeline_comment`	Boolean
`maximum_shipping_price_amount`	Double
`maximum_shipping_price_currency_code`	String
`minimum_requirement_greater_than_or_equal_to_quantity`	Int
`minimum_requirement_gte_subtotal_amount`	Double
`minimum_requirement_gte_subtotal_currency_code`	String
`recurring_cycle_limit`	Long
`short_summary`	String
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`total_sales_amount`	Double
`total_sales_currency_code`	String
`updated_at`	Instant

company_location_catalog

Column	Type	Keys
`catalog_id`	Long	PKFK
`company_location_id`	Long	PKFK

discount_automatic_app

Column	Type	Keys
`id`	Long	PK
`app_discount_type_app_id`	Long	FK
`app_discount_type_app_bridge_create_path`	String
`app_discount_type_app_bridge_details_path`	String
`app_discount_type_app_key`	String
`app_discount_type_description`	String
`app_discount_type_discount_class`	String
`app_discount_type_function_id`	String
`app_discount_type_target_type`	String
`app_discount_type_title`	String
`applies_on_one_time_purchase`	Boolean
`applies_on_subscription`	Boolean
`async_usage_count`	Long
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`discount_class`	String
`discount_id`	Long
`ends_at`	Instant
`recurring_cycle_limit`	Long
`starts_at`	Instant
`status`	String
`title`	String
`updated_at`	Instant
`error_history_`

tender_transaction

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	FK
`user_id`	Long	FK
`amount`	Double
`currency`	String
`payment_details_credit_card_company`	String
`payment_details_credit_card_number`	String
`payment_method`	String
`processed_at`	Instant
`remote_reference`	String
`test`	Boolean

customer_tag

Column	Type	Keys
`index`	Long	PK
`customer_id`	Long	PKFK
`value`	String

order_line_duty_tax_line

Column	Type	Keys
`index`	Long	PK
`order_line_duty_id`	Long	PKFK
`channel_liable`	Boolean
`price_set_pres_amount`	Double
`price_set_pres_currency_code`	String
`price_set_shop_amount`	Double
`price_set_shop_currency_code`	String
`rate`	Double
`rate_percentage`	Double
`source`	String
`title`	String

fulfillment_event

Column	Type	Keys
`id`	Long	PK
`fulfillment_id`	Long	FK
`order_id`	Long	FK
`address_1`	String
`city`	String
`country`	String
`created_at`	Instant
`estimated_delivery_at`	Instant
`happened_at`	Instant
`latitude`	Float
`longitude`	Float
`message`	String
`province`	String
`shop_id`	Long
`status`	String
`updated_at`	Instant
`zip`	String

return

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`created_at`	Instant
`decline_note`	String
`decline_reason`	String
`name`	String
`return_shipping_fees`	Json
`status`	String
`total_quantity`	Int

gift_card

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`line_item_id`	Long	FK
`order_id`	Long	FK
`user_id`	Long	FK
`api_client_id`	String
`balance`	Double
`code`	String
`created_at`	Instant
`currency`	String
`disabled_at`	String
`expires_on`	LocalDate
`initial_value`	String
`last_characters`	String
`note`	String
`template_suffix`	String
`updated_at`	Instant

product_option

Column	Type	Keys
`id`	Long	PK
`product_id`	Long	FK
`linked_metafield_key`	String
`linked_metafield_namespace`	String
`name`	String
`position`	Long
`values`	Json

product_removed_from_cart_event

Column	Type	Keys
`event_id`	String	PK
`merchandise_id`	Unknown	FK
`cost_amount`	Double
`cost_currency_code`	String
`event_client_id`	String
`event_timestamp`	Instant
`quantity`	Int

price_rule_ent_collection

Column	Type	Keys
`collection_id`	Long	PKFK
`price_rule_id`	Long	PKFK

balance_transaction

Column	Type	Keys
`id`	Long	PK
`payout_id`	Long	FK
`source_order_id`	Long	FK
`source_order_transaction_id`	Long	FK
`amount`	Double
`currency`	String
`fee`	Double
`net`	Double
`payout_status`	String
`processed_at`	Instant
`source_id`	Long
`source_type`	String
`test`	Boolean
`type`	String

company_location_tax_exemption

Column	Type	Keys
`tax_exemption`	String	PK
`company_location_id`	Long	PKFK

media

Column	Type	Keys
`id`	Long	PK
`alt`	String
`created_at`	Instant
`file_status`	String
`media_content_type`	String
`preview_image_alt_text`	String
`preview_image_height`	Long
`preview_image_id`	Long
`preview_image_url`	String
`preview_image_width`	Long
`preview_status`	String
`status`	String
`updated_at`	Instant

checkout_line_item_discount_allocation_event

Column	Type	Keys
`index`	Long	PK
`checkout_line_item_id`	String	PKFK
`event_id`	String	PKFK
`amount`	Double
`currency_code`	String
`discount_application_`

discount_automatic_basic

Column	Type	Keys
`id`	Long	PK
`async_usage_count`	Long
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`discount_class`	String
`ends_at`	Instant
`minimum_requirement_greater_than_or_equal_to_quantity`	Int
`minimum_requirement_gte_subtotal_amount`	Double
`minimum_requirement_gte_subtotal_currency_code`	String
`recurring_cycle_limit`	Long
`short_summary`	String
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`updated_at`	Instant
`customer_gets_`

bundle_component

Column	Type	Keys
`index`	Long	PK
`product_id`	Long	PKFK
`component_product_id`	Long	FK
`quantity_option_parent_option_id`	Long	FK
`quantity`	Long
`quantity_option_name`	String
`quantity_option_values`	Json

abandoned_checkout_tax_line

Column	Type	Keys
`_fivetran_id`	String	PK
`index`	Long	PK
`checkout_id`	Long	FK
`checkout_line_id`	String	FK
`checkout_shipping_line_id`	String	FK
`compare_at`	Double
`position`	Long
`price`	Double
`rate`	Double
`source`	String
`title`	String
`zone`	String

collection_product

Column	Type	Keys
`collection_id`	Long	PKFK
`product_id`	Long	PKFK

price_rule_ent_country

Column	Type	Keys
`country_id`	Long	PK
`price_rule_id`	Long	PKFK

order_discount_code

Column	Type	Keys
`index`	Long	PK
`order_id`	Long	PKFK
`code`	String	FK
`amount`	Double
`type`	String

app

Column	Type	Keys
`id`	Long	PK
`app_store_app_url`	String
`app_store_developer_url`	String
`description`	String
`developer_name`	String
`developer_type`	String
`embedded`	Boolean
`features`	Json
`handle`	String
`install_url`	String
`is_post_purchase_app_in_use`	Boolean
`previously_installed`	Boolean
`pricing_details`	String
`pricing_details_summary`	String
`privacy_policy_url`	String
`published`	Boolean
`shopify_developed`	Boolean
`title`	String
`uninstall_message`	String
`banner_`
`icon_`

order_line_duty

Column	Type	Keys
`id`	Long	PK
`order_line_id`	Long	PKFK
`country_code_of_origin`	String
`harmonized_system_code`	String
`price_pres_amount`	Double
`price_pres_currency_code`	String
`price_shop_amount`	Double
`price_shop_currency_code`	String

customer_segment

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`query`	String
`updated_at`	Instant

abandoned_checkout

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	FK
`location_id`	Long	FK
`user_id`	Long	FK
`abandoned_checkout_url`	String
`buyer_accepts_marketing`	Boolean
`cart_token`	String
`closed_at`	Instant
`completed_at`	Instant
`created_at`	Instant
`currency`	String
`customer_locale`	String
`device_id`	Long
`email`	String
`gateway`	String
`landing_site_base_url`	String
`name`	String
`note`	String
`note_attributes`	Json
`phone`	String
`presentment_currency`	String
`referring_site`	String
`shipping_line`	String
`shipping_rate_id`	String
`shipping_rate_price`	Double
`shipping_rate_title`	String
`source`	String
`source_identifier`	String
`source_name`	String
`source_url`	String
`subtotal_price`	Double
`taxes_included`	Boolean
`token`	String
`total_discounts`	Double
`total_duties`	String
`total_line_items_price`	Double
`total_price`	Double
`total_tax`	Double
`total_weight`	Long
`updated_at`	Instant
`applied_discount_`
`billing_address_`
`credit_card_`
`shipping_address_`

checkout_event

Column	Type	Keys
`event_id`	String	PK
`buyer_accepts_email_marketing`	Boolean
`buyer_accepts_sms_marketing`	Boolean
`currency_code`	String
`discounts_amount`	Double
`discounts_currency_code`	String
`email`	String
`event_client_id`	String
`event_name`	String
`event_timestamp`	Instant
`localization_country_iso_code`	String
`localization_language_iso_code`	String
`localization_market_handle`	String
`localization_market_id`	Long
`order_customer_id`	Long
`order_customer_is_first_order`	Boolean
`order_id`	Long
`phone`	String
`shipping_line_price_amount`	Double
`shipping_line_price_currency_code`	String
`sms_marketing_phone`	String
`subtotal_price_amount`	Double
`subtotal_price_currency_code`	String
`token`	String
`total_price_amount`	Double
`total_price_currency_code`	String
`total_tax_amount`	Double
`total_tax_currency_code`	String
`billing_address_`
`shipping_address_`

market_condition_company_location

Column	Type	Keys
`company_location_id`	Long	PKFK
`market_id`	Long	PKFK

customer_address

Column	Type	Keys
`id`	Long	PK
`customer_id`	Long	PKFK
`address_1`	String
`address_2`	String
`city`	String
`company`	String
`country`	String
`country_code`	String
`first_name`	String
`is_default`	Boolean
`last_name`	String
`latitude`	String
`longitude`	String
`name`	String
`phone`	String
`province`	String
`province_code`	String
`zip`	String

price_rule_prereq_collection

Column	Type	Keys
`collection_id`	Long	PKFK
`price_rule_id`	Long	PKFK

draft_order_payment_term

Column	Type	Keys
`id`	Long	PK
`draft_order_id`	Long	PKFK
`order_id`	Long	FK
`due`	Boolean
`due_in_days`	Int
`overdue`	Boolean
`payment_terms_name`	String
`payment_terms_type`	String
`translated_name`	String

order_risk_assessment

Column	Type	Keys
`index`	Int	PK
`order_id`	Long	PKFK
`provider`	Long
`risk_level`	String

sale_tax

Column	Type	Keys
`id`	Long	PK
`sale_id`	Long	PKFK
`pres_amount`	Double
`pres_currency_code`	String
`shop_amount`	Double
`shop_currency_code`	String
`tax_line_`

checkout_attribute_event

Column	Type	Keys
`key`	String	PK
`event_id`	String	PKFK
`value`	String

video

Column	Type	Keys
`media_id`	Long	PKFK
`duration`	Int
`file_name`	String
`original_source_`

discount_code_free_shipping

Column	Type	Keys
`id`	Long	PK
`applies_on_one_time_purchase`	Boolean
`applies_on_subscription`	Boolean
`applies_once_per_customer`	Boolean
`async_usage_count`	Int
`codes_count`	Int
`codes_precision`	String
`combines_with_order_discounts`	Boolean
`combines_with_product_discounts`	Boolean
`combines_with_shipping_discounts`	Boolean
`created_at`	Instant
`customer_selection_all_customers`	Boolean
`destination_selection_all_countries`	Boolean
`destination_selection_include_rest_of_world`	Boolean
`discount_class`	String
`ends_at`	Instant
`has_timeline_comment`	Boolean
`maximum_shipping_price_amount`	Double
`maximum_shipping_price_currency_code`	String
`minimum_requirement_greater_than_or_equal_to_quantity`	Int
`minimum_requirement_gte_subtotal_amount`	Double
`minimum_requirement_gte_subtotal_currency_code`	String
`recurring_cycle_limit`	Int
`short_summary`	String
`starts_at`	Instant
`status`	String
`summary`	String
`title`	String
`total_sales_amount`	Double
`total_sales_currency_code`	String
`updated_at`	Instant
`usage_limit`	Long

abandoned_applied_discount

Column	Type	Keys
`_fivetran_id`	String	PK
`index`	Long	PK
`checkout_line_id`	String	FK
`checkout_shipping_line_id`	String	FK
`price_rule_id`	Long	FK
`amount`	Double
`applicable`	Boolean
`description`	String
`non_applicable_reason`	String
`script_version_id`	Long
`title`	String
`value`	Double
`value_type`	String

fulfillment_order

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`assigned_location_location_id`	Long	FK
`assigned_location_address_1`	String
`assigned_location_address_2`	String
`assigned_location_city`	String
`assigned_location_country_code`	String
`assigned_location_id`	Long
`assigned_location_name`	String
`assigned_location_phone`	String
`assigned_location_province`	String
`assigned_location_zip`	String
`created_at`	Instant
`fulfill_at`	Instant
`fulfill_by`	Instant
`international_duties_incoterm`	String
`request_status`	String
`status`	String
`supported_actions`	Json
`updated_at`	Instant
`delivery_method_`
`destination_`

publication

Column	Type	Keys
`id`	Long	PK
`catalog_id`	Long	FK
`auto_publish`	Boolean
`supports_future_publishing`	Boolean

location

Column	Type	Keys
`id`	Long	PK
`active`	Boolean
`address_1`	String
`address_2`	String
`city`	String
`country`	String
`country_code`	String
`country_name`	String
`created_at`	Instant
`legacy`	Boolean
`localized_country_name`	String
`localized_province_name`	String
`name`	String
`phone`	String
`province`	String
`province_code`	String
`updated_at`	Instant
`zip`	String

draft_order_tag

Column	Type	Keys
`index`	Long	PK
`draft_order_id`	Long	PKFK
`value`	String

discount_customer_gets_product_variant

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`product_variant_id`	Long	PKFK

cart_attribute_event

Column	Type	Keys
`key`	String	PK
`event_id`	String	PKFK
`value`	String

draft_order_payment_schedule

Column	Type	Keys
`id`	Long	PK
`draft_order_payment_term_id`	Long	PKFK
`balance_due_amount`	Double
`balance_due_currency_code`	String
`completed_at`	Instant
`due`	Boolean
`due_at`	Instant
`issued_at`	Instant
`total_balance_amount`	Double
`total_balance_currency_code`	String

user

Column	Type	Keys
`id`	Long	PK
`bio`	String
`email`	String
`first_name`	String
`im_address`	String
`is_account_owner`	Boolean
`last_name`	String
`locale`	String
`permissions`	Json
`phone`	String
`receive_announcements`	Long
`url`	String
`user_type`	String

abandoned_checkout_discount_code

Column	Type	Keys
`index`	Long	PK
`checkout_id`	Long	PKFK
`amount`	Double
`code`	String
`created_at`	Instant
`type`	String
`updated_at`	Instant

product

Column	Type	Keys
`id`	Long	PK
`compare_at_price_range_max_variant_compare_at_price_amount`	Double
`compare_at_price_range_max_variant_compare_at_price_currency_code`	String
`compare_at_price_range_min_variant_compare_at_price_amount`	Double
`compare_at_price_range_min_variant_compare_at_price_currency_code`	String
`created_at`	Instant
`description`	String
`description_html`	String
`featured_media_id`	Long
`gift_card_template_suffix`	String
`handle`	String
`has_only_default_variant`	Boolean
`has_out_of_stock_variants`	Boolean
`has_variants_that_requires_components`	Boolean
`is_gift_card`	Boolean
`legacy_resource_id`	Long
`max_variant_price_amount`	Double
`max_variant_price_currency_code`	String
`metafield`	Json
`min_variant_price_amount`	Double
`min_variant_price_currency_code`	String
`online_store_preview_url`	String
`product_type`	String
`published_at`	Instant
`requires_selling_plan`	Boolean
`seo_description`	String
`seo_title`	String
`status`	String
`template_suffix`	String
`title`	String
`total_inventory`	Long
`tracks_inventory`	Boolean
`updated_at`	Instant
`vendor`	String
`category_`

model_3_d

Column	Type	Keys
`media_id`	Long	PKFK
`bounding_box_size_x`	Double
`bounding_box_size_y`	Double
`bounding_box_size_z`	Double
`file_name`	String
`original_source_`

order

Column	Type	Keys
`id`	Long	PK
`company_id`	Long	FK
`company_location_id`	Long	FK
`customer_id`	Long	FK
`location_id`	Long	FK
`user_id`	Long	FK
`app_id`	Long
`browser_ip`	String
`buyer_accepts_marketing`	Boolean
`cancel_reason`	String
`cancelled_at`	Instant
`cart_token`	String
`checkout_id`	String
`checkout_token`	String
`client_details_user_agent`	String
`closed_at`	Instant
`confirmed`	Boolean
`created_at`	Instant
`currency`	String
`current_subtotal_price`	Double
`current_subtotal_price_set`	Json
`current_total_discounts`	Double
`current_total_discounts_set`	Json
`current_total_duties_set`	Json
`current_total_price`	Double
`current_total_price_set`	Json
`current_total_tax`	Double
`current_total_tax_set`	Json
`customer_locale`	String
`device_id`	String
`email`	String
`financial_status`	String
`fulfillment_status`	String
`landing_site_base_url`	String
`landing_site_ref`	String
`name`	String
`note`	String
`note_attributes`	Json
`number`	Long
`order_number`	Long
`order_status_url`	String
`original_total_duties_set`	Json
`payment_gateway_names`	Json
`phone`	String
`presentment_currency`	String
`processed_at`	Instant
`reference`	String
`referring_site`	String
`source_identifier`	String
`source_name`	String
`source_url`	String
`subtotal_price`	Double
`subtotal_price_set`	Json
`taxes_included`	Boolean
`test`	Boolean
`token`	String
`total_discounts`	Double
`total_discounts_set`	Json
`total_line_items_price`	Double
`total_line_items_price_set`	Json
`total_outstanding`	Double
`total_price`	Double
`total_price_set`	Json
`total_shipping_price_set`	Json
`total_tax`	Double
`total_tax_set`	Json
`total_tip_received`	Double
`total_weight`	Long
`updated_at`	Instant
`billing_address_`
`shipping_address_`

order_shipping_line

Column	Type	Keys
`id`	Long	PK
`order_id`	Long	PKFK
`carrier_identifier`	String
`code`	String
`discounted_price`	Double
`discounted_price_set`	Json
`is_removed`	Boolean
`phone`	String
`price`	Double
`price_set`	Json
`requested_fulfillment_service_id`	String
`source`	String
`title`	String

order_note_attribute

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

discount_redeem_code

Column	Type	Keys
`discount_id`	Long	PK
`discount_type`	String	PK
`id`	Long	PK
`created_by_id`	Long	FK
`code`	String

price_rule_prereq_customer_segment

Column	Type	Keys
`price_rule_id`	Long	PKFK
`segment_id`	Long	PKFK

abandoned_checkout_shipping_line

Column	Type	Keys
`index`	Long	PK
`checkout_id`	Long	PKFK
`api_client_id`	Long
`carrier_identifier`	String
`carrier_service_id`	Long
`code`	String
`delivery_category`	String
`delivery_expectation_range`	String
`delivery_expectation_range_max`	Long
`delivery_expectation_range_min`	Long
`delivery_expectation_type`	String
`discounted_price`	Double
`id`	String
`markup`	Double
`original_shop_markup`	String
`original_shop_price`	String
`phone`	String
`presentment_title`	String
`price`	Double
`requested_fulfillment_service_id`	String
`source`	String
`title`	String
`validation_context`	String

search_result_product_variant_event

Column	Type	Keys
`event_id`	String	PKFK
`product_variant_id`	Unknown	PKFK

media_source

Column	Type	Keys
`index`	Int	PK
`media_id`	Long	PKFK
`file_size`	Int
`format`	String
`height`	Int
`mime_type`	String
`url`	String
`width`	Int

order_risk_fact

Column	Type	Keys
`index`	Int	PK
`order_id`	Long	PKFK
`order_risk_assessment_index`	Int	PKFK
`description`	String
`sentiment`	String

discount_customer_selection

Column	Type	Keys
`discount_id`	Long	PK
`discount_type`	String	PK
`index`	Int	PK
`customer_id`	Long	FK

discount_customer_gets_product

Column	Type	Keys
`discount_id`	Long	PK
`discount_resource`	String	PK
`product_id`	Long	PKFK

marketing_event

Column	Type	Keys
`id`	Long	PK
`app_id`	Long	FK
`channel_handle`	String
`description`	String
`ended_at`	Instant
`manage_url`	String
`marketing_channel_type`	String
`preview_url`	String
`remote_id`	String
`scheduled_to_end_at`	Instant
`source_and_medium`	String
`started_at`	Instant
`type`	String
`utm_campaign`	String
`utm_medium`	String
`utm_source`	String

customer

Column	Type	Keys
`id`	Long	PK
`default_email_address_source_location_id`	Long	FK
`default_phone_number_source_location_id`	Long	FK
`created_at`	Instant
`currency`	String
`default_email_address`	String
`default_phone_number`	String
`default_phone_number_marketing_collected_from`	String
`default_phone_number_marketing_opt_in_level`	String
`default_phone_number_marketing_state`	String
`default_phone_number_marketing_updated_at`	Instant
`email`	String
`email_marketing_consent_consent_updated_at`	Instant
`email_marketing_consent_opt_in_level`	String
`email_marketing_consent_state`	String
`first_name`	String
`last_name`	String
`metafield`	Json
`multipass_identifier`	String
`note`	String
`orders_count`	Long
`phone`	String
`state`	String
`tax_exempt`	Boolean
`total_spent`	Double
`updated_at`	Instant
`verified_email`	Boolean
`sms_marketing_consent_`

media_image

Column	Type	Keys
`media_id`	Long	PKFK
`mime_type`	String
`original_source_file_size`	Int
`original_source_url`	String
`image_`

price_rule_prereq_product

Column	Type	Keys
`price_rule_id`	Long	PKFK
`product_id`	Long	PKFK

fulfillment_order_line_item

Column	Type	Keys
`id`	Long	PK
`fulfillment_order_id`	Long	PKFK
`inventory_item_id`	Long
`remaining_quantity`	Long
`total_quantity`	Long

translatable_resource_translation

Column	Type	Keys
`key`	String	PK
`locale`	String	PK
`resource_type`	String	PK
`resource_id`	Long	PKFK
`market_id`	Long	FK
`outdated`	Boolean
`updated_at`	Instant
`value`	String

cart_viewed_event

Column	Type	Keys
`event_id`	String	PK
`cart_id`	String
`cost_amount`	Double
`cost_currency_code`	String
`event_client_id`	String
`event_timestamp`	Instant
`total_quantity`	Int

discount_application

Column	Type	Keys
`index`	Long	PK
`order_id`	Long	PKFK
`allocation_method`	String
`code`	String
`description`	String
`target_selection`	String
`target_type`	String
`title`	String
`type`	String
`value`	Double
`value_type`	String

collection_viewed_product_variant_event

Column	Type	Keys
`event_id`	String	PKFK
`product_variant_id`	Long	PKFK

checkout_delivery_option_event

Column	Type	Keys
`index`	Long	PK
`event_id`	String	PKFK
`cost_after_discounts_amount`	Double
`cost_after_discounts_currency_code`	String
`cost_amount`	Double
`cost_currency_code`	String
`description`	String
`handle`	String
`title`	String
`type`	String

external_video

Column	Type	Keys
`media_id`	Long	PKFK
`embed_url`	String
`host`	String
`origin_url`	String

price_rule_ent_product

Column	Type	Keys
`price_rule_id`	Long	PKFK
`product_id`	Long	PKFK

collection_viewed_event

Column	Type	Keys
`event_id`	String	PK
`collection_id`	String
`event_client_id`	String
`event_timestamp`	Instant
`title`	String

search_submitted_event

Column	Type	Keys
`event_id`	String	PK
`event_client_id`	String
`event_timestamp`	Instant
`query`	String

return_shipping_fee

Column	Type	Keys
`id`	Long	PK
`return_id`	Long	PKFK
`amount_set_presentment_money_amount`	Double
`amount_set_presentment_money_currency_code`	String
`amount_set_shop_money_amount`	Double
`amount_set_shop_money_currency_code`	String

sale

Column	Type	Keys
`id`	Long	PK
`sales_agreement_id`	Long	PKFK
`action_type`	String
`line_item_id`	Long
`line_type`	String
`quantity`	Int
`total_amount_pres_amount`	Double
`total_amount_pres_currency_code`	String
`total_amount_shop_amount`	Double
`total_amount_shop_currency_code`	String
`total_discount_amount_after_taxes_pres_amount`	Double
`total_discount_amount_after_taxes_pres_currency_code`	String
`total_discount_amount_after_taxes_shop_amount`	Double
`total_discount_amount_after_taxes_shop_currency_code`	String
`total_discount_amount_before_taxes_pres_amount`	Double
`total_discount_amount_before_taxes_pres_currency_code`	String
`total_discount_amount_before_taxes_shop_amount`	Double
`total_discount_amount_before_taxes_shop_currency_code`	String
`total_tax_amount_pres_amount`	Double
`total_tax_amount_pres_currency_code`	String
`total_tax_amount_shop_amount`	Double
`total_tax_amount_shop_currency_code`	String