commercetools

Explore the interactive ERD

Table & Field Reference

review

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`author_name`	String
`created_at`	Instant
`customer_type_id`	Unknown
`included_in_statistics`	Boolean
`key`	Unknown
`last_modified_at`	Instant
`locale`	Unknown
`rating`	Int
`state_id`	String
`state_type_id`	Unknown
`target_id`	String
`target_type_id`	Unknown
`text`	String
`title`	String
`uniqeness_value`	Unknown
`version`	Unknown
`version_modified_at`	Instant
`custom_`

shipping_method_zone_shipping_rate

Column	Type	Keys
`index`	Unknown	PK
`shipping_method_zone_rate_shipping_method_id`	Unknown	PKFK
`shipping_method_zone_rate_zone_id`	Unknown	PKFK
`free_above_cent_amount`	Unknown
`free_above_currency_code`	Unknown
`free_above_fraction_digits`	Unknown
`free_above_precise_amount`	Unknown
`free_above_type`	Unknown
`is_matching`	Unknown
`price_cent_amount`	Unknown
`price_currency_code`	Unknown
`price_fraction_digits`	Unknown
`price_precise_amount`	Unknown
`price_type`	Unknown

shipping_method_zone_rate

Column	Type	Keys
`zone_id`	Unknown	PK
`shipping_method_id`	Unknown	PKFK
`zone_type_id`	Unknown

shipping_method

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_default`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`name`	Unknown
`predicate`	Unknown
`tax_category_id`	Unknown
`tax_category_type_id`	Unknown
`version`	Unknown
`custom_`
`localized_description_`
`localized_name_`

discount_code_reference

Column	Type	Keys
`reference_id`	Unknown	PK
`discount_code_id`	Unknown	PKFK
`reference_type_id`	Unknown

cart_discount_code

Column	Type	Keys
`cart_id`	Unknown	PK
`discount_code_id`	Unknown	PKFK
`id`	Unknown	FK
`cart_type_id`	Unknown

discount_code_group

Column	Type	Keys
`group_name`	Unknown	PK
`discount_code_id`	Unknown	PKFK

discount_code

Column	Type	Keys
`id`	Unknown	PK
`application_version`	Unknown
`cart_predicate`	Unknown
`code`	Unknown
`created_at`	Unknown
`is_active`	Unknown
`last_modified_at`	Instant
`max_applications`	Unknown
`max_applications_per_customer`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`custom_`
`description_`
`name_`

shopping_list_line_item

Column	Type	Keys
`id`	Unknown	PK
`shopping_list_id`	Unknown	PKFK
`product_id`	Unknown	FK
`added_at`	Unknown
`deactivated_at`	Unknown
`product_type_id`	Unknown
`product_type_type_id`	Unknown
`quantity`	Unknown
`variant_id`	Unknown
`custom_`
`name_`
`product_slug_`

shopping_list_text_line_item

Column	Type	Keys
`id`	Unknown	PK
`shopping_list_id`	Unknown	PKFK
`added_at`	Unknown
`quantity`	Unknown
`custom_`
`description_`
`name_`

shopping_list

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`anonymous_id`	Unknown
`created_at`	Unknown
`customer_type_id`	Unknown
`delete_days_after_last_modification`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`store_id`	Unknown
`store_type_id`	Unknown
`version`	Unknown
`custom_`
`description_`
`name_`
`slug_`

business_unit_store

Column	Type	Keys
`key`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`type_id`	Unknown

business_unit_address

Column	Type	Keys
`id`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`additional_address_info`	Unknown
`additional_street_info`	Unknown
`apartment`	Unknown
`building`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`department`	Unknown
`email`	Unknown
`external_id`	Unknown
`fax`	Unknown
`first_name`	Unknown
`key`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`phone`	Unknown
`po_box`	Unknown
`postal_code`	Unknown
`region`	Unknown
`salutation`	Unknown
`state`	Unknown
`street_name`	Unknown
`street_number`	Unknown
`title`	Unknown

business_unit_associate_role

Column	Type	Keys
`role`	Unknown	PK
`business_unit_associate_business_unit_id`	Unknown	PKFK
`business_unit_associate_index`	Unknown	PKFK

business_unit_associate

Column	Type	Keys
`index`	Unknown	PK
`business_unit_id`	Unknown	PKFK
`customer_id`	Unknown
`customer_type_id`	Unknown

business_unit

Column	Type	Keys
`id`	Unknown	PK
`parent_unit_key`	Unknown	FK
`top_level_unit_key`	Unknown	FK
`contact_email`	Unknown
`created_at`	Unknown
`default_billing_address_id`	Unknown
`default_shipping_address_id`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`name`	Unknown
`parent_unit_type_id`	Unknown
`status`	Unknown
`store_mode`	Unknown
`top_level_unit_type_id`	Unknown
`unit_type`	Unknown
`version`	Unknown
`custom_`

customer_group

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`name`	Unknown
`version`	Unknown
`custom_`

standalone_price_tier

Column	Type	Keys
`index`	Unknown	PK
`standalone_price_id`	Unknown	PKFK
`minimum_quantity`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown

standalone_price

Column	Type	Keys
`id`	Unknown	PK
`active`	Unknown
`country`	Unknown
`create_at`	Unknown
`customer_group_id`	Unknown
`customer_group_type_id`	Unknown
`discount_id`	Unknown
`discount_type_id`	Unknown
`discount_value_cent_amount`	Unknown
`discount_value_currency_code`	Unknown
`discount_value_fraction_digits`	Unknown
`discount_value_precise_amount`	Unknown
`discount_value_type`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`sku`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown
`version`	Unknown
`custom_`

cart_discount_reference

Column	Type	Keys
`reference_id`	Unknown	PK
`cart_discount_id`	Unknown	PKFK
`reference_type_id`	Unknown

cart_discount

Column	Type	Keys
`id`	Unknown	PK
`cart_predicate`	Unknown
`created_at`	Unknown
`is_active`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`requires_discount_code`	Unknown
`sort_order`	Unknown
`stacking_mode`	Unknown
`target_predicate`	Unknown
`target_type`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`value_money`	Unknown
`value_permyriad`	Unknown
`value_type`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`custom_`
`description_`
`name_`

product_discount_reference

Column	Type	Keys
`reference_id`	Unknown	PK
`product_discount_id`	Unknown	PKFK
`reference_type_id`	Unknown

product_discount

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`is_active`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`predicate`	Unknown
`sort_order`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`value_money`	Unknown
`value_permyriad`	Unknown
`value_type`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`description_`
`name_`

tax_category_rate

Column	Type	Keys
`id`	Unknown	PK
`tax_category_id`	Unknown	PKFK
`amount`	Unknown
`country`	Unknown
`included_in_price`	Unknown
`name`	Unknown

tax_category

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Instant
`description`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`name`	Unknown
`version`	Unknown
`version_modified_at`	Instant

shipping_zone_location

Column	Type	Keys
`index`	Unknown	PK
`shipping_zone_id`	Unknown	PKFK
`country`	Unknown
`state`	Unknown

shipping_zone

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`description`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`name`	Unknown
`version`	Unknown

category_ancestor

Column	Type	Keys
`ancestor_id`	Unknown	PK
`category_id`	Unknown	PKFK
`ancestory_type_id`	Unknown

channel_role

Column	Type	Keys
`role`	Unknown	PK
`channel_id`	Unknown	PKFK

channel

Column	Type	Keys
`id`	Unknown	PK
`address_city`	Unknown
`address_country`	Unknown
`address_email`	Unknown
`address_first_name`	Unknown
`address_key`	Unknown
`address_last_name`	Unknown
`address_mobile`	Unknown
`address_phone`	Unknown
`address_postal_code`	Unknown
`address_street_name`	Unknown
`address_street_number`	Unknown
`address_title`	Unknown
`created_at`	Unknown
`geo_location_coordinates`	Json
`geo_location_type`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`review_rating_statistics_average_rating`	Unknown
`review_rating_statistics_count`	Unknown
`review_rating_statistics_highest_rating`	Unknown
`review_rating_statistics_lowest_rating`	Unknown
`review_rating_statistics_ratings_distribution`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`custom_`
`description_`
`name_`

cart_line_item_state

Column	Type	Keys
`index`	Unknown	PK
`cart_line_item_id`	Unknown	PKFK
`quantity`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown

cart_line_item

Column	Type	Keys
`id`	Unknown	PK
`cart_id`	Unknown	PKFK
`added_at`	Unknown
`inventory_mode`	Unknown
`last_modified_at`	Unknown
`line_item_mode`	Unknown
`price_country`	Unknown
`price_id`	Unknown
`price_key`	Unknown
`price_mode`	Unknown
`price_valid_from`	Unknown
`price_valid_until`	Unknown
`price_value_cent_amount`	Unknown
`price_value_currency_code`	Unknown
`price_value_fraction_digits`	Unknown
`price_value_precise_amount`	Unknown
`price_value_type`	Unknown
`product_id`	Unknown
`product_key`	Unknown
`product_type_id`	Unknown
`product_type_type_id`	Unknown
`quantity`	Unknown
`shipping_details_targets`	Unknown
`shipping_details_valid`	Unknown
`tax_rate_amount`	Unknown
`tax_rate_country`	Unknown
`tax_rate_id`	Unknown
`tax_rate_included_in_price`	Unknown
`tax_rate_name`	Unknown
`tax_rate_state`	Unknown
`taxed_price_portions`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`variant_id`	Unknown
`custom_`
`name_`
`product_slug_`

cart_custom_line_item_state

Column	Type	Keys
`index`	Unknown	PK
`cart_custom_line_item_id`	Unknown	PKFK
`quantity`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown

cart_custom_line_item

Column	Type	Keys
`id`	Unknown	PK
`cart_id`	Unknown	PKFK
`money_cent_amount`	Unknown
`money_currency_code`	Unknown
`money_fraction_digits`	Unknown
`money_precise_amount`	Unknown
`money_type`	Unknown
`price_mode`	Unknown
`quantity`	Unknown
`slug`	Unknown
`tax_category_id`	Unknown
`tax_category_type_id`	Unknown
`tax_rate_amount`	Unknown
`tax_rate_country`	Unknown
`tax_rate_id`	Unknown
`tax_rate_included_in_price`	Unknown
`tax_rate_name`	Unknown
`tax_rate_state`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`custom_`
`name_`

cart_shipping

Column	Type	Keys
`shipping_key`	Unknown	PK
`cart_id`	Unknown	PKFK
`shipping_info_pricecent_amount`	Unknown
`shipping_info_pricecurrency_code`	Unknown
`shipping_info_pricefraction_digits`	Unknown
`shipping_info_priceprecise_amount`	Unknown
`shipping_info_pricetype`	Unknown
`shipping_info_shipping_method_id`	Unknown
`shipping_info_shipping_method_name`	Unknown
`shipping_info_shipping_method_type_id`	Unknown
`shipping_info_tax_category_id`	Unknown
`shipping_info_tax_category_type_id`	Unknown
`shipping_rate_input_key`	Unknown
`shipping_rate_input_label`	Unknown
`shipping_rate_input_score`	Unknown
`shipping_rate_input_type`	Unknown
`custom_`

cart_item_shipping_address

Column	Type	Keys
`index`	Unknown	PK
`cart_id`	Unknown	PKFK
`id`	Unknown	FK

cart

Column	Type	Keys
`id`	Unknown	PK
`billing_address_id`	Unknown	FK
`customer_id`	Unknown	FK
`shipping_address_id`	Unknown	FK
`anonymous_id`	Unknown
`cart_state`	Unknown
`country`	Unknown
`created_at`	Unknown
`customer_email`	Unknown
`customer_group_id`	Unknown
`customer_group_type_id`	Unknown
`delete_days_after_last_modification`	Unknown
`inventory_mode`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`locale`	Unknown
`origin`	Unknown
`shipping_mode`	Unknown
`shipping_rate_inputkey`	Unknown
`shipping_rate_inputlabel`	Unknown
`shipping_rate_inputtype`	Unknown
`store_id`	Unknown
`store_type_id`	Unknown
`tax_calculation_mode`	Unknown
`tax_mode`	Unknown
`tax_rounding_mode`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`taxed_shipping_price_total_gross_cent_amount`	Unknown
`taxed_shipping_price_total_gross_currency_code`	Unknown
`taxed_shipping_price_total_gross_fraction_digits`	Unknown
`taxed_shipping_price_total_gross_type`	Unknown
`taxed_shipping_price_total_net_cent_amount`	Unknown
`taxed_shipping_price_total_net_currency_code`	Unknown
`taxed_shipping_price_total_net_fraction_digits`	Unknown
`taxed_shipping_price_total_net_type`	Unknown
`taxed_shipping_price_total_tax_cent_amount`	Unknown
`taxed_shipping_price_total_tax_currency_code`	Unknown
`taxed_shipping_price_total_tax_fraction_digits`	Unknown
`taxed_shipping_price_total_tax_type`	Unknown
`total_line_item_quantity`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`version`	Unknown
`custom_`

payment_transaction

Column	Type	Keys
`id`	Unknown	PK
`payment_id`	Unknown	PKFK
`amount_cent_amount`	Unknown
`amount_currency_code`	Unknown
`amount_fraction_digits`	Unknown
`amount_type`	Unknown
`interaction_id`	Unknown
`state`	Unknown
`transaction_timestamp`	Unknown
`type`	Unknown
`custom_`

payment_interface_interaction

Column	Type	Keys
`index`	Unknown	PK
`payment_id`	Unknown	PKFK
`custom_`

payment

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`amount_planned_cent_amount`	Unknown
`amount_planned_currency_code`	Unknown
`amount_planned_fraction_digits`	Unknown
`amount_planned_type`	Unknown
`anonymous_id`	Unknown
`created_at`	Unknown
`customer_type_id`	Unknown
`interface_id`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`payment_method_info_method`	Unknown
`payment_method_info_payment_interface`	Unknown
`payment_status_interface_code`	Unknown
`payment_status_interface_text`	Unknown
`payment_status_state_id`	Unknown
`payment_status_state_type_id`	Unknown
`version`	Unknown
`custom_`
`payment_method_info_name_`

order_line_item_state

Column	Type	Keys
`index`	Unknown	PK
`order_line_item_id`	Unknown	PKFK
`quantity`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown

order_line_item

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	PKFK
`product_id`	Unknown	FK
`variant_id`	Unknown	FK
`added_at`	Unknown
`inventory_mode`	Unknown
`last_modified_at`	Unknown
`line_item_mode`	Unknown
`price_country`	Unknown
`price_id`	Unknown
`price_key`	Unknown
`price_mode`	Unknown
`price_valid_from`	Unknown
`price_valid_until`	Unknown
`price_value_cent_amount`	Unknown
`price_value_currency_code`	Unknown
`price_value_fraction_digits`	Unknown
`price_value_precise_amount`	Unknown
`price_value_type`	Unknown
`product_key`	Unknown
`product_type_id`	Unknown
`product_type_type_id`	Unknown
`quantity`	Unknown
`shipping_details_targets`	Unknown
`shipping_details_valid`	Unknown
`tax_rate_amount`	Unknown
`tax_rate_country`	Unknown
`tax_rate_id`	Unknown
`tax_rate_included_in_price`	Unknown
`tax_rate_name`	Unknown
`tax_rate_state`	Unknown
`taxed_price_portions`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`custom_`
`name_`
`product_slug_`

order_custom_line_item_state

Column	Type	Keys
`index`	Unknown	PK
`order_custom_line_item_id`	Unknown	PKFK
`quantity`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown

order_custom_line_item

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	PKFK
`money_cent_amount`	Unknown
`money_currency_code`	Unknown
`money_fraction_digits`	Unknown
`money_precise_amount`	Unknown
`money_type`	Unknown
`price_mode`	Unknown
`quantity`	Unknown
`slug`	Unknown
`tax_category_id`	Unknown
`tax_category_type_id`	Unknown
`tax_rate_amount`	Unknown
`tax_rate_country`	Unknown
`tax_rate_id`	Unknown
`tax_rate_included_in_price`	Unknown
`tax_rate_name`	Unknown
`tax_rate_state`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`custom_`
`name_`

order_shipping

Column	Type	Keys
`shipping_key`	Unknown	PK
`orders_id`	Unknown	PKFK
`shipping_info_pricecent_amount`	Unknown
`shipping_info_pricecurrency_code`	Unknown
`shipping_info_pricefraction_digits`	Unknown
`shipping_info_priceprecise_amount`	Unknown
`shipping_info_pricetype`	Unknown
`shipping_info_shipping_method_id`	Unknown
`shipping_info_shipping_method_name`	Unknown
`shipping_info_shipping_method_type_id`	Unknown
`shipping_info_tax_category_id`	Unknown
`shipping_info_tax_category_type_id`	Unknown
`shipping_rate_input_key`	Unknown
`shipping_rate_input_label`	Unknown
`shipping_rate_input_score`	Unknown
`shipping_rate_input_type`	Unknown
`custom_`

order_sync_info

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`channel_id`	Unknown	FK
`channel_type_id`	Unknown
`external_id`	Unknown
`synced_at`	Unknown

order_return_info_items

Column	Type	Keys
`id`	Unknown	PK
`order_return_info_index`	Unknown	PKFK
`order_return_info_order_id`	Unknown	PKFK
`comment`	Unknown
`created_at`	Unknown
`last_modified_at`	Unknown
`line_item_id`	Unknown
`payment_state`	Unknown
`quantity`	Unknown
`shipment_state`	Unknown
`type`	Unknown

order_return_info

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`return_date`	Unknown
`return_tracking_id`	Unknown

order_discount_code

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`discount_code_id`	Unknown
`discount_code_type_id`	Unknown
`state`	Unknown

order_payment_info

Column	Type	Keys
`id`	Unknown	PKFK
`orders_id`	Unknown	PKFK
`type_id`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`business_unit_key`	Unknown	FK
`cart_id`	Unknown	FK
`customer_group_id`	Unknown	FK
`customer_id`	Unknown	FK
`anonymous_id`	Unknown
`billing_address_additional_address_info`	Unknown
`billing_address_additional_street_info`	Unknown
`billing_address_apartment`	Unknown
`billing_address_building`	Unknown
`billing_address_city`	Unknown
`billing_address_company`	Unknown
`billing_address_country`	Unknown
`billing_address_department`	Unknown
`billing_address_email`	Unknown
`billing_address_external_id`	Unknown
`billing_address_fax`	Unknown
`billing_address_first_name`	Unknown
`billing_address_id`	Unknown
`billing_address_key`	Unknown
`billing_address_last_name`	Unknown
`billing_address_mobile`	Unknown
`billing_address_phone`	Unknown
`billing_address_po_box`	Unknown
`billing_address_postal_code`	Unknown
`billing_address_region`	Unknown
`billing_address_salutation`	Unknown
`billing_address_state`	Unknown
`billing_address_street_name`	Unknown
`billing_address_street_number`	Unknown
`billing_address_title`	Unknown
`business_unit_type_id`	Unknown
`cart_type_id`	Unknown
`completed_at`	Unknown
`country`	Unknown
`created_at`	Unknown
`customer_email`	Unknown
`customer_group_type_id`	Unknown
`inventory_mode`	Unknown
`last_modified_at`	Instant
`locale`	Unknown
`order_number`	Unknown
`order_state`	Unknown
`origin`	Unknown
`payment_state`	Unknown
`quote_id`	Unknown
`quote_type_id`	Unknown
`shipment_state`	Unknown
`shipping_address_additional_address_info`	Unknown
`shipping_address_additional_street_info`	Unknown
`shipping_address_apartment`	Unknown
`shipping_address_building`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company`	Unknown
`shipping_address_country`	Unknown
`shipping_address_department`	Unknown
`shipping_address_email`	Unknown
`shipping_address_external_id`	Unknown
`shipping_address_fax`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_id`	Unknown
`shipping_address_key`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_mobile`	Unknown
`shipping_address_phone`	Unknown
`shipping_address_po_box`	Unknown
`shipping_address_postal_code`	Unknown
`shipping_address_region`	Unknown
`shipping_address_salutation`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street_name`	Unknown
`shipping_address_street_number`	Unknown
`shipping_address_title`	Unknown
`shipping_info_pricecent_amount`	Unknown
`shipping_info_pricecurrency_code`	Unknown
`shipping_info_pricefraction_digits`	Unknown
`shipping_info_priceprecise_amount`	Unknown
`shipping_info_pricetype`	Unknown
`shipping_info_shipping_method_id`	Unknown
`shipping_info_shipping_method_name`	Unknown
`shipping_info_shipping_method_type_id`	Unknown
`shipping_info_tax_category_id`	Unknown
`shipping_info_tax_category_type_id`	Unknown
`shipping_mode`	Unknown
`shipping_rate_input`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown
`store_key`	Unknown
`store_type_id`	Unknown
`tax_calculation_mode`	Unknown
`tax_mode`	Unknown
`tax_rounding_mode`	Unknown
`taxed_price_total_gross_cent_amount`	Unknown
`taxed_price_total_gross_currency_code`	Unknown
`taxed_price_total_gross_fraction_digits`	Unknown
`taxed_price_total_gross_type`	Unknown
`taxed_price_total_net_cent_amount`	Unknown
`taxed_price_total_net_currency_code`	Unknown
`taxed_price_total_net_fraction_digits`	Unknown
`taxed_price_total_net_type`	Unknown
`taxed_price_total_tax_cent_amount`	Unknown
`taxed_price_total_tax_currency_code`	Unknown
`taxed_price_total_tax_fraction_digits`	Unknown
`taxed_price_total_tax_type`	Unknown
`taxed_shipping_price_total_gross_cent_amount`	Unknown
`taxed_shipping_price_total_gross_currency_code`	Unknown
`taxed_shipping_price_total_gross_fraction_digits`	Unknown
`taxed_shipping_price_total_gross_type`	Unknown
`taxed_shipping_price_total_net_cent_amount`	Unknown
`taxed_shipping_price_total_net_currency_code`	Unknown
`taxed_shipping_price_total_net_fraction_digits`	Unknown
`taxed_shipping_price_total_net_type`	Unknown
`taxed_shipping_price_total_tax_cent_amount`	Unknown
`taxed_shipping_price_total_tax_currency_code`	Unknown
`taxed_shipping_price_total_tax_fraction_digits`	Unknown
`taxed_shipping_price_total_tax_type`	Unknown
`total_price_cent_amount`	Unknown
`total_price_currency_code`	Unknown
`total_price_fraction_digits`	Unknown
`total_price_type`	Unknown
`version`	Unknown
`custom_`

inventory

Column	Type	Keys
`id`	Unknown	PK
`available_quantity`	Unknown
`created_at`	Unknown
`expected_delivery`	Unknown
`key`	Unknown
`last_message_sequence_number`	Unknown
`last_modified_at`	Instant
`quantity_on_stock`	Unknown
`restockable_in_days`	Unknown
`sku`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`custom_`

product_category

Column	Type	Keys
`category_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

product_variant_image

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_variant_id`	Unknown	PKFK
`dimensions_h`	Unknown
`dimensions_w`	Unknown
`label`	Unknown
`url`	Unknown

product_variant_price_tier

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_variant_prices_id`	Unknown	PKFK
`minimum_quantity`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown

product_variant_prices

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`product_variant_id`	Unknown	PKFK
`country`	Unknown
`customer_group_id`	Unknown
`customer_group_type_id`	Unknown
`key`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown
`custom_`

product_variant_attribute

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`product_variant_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

product_variant

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`available_quantity`	Unknown
`channels`	Unknown
`is_matching_variant`	Unknown
`is_on_stock`	Unknown
`key`	Unknown
`restockable_in_days`	Unknown
`scoped_price_country`	Unknown
`scoped_price_current_value_cent_amount`	Unknown
`scoped_price_current_value_currency_code`	Unknown
`scoped_price_current_value_fraction_digits`	Unknown
`scoped_price_current_value_precise_amount`	Unknown
`scoped_price_current_value_type`	Unknown
`scoped_price_customer_group_id`	Unknown
`scoped_price_customer_group_type_id`	Unknown
`scoped_price_discounted`	Unknown
`scoped_price_id`	Unknown
`scoped_price_valid_from`	Unknown
`scoped_price_valid_until`	Unknown
`scoped_price_value_cent_amount`	Unknown
`scoped_price_value_currency_code`	Unknown
`scoped_price_value_fraction_digits`	Unknown
`scoped_price_value_precise_amount`	Unknown
`scoped_price_value_type`	Unknown
`sku`	Unknown

master_variant_image

Column	Type	Keys
`index`	Unknown	PK
`master_variant_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`dimensions_h`	Unknown
`dimensions_w`	Unknown
`label`	Unknown
`url`	Unknown

master_variant_asset_source

Column	Type	Keys
`index`	Unknown	PK
`master_variant_asset_id`	Unknown	PKFK
`master_variant_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`content_type`	Unknown
`dimensions_h`	Unknown
`dimensions_w`	Unknown
`uri`	Unknown

master_variant_asset

Column	Type	Keys
`id`	Unknown	PK
`master_variant_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`description`	Unknown
`key`	Unknown
`name`	Unknown
`tags`	Json
`custom_`

master_variant_price_tier

Column	Type	Keys
`index`	Unknown	PK
`master_variant_id`	Unknown	PKFK
`master_variant_price_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`minimum_quantity`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown

master_variant_price

Column	Type	Keys
`id`	Unknown	PK
`master_variant_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`channel_id`	Unknown	FK
`channel_type_id`	Unknown
`country`	Unknown
`customer_group_id`	Unknown
`customer_group_type_id`	Unknown
`discounted_value_cent_amount`	Unknown
`discounted_value_currency_code`	Unknown
`discounted_value_fraction_digits`	Unknown
`discounted_value_precise_amount`	Unknown
`discounted_value_type`	Unknown
`key`	Unknown
`valid_from`	Unknown
`valid_until`	Unknown
`value_cent_amount`	Unknown
`value_currency_code`	Unknown
`value_fraction_digits`	Unknown
`value_precise_amount`	Unknown
`value_type`	Unknown
`custom_`

master_variant_attribute

Column	Type	Keys
`index`	Unknown	PK
`master_variant_id`	Unknown	PKFK
`product_id`	Unknown	PKFK
`name`	Unknown
`value`	Unknown

master_variant

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`inventory_id`	Unknown	FK
`available_quantity`	Unknown
`channels`	Json
`is_matching_variant`	Unknown
`is_on_stock`	Unknown
`key`	Unknown
`restockable_in_days`	Unknown
`scoped_price_country`	Unknown
`scoped_price_current_value_cent_amount`	Unknown
`scoped_price_current_value_currency_code`	Unknown
`scoped_price_current_value_fraction_digits`	Unknown
`scoped_price_current_value_precise_amount`	Unknown
`scoped_price_current_value_type`	Unknown
`scoped_price_customer_group_id`	Unknown
`scoped_price_customer_group_type_id`	Unknown
`scoped_price_discount_id`	Unknown
`scoped_price_discount_obj`	Json
`scoped_price_discount_type_id`	Unknown
`scoped_price_discounted`	Unknown
`scoped_price_discounted_value_cent_amount`	Unknown
`scoped_price_discounted_value_currency_code`	Unknown
`scoped_price_discounted_value_fraction_digits`	Unknown
`scoped_price_discounted_value_precise_amount`	Unknown
`scoped_price_discounted_value_type`	Unknown
`scoped_price_id`	Unknown
`scoped_price_valid_from`	Unknown
`scoped_price_valid_until`	Unknown
`scoped_price_value_cent_amount`	Unknown
`scoped_price_value_currency_code`	Unknown
`scoped_price_value_fraction_digits`	Unknown
`scoped_price_value_precise_amount`	Unknown
`scoped_price_value_type`	Unknown
`sku`	Unknown
`custom_`

product

Column	Type	Keys
`id`	Unknown	PK
`tax_category_id`	Unknown	FK
`created_at`	Unknown
`current_category_order_hints`	Unknown
`current_published`	Unknown
`has_staged_changes`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`price_mode`	Unknown
`product_type_id`	Unknown
`product_type_type_id`	Unknown
`published`	Unknown
`review_rating_statistics_average_rating`	Unknown
`review_rating_statistics_count`	Unknown
`review_rating_statistics_highest_rating`	Unknown
`review_rating_statistics_lowest_rating`	Unknown
`review_rating_statistics_ratings_distribution`	Unknown
`state_id`	Unknown
`state_type_id`	Unknown
`tax_category_type_id`	Unknown
`version`	Unknown
`current_description_`
`current_meta_description_`
`current_meta_keywords_`
`current_meta_title_`
`current_name_`
`current_slug_`

customer_address

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	PKFK
`additional_address_info`	Unknown
`additional_street_info`	Unknown
`apartment`	Unknown
`building`	Unknown
`city`	Unknown
`company`	Unknown
`country`	Unknown
`department`	Unknown
`email`	Unknown
`external_id`	Unknown
`fax`	Unknown
`first_name`	Unknown
`key`	Unknown
`last_name`	Unknown
`mobile`	Unknown
`phone`	Unknown
`po_box`	Unknown
`postal_code`	Unknown
`region`	Unknown
`salutation`	Unknown
`state`	Unknown
`street_name`	Unknown
`street_number`	Unknown
`title`	Unknown

customer_store

Column	Type	Keys
`key`	Unknown	PK
`customer_id`	Unknown	PKFK
`type_id`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`customer_group_id`	Unknown	FK
`company_name`	Unknown
`created_at`	Unknown
`customer_group_type_id`	Unknown
`customer_number`	Unknown
`date_of_birth`	Unknown
`default_billing_address_id`	Unknown
`default_shipping_address_id`	Unknown
`email`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`is_email_verified`	Unknown
`key`	Unknown
`last_modified_at`	Instant
`last_name`	Unknown
`locale`	Unknown
`middle_name`	Unknown
`password`	Unknown
`salutation`	Unknown
`title`	Unknown
`vat_id`	Unknown
`version`	Unknown
`custom_`

Column	Type	Keys
`id`	Unknown	PK
`assets`	Unknown
`created_at`	Unknown
`key`	Unknown
`last_message_sequence_number`	Unknown
`last_modified_at`	Instant
`orders_hint`	Unknown
`parent_id`	String
`parent_type_id`	Unknown
`version`	Unknown
`version_modified_at`	Unknown
`custom_`
`description_`
`meta_description_`
`meta_keywords_`
`meta_title_`
`name_`
`slug_`