# parcelLab schema ERD

Table and field reference for the Fivetran parcelLab connector.

## Table & Field Reference

### returns_configuration_courier_service_level

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| returns_configuration_courier_mapping_index | Unknown | PK, FK |
| returns_configuration_id | Unknown | PK, FK |
| key | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### returns_configuration_courier_mapping

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| returns_configuration_id | Unknown | PK, FK |
| courier_api_account | Unknown |  |
| courier_api_courier_code | Unknown |  |
| courier_api_has_oauth_credential | Unknown |  |
| courier_api_identifier | Unknown |  |
| courier_api_name | Unknown |  |
| courier_api_service_config | Unknown |  |
| courier_api_service_name | Unknown |  |
| filter | Json |  |

### returns_configuration_returnable_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| returns_configuration_id | Unknown | PK, FK |
| description | Unknown |  |
| filter | Json |  |
| grace_period | Unknown |  |
| grace_period_shipping_date | Unknown |  |
| is_warranty_period | Unknown |  |
| trial_period | Unknown |  |

### returns_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown | FK |
| client | Unknown |  |
| code | Unknown |  |
| returns_order_api | Unknown |  |
| returns_rules | Unknown |  |

### document_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account | Unknown | FK |
| client_key | Unknown |  |
| content | Unknown |  |
| identifier | Unknown |  |
| key | Unknown |  |

### survey_theme

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| background_image | Unknown |  |
| background_image_attachment | Unknown |  |
| background_image_fit | Unknown |  |
| background_opacity | Unknown |  |
| color_palette | Unknown |  |
| css_variables | Json |  |
| header_view | Unknown |  |
| is_panelless | Unknown |  |
| theme_name | Unknown |  |

### order_info_tracking_checkpoint

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_info_tracking_number | Unknown | PK, FK |
| order_number | Unknown | PK, FK |
| courier | Unknown |  |
| delivery_extra_info | Unknown |  |
| delivery_location_type | Unknown |  |
| estimated_delivery_date_end_date | Unknown |  |
| estimated_delivery_date_end_time | Unknown |  |
| estimated_delivery_date_start_date | Unknown |  |
| estimated_delivery_date_start_time | Unknown |  |
| event_timestamp | Unknown |  |
| exception_type | Unknown |  |
| is_hidden | Unknown |  |
| location | Unknown |  |
| next_action | Unknown |  |
| status_code | Unknown |  |
| status_details | Unknown |  |
| status_text | Unknown |  |
| step | Unknown |  |

### order_info_tracking_opening_hours

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_info_tracking_number | Unknown | PK, FK |
| order_number | Unknown | PK, FK |
| close | Unknown |  |
| day | Unknown |  |
| is_open | Unknown |  |

### order_info_tracking_article

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| order_info_tracking_number | Unknown | PK, FK |
| order_number | Unknown | PK, FK |
| additional_attributes | Json |  |
| amount_invoiced | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_image_url | Unknown |  |
| article_name | Unknown |  |
| article_store_url | Unknown |  |
| barcode | Unknown |  |
| color | Unknown |  |
| harmonized_system_code | Unknown |  |
| height | Unknown |  |
| is_bulky | Unknown |  |
| length | Unknown |  |
| length_unit | Unknown |  |
| line_item_id | Unknown |  |
| order_item_id | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| size | Unknown |  |
| sku | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| unit_price_original | Unknown |  |
| variant_id | Unknown |  |
| version | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### order_info_tracking

| Column | Type | Keys |
| --- | --- | --- |
| order_number | Unknown | PK, FK |
| tracking_number | Unknown | PK, FK |
| action_box_address | Unknown |  |
| action_box_label | Unknown |  |
| action_box_label_caption | Unknown |  |
| action_box_label_communication | Unknown |  |
| action_box_raw_earliest_date | Unknown |  |
| action_box_raw_earliest_time | Unknown |  |
| action_box_raw_has_time | Unknown |  |
| action_box_raw_latest_date | Unknown |  |
| action_box_raw_latest_time | Unknown |  |
| action_box_type | Unknown |  |
| additional_attributes | Json |  |
| courier_info_courier | Unknown |  |
| courier_info_courier_name | Unknown |  |
| courier_info_courier_reroute_url | Unknown |  |
| courier_info_courier_tracking_url | Unknown |  |
| courier_info_last_mile_courier | Unknown |  |
| courier_info_last_mile_courier_name | Unknown |  |
| delivery_location | Unknown |  |
| is_delayed | Unknown |  |
| is_exception | Unknown |  |
| last_delivery_delivery_extra_info | Unknown |  |
| last_delivery_event_timestamp | Unknown |  |
| last_delivery_exception_type | Unknown |  |
| last_delivery_icon_hint | Unknown |  |
| last_delivery_lifecycle_status | Unknown |  |
| last_delivery_next_action | Unknown |  |
| last_delivery_status_code | Unknown |  |
| last_delivery_status_details | Unknown |  |
| last_delivery_status_text | Unknown |  |
| last_delivery_step | Unknown |  |
| reporting_contacted_with_message | Json |  |
| reporting_contacted_with_messages | Json |  |
| reporting_courier_dropoff_date | Unknown |  |
| reporting_delivery_date | Unknown |  |
| reporting_exception_message | Json |  |
| reporting_exception_messages | Json |  |
| reporting_has_failed_attempt | Unknown |  |
| reporting_in_transit_date | Unknown |  |
| reporting_is_customer_promise_exceeded | Unknown |  |
| reporting_is_delayed | Unknown |  |
| reporting_is_delayed_dispatch | Unknown |  |
| reporting_is_forgotten | Unknown |  |
| reporting_is_returned | Unknown |  |
| reporting_pickup_date | Unknown |  |
| reporting_returned_date | Unknown |  |
| reporting_trending_late_probability | Unknown |  |
| reporting_trending_late_status | Unknown |  |
| supports_live_refresh | Unknown |  |

### prediction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| courier | Unknown |  |
| courier_alias | Json |  |
| courier_name | Unknown |  |
| courier_service_level | Json |  |
| prediction_cutoff | Unknown |  |
| prediction_cutoff_locale | Unknown |  |
| prediction_earliest_date | Unknown |  |
| prediction_earliest_locale | Unknown |  |
| prediction_latest_date | Unknown |  |
| prediction_latest_locale | Unknown |  |
| prediction_likely | Unknown |  |
| prediction_max | Unknown |  |
| prediction_min | Unknown |  |
| prediction_most_likely_date | Unknown |  |
| prediction_most_likely_locale | Unknown |  |
| prediction_send_date | Unknown |  |
| warehouse | Unknown |  |

### orders_article

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| additional_attributes | Json |  |
| amount_invoiced | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_image_url | Unknown |  |
| article_name | Unknown |  |
| article_store_url | Unknown |  |
| barcode | Unknown |  |
| color | Unknown |  |
| harmonized_system_code | Unknown |  |
| height | Unknown |  |
| is_bulky | Unknown |  |
| length | Unknown |  |
| length_unit | Unknown |  |
| order_item_id | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| other_property | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| size | Unknown |  |
| sku | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| unit_price_original | Unknown |  |
| variant_id | Unknown |  |
| version | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### orders_additional_attribute

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| key | Unknown |  |
| value | Unknown |  |

### orders_mutation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| tracking_number | Unknown | FK |
| cancelled_date | Unknown |  |
| cancelled_reason | Unknown |  |
| current_quantity | Unknown |  |
| line_item | Json |  |
| line_item_id | Unknown |  |
| new_line_item | Json |  |
| old_line_item_id | Unknown |  |
| operation_id | Unknown |  |
| quantity | Unknown |  |
| reason | Unknown |  |
| result | Unknown |  |
| result_errors | Json |  |
| result_message | Unknown |  |
| result_success | Unknown |  |
| result_warning | Json |  |
| tracking_courier | Unknown |  |
| type | Unknown |  |

### orders_tracking_article

| Column | Type | Keys |
| --- | --- | --- |
| line_item_id | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| orders_tracking_index | Unknown | PK, FK |
| amount_invoiced | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_image_url | Unknown |  |
| article_name | Unknown |  |
| article_store_url | Unknown |  |
| barcode | Unknown |  |
| color | Unknown |  |
| harmonized_system_code | Unknown |  |
| height | Unknown |  |
| is_bulky | Unknown |  |
| length | Unknown |  |
| length_unit | Unknown |  |
| order_item_id | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| size | Unknown |  |
| sku | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| unit_price_original | Unknown |  |
| variant_id | Unknown |  |
| version | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### orders_tracking_checkpoint

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| orders_tracking_index | Unknown | PK, FK |
| courier | Unknown |  |
| courier_status | Unknown |  |
| delivery_location | Unknown |  |
| event_timestamp | Unknown |  |
| exception | Json |  |
| message | Unknown |  |
| status_code | Unknown |  |

### orders_tracking

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| orders_external_id | Unknown | PK, FK |
| additional_fields | Unknown |  |
| additional_recipients | Json |  |
| announced_delivery_date | Unknown |  |
| announced_delivery_date_max | Unknown |  |
| announced_delivery_date_min | Unknown |  |
| announced_send_date | Unknown |  |
| cancelled_date | Unknown |  |
| cash_on_delivery_amount | Unknown |  |
| client_key | Unknown |  |
| collection_code_carrier | Unknown |  |
| collection_code_retailer | Unknown |  |
| courier | Unknown |  |
| courier_change_url | Unknown |  |
| courier_contact_email | Unknown |  |
| courier_contact_name | Unknown |  |
| courier_contact_phone | Unknown |  |
| courier_service_level | Unknown |  |
| delivery_method | Unknown |  |
| delivery_number | Unknown |  |
| destination_country_iso_3 | Unknown |  |
| external_reference | Unknown |  |
| flags | Json |  |
| identifiers_consignment | Unknown |  |
| invoice_number | Unknown |  |
| is_dropshipment | Unknown |  |
| is_return | Unknown |  |
| is_returns_portal | Unknown |  |
| language_iso_2 | Unknown |  |
| notifications_inactive | Unknown |  |
| number_of_parcels | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| origin_postal_code | Unknown |  |
| origin_region | Unknown |  |
| pod_date | Unknown |  |
| pod_identifier | Unknown |  |
| pod_signature | Unknown |  |
| recipient_email | Unknown |  |
| recipient_name | Unknown |  |
| recipient_phone | Unknown |  |
| recipient_postal_code | Unknown |  |
| reporting_courier_dropoff_date | Unknown |  |
| reporting_delivery_date | Unknown |  |
| reporting_in_transit_date | Unknown |  |
| reporting_pickup_date | Unknown |  |
| requires_signature | Unknown |  |
| review_link | Unknown |  |
| security_hash | Unknown |  |
| shipping_address_address_line | Unknown |  |
| shipping_address_address_line_extra | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company_name | Unknown |  |
| shipping_address_country_iso_3 | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_region_code | Unknown |  |
| shipping_cost_discount | Unknown |  |
| shipping_cost_net | Unknown |  |
| shipping_cost_total | Unknown |  |
| shipping_dimensions_unit | Unknown |  |
| shipping_height | Unknown |  |
| shipping_length | Unknown |  |
| shipping_volume_total | Unknown |  |
| shipping_volume_unit | Unknown |  |
| shipping_weight_total | Unknown |  |
| shipping_weight_unit | Unknown |  |
| shipping_width | Unknown |  |
| status_link | Unknown |  |
| support_phone | Unknown |  |
| tags | Json |  |
| timezone | Unknown |  |
| tracking_number | Unknown |  |
| transport_number | Unknown |  |
| warehouse | Unknown |  |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| account | Unknown | PK |
| external_id | Unknown | PK |
| additional_recipients | Json |  |
| announced_delivery_date | Unknown |  |
| announced_delivery_date_max | Unknown |  |
| announced_delivery_date_min | Unknown |  |
| billing_address_city | Unknown |  |
| billing_address_company_name | Unknown |  |
| billing_address_country_iso_3 | Unknown |  |
| billing_address_first_name | Unknown |  |
| billing_address_last_name | Unknown |  |
| billing_address_line | Unknown |  |
| billing_address_line_extra | Unknown |  |
| billing_address_phone | Unknown |  |
| billing_address_postal_code | Unknown |  |
| billing_address_region_code | Unknown |  |
| cancelled_date | Unknown |  |
| cancelled_reason | Unknown |  |
| channel | Unknown |  |
| client_key | Unknown |  |
| customer_number | Unknown |  |
| delivery_method | Unknown |  |
| destination_country_iso_3 | Unknown |  |
| external_reference | Unknown |  |
| has_multiple_shipments | Unknown |  |
| invoice_number | Unknown |  |
| language_iso_2 | Unknown |  |
| order_currency | Unknown |  |
| order_date | Unknown |  |
| order_discount_amount | Unknown |  |
| order_net_amount | Unknown |  |
| order_number | Unknown |  |
| order_status | Unknown |  |
| order_tax_amount | Unknown |  |
| order_total_amount | Unknown |  |
| payment_method | Unknown |  |
| payments | Json |  |
| recipient_email | Unknown |  |
| recipient_name | Unknown |  |
| shipping_address_city | Unknown |  |
| shipping_address_company_name | Unknown |  |
| shipping_address_country_iso_3 | Unknown |  |
| shipping_address_first_name | Unknown |  |
| shipping_address_last_name | Unknown |  |
| shipping_address_line | Unknown |  |
| shipping_address_line_extra | Unknown |  |
| shipping_address_phone | Unknown |  |
| shipping_address_postal_code | Unknown |  |
| shipping_address_region_code | Unknown |  |
| tags | Json |  |
| timezone | Unknown |  |

### return_registration_article_order

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| additional_attribute | Json |  |
| amount_invoiced | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_currency | Unknown |  |
| article_image_url | Unknown |  |
| article_name | Unknown |  |
| article_store_url | Unknown |  |
| barcode | Unknown |  |
| color | Unknown |  |
| delivery_no | Unknown |  |
| discount_allocation | Json |  |
| fulfillment_origin_location_id | Unknown |  |
| harmonized_system_code | Unknown |  |
| height | Unknown |  |
| hide_label | Unknown |  |
| is_bulky | Unknown |  |
| is_free_gift_auto_selected | Unknown |  |
| is_non_returnable | Unknown |  |
| length | Unknown |  |
| length_unit | Unknown |  |
| line_item_id | Unknown |  |
| msrp | Unknown |  |
| msrp_delta | Unknown |  |
| non_returnable_final_sale | Unknown |  |
| option_values | Json |  |
| order_item_id | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| original_compensation_method | Unknown |  |
| pretty_condition | Unknown |  |
| pretty_product_id | Unknown |  |
| product_id | Unknown |  |
| properties | Json |  |
| quantity | Unknown |  |
| requires_extra_material | Unknown |  |
| return_reason_path | Unknown |  |
| returned_to_retailer | Unknown |  |
| shopify_fulfillment_line_item_id | Unknown |  |
| shopify_fulfillment_line_items | Json |  |
| shopify_line_item_id | Unknown |  |
| size | Unknown |  |
| size_check | Unknown |  |
| sku | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| unit_price_original | Unknown |  |
| variant_id | Unknown |  |
| variant_id_shopify | Unknown |  |
| vendor | Unknown |  |
| version | Unknown |  |
| warranty | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### return_registration_article_return

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| accepted_quantity | Unknown |  |
| additional_attribute | Json |  |
| amount_invoiced | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_image | Json |  |
| article_image_url | Unknown |  |
| article_name | Unknown |  |
| article_store_url | Unknown |  |
| barcode | Unknown |  |
| color | Unknown |  |
| compensation_method | Unknown |  |
| condition | Unknown |  |
| delivered_date | Unknown |  |
| fulfillment | Unknown |  |
| harmonized_system_code | Unknown |  |
| height | Unknown |  |
| hide_label | Unknown |  |
| is_bulky | Unknown |  |
| length | Unknown |  |
| length_unit | Unknown |  |
| line_item_id | Unknown |  |
| order_item_id | Unknown |  |
| origin_country_iso_3 | Unknown |  |
| problem_description | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| quantity_returned | Unknown |  |
| reference_date_for_return | Unknown |  |
| reference_date_type | Unknown |  |
| rejected_quantity | Unknown |  |
| return_quantity | Unknown |  |
| return_reason | Unknown |  |
| return_reason_code | Unknown |  |
| return_reason_pretty | Unknown |  |
| shopify_return_reason | Unknown |  |
| size | Unknown |  |
| size_check | Unknown |  |
| sku | Unknown |  |
| status_reason | Unknown |  |
| status_reason_code | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| unit_price | Unknown |  |
| unit_price_msrp_current | Unknown |  |
| unit_price_original | Unknown |  |
| variant_id | Unknown |  |
| version | Unknown |  |
| weight | Unknown |  |
| weight_unit | Unknown |  |
| width | Unknown |  |

### return_registration_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| tracking_number | Unknown | FK |
| configuration_id | Unknown |  |
| courier | Unknown |  |
| delivery_status | Unknown |  |
| destination_id | Unknown |  |
| documents | Json |  |
| earliest_pickup_time | Unknown |  |
| external_reference | Unknown |  |
| flags | Json |  |
| is_free_label | Unknown |  |
| is_pickup | Unknown |  |
| label_cost_amount | Unknown |  |
| latest_pickup_time | Unknown |  |
| line_item_ids | Json |  |
| locations_url | Unknown |  |
| pickup_confirmation_code | Unknown |  |
| pickup_date | Unknown |  |
| pickup_time | Unknown |  |
| service_level | Unknown |  |
| tracking_id | Unknown |  |
| type | Unknown |  |

### return_registration_mutation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| destination_address_address_line | Unknown |  |
| destination_address_address_line_extra | Unknown |  |
| destination_address_city | Unknown |  |
| destination_address_company_name | Unknown |  |
| destination_address_country_iso_3 | Unknown |  |
| destination_address_first_name | Unknown |  |
| destination_address_last_name | Unknown |  |
| destination_address_phone | Unknown |  |
| destination_address_postal_code | Unknown |  |
| destination_address_region_code | Unknown |  |
| operation_id | Unknown |  |
| request_additional_fields | Json |  |
| request_courier | Unknown |  |
| request_destination_id | Unknown |  |
| request_flags | Json |  |
| request_label_types | Json |  |
| request_line_item_ids | Json |  |
| request_service_level | Unknown |  |
| request_template_id | Unknown |  |
| request_tracking_number | Unknown |  |
| request_type | Unknown |  |
| result_errors | Json |  |
| result_warning | Json |  |
| success | Unknown |  |
| type | Unknown |  |

### return_registration

| Column | Type | Keys |
| --- | --- | --- |
| external_id | Unknown | PK |
| account | Unknown |  |
| additional_fields | Json |  |
| client_key | Unknown |  |
| code | Unknown |  |
| created_at | Unknown |  |
| customer_address_city | Unknown |  |
| customer_address_company_name | Unknown |  |
| customer_address_country_iso_3 | Unknown |  |
| customer_address_first_name | Unknown |  |
| customer_address_last_name | Unknown |  |
| customer_address_line | Unknown |  |
| customer_address_line_extra | Unknown |  |
| customer_address_phone | Unknown |  |
| customer_address_postal_code | Unknown |  |
| customer_address_region_code | Unknown |  |
| customer_country_iso_3 | Unknown |  |
| customer_email | Unknown |  |
| customer_first_name | Unknown |  |
| customer_last_name | Unknown |  |
| customer_phone | Unknown |  |
| customer_salutation | Unknown |  |
| external_reference | Unknown |  |
| is_gift_returns_portal | Unknown |  |
| language_iso_2 | Unknown |  |
| order_currency | Unknown |  |
| order_date | Unknown |  |
| order_delivery_date | Unknown |  |
| order_payment_method | Json |  |
| order_shipping_amount | Unknown |  |
| order_shipping_date | Unknown |  |
| order_tax_amount | Unknown |  |
| order_total_amount | Unknown |  |
| original_courier | Unknown |  |
| original_order_id | Unknown |  |
| reference | Unknown |  |
| refund_method | Unknown |  |
| sequence_number | Unknown |  |
| status | Unknown |  |
| status_reason | Unknown |  |
| tags | Json |  |
| updated_at | Unknown |  |
| verification_code_used | Unknown |  |
| version | Unknown |  |

### return_registration_article_returnability_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_article_returnability_index | Unknown | PK, FK |
| return_registration_external_id | Unknown | PK, FK |
| code | Unknown |  |
| id | Unknown |  |
| image_upload | Unknown |  |
| name | Unknown |  |
| name_localized | Unknown |  |
| note | Unknown |  |
| note_localized | Unknown |  |
| path | Unknown |  |
| path_segments | Json |  |
| problem_description | Unknown |  |
| problem_description_min_length | Unknown |  |
| shopify_return_reason | Unknown |  |
| tags | Json |  |
| type | Unknown |  |

### return_registration_article_returnability_compensation_method

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_article_returnability_index | Unknown | PK, FK |
| return_registration_external_id | Unknown | PK, FK |
| category | Unknown |  |
| description | Unknown |  |
| description_localized | Unknown |  |
| external_code | Unknown |  |
| tags | Json |  |

### return_registration_article_returnability

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| article_additional_attribute | Json |  |
| article_amount_invoiced | Unknown |  |
| article_article_currency | Unknown |  |
| article_barcode | Unknown |  |
| article_brand | Unknown |  |
| article_category | Unknown |  |
| article_color | Unknown |  |
| article_delivered_date | Unknown |  |
| article_delivery_no | Unknown |  |
| article_discount_allocation | Json |  |
| article_filters | Json |  |
| article_fulfillment | Unknown |  |
| article_fulfillment_origin_location_id | Unknown |  |
| article_harmonized_system_code | Unknown |  |
| article_height | Unknown |  |
| article_hide_label | Unknown |  |
| article_image_url | Unknown |  |
| article_is_bulky | Unknown |  |
| article_is_free_gift_auto_selected | Unknown |  |
| article_is_non_returnable | Unknown |  |
| article_length | Unknown |  |
| article_length_unit | Unknown |  |
| article_line_item_id | Unknown |  |
| article_msrp | Unknown |  |
| article_msrp_delta | Unknown |  |
| article_name | Unknown |  |
| article_option_values | Json |  |
| article_order_item_id | Unknown |  |
| article_origin_country_iso_3 | Unknown |  |
| article_pretty_condition | Unknown |  |
| article_pretty_product_id | Unknown |  |
| article_price | Unknown |  |
| article_price_paid_no_tax | Unknown |  |
| article_price_paid_shop_currency | Unknown |  |
| article_price_paid_shop_currency_no_tax | Unknown |  |
| article_price_shop_currency | Unknown |  |
| article_product_id | Unknown |  |
| article_properties | Json |  |
| article_quantity | Unknown |  |
| article_quantity_returned | Unknown |  |
| article_reference_date_for_return | Unknown |  |
| article_reference_date_type | Unknown |  |
| article_requires_extra_material | Unknown |  |
| article_return_reason_path | Unknown |  |
| article_returned_to_retailer | Unknown |  |
| article_shopify_fulfillment_line_item | Json |  |
| article_shopify_fulfillment_line_item_id | Unknown |  |
| article_shopify_line_item_id | Unknown |  |
| article_size | Unknown |  |
| article_size_check | Unknown |  |
| article_sku | Unknown |  |
| article_store_url | Unknown |  |
| article_tags | Json |  |
| article_tax_amount | Unknown |  |
| article_tracking_number | Json |  |
| article_unit_price | Unknown |  |
| article_unit_price_msrp_current | Unknown |  |
| article_unit_price_original | Unknown |  |
| article_variant_id | Unknown |  |
| article_vendor | Unknown |  |
| article_version | Unknown |  |
| article_warranty | Unknown |  |
| article_weight | Unknown |  |
| article_weight_unit | Unknown |  |
| article_width | Unknown |  |
| grace_period_day | Unknown |  |
| has_compensation | Unknown |  |
| is_in_trial_period | Unknown |  |
| is_in_warranty_period | Unknown |  |
| trial_period_day | Unknown |  |
| warranty_period_day | Unknown |  |

### return_registration_article_selection

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| article_images | Json |  |
| compensation_method | Unknown |  |
| exchange_product_options | Json |  |
| line_item_id | Unknown |  |
| problem_description | Unknown |  |
| return_quantity | Unknown |  |
| return_reason | Unknown |  |
| selected | Unknown |  |

### return_registration_refund_method

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| code | Unknown |  |
| code_localized | Unknown |  |
| hint_localized | Unknown |  |
| type | Unknown |  |

### return_registration_line_items_by_flag_article

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| return_registration_line_items_by_flag_index | Unknown | PK, FK |
| article_name | Unknown |  |
| line_item_id | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### return_registration_line_items_by_flag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| description_localized | Unknown |  |
| flag | Unknown |  |
| title_localized | Unknown |  |

### return_registration_split_group_article

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| return_registration_split_group_index | Unknown | PK, FK |
| article_name | Unknown |  |
| line_item_id | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| sku | Unknown |  |

### return_registration_split_group

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| return_registration_external_id | Unknown | PK, FK |
| display_name | Unknown |  |
| key | Unknown |  |

## Relationships

- returns_configuration_courier_service_level(returns_configuration_courier_mapping_index) → returns_configuration_courier_mapping(index)
- returns_configuration_courier_service_level(returns_configuration_id) → returns_configuration_courier_mapping(returns_configuration_id)
- returns_configuration_courier_mapping(returns_configuration_id) → returns_configuration(id)
- returns_configuration_returnable_period(returns_configuration_id) → returns_configuration(id)
- returns_configuration(account) → orders(account)
- document_template(account) → orders(account)
- order_info_tracking_checkpoint(order_info_tracking_number) → order_info_tracking(tracking_number)
- order_info_tracking_checkpoint(order_number) → order_info_tracking(order_number)
- order_info_tracking_opening_hours(order_info_tracking_number) → order_info_tracking(tracking_number)
- order_info_tracking_opening_hours(order_number) → order_info_tracking(order_number)
- order_info_tracking_article(order_info_tracking_number) → order_info_tracking(tracking_number)
- order_info_tracking_article(order_number) → order_info_tracking(order_number)
- order_info_tracking(tracking_number) → orders_tracking(tracking_number)
- order_info_tracking(order_number) → orders(order_number)
- orders_article(orders_external_id) → orders(external_id)
- orders_additional_attribute(orders_external_id) → orders(external_id)
- orders_mutation(tracking_number) → orders_tracking(tracking_number)
- orders_mutation(orders_external_id) → orders(external_id)
- orders_tracking_article(orders_external_id) → orders_tracking(orders_external_id)
- orders_tracking_article(orders_tracking_index) → orders_tracking(index)
- orders_tracking_checkpoint(orders_external_id) → orders_tracking(orders_external_id)
- orders_tracking_checkpoint(orders_tracking_index) → orders_tracking(index)
- orders_tracking(orders_external_id) → orders(external_id)
- return_registration_article_order(return_registration_external_id) → return_registration(external_id)
- return_registration_article_return(return_registration_external_id) → return_registration(external_id)
- return_registration_label(tracking_number) → orders_tracking(tracking_number)
- return_registration_label(return_registration_external_id) → return_registration(external_id)
- return_registration_mutation(return_registration_external_id) → return_registration(external_id)
- return_registration_article_returnability_reason(return_registration_external_id) → return_registration_article_returnability(return_registration_external_id)
- return_registration_article_returnability_reason(return_registration_article_returnability_index) → return_registration_article_returnability(index)
- return_registration_article_returnability_compensation_method(return_registration_external_id) → return_registration_article_returnability(return_registration_external_id)
- return_registration_article_returnability_compensation_method(return_registration_article_returnability_index) → return_registration_article_returnability(index)
- return_registration_article_returnability(return_registration_external_id) → return_registration(external_id)
- return_registration_article_selection(return_registration_external_id) → return_registration(external_id)
- return_registration_refund_method(return_registration_external_id) → return_registration(external_id)
- return_registration_line_items_by_flag_article(return_registration_line_items_by_flag_index) → return_registration_line_items_by_flag(index)
- return_registration_line_items_by_flag_article(return_registration_external_id) → return_registration_line_items_by_flag(return_registration_external_id)
- return_registration_line_items_by_flag(return_registration_external_id) → return_registration(external_id)
- return_registration_split_group_article(return_registration_split_group_index) → return_registration_split_group(index)
- return_registration_split_group_article(return_registration_external_id) → return_registration_split_group(return_registration_external_id)
- return_registration_split_group(return_registration_external_id) → return_registration(external_id)