Centra

Explore the interactive ERD

Table & Field Reference

country

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`continent`	Unknown
`is_eu`	Unknown
`name`	Unknown

pricelist_price

Column	Type	Keys
`id`	Unknown	PK
`pricelist_id`	Unknown	PKFK
`product_id`	Unknown	FK
`product_variant_id`	Unknown	FK
`price_conversion_date`	Unknown
`price_conversion_rate`	Unknown
`price_formatted_value`	Unknown
`price_value`	Unknown
`price_value_in_cents`	Unknown
`recommended_retail_price_conversion_date`	Unknown
`recommended_retail_price_conversion_rate`	Unknown
`recommended_retail_price_formatted_value`	Unknown
`recommended_retail_price_value`	Unknown
`recommended_retail_price_value_in_cents`	Unknown

product_size_stock

Column	Type	Keys
`_fivetran_id`	String	PK
`product_size_id`	Unknown	FK
`warehouse_id`	Unknown	FK
`allocated_quantity`	Unknown
`available_now_quantity`	Unknown
`available_quantity`	Unknown
`demand_quantity`	Unknown
`free_to_allocate_quantity`	Unknown
`incoming_quantity`	Unknown
`linked_incoming_quantity`	Unknown
`on_delivery_quantity`	Unknown
`physical_quantity`	Unknown
`unlinked_incoming_quantity`	Unknown
`unshipped_quantity`	Unknown

voucher

Column	Type	Keys
`id`	Unknown	PK
`store_id`	Unknown	FK
`code`	Unknown
`combine_with_other_discount`	Unknown
`combine_with_other_voucher`	Unknown
`conversion_html`	Unknown
`created_at`	Unknown
`entry_point_strategy`	Unknown
`max_usages`	Unknown
`method`	Unknown
`name`	Unknown
`priority`	Unknown
`reuse`	Unknown
`start_at`	Unknown
`status`	Unknown
`stop_at`	Unknown
`successful_usages`	Unknown
`type`	Unknown
`updated_at`	Unknown
`url`	Unknown

product_category

Column	Type	Keys
`display_id`	Unknown	PK
`category_id`	Unknown	PKFK
`product_id`	Unknown	FK
`canonical_category_id`	Unknown

voucher_usage

Column	Type	Keys
`_fivetran_id`	String	PK
`order_id`	Unknown	FK
`voucher_id`	Unknown	FK
`code`	Unknown
`date`	Unknown
`params_json`	Unknown
`url`	Unknown
`voucher_method`	Unknown
`voucher_name`	Unknown

brand

Column	Type	Keys
`id`	Unknown	PK
`external_id`	Unknown
`name`	Unknown
`uri`	Unknown

mapped_attribute

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown
`object_type`	Unknown

shipment_invoice_line

Column	Type	Keys
`id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK
`shipment_line_id`	Unknown	PKFK

shipment_allocation

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`shipment_line_id`	Unknown	PKFK
`warehouse_id`	Unknown	FK
`is_waiting_for_confirmation`	Unknown
`quantity`	Unknown
`stock_change_line_currency_base_rate`	Unknown
`stock_change_line_delivered_quantity`	Unknown
`stock_change_line_free_to_allocate_quantity`	Unknown
`stock_change_line_id`	Unknown
`stock_change_line_is_available`	Unknown

shipment_applied_tax_rule

Column	Type	Keys
`index`	Unknown	PK
`shipment_id`	Unknown	PKFK
`shipment_line_id`	Unknown	PKFK
`rule_tax_id`	Unknown
`rule_tax_name`	Unknown
`rule_tax_percent`	Unknown
`tax_added_value`	Unknown
`tax_deducted_value`	Unknown
`tax_included_value`	Unknown

shipment_line

Column	Type	Keys
`id`	Unknown	PK
`shipment_id`	Unknown	PKFK
`order_line_id`	Unknown	FK
`invoiced_quantity`	Unknown
`line_value`	Unknown
`quantity`	Unknown
`returned_quantity`	Unknown
`unit_price`	Unknown
`unit_price_conversion_date`	Unknown
`unit_price_conversion_rate`	Unknown
`unit_price_formatted_value`	Unknown
`unit_price_value`	Unknown
`unit_price_value_in_cents`	Unknown

shipment_invoice

Column	Type	Keys
`id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK

shipment_return

Column	Type	Keys
`id`	Unknown	PKFK
`shipment_id`	Unknown	PKFK

shipment

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`shipping_address_country_id`	Unknown	FK
`store_id`	Unknown	FK
`additional_message`	Unknown
`captured_at`	Unknown
`captured_value`	Unknown
`carrier_account_identifier`	Unknown
`carrier_name`	Unknown
`carrier_service_name`	Unknown
`carrier_tax_id`	Unknown
`consignation_warehouse_status`	Unknown
`created_at`	Unknown
`currency_base_rate`	Unknown
`external_id`	Unknown
`grand_total`	Unknown
`internal_shipping_cost`	Unknown
`is_captured`	Unknown
`is_good_to_go`	Unknown
`is_on_hold`	Unknown
`is_paid`	Unknown
`is_printed`	Unknown
`is_shipped`	Unknown
`number`	Unknown
`number_of_packages`	Unknown
`paid_at`	Unknown
`return_tracking_number`	Unknown
`shipment_admin_user_created_at`	Unknown
`shipment_admin_user_email`	Unknown
`shipment_admin_user_external_id`	Unknown
`shipment_admin_user_id`	Unknown
`shipment_admin_user_last_login_at`	Unknown
`shipment_admin_user_last_online_at`	Unknown
`shipment_admin_user_name`	Unknown
`shipment_admin_user_status`	Unknown
`shipment_plugin_external_id`	Unknown
`shipment_plugin_id`	Unknown
`shipment_plugin_name`	Unknown
`shipment_plugin_plugin`	Unknown
`shipment_plugin_status`	Unknown
`shipment_plugin_type`	Unknown
`shipment_plugin_uri`	Unknown
`shipped_at`	Unknown
`shipping_address_address_1`	Unknown
`shipping_address_address_2`	Unknown
`shipping_address_attention`	Unknown
`shipping_address_cell_phone_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company_name`	Unknown
`shipping_address_ec_vat_number`	Unknown
`shipping_address_email`	Unknown
`shipping_address_fax_number`	Unknown
`shipping_address_first_name`	Unknown
`shipping_address_last_name`	Unknown
`shipping_address_phone_number`	Unknown
`shipping_address_state_id`	Unknown
`shipping_address_state_name`	Unknown
`shipping_address_state_or_province`	Unknown
`shipping_address_vat_number`	Unknown
`shipping_address_zip_code`	Unknown
`total_discount`	Unknown
`total_handling_value`	Unknown
`total_line_value`	Unknown
`total_quantity`	Unknown
`total_returned_quantity`	Unknown
`total_shipping_value`	Unknown
`total_tax_added`	Unknown
`total_tax_deducted`	Unknown
`total_tax_included`	Unknown
`tracking_number`	Unknown
`updated_at`	Unknown
`used_fallback_tax`	Unknown

product_variant_display

Column	Type	Keys
`id`	Unknown	PK
`product_variant_id`	Unknown	PKFK
`comment`	Unknown
`description`	Unknown
`meta_description`	Unknown
`meta_keywords`	Unknown
`meta_title`	Unknown
`minimum_order_quantity`	Unknown
`name`	Unknown
`order_quantity_denominator`	Unknown
`short_description`	Unknown
`status`	Unknown
`store_item_id`	Unknown
`tags`	Json
`updated_at`	Unknown
`uri`	Unknown

product_variant_media

Column	Type	Keys
`id`	Unknown	PK
`product_variant_id`	Unknown	PKFK
`metadata`	Json
`source_mime_type`	Unknown
`source_type`	Unknown
`source_url`	Unknown

product_variant

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	FK
`external_id`	Unknown
`internal_name`	Unknown
`name`	Unknown
`status`	Unknown
`stock_offset`	Unknown
`unit_cost_conversion_date`	Unknown
`unit_cost_conversion_rate`	Unknown
`unit_cost_formatted_value`	Unknown
`unit_cost_value`	Unknown
`unit_cost_value_in_cents`	Unknown
`updated_at`	Unknown
`variant_number`	Unknown

store_brand

Column	Type	Keys
`brand_id`	Unknown	PKFK
`store_id`	Unknown	PKFK

product_size

Column	Type	Keys
`id`	Unknown	PK
`product_variant_id`	Unknown	FK
`comment`	Unknown
`description`	Unknown
`ean`	Unknown
`is_active`	Unknown
`preorder`	Unknown
`quantity`	Unknown
`size_number`	Unknown
`sku`	Unknown
`upc`	Unknown
`updated_at`	Unknown

warehouse

Column	Type	Keys
`id`	Unknown	PK
`brick_and_mortar_id`	Unknown	FK
`country_id`	Unknown	FK
`state_id`	Unknown	FK
`address`	Unknown
`address_2`	Unknown
`allocation_policy`	Unknown
`city`	Unknown
`external_id`	Unknown
`is_consignation`	Unknown
`is_hidden_from_stock_view`	Unknown
`name`	Unknown
`status`	Unknown
`stock_master`	Unknown
`stock_ownership`	Unknown
`threshold`	Unknown
`zip_code`	Unknown

market_campaign

Column	Type	Keys
`campaign_id`	Unknown	PKFK
`market_id`	Unknown	PKFK

country_state

Column	Type	Keys
`id`	Unknown	PK
`country_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown

market_assigned_to_country

Column	Type	Keys
`country_id`	Unknown	PKFK
`market_id`	Unknown	PKFK

market

Column	Type	Keys
`id`	Unknown	PK
`store_id`	Unknown	FK
`allocation_rule_id`	Unknown
`allocation_rule_is_active`	Unknown
`allocation_rule_name`	Unknown
`allocation_rule_type`	Unknown
`comment`	Unknown
`external_id`	Unknown
`name`	Unknown
`updated_at`	Unknown

pricelist

Column	Type	Keys
`id`	Unknown	PK
`comment`	Unknown
`is_default_for_currency`	Unknown
`name`	Unknown
`status`	Unknown
`updated_at`	Unknown

brick_and_mortar_store

Column	Type	Keys
`brick_and_mortar_id`	Unknown	PKFK
`store_id`	Unknown	PKFK

campaign_variant

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	PKFK
`created_at`	Unknown
`discount_percent`	Unknown
`show_news`	Unknown
`show_sale`	Unknown
`start_at`	Unknown
`status`	Unknown
`stop_at`	Unknown
`type`	Unknown

campaign

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`status`	Unknown
`updated_at`	Unknown

order_line

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	PKFK
`line_campaign_id`	Unknown	FK
`product_size_id`	Unknown	FK
`cancelled_quantity`	Unknown
`comment`	Unknown
`discount_percent`	Unknown
`external_id`	Unknown
`folder_name`	Unknown
`frontend_item_id`	Unknown
`has_any_discount`	Unknown
`line_campaign_discount_conversion_date`	Unknown
`line_campaign_discount_conversion_rate`	Unknown
`line_campaign_discount_formatted_value`	Unknown
`line_campaign_discount_percent`	Unknown
`line_campaign_discount_value`	Unknown
`line_campaign_discount_value_in_cents`	Unknown
`line_campaign_fixed_price_conversion_date`	Unknown
`line_campaign_fixed_price_conversion_rate`	Unknown
`line_campaign_fixed_price_formatted_value`	Unknown
`line_campaign_fixed_price_value`	Unknown
`line_campaign_fixed_price_value_in_cents`	Unknown
`line_campaign_name`	Unknown
`line_campaign_original_discount_conversion_date`	Unknown
`line_campaign_original_discount_conversion_rate`	Unknown
`line_campaign_original_discount_formatted_value`	Unknown
`line_campaign_original_discount_value`	Unknown
`line_campaign_original_discount_value_in_cents`	Unknown
`line_campaign_show_news`	Unknown
`line_campaign_show_sale`	Unknown
`line_campaign_start_at`	Unknown
`line_campaign_stop_at`	Unknown
`line_campaign_type`	Unknown
`line_value_conversion_date`	Unknown
`line_value_conversion_rate`	Unknown
`line_value_formatted_value`	Unknown
`line_value_value`	Unknown
`line_value_value_in_cents`	Unknown
`product_brand`	Unknown
`product_external_url`	Unknown
`product_name`	Unknown
`product_number`	Unknown
`product_variant_name`	Unknown
`quantity`	Unknown
`returned_quantity`	Unknown
`size`	Unknown
`tax_percent`	Unknown
`unit_original_price_conversion_date`	Unknown
`unit_original_price_conversion_rate`	Unknown
`unit_original_price_formatted_value`	Unknown
`unit_original_price_value`	Unknown
`unit_original_price_value_in_cents`	Unknown
`unit_price_conversion_date`	Unknown
`unit_price_conversion_rate`	Unknown
`unit_price_formatted_value`	Unknown
`unit_price_value`	Unknown
`unit_price_value_in_cents`	Unknown

orders_attribute_element

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`orders_attribute_index`	Unknown	PKFK
`description`	Unknown
`is_multi`	Unknown
`key`	Unknown
`kind`	Unknown
`selected_value`	Unknown
`selected_value_name`	Unknown
`value`	Unknown

orders_attribute

Column	Type	Keys
`index`	Unknown	PK
`order_id`	Unknown	PKFK
`description`	Unknown
`object_type`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`billing_address_country_id`	Unknown	FK
`billing_address_state_id`	Unknown	FK
`customer_id`	Unknown	FK
`shipping_address_country_id`	Unknown	FK
`shipping_address_state_id`	Unknown	FK
`store_id`	Unknown	FK
`allocated_warehouse_count`	Unknown
`billing_address_address_1`	Unknown
`billing_address_address_2`	Unknown
`billing_address_attention`	Unknown
`billing_address_cell_phone_number`	Unknown
`billing_address_city`	Unknown
`billing_address_company_name`	Unknown
`billing_address_ec_vat_number`	Unknown
`billing_address_email`	Unknown
`billing_address_fax_number`	Unknown
`billing_address_firstname`	Unknown
`billing_address_lastname`	Unknown
`billing_address_phone_number`	Unknown
`billing_address_state_or_province`	Unknown
`billing_address_vat_number`	Unknown
`billing_address_zip_code`	Unknown
`created_at`	Unknown
`currency_base_rate`	Unknown
`external_id`	Unknown
`has_pending_allocation_requests`	Unknown
`internal_comment`	Unknown
`is_internal`	Unknown
`is_locked`	Unknown
`is_on_hold`	Unknown
`is_waiting_for_payment`	Unknown
`number`	Unknown
`order_date`	Unknown
`other_comment`	Unknown
`payment_method_external_id`	Unknown
`payment_method_id`	Unknown
`payment_method_name`	Unknown
`payment_method_plugin`	Unknown
`payment_method_status`	Unknown
`payment_method_type`	Unknown
`payment_method_uri`	Unknown
`shipping_address_address_1`	Unknown
`shipping_address_address_2`	Unknown
`shipping_address_attention`	Unknown
`shipping_address_cell_phone_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company_name`	Unknown
`shipping_address_ec_vat_number`	Unknown
`shipping_address_email`	Unknown
`shipping_address_fax_number`	Unknown
`shipping_address_firstname`	Unknown
`shipping_address_lastname`	Unknown
`shipping_address_phone_number`	Unknown
`shipping_address_state_or_province`	Unknown
`shipping_address_vat_number`	Unknown
`shipping_address_zip_code`	Unknown
`status`	Unknown
`tax_breakdown_description`	Unknown
`tax_breakdown_tax_included`	Unknown
`tax_breakdown_tax_percent`	Unknown
`tax_conversion_date`	Unknown
`tax_conversion_rate`	Unknown
`tax_formatted_value`	Unknown
`tax_value`	Unknown
`tax_value_in_cents`	Unknown
`total_cancelled_quantity`	Unknown
`total_discount_conversion_date`	Unknown
`total_discount_conversion_rate`	Unknown
`total_discount_formatted_value`	Unknown
`total_discount_value`	Unknown
`total_discount_value_in_cents`	Unknown
`total_handling_conversion_date`	Unknown
`total_handling_conversion_rate`	Unknown
`total_handling_formatted_value`	Unknown
`total_handling_value`	Unknown
`total_handling_value_in_cents`	Unknown
`total_line_conversion_date`	Unknown
`total_line_conversion_rate`	Unknown
`total_line_formatted_value`	Unknown
`total_line_value`	Unknown
`total_line_value_in_cents`	Unknown
`total_original_quantity`	Unknown
`total_quantity`	Unknown
`total_shipping_conversion_date`	Unknown
`total_shipping_conversion_rate`	Unknown
`total_shipping_formatted_value`	Unknown
`total_shipping_value`	Unknown
`total_shipping_value_in_cents`	Unknown
`total_tax_added_conversion_date`	Unknown
`total_tax_added_conversion_rate`	Unknown
`total_tax_added_formatted_value`	Unknown
`total_tax_added_value`	Unknown
`total_tax_added_value_in_cents`	Unknown
`total_tax_deducted_conversion_date`	Unknown
`total_tax_deducted_conversion_rate`	Unknown
`total_tax_deducted_formatted_value`	Unknown
`total_tax_deducted_value`	Unknown
`total_tax_deducted_value_in_cents`	Unknown
`total_tax_included_conversion_date`	Unknown
`total_tax_included_conversion_rate`	Unknown
`total_tax_included_formatted_value`	Unknown
`total_tax_included_value`	Unknown
`total_tax_included_value_in_cents`	Unknown
`total_unexpedited_quantity`	Unknown
`updated_at`	Unknown
`user_ip`	Unknown

lowest_price_market

Column	Type	Keys
`lowest_price_fivetran_id`	Unknown	PKFK
`market_id`	Unknown	PKFK

lowest_price

Column	Type	Keys
`_fivetran_id`	String	PK
`pricelist_id`	Unknown	FK
`product_variant_id`	Unknown	FK
`original_price_conversion_date`	Unknown
`original_price_conversion_rate`	Unknown
`original_price_formatted_value`	Unknown
`original_price_value`	Unknown
`original_price_value_in_cents`	Unknown
`price_conversion_date`	Unknown
`price_conversion_rate`	Unknown
`price_formatted_value`	Unknown
`price_value`	Unknown
`price_value_in_cents`	Unknown
`start_date`	Unknown

newsletter_subscription

Column	Type	Keys
`id`	Unknown	PK
`product_size_id`	Unknown	FK
`product_variant_id`	Unknown	FK
`store_id`	Unknown	FK
`created_at`	Unknown
`email`	Unknown
`is_active`	Unknown

invoice_payment

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	FK
`created_at`	Unknown
`payment_date`	Unknown
`type`	Unknown
`value_conversion_date`	Unknown
`value_conversion_rate`	Unknown
`value_formatted_value`	Unknown
`value_value`	Unknown
`value_value_in_cents`	Unknown

product_attribute_element

Column	Type	Keys
`index`	Unknown	PK
`product_attribute_index`	Unknown	PKFK
`product_id`	Unknown	PKFK
`description`	Unknown
`is_multi`	Unknown
`key`	Unknown
`kind`	Unknown
`selected_value`	Unknown
`selected_value_name`	Unknown
`value`	Unknown

product_attribute

Column	Type	Keys
`index`	Unknown	PK
`product_id`	Unknown	PKFK
`description`	Unknown
`object_type`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`brand_id`	Unknown	FK
`created_at`	Unknown
`external_id`	Unknown
`harmonized_commodity_code`	Unknown
`harmonized_commodity_code_description`	Unknown
`internal_comment`	Unknown
`is_bundle`	Unknown
`is_serializable_product`	Unknown
`name`	Unknown
`number`	Unknown
`status`	Unknown
`updated_at`	Unknown
`weight`	Unknown
`weight_formatted_value`	Unknown
`weight_unit`	Unknown
`weight_value`	Unknown

store

Column	Type	Keys
`id`	Unknown	PK
`allocation_rule_id`	Unknown
`allocation_rule_is_active`	Unknown
`allocation_rule_name`	Unknown
`allocation_rule_type`	Unknown
`name`	Unknown
`type`	Unknown

customer_order

Column	Type	Keys
`customer_id`	Unknown	PKFK
`order_id`	Unknown	PKFK

invoice_line

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	PKFK
`order_line_id`	Unknown	FK
`brand_name`	Unknown
`discount_percent`	Unknown
`harmonized_commodity_code`	Unknown
`harmonized_commodity_description`	Unknown
`product_name`	Unknown
`product_number`	Unknown
`product_variant_name`	Unknown
`quantity`	Unknown
`size`	Unknown
`tax_percent`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`state_id`	Unknown	FK
`additional_information`	Unknown
`billing_address_1`	Unknown
`billing_address_2`	Unknown
`billing_address_attention`	Unknown
`billing_address_cell_phone_number`	Unknown
`billing_address_city`	Unknown
`billing_address_company_name`	Unknown
`billing_address_ec_vat_number`	Unknown
`billing_address_email`	Unknown
`billing_address_fax_number`	Unknown
`billing_address_firstname`	Unknown
`billing_address_lastname`	Unknown
`billing_address_phone_number`	Unknown
`billing_address_state_or_province`	Unknown
`billing_address_vat_number`	Unknown
`billing_address_zip_code`	Unknown
`commissionconversion_date`	Unknown
`commissionconversion_rate`	Unknown
`commissionformatted_value`	Unknown
`commissionvalue`	Unknown
`commissionvalue_in_cents`	Unknown
`company_registration_number`	Unknown
`created_at`	Unknown
`currency_base_rate`	Unknown
`discount_conversion_date`	Unknown
`discount_conversion_rate`	Unknown
`discount_formatted_value`	Unknown
`discount_value`	Unknown
`discount_value_in_cents`	Unknown
`due_date`	Unknown
`external_id`	Unknown
`is_overdue`	Unknown
`line_values_conversion_date`	Unknown
`line_values_conversion_rate`	Unknown
`line_values_formatted_value`	Unknown
`line_values_value`	Unknown
`line_values_value_in_cents`	Unknown
`number`	Unknown
`order_date`	Unknown
`our_reference`	Unknown
`pdf_url`	Unknown
`pre_paid_conversion_date`	Unknown
`pre_paid_conversion_rate`	Unknown
`pre_paid_formatted_value`	Unknown
`pre_paid_value`	Unknown
`pre_paid_value_in_cents`	Unknown
`purchase_order_number`	Unknown
`shipping_address_1`	Unknown
`shipping_address_2`	Unknown
`shipping_address_attention`	Unknown
`shipping_address_cell_phone_number`	Unknown
`shipping_address_city`	Unknown
`shipping_address_company_name`	Unknown
`shipping_address_ec_vat_number`	Unknown
`shipping_address_email`	Unknown
`shipping_address_fax_number`	Unknown
`shipping_address_firstname`	Unknown
`shipping_address_lastname`	Unknown
`shipping_address_phone_number`	Unknown
`shipping_address_state_or_province`	Unknown
`shipping_address_vat_number`	Unknown
`shipping_address_zip_code`	Unknown
`shipping_conversion_date`	Unknown
`shipping_conversion_rate`	Unknown
`shipping_formatted_value`	Unknown
`shipping_value`	Unknown
`shipping_value_in_cents`	Unknown
`status`	Unknown
`tax_added_conversion_date`	Unknown
`tax_added_conversion_rate`	Unknown
`tax_added_formatted_value`	Unknown
`tax_added_value`	Unknown
`tax_added_value_in_cents`	Unknown
`type`	Unknown
`updated_at`	Unknown

brick_and_mortar

Column	Type	Keys
`id`	Unknown	PK
`state_id`	Unknown	FK
`address`	Unknown
`display_name`	Unknown
`email`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`name`	Unknown
`phone_number`	Unknown
`status`	Unknown
`type`	Unknown
`website`	Unknown

affiliate

Column	Type	Keys
`id`	Unknown	PK
`store_id`	Unknown	FK
`html_snippet`	Unknown
`name`	Unknown
`status`	Unknown
`updated_at`	Unknown
`uri`	Unknown

return

Column	Type	Keys
`id`	Unknown	PK
`order_id`	Unknown	FK
`store_id`	Unknown	FK
`comment`	Unknown
`created_at`	Unknown
`created_from`	Unknown
`currency_base_rate`	Unknown
`external_id`	Unknown
`grand_total_formatted_value`	Unknown
`grand_total_value`	Unknown
`grand_total_value_in_cent`	Unknown
`return_status`	Unknown
`returned_to_stock`	Unknown
`total_quantity`	Unknown

account_attribute_element

Column	Type	Keys
`index`	Unknown	PK
`account_attribute_index`	Unknown	PKFK
`account_id`	Unknown	PKFK
`description`	Unknown
`is_multi`	Unknown
`key`	Unknown
`kind`	Unknown
`selected_value`	Unknown
`selected_value_name`	Unknown
`value`	Unknown

account_attribute

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`description`	Unknown
`object_type`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`account_address_state_id`	Unknown	FK
`billing_address_state_id`	Unknown	FK
`account_address_1`	Unknown
`account_address_2`	Unknown
`account_address_attention`	Unknown
`account_address_cell_phone_number`	Unknown
`account_address_city`	Unknown
`account_address_company_name`	Unknown
`account_address_ec_vat_number`	Unknown
`account_address_email`	Unknown
`account_address_fax_number`	Unknown
`account_address_first_name`	Unknown
`account_address_last_name`	Unknown
`account_address_phone_number`	Unknown
`account_address_state_or_province`	Unknown
`account_address_vat_number`	Unknown
`account_address_zip_code`	Unknown
`account_email`	Unknown
`allow_consignation`	Unknown
`apply_credit_limit`	Unknown
`attribute_description`	Unknown
`attribute_object_type`	Unknown
`billing_address_1`	Unknown
`billing_address_2`	Unknown
`billing_address_attention`	Unknown
`billing_address_cell_phone_number`	Unknown
`billing_address_city`	Unknown
`billing_address_company_name`	Unknown
`billing_address_ec_vat_number`	Unknown
`billing_address_email`	Unknown
`billing_address_fax_number`	Unknown
`billing_address_firstname`	Unknown
`billing_address_lastname`	Unknown
`billing_address_phone_number`	Unknown
`billing_address_state_or_province`	Unknown
`billing_address_vat_number`	Unknown
`billing_address_zip_code`	Unknown
`billing_email`	Unknown
`block_if_unpaid_invoices`	Unknown
`carrier_information_account_identifier`	Unknown
`carrier_information_carrier_name`	Unknown
`carrier_information_service_name`	Unknown
`carrier_information_tax_id`	Unknown
`created_at`	Unknown
`discount_percent`	Unknown
`external_id`	Unknown
`has_brands_restriction`	Unknown
`internal_comment`	Unknown
`is_discount_visible`	Unknown
`is_internal`	Unknown
`name`	Unknown
`other_comment`	Unknown
`shipping_email`	Unknown
`status`	Unknown
`updated_at`	Unknown
`vat_number`	Unknown
`website_url`	Unknown

customer_attribute_element

Column	Type	Keys
`index`	Unknown	PK
`customer_attribute_index`	Unknown	PKFK
`customer_id`	Unknown	PKFK
`description`	Unknown
`is_multi`	Unknown
`key`	Unknown
`kind`	Unknown
`selected_value`	Unknown
`selected_value_name`	Unknown
`value`	Unknown

customer_attribute

Column	Type	Keys
`index`	Unknown	PK
`customer_id`	Unknown	PKFK
`description`	Unknown
`object_type`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`billing_state_id`	Unknown	FK
`store_id`	Unknown	FK
`billing_address_1`	Unknown
`billing_address_2`	Unknown
`billing_address_attention`	Unknown
`billing_address_cell_phone_number`	Unknown
`billing_address_city`	Unknown
`billing_address_company_name`	Unknown
`billing_address_ec_vat_number`	Unknown
`billing_address_email`	Unknown
`billing_address_fax_number`	Unknown
`billing_address_firstname`	Unknown
`billing_address_lastname`	Unknown
`billing_address_phone_number`	Unknown
`billing_address_state_or_province`	Unknown
`billing_address_vat_number`	Unknown
`billing_address_zip_code`	Unknown
`birthdate`	Unknown
`created_at`	Unknown
`email`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`gender`	Unknown
`internal_comment`	Unknown
`is_anonymized`	Unknown
`is_registered`	Unknown
`last_login_at`	Unknown
`last_name`	Unknown
`last_online_at`	Unknown
`status`	Unknown
`total_orders`	Unknown
`updated_at`	Unknown
`website_url`	Unknown