# Centra schema ERD

Table and field reference for the Fivetran Centra connector.

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

### shipment_allocation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| shipment_id | Unknown | PK, FK |
| shipment_line_id | Unknown | PK, FK |
| 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 | PK, FK |
| shipment_line_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| shipment_id | Unknown | PK, FK |

### shipment_return

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| shipment_id | Unknown | PK, FK |

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

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

### country_state

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| country_id | Unknown | PK, FK |
| code | Unknown |  |
| name | Unknown |  |

### market_assigned_to_country

| Column | Type | Keys |
| --- | --- | --- |
| country_id | Unknown | PK, FK |
| market_id | Unknown | PK, FK |

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

### campaign_variant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| orders_attribute_index | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| market_id | Unknown | PK, FK |

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

### invoice_line

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

### category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| store_id | Unknown | FK |
| display_sort_type | Unknown |  |
| is_top_category | Unknown |  |
| meta_description | Unknown |  |
| meta_keywords | Unknown |  |
| meta_title | Unknown |  |
| name | Unknown |  |
| status | 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 | PK, FK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| customer_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- pricelist_price(product_variant_id) → product_variant(id)
- pricelist_price(product_id) → product(id)
- pricelist_price(pricelist_id) → pricelist(id)
- product_size_stock(warehouse_id) → warehouse(id)
- product_size_stock(product_size_id) → product_size(id)
- voucher(store_id) → store(id)
- product_category(category_id) → category(id)
- product_category(product_id) → product(id)
- voucher_usage(order_id) → orders(id)
- voucher_usage(voucher_id) → voucher(id)
- shipment_invoice_line(id) → invoice_line(id)
- shipment_invoice_line(shipment_line_id) → shipment_line(id)
- shipment_invoice_line(shipment_id) → shipment_line(shipment_id)
- shipment_allocation(warehouse_id) → warehouse(id)
- shipment_allocation(shipment_id) → shipment_line(shipment_id)
- shipment_allocation(shipment_line_id) → shipment_line(id)
- shipment_applied_tax_rule(shipment_id) → shipment_line(shipment_id)
- shipment_applied_tax_rule(shipment_line_id) → shipment_line(id)
- shipment_line(order_line_id) → order_line(id)
- shipment_line(shipment_id) → shipment(id)
- shipment_invoice(id) → invoice(id)
- shipment_invoice(shipment_id) → shipment(id)
- shipment_return(id) → return(id)
- shipment_return(shipment_id) → shipment(id)
- shipment(order_id) → orders(id)
- shipment(store_id) → store(id)
- shipment(shipping_address_country_id) → country(id)
- product_variant_display(product_variant_id) → product_variant(id)
- product_variant_media(product_variant_id) → product_variant(id)
- product_variant(product_id) → product(id)
- store_brand(brand_id) → brand(id)
- store_brand(store_id) → store(id)
- product_size(product_variant_id) → product_variant(id)
- warehouse(brick_and_mortar_id) → brick_and_mortar(id)
- warehouse(state_id) → country_state(id)
- warehouse(country_id) → country(id)
- market_campaign(campaign_id) → campaign(id)
- market_campaign(market_id) → market(id)
- country_state(country_id) → country(id)
- market_assigned_to_country(country_id) → country(id)
- market_assigned_to_country(market_id) → market(id)
- market(store_id) → store(id)
- brick_and_mortar_store(store_id) → store(id)
- brick_and_mortar_store(brick_and_mortar_id) → brick_and_mortar(id)
- campaign_variant(campaign_id) → campaign(id)
- order_line(product_size_id) → product_size(id)
- order_line(line_campaign_id) → campaign(id)
- order_line(order_id) → orders(id)
- orders_attribute_element(order_id) → orders_attribute(order_id)
- orders_attribute_element(orders_attribute_index) → orders_attribute(index)
- orders_attribute(order_id) → orders(id)
- orders(shipping_address_country_id) → country(id)
- orders(store_id) → store(id)
- orders(customer_id) → customer(id)
- orders(billing_address_country_id) → country(id)
- orders(billing_address_state_id) → country_state(id)
- orders(shipping_address_state_id) → country_state(id)
- lowest_price_market(market_id) → market(id)
- lowest_price_market(lowest_price_fivetran_id) → lowest_price(_fivetran_id)
- lowest_price(product_variant_id) → product_variant(id)
- lowest_price(pricelist_id) → pricelist(id)
- newsletter_subscription(store_id) → store(id)
- newsletter_subscription(product_variant_id) → product_variant(id)
- newsletter_subscription(product_size_id) → product_size(id)
- invoice_payment(invoice_id) → invoice(id)
- product_attribute_element(product_id) → product_attribute(product_id)
- product_attribute_element(product_attribute_index) → product_attribute(index)
- product_attribute(product_id) → product(id)
- product(brand_id) → brand(id)
- customer_order(order_id) → orders(id)
- customer_order(customer_id) → customer(id)
- invoice_line(order_line_id) → order_line(id)
- invoice_line(invoice_id) → invoice(id)
- invoice(account_id) → account(id)
- invoice(state_id) → country_state(id)
- brick_and_mortar(state_id) → country_state(id)
- affiliate(store_id) → store(id)
- category(store_id) → store(id)
- return(order_id) → orders(id)
- return(store_id) → store(id)
- account_attribute_element(account_id) → account_attribute(account_id)
- account_attribute_element(account_attribute_index) → account_attribute(index)
- account_attribute(account_id) → account(id)
- account(account_address_state_id) → country_state(id)
- account(billing_address_state_id) → country_state(id)
- customer_attribute_element(customer_id) → customer_attribute(customer_id)
- customer_attribute_element(customer_attribute_index) → customer_attribute(index)
- customer_attribute(customer_id) → customer(id)
- customer(store_id) → store(id)
- customer(billing_state_id) → country_state(id)