Shopware
Explore the interactive ERD
Table & Field Reference
order_delivery_tracking_code
| Column | Type | Keys |
|---|---|---|
tracking_code | Unknown | PK |
order_delivery_id | Unknown | PKFK |
order_delivery_calculated_tax
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_delivery_id | Unknown | FK |
extensions | Json | |
price | Unknown | |
tax | Unknown | |
tax_rate | Unknown |
order_delivery_tax_rule
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_delivery_id | Unknown | FK |
extensions | Json | |
percentage | Unknown | |
tax_rate | Unknown |
order_delivery_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_delivery_id | Unknown | PKFK |
value | Unknown |
order_delivery_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_delivery_id | Unknown | PKFK |
value | Unknown |
order_delivery
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
shipping_method_id | Unknown | FK |
shipping_order_address_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
shipping_costs_extensions | Json | |
shipping_costs_list_price | Unknown | |
shipping_costs_quantity | Unknown | |
shipping_costs_reference_price | Unknown | |
shipping_costs_regulation_price | Unknown | |
shipping_costs_total_price | Unknown | |
shipping_costs_unit_price | Unknown | |
shipping_date_ear_liest | Unknown | |
shipping_date_latest | Unknown | |
shipping_order_address_version_id | Unknown | |
state_id | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
delivery_time_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
delivery_time_id | Unknown | PKFK |
value | Unknown |
delivery_time_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
delivery_time_id | Unknown | PKFK |
value | Unknown |
delivery_time
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
maximum | Unknown | |
minimum | Unknown | |
name | Unknown | |
unit | Unknown | |
updated_at | Unknown |
property_group_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
property_group_id | Unknown | PKFK |
value | Unknown |
property_group_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
property_group_id | Unknown | PKFK |
value | Unknown |
property_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
description | Unknown | |
display_type | Unknown | |
filterable | Unknown | |
name | Unknown | |
position | Unknown | |
sorting_type | Unknown | |
translated_description | Unknown | |
translated_name | Unknown | |
translated_position | Unknown | |
updated_at | Unknown | |
visible_on_product_detail_page | Unknown |
order_line_item_property
| Column | Type | Keys |
|---|---|---|
property_id | Unknown | PK |
order_line_item_id | Unknown | PKFK |
order_line_item_option
| Column | Type | Keys |
|---|---|---|
option_id | Unknown | PK |
order_line_item_id | Unknown | PKFK |
order_line_item_stream
| Column | Type | Keys |
|---|---|---|
stream_id | Unknown | PK |
order_line_item_id | Unknown | PKFK |
order_line_item_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PK |
object_id | Unknown | PKFK |
order_line_item_category
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PK |
order_line_item_id | Unknown | PKFK |
order_line_item_payload_option_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_line_item_payload_option_index | Unknown | PKFK |
order_line_item_payload_option_order_line_item_id | Unknown | PKFK |
value | Unknown |
order_line_item_payload_option
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
order_line_item_id | Unknown | PKFK |
groups | Unknown | |
option | Unknown |
order_line_item_calculated_tax
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_line_item_id | Unknown | FK |
extensions | Json | |
price | Unknown | |
tax | Unknown | |
tax_rate | Unknown |
order_line_item_tax_rule
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_line_item_id | Unknown | FK |
extensions | Json | |
percentage | Unknown | |
tax_rate | Unknown |
order_line_item_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_line_item_id | Unknown | PKFK |
value | Unknown |
order_line_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
parent_id | Unknown | FK |
payload_tax_id | Unknown | FK |
product_id | Unknown | FK |
promotion_id | Unknown | FK |
api_alias | Unknown | |
cover_id | Unknown | |
created_at | Unknown | |
description | Unknown | |
good | Unknown | |
identifier | Unknown | |
label | Unknown | |
parent_version_id | Unknown | |
payload_created_at | Unknown | |
payload_custom_field | Unknown | |
payload_features | Json | |
payload_is_close_out | Unknown | |
payload_is_new | Unknown | |
payload_manufacturer_id | Unknown | |
payload_mark_as_top_seller | Unknown | |
payload_parent_id | Unknown | |
payload_product_number | Unknown | |
payload_purchase_prices | Unknown | |
payload_releasedate | Unknown | |
payload_stock | Unknown | |
position | Unknown | |
price_definition_extensions | Json | |
price_definition_is_calculated | Unknown | |
price_definition_list_price | Unknown | |
price_definition_price | Unknown | |
price_definition_quantity | Unknown | |
price_definition_reference_price_definition | Unknown | |
price_definition_regulation_price | Unknown | |
price_definition_type | Unknown | |
price_extensions | Json | |
price_list_price | Unknown | |
price_quantity | Unknown | |
price_reference_price | Unknown | |
price_regulation_price | Unknown | |
price_total_price | Unknown | |
price_unit_price | Unknown | |
product_version_id | Unknown | |
quantity | Unknown | |
referenced_id | Unknown | |
removable | Unknown | |
stackable | Unknown | |
total_price | Unknown | |
type | Unknown | |
unit_price | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
customer_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PK |
customer_id | Unknown | PKFK |
customer_vat
| Column | Type | Keys |
|---|---|---|
vat_id | Unknown | PK |
customer_id | Unknown | PKFK |
customer_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
customer_id | Unknown | PKFK |
value | Unknown |
customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_billing_address_id | Unknown | FK |
default_payment_method_id | Unknown | FK |
default_shipping_address_id | Unknown | FK |
group_id | Unknown | FK |
language_id | Unknown | FK |
sales_channel_id | Unknown | FK |
active | Unknown | |
affiliate_code | Unknown | |
api_alias | Unknown | |
auto_increment | Unknown | |
birthday | Unknown | |
bound_sales_channel_id | Unknown | |
campaign_code | Unknown | |
company | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
customer_number | Unknown | |
double_opt_in_confirm_date | Unknown | |
double_opt_in_email_sent_date | Unknown | |
double_opt_in_registration | Unknown | |
email | Unknown | |
first_login | Unknown | |
first_name | Unknown | |
guest | Unknown | |
hash | Unknown | |
last_login | Unknown | |
last_name | Unknown | |
last_order_date | Unknown | |
last_payment_method_id | Unknown | |
news_letter | Unknown | |
order_count | Unknown | |
order_total_amount | Unknown | |
remote_address | Unknown | |
requested_group_id | Unknown | |
salutation_id | Unknown | |
title | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown |
promotion_discount
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
promotion_id | Unknown | FK |
api_alias | Unknown | |
applier_key | Unknown | |
consider_advanced_rules | Unknown | |
created_at | Unknown | |
maximum_value | Unknown | |
picker_key | Unknown | |
scope | Unknown | |
sorter_key | Unknown | |
type | Unknown | |
updated_at | Unknown | |
usage_key | Unknown | |
value | Unknown |
order_transaction_calculated_tax
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_transaction_id | Unknown | FK |
extensions | Json | |
price | Unknown | |
tax | Unknown | |
tax_rate | Unknown |
order_transaction_tax_rule
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_transaction_id | Unknown | FK |
extensions | Json | |
percentage | Unknown | |
tax_rate | Unknown |
order_transaction_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_transaction_id | Unknown | PKFK |
value | Unknown |
order_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
payment_method_id | Unknown | FK |
shipping_method_id | Unknown | FK |
state_id | Unknown | FK |
amount_list_price | Unknown | |
amount_quantity | Unknown | |
amount_reference_price | Unknown | |
amount_regulation_price | Unknown | |
amount_total_price | Unknown | |
amount_unit_extensions | Json | |
amount_unit_price | Unknown | |
api_alias | Unknown | |
created_at | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
payment_method_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
payment_method_id | Unknown | PKFK |
value | Unknown |
payment_method_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
payment_method_id | Unknown | PKFK |
value | Unknown |
payment_method
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
availability_rule_id | Unknown | FK |
media_id | Unknown | FK |
active | Unknown | |
after_order_enabled | Unknown | |
api_alias | Unknown | |
asynchronous | Unknown | |
created_at | Unknown | |
description | Unknown | |
distinguishable_name | Unknown | |
formatted_handler_identifier | Unknown | |
handler_identifier | Unknown | |
name | Unknown | |
plugin_id | Unknown | |
position | Unknown | |
prepared | Unknown | |
refundable | Unknown | |
synchronous | Unknown | |
translated_description | Unknown | |
translated_distinguishable_name | Unknown | |
translated_name | Unknown | |
updated_at | Unknown |
user_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
users_id | Unknown | PKFK |
value | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
admin | Unknown | |
api_alias | Unknown | |
avatar_id | Unknown | |
created_at | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
last_updated_password_at | Unknown | |
locale_id | Unknown | |
timezone | Unknown | |
title | Unknown | |
updated_at | Unknown | |
username | Unknown |
order_customer_vat
| Column | Type | Keys |
|---|---|---|
vat_id | Unknown | PK |
order_customer_id | Unknown | PKFK |
order_customer_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_customer_id | Unknown | PKFK |
value | Unknown |
order_customer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
order_id | Unknown | FK |
api_alias | Unknown | |
company | Unknown | |
created_at | Unknown | |
customer_number | Unknown | |
email | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
remote_address | Unknown | |
salutation_id | Unknown | |
title | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
customer_address_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
customer_address_id | Unknown | PKFK |
value | Unknown |
customer_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
customer_id | Unknown | FK |
additional_address_line_1 | Unknown | |
additional_address_line_2 | Unknown | |
api_alias | Unknown | |
city | Unknown | |
company | Unknown | |
country_id | Unknown | |
country_state_id | Unknown | |
created_at | Unknown | |
department | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
phone_number | Unknown | |
salutation_id | Unknown | |
street | Unknown | |
title | Unknown | |
updated_at | Unknown | |
zip_code | Unknown |
analytics
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
active | Unknown | |
anonymize_ip | Unknown | |
api_alias | Unknown | |
created_at | Unknown | |
track_orders | Unknown | |
tracking_id | Unknown | |
updated_at | Unknown |
sales_channel_payment_method
| Column | Type | Keys |
|---|---|---|
payment_method_id | Unknown | PKFK |
sales_channel_id | Unknown | PKFK |
promotion_sales_channel_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
sales_channel_id | Unknown | PKFK |
value | Unknown |
promotion_sales_channel_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
sales_channel_id | Unknown | PKFK |
value | Unknown |
sales_channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
analytics_id | Unknown | FK |
country_id | Unknown | FK |
currency_id | Unknown | FK |
customer_group_id | Unknown | FK |
footer_category_id | Unknown | FK |
language_id | Unknown | FK |
navigation_category_id | Unknown | FK |
payment_method_id | Unknown | FK |
service_category_id | Unknown | FK |
shipping_method_id | Unknown | FK |
access_key | Unknown | |
active | Unknown | |
api_alias | Unknown | |
configuration | Unknown | |
created_at | Unknown | |
footer_category_version_id | Unknown | |
home_cms_page_id | Unknown | |
home_cms_page_version_id | Unknown | |
home_enabled | Unknown | |
home_keywords | Unknown | |
home_meta_description | Unknown | |
home_meta_title | Unknown | |
home_name | Unknown | |
home_slot_config | Unknown | |
hreflang_active | Unknown | |
hreflang_default_domain_id | Unknown | |
mail_header_footer_id | Unknown | |
maintenance | Unknown | |
maintenance_ip_white_list | Unknown | |
name | Unknown | |
navigation_category_depth | Unknown | |
navigation_category_version_id | Unknown | |
service_category_version_id | Unknown | |
short_name | Unknown | |
tax_calculation_type | Unknown | |
translated_home_enabled | Unknown | |
translated_home_keywords | Unknown | |
translated_home_meta_description | Unknown | |
translated_home_meta_title | Unknown | |
translated_home_name | Unknown | |
translated_home_slot_config | Unknown | |
translated_name | Unknown | |
type_id | Unknown | |
updated_at | Unknown |
category_breadcrumb
| Column | Type | Keys |
|---|---|---|
breadcrumb | Unknown | PK |
category_id | Unknown | PKFK |
category_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
category_id | Unknown | PKFK |
value | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
after_category_id | Unknown | FK |
media_id | Unknown | FK |
parent_id | Unknown | FK |
active | Unknown | |
after_category_version_id | Unknown | |
api_alias | Unknown | |
auto_increment | Unknown | |
child_count | Unknown | |
cms_page_id | Unknown | |
cms_page_version_id | Unknown | |
created_at | Unknown | |
description | Unknown | |
display_nested_products | Unknown | |
external_link | Unknown | |
internal_link | Unknown | |
keywords | Unknown | |
level | Unknown | |
link_new_tab | Unknown | |
link_type | Unknown | |
meta_description | Unknown | |
meta_title | Unknown | |
name | Unknown | |
parent_version_id | Unknown | |
path | Unknown | |
product_assignment_type | Unknown | |
product_stream_id | Unknown | |
slot_config | Json | |
translated_description | Unknown | |
translated_external_link | Unknown | |
translated_internal_link | Unknown | |
translated_keywords | Unknown | |
translated_link_new_tab | Unknown | |
translated_link_type | Unknown | |
translated_meta_description | Unknown | |
translated_meta_title | Unknown | |
translated_name | Unknown | |
translated_slot_config | Json | |
type | Unknown | |
updated_at | Unknown | |
version_id | Unknown | |
visible | Unknown |
language_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
languages_id | Unknown | PKFK |
value | Unknown |
languages
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
locale_id | Unknown | |
name | Unknown | |
translation_code_id | Unknown | |
updated_at | Unknown |
manufacturer_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
manufacturer_id | Unknown | PKFK |
value | Unknown |
manufacturer_transalated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
manufacturer_id | Unknown | PKFK |
value | Unknown |
manufacturer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
media_id | Unknown | FK |
apia_lias | Unknown | |
created_at | Unknown | |
description | Unknown | |
link | Unknown | |
name | Unknown | |
translated_description | Unknown | |
translated_name | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
shipping_method_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
shipping_method_id | Unknown | PKFK |
value | Unknown |
shipping_method_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
shipping_method_id | Unknown | PKFK |
value | Unknown |
shipping_method
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
availability_rule_id | Unknown | FK |
delivery_time_id | Unknown | FK |
media_id | Unknown | FK |
tax_id | Unknown | FK |
active | Unknown | |
api_alias | Unknown | |
created_at | Unknown | |
description | Unknown | |
name | Unknown | |
position | Unknown | |
tax_type | Unknown | |
tracking_url | Unknown | |
translated_description | Unknown | |
translated_name | Unknown | |
translated_trackingurl | Unknown | |
updated_at | Unknown |
order_address_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
order_address_id | Unknown | PKFK |
value | Unknown |
order_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
order_id | Unknown | FK |
additional_address_line_1 | Unknown | |
additional_address_line_2 | Unknown | |
api_alias | Unknown | |
city | Unknown | |
company | Unknown | |
country_id | Unknown | |
country_state_id | Unknown | |
created_at | Unknown | |
department | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
phone_number | Unknown | |
salutation_id | Unknown | |
street | Unknown | |
title | Unknown | |
updated_at | Unknown | |
vat_id | Unknown | |
version_id | Unknown | |
zip_code | Unknown |
tax_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
tax_id | Unknown | PKFK |
value | Unknown |
tax
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
name | Unknown | |
position | Unknown | |
tax_rate | Unknown | |
updated_at | Unknown |
country_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
country_id | Unknown | PKFK |
value | Unknown |
country_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
country_id | Unknown | PKFK |
value | Unknown |
country
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_tax_currency_id | Unknown | FK |
customer_tax_currency_id | Unknown | FK |
active | Unknown | |
advanced_postal_code_pattern | Unknown | |
api_alias | Unknown | |
check_advanced_postal_code_pattern | Unknown | |
check_postal_code_pattern | Unknown | |
check_vatid_pattern | Unknown | |
company_tax_amount | Unknown | |
company_tax_enabled | Unknown | |
company_tax_extensions | Json | |
company_tax_free | Unknown | |
created_at | Unknown | |
customer_tax_amount | Unknown | |
customer_tax_enabled | Unknown | |
customer_tax_extensions | Json | |
default_postal_code_pattern | Unknown | |
display_state_in_registration | Unknown | |
force_state_in_registration | Unknown | |
iso | Unknown | |
iso_3 | Unknown | |
name | Unknown | |
position | Unknown | |
postal_code_required | Unknown | |
shippingavailable | Unknown | |
tax_free | Unknown | |
translated_name | Unknown | |
updated_at | Unknown | |
vat_id_pattern | Unknown | |
vat_id_required | Unknown |
product_property
| Column | Type | Keys |
|---|---|---|
property_id | Unknown | PK |
product_id | Unknown | PKFK |
product_option
| Column | Type | Keys |
|---|---|---|
option_id | Unknown | PK |
product_id | Unknown | PKFK |
product_stream
| Column | Type | Keys |
|---|---|---|
stream_id | Unknown | PK |
product_id | Unknown | PKFK |
product_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PK |
product_id | Unknown | PKFK |
product_category
| Column | Type | Keys |
|---|---|---|
category_id | Unknown | PK |
product_id | Unknown | PKFK |
product_attribute_price
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
currency_id | Unknown | FK |
extensions | Json | |
gross | Unknown | |
linked | Unknown | |
list_price | Unknown | |
net | Unknown | |
percentage | Unknown | |
regulation_price | Unknown |
product_attribute_cheapest_price
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
product_id | Unknown | PKFK |
currency_id | Unknown | FK |
extensions | Json | |
gross | Unknown | |
linked | Unknown | |
list_price | Unknown | |
net | Unknown | |
percentage | Unknown | |
regulation_price | Unknown |
product_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
product_id | Unknown | PKFK |
value | Unknown |
product_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
product_id | Unknown | PKFK |
value | Unknown |
product
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
delivery_time_id | Unknown | FK |
manufacturer_id | Unknown | FK |
parent_id | Unknown | FK |
tax_id | Unknown | FK |
active | Unknown | |
api_alias | Unknown | |
auto_increment | Unknown | |
available | Unknown | |
available_stock | Unknown | |
canonical_product_id | Unknown | |
category_tree | Unknown | |
cheapest_price_extensions | Json | |
cheapest_price_hasrange | Unknown | |
cheapest_price_parentid | Unknown | |
cheapest_price_purchase | Unknown | |
cheapest_price_reference | Unknown | |
cheapest_price_rule_id | Unknown | |
cheapest_price_unit_id | Unknown | |
cheapest_price_variant_id | Unknown | |
child_count | Unknown | |
cms_page_id | Unknown | |
cms_page_version_id | Unknown | |
configurator_group_config | Unknown | |
cover_id | Unknown | |
created_at | Unknown | |
custom_field_set_selection_active | Unknown | |
custom_search_keywords | Unknown | |
description | Unknown | |
display_group | Unknown | |
display_parent | Unknown | |
ean | Unknown | |
feature_set_id | Unknown | |
height | Unknown | |
is_closeout | Unknown | |
keywords | Unknown | |
length | Unknown | |
main_variant_id | Unknown | |
manufacturer_number | Unknown | |
mark_as_to_pseller | Unknown | |
maximum_purchase | Unknown | |
meta_description | Unknown | |
meta_title | Unknown | |
minimum_purchase | Unknown | |
name | Unknown | |
pack_unit | Unknown | |
pack_unit_plural | Unknown | |
parent_version_id | Unknown | |
product_manufacturer_version_id | Unknown | |
product_media_version_id | Unknown | |
product_number | Unknown | |
purchase_prices | Unknown | |
purchase_steps | Unknown | |
purchase_unit | Unknown | |
rating_average | Unknown | |
reference_unit | Unknown | |
release_date | Unknown | |
restock_time | Unknown | |
sales | Unknown | |
shipping_free | Unknown | |
slot_config | Unknown | |
stock | Unknown | |
translated_custom_search_keywords | Unknown | |
translated_description | Unknown | |
translated_keywords | Unknown | |
translated_meta_description | Unknown | |
translated_metatitle | Unknown | |
translated_name | Unknown | |
translated_pack_unit | Unknown | |
translated_pack_unit_plural | Unknown | |
translated_slot_config | Unknown | |
unit_id | Unknown | |
updated_at | Unknown | |
variant_listing_config | Unknown | |
variant_restrictions | Unknown | |
version_id | Unknown | |
weight | Unknown | |
width | Unknown |
order_calculated_tax
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_id | Unknown | FK |
extensions | Json | |
price | Unknown | |
tax | Unknown | |
tax_rate | Unknown |
order_tax_rule
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
order_id | Unknown | FK |
extensions | Json | |
percentage | Unknown | |
tax_rate | Unknown |
order_rule
| Column | Type | Keys |
|---|---|---|
order_id | Unknown | PKFK |
rule_id | Unknown | PKFK |
order_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
orders_id | Unknown | PKFK |
value | Unknown |
orders
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
billing_address_id | Unknown | FK |
currency_id | Unknown | FK |
language_id | Unknown | FK |
order_customer_id | Unknown | FK |
sales_channel_id | Unknown | FK |
state_id | Unknown | FK |
affiliate_code | Unknown | |
amount_net | Unknown | |
amount_total | Unknown | |
api_alias | Unknown | |
auto_increment | Unknown | |
billing_address_version_id | Unknown | |
campaign_code | Unknown | |
created_at | Unknown | |
created_by_id | Unknown | |
currency_factor | Unknown | |
customer_comment | Unknown | |
deep_link_code | Unknown | |
item_rounding_decimals | Unknown | |
item_rounding_extension | Json | |
item_rounding_interval | Unknown | |
item_rounding_roundfor_net | Unknown | |
order_date | Unknown | |
order_date_time | Unknown | |
order_number | Unknown | |
position_price | Unknown | |
price_extensions | Json | |
price_net_price | Unknown | |
price_position_price | Unknown | |
price_raw_total | Unknown | |
price_tax_status | Unknown | |
price_total_price | Unknown | |
shipping_costs_list_price | Unknown | |
shipping_costs_quantity | Unknown | |
shipping_costs_reference_price | Unknown | |
shipping_costs_regulation_price | Unknown | |
shipping_costs_total_price | Unknown | |
shipping_costs_unit_price | Unknown | |
shipping_total | Unknown | |
tax_status | Unknown | |
total_rounding_decimals | Unknown | |
total_rounding_extensions | Json | |
total_rounding_interval | Unknown | |
total_rounding_roundfornet | Unknown | |
updated_at | Unknown | |
updated_by_id | Unknown | |
version_id | Unknown |
media_flag
| Column | Type | Keys |
|---|---|---|
flag | Unknown | PK |
media_id | Unknown | PKFK |
media_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
media_id | Unknown | PKFK |
value | Unknown |
media_metadata
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
media_id | Unknown | PKFK |
value | Unknown |
media_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
media_id | Unknown | PKFK |
value | Unknown |
media
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
media_folder_id | Unknown | FK |
user_id | Unknown | FK |
alt | Unknown | |
api_alias | Unknown | |
created_at | Unknown | |
file_extension | Unknown | |
file_name | Unknown | |
file_size | Unknown | |
has_file | Unknown | |
media_type_extensions | Json | |
media_type_name | Unknown | |
mime_type | Unknown | |
private | Unknown | |
title | Unknown | |
translated_alt | Unknown | |
translated_title | Unknown | |
updated_at | Unknown | |
uploaded_at | Unknown | |
url | Unknown |
state_machine_state_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
state_machine_state_id | Unknown | PKFK |
value | Unknown |
state_machine_state_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
state_machine_state_id | Unknown | PKFK |
value | Unknown |
state_machine_state
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
state_machine_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
name | Unknown | |
technical_name | Unknown | |
translated_name | Unknown | |
updated_at | Unknown |
customer_group_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
customer_group_id | Unknown | PKFK |
value | Unknown |
customer_group_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
customer_group_id | Unknown | PKFK |
value | Unknown |
customer_group
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
display_gross | Unknown | |
name | Unknown | |
registration_active | Unknown | |
registration_introduction | Unknown | |
registration_only_company_registration | Unknown | |
registration_seo_meta_description | Unknown | |
registration_title | Unknown | |
translated_name | Unknown | |
translated_registration_only_company_registration | Unknown | |
translated_registration_seo_meta_description | Unknown | |
translated_registration_title | Unknown | |
translated_registrationin_troduction | Unknown | |
updated_at | Unknown |
state_machine_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
state_machine_id | Unknown | PKFK |
value | Unknown |
state_machine_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
state_machine_id | Unknown | PKFK |
value | Unknown |
state_machine
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
initial_state_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
name | Unknown | |
technical_name | Unknown | |
translated_name | Unknown | |
updated_at | Unknown |
product_media_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
product_media_id | Unknown | PKFK |
value | Unknown |
product_media
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
media_id | Unknown | FK |
product_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
position | Unknown | |
product_version_id | Unknown | |
updated_at | Unknown | |
version_id | Unknown |
rule_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
rule_id | Unknown | PKFK |
value | Unknown |
rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
description | Unknown | |
invalid | Unknown | |
module_types | Unknown | |
name | Unknown | |
priority | Unknown | |
updated_at | Unknown |
currency_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
currency_id | Unknown | PKFK |
value | Unknown |
currency_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
currency_id | Unknown | PKFK |
value | Unknown |
currency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
api_alias | Unknown | |
created_at | Unknown | |
factor | Unknown | |
is_system_default | Unknown | |
iso_code | Unknown | |
item_rounding_decimals | Unknown | |
item_rounding_extensions | Json | |
item_rounding_interval | Unknown | |
item_rounding_roundfornet | Unknown | |
name | Unknown | |
position | Unknown | |
short_name | Unknown | |
symbol | Unknown | |
tax_free_from | Unknown | |
total_rounding_decimals | Unknown | |
total_rounding_extensions | Json | |
total_rounding_interval | Unknown | |
total_rounding_roundfornet | Unknown | |
translated_name | Unknown | |
translated_short_name | Unknown | |
updated_at | Unknown |
media_folder_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
media_folder_id | Unknown | PKFK |
value | Unknown |
media_folder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
api_alias | Unknown | |
child_count | Unknown | |
configuration_id | Unknown | |
created_at | Unknown | |
default_folder_id | Unknown | |
name | Unknown | |
path | Unknown | |
updated_at | Unknown | |
use_parent_configuration | Unknown |
promotion_sales_channel
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
promotion_id | Unknown | FK |
sales_channel_id | Unknown | FK |
api_alias | Unknown | |
created_at | Unknown | |
priority | Unknown | |
updated_at | Unknown |
promotion_exclusion
| Column | Type | Keys |
|---|---|---|
exclusion_id | Unknown | PK |
promotion_id | Unknown | PKFK |
promotion_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
promotion_id | Unknown | PKFK |
value | Unknown |
promotion_translated_custom_field
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
promotion_id | Unknown | PKFK |
value | Unknown |
promotion_order_per_customer
| Column | Type | Keys |
|---|---|---|
order_per_customer | Unknown | PK |
promotion_id | Unknown | PKFK |
count | Unknown |
promotion
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
product_id | Unknown | FK |
active | Unknown | |
api_alias | Unknown | |
code | Unknown | |
created_at | Unknown | |
customer_restriction | Unknown | |
exclusive | Unknown | |
individual_code_pattern | Unknown | |
maximum_redemptions_global | Unknown | |
maximum_redemptions_per_customer | Unknown | |
name | Unknown | |
order_count | Unknown | |
prevent_combination | Unknown | |
priority | Unknown | |
translated_name | Unknown | |
updated_at | Unknown | |
use_codes | Unknown | |
use_individual_codes | Unknown | |
use_set_groups | Unknown | |
valid_from | Unknown | |
valid_until | Unknown |