Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CONFIGURABLE_PRODUCTS ⇱
id 🔑
product_id 🔑 ▶ PRODUCT
attribute_set_id
created_at
name
price
sku
status
type_id
updated_at
visibility
weight
ADOBESTOCK ⇱
id 🔑
category_id ▶ CATEGORY
category_name
creation_date
creator_id
creator_name
is_licensed
media_gallery_id
PRODUCT_LINK ⇱
index 🔑
product_id 🔑 ▶ PRODUCT
extension_attributes_qty
link_type
linked_product_sku
linked_product_type
position
sku
PRODUCT_OPTION_VALUE ⇱
index 🔑
product_option_option_id 🔑 ▶ PRODUCT_OPTION.option_id
option_type_id
price
price_type
sku
sort_order
title
PRODUCT_OPTION ⇱
option_id 🔑
product_id 🔑 ▶ PRODUCT
file_extension
image_size_x
image_size_y
is_require
max_characters
price
price_type
product_sku
sku
sort_order
title
type
PRODUCT_MEDIA_GALLERY_ENTRY ⇱
id 🔑
product_id 🔑 ▶ PRODUCT
content_base_64_encoded_data
content_name
content_type
disabled
extension_attributes_video_content_media_type
extension_attributes_video_content_video_description
extension_attributes_video_content_video_metadata
extension_attributes_video_content_video_provider
extension_attributes_video_content_video_title
extension_attributes_video_content_video_url
file
label
media_type
position
types
PRODUCT_TIER_PRICE ⇱
index 🔑
product_id 🔑 ▶ PRODUCT
customer_group_id
extension_attributes_percentage_value
extension_attributes_website_id
qty
value
PRODUCT_BUNDLE_PRODUCT_OPTION ⇱
option_id 🔑
product_id 🔑 ▶ PRODUCT
position
required
sku
title
type
PRODUCT ⇱
id 🔑
attribute_set_id
created_at
custom_attributes
name
price
sku
status
type_id
updated_at
visibility
weight
custom_*
CATEGORY ⇱
id 🔑
parent_id ▶ CATEGORY
available_sort_by
children
created_at
custom_attributes
include_in_menu
is_active
level
name
path
position
updated_at
custom_*
PRODUCT_BUNDLE_PRODUCTS ⇱
id 🔑
product_id 🔑 ▶ PRODUCT
option_id ▶ PRODUCT_OPTION.option_id
can_change_quantity
is_default
position
price
price_type
qty
sku
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
SHIPMENT_ITEM ⇱
entity_id 🔑
shipment_entity_id 🔑 ▶ SHIPMENT
order_item_id ▶ ORDER_ITEM
parent_id ▶ SHIPMENT_ITEM
product_id ▶ PRODUCT
additional_data
description
name
price
qty
row_total
sku
weight
SHIPMENT_TRACK ⇱
entity_id 🔑
shipment_entity_id 🔑 ▶ SHIPMENT
parent_id ▶ SHIPMENT_TRACK
carrier_code
created_at
description
qty
title
track_number
updated_at
weight
SHIPMENT_COMMENT ⇱
entity_id 🔑
shipment_entity_id 🔑 ▶ SHIPMENT
parent_id ▶ SHIPMENT_COMMENT
comment
created_at
is_customer_notified
is_visible_on_front
SHIPMENT ⇱
entity_id 🔑
billing_address_id ▶ CUSTOMER_ADDRESS
customer_id ▶ CUSTOMER
order_id ▶ ORDERS
shipping_address_id ▶ CUSTOMER_ADDRESS
store_id ▶ STORE
created_at
email_sent
extension_attributes_source_code
increment_id
shipment_status
shipping_label
total_qty
total_weight
updated_at
TRANSACTION ⇱
id 🔑
order_id ▶ ORDERS
parent_id ▶ TRANSACTION
additional_information
created_at
is_closed
parent_txn_id
payment_id
txn_id
txn_type
INVOICE_ITEM ⇱
index 🔑
invoice_entity_id 🔑 ▶ INVOICE
parent_id ▶ INVOICE_ITEM
additional_data
base_cost
base_discount_amount
base_discount_tax_compensation_amount
base_price
base_price_incl_tax
base_row_total
base_row_total_incl_tax
base_tax_amount
description
discount_amount
discount_tax_compensation_amount
entity_id
name
order_item_id
price
price_incl_tax
product_id
qty
row_total
row_total_incl_tax
sku
tax_amount
INVOICE_COMMENT ⇱
index 🔑
invoice_entity_id 🔑 ▶ INVOICE
parent_id ▶ INVOICE_COMMENT
comment
created_at
entity_id
is_customer_notified
is_visible_on_front
INVOICE ⇱
entity_id 🔑
order_id ▶ ORDERS
store_id ▶ STORE
transaction_id ▶ TRANSACTION
base_currency_code
base_discount_amount
base_discount_tax_compensation_amount
base_grand_total
base_shipping_amount
base_shipping_discount_tax_compensation_amnt
base_shipping_incl_tax
base_shipping_tax_amount
base_subtotal
base_subtotal_incl_tax
base_tax_amount
base_to_global_rate
base_to_order_rate
base_total_refunded
billing_address_id
can_void_flag
created_at
discount_amount
discount_description
discount_tax_compensation_amount
email_sent
global_currency_code
grand_total
increment_id
is_used_for_refund
order_currency_code
shipping_address_id
shipping_amount
shipping_discount_tax_compensation_amount
shipping_incl_tax
shipping_tax_amount
state
store_currency_code
store_to_base_rate
store_to_order_rate
subtotal
subtotal_incl_tax
tax_amount
total_qty
updated_at
extension_attributes_*
RETURN_ITEM ⇱
entity_id 🔑
return_entity_id 🔑 ▶ RETURN
condition
order_item_id
qty_approved
qty_authorized
qty_requested
qty_returned
reason
resolution
rma_entity_id
status
RETURN_COMMENT ⇱
entity_id 🔑
return_entity_id 🔑 ▶ RETURN
admin
comment
created_at
custom_attributes
customer_notified
rma_entity_id
visible_on_front
custom_*
RETURN_TRACK ⇱
entity_id 🔑
return_entity_id 🔑 ▶ RETURN
carrier_code
carrier_title
qty_approved
rma_entity_id
track_number
RETURN ⇱
entity_id 🔑
customer_id ▶ CUSTOMER
order_id ▶ ORDERS
store_id ▶ STORE
custom_attributes
customer_custom_email
date_requested
increment_id
order_increment_id
status
custom_*
ORDER_STATUS_HISTORY ⇱
entity_id 🔑
orders_entity_id 🔑 ▶ ORDERS
parent_id ▶ ORDER_STATUS_HISTORY
comment
created_at
entity_name
is_customer_notified
is_visible_on_front
status
ORDER_ITEM ⇱
item_id 🔑
orders_entity_id 🔑 ▶ ORDERS
product_id ▶ PRODUCT
additional_data
amount_refunded
applied_rule_ids
base_amount_refunded
base_cost
base_original_price
base_price
base_price_incl_tax
base_row_invoiced
base_row_total
base_row_total_incl_tax
base_tax_amount
base_tax_before_discount
base_tax_invoiced
base_tax_refunded
created_at
description
discount_amount
discount_invoiced
discount_percent
discount_refunded
event_id
ext_order_item_id
free_shipping
gw_base_price
gw_base_price_invoiced
gw_base_price_refunded
gw_base_tax_amount
gw_base_tax_amount_invoiced
gw_base_tax_amount_refunded
gw_id
gw_price
gw_price_invoiced
gw_price_refunded
gw_tax_amount
gw_tax_amount_invoiced
gw_tax_amount_refunded
is_qty_decimal
is_virtual
locked_do_invoice
locked_do_ship
name
no_discount
order_id
original_price
parent_item_id
price
price_incl_tax
product_type
qty_backordered
qty_canceled
qty_invoiced
qty_ordered
qty_refunded
qty_returned
qty_shipped
quote_item_id
row_invoiced
row_total
row_total_incl_tax
row_weight
sku
store_id
updated_at
weee_tax_applied
weee_tax_applied_amount
weee_tax_applied_row_amount
weee_tax_disposition
weee_tax_row_disposition
weight
base_discount_*
base_weee_tax_*
discount_tax_*
tax_*
ORDERS ⇱
entity_id 🔑
billing_address_id ▶ CUSTOMER_ADDRESS
customer_id ▶ CUSTOMER
store_id ▶ STORE
adjustment_negative
adjustment_positive
applied_rule_ids
base_adjustment_negative
base_adjustment_positive
base_currency_code
base_grand_total
base_subtotal
base_subtotal_canceled
base_subtotal_incl_tax
base_subtotal_invoiced
base_subtotal_refunded
base_tax_amount
base_tax_canceled
base_tax_invoiced
base_tax_refunded
base_to_global_rate
base_to_order_rate
can_ship_partially
can_ship_partially_item
coupon_code
created_at
discount_amount
discount_canceled
discount_description
discount_invoiced
discount_refunded
discount_tax_compensation_amount
discount_tax_compensation_invoiced
discount_tax_compensation_refunded
edit_increment
email_sent
ext_customer_id
ext_order_id
forced_shipment_with_invoice
global_currency_code
grand_total
hold_before_state
hold_before_status
increment_id
is_virtual
order_currency_code
original_increment_id
protect_code
quote_address_id
quote_id
relation_child_id
relation_child_real_id
relation_parent_id
relation_parent_real_id
remote_ip
shipping_amount
shipping_canceled
shipping_description
shipping_discount_amount
shipping_discount_tax_compensation_amount
shipping_incl_tax
shipping_invoiced
shipping_refunded
shipping_tax_amount
shipping_tax_refunded
state
status
store_currency_code
store_to_base_rate
store_to_order_rate
subtotal
subtotal_canceled
subtotal_incl_tax
subtotal_invoiced
subtotal_refunded
tax_amount
tax_canceled
tax_invoiced
tax_refunded
total_canceled
total_due
total_invoiced
total_item_count
total_offline_refunded
total_online_refunded
total_paid
total_qty_ordered
total_refunded
updated_at
weight
x_forwarded_for
base_discount_*
base_shipping_*
base_total_*
extension_attributes_*
payment_*
STORE ⇱
id 🔑
code
is_active
name
store_group_id
website_id
CREDIT_MEMO_ITEM ⇱
entity_id 🔑
credit_memo_entity_id 🔑 ▶ CREDIT_MEMO
parent_id ▶ CREDIT_MEMO_ITEM
additional_data
base_cost
base_discount_amount
base_discount_tax_compensation_amount
base_price
base_price_incl_tax
base_row_total
base_row_total_incl_tax
base_tax_amount
base_weee_tax_applied_amount
base_weee_tax_applied_row_amnt
base_weee_tax_disposition
base_weee_tax_row_disposition
description
discount_amount
discount_tax_compensation_amount
name
order_item_id
price
price_incl_tax
product_id
qty
row_total
row_total_incl_tax
sku
tax_amount
weee_tax_applied
weee_tax_applied_amount
weee_tax_applied_row_amount
weee_tax_disposition
weee_tax_row_disposition
CREDIT_MEMO_COMMENT ⇱
entity_id 🔑
credit_memo_entity_id 🔑 ▶ CREDIT_MEMO
parent_id ▶ CREDIT_MEMO_COMMENT
comment
created_at
is_customer_notified
is_visible_on_front
CREDIT_MEMO ⇱
entity_id 🔑
invoice_id ▶ INVOICE
order_id ▶ ORDERS
store_id ▶ STORE
transaction_id ▶ TRANSACTION
adjustment
adjustment_negative
adjustment_positive
base_adjustment
base_adjustment_negative
base_adjustment_positive
base_currency_code
base_customer_balance_amount
base_discount_amount
base_discount_tax_compensation_amount
base_gift_cards_amount
base_grand_total
base_shipping_amount
base_shipping_discount_tax_compensation_amnt
base_shipping_incl_tax
base_shipping_tax_amount
base_subtotal
base_subtotal_incl_tax
base_tax_amount
base_to_global_rate
base_to_order_rate
billing_address_id
created_at
creditmemo_status
customer_balance_amount
discount_amount
discount_description
discount_tax_compensation_amount
email_sent
gift_cards_amount
global_currency_code
grand_total
gw_base_price
gw_base_tax_amount
gw_card_base_price
gw_card_price
gw_items_base_price
gw_items_price
gw_price
increment_id
order_currency_code
shipping_address_id
shipping_amount
shipping_discount_tax_compensation_amount
shipping_incl_tax
shipping_tax_amount
state
store_currency_code
store_to_base_rate
store_to_order_rate
subtotal
subtotal_incl_tax
tax_amount
updated_at
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
CUSTOMER_GROUP ⇱
id 🔑
code
extension_attributes_exclude_website_ids
tax_class_id
tax_class_name
DIRECTORY_COUNTRY_AVAILABLE_REGION ⇱
id 🔑
directory_country_id 🔑 ▶ DIRECTORY_COUNTRY
code
name
DIRECTORY_COUNTRY ⇱
id 🔑
full_name_english
full_name_locale
three_letter_abbreviation
two_letter_abbreviation
COMPANY_CREDIT ⇱
id 🔑
company_id ▶ COMPANY
available_limit
balance
credit_limit
currency_code
exceed_limit
CUSTOMER_ADDRESS ⇱
id 🔑
customer_id 🔑 ▶ CUSTOMER
country_id ▶ DIRECTORY_COUNTRY
region_id ▶ DIRECTORY_COUNTRY_AVAILABLE_REGION.id
city
company
custom_attributes
default_billing
default_shipping
fax
first_name
last_name
middle_name
postcode
prefix
street
suffix
telephone
vat_id
custom_*
CUSTOMER ⇱
id 🔑
group_id ▶ CUSTOMER_GROUP
store_id ▶ STORE
assistance_allowed
confirmation
created_at
created_in
custom_attributes
default_billing
default_shipping
disable_auto_group_change
dob
first_name
gender
is_subscribed
last_name
middle_name
prefix
suffix
tax_vat
updated_at
website_id
company_attributes_*
custom_*
COMPANY ⇱
id 🔑
country_id ▶ DIRECTORY_COUNTRY_AVAILABLE_REGION.directory_country_id
customer_group_id ▶ CUSTOMER_GROUP
region_id ▶ DIRECTORY_COUNTRY_AVAILABLE_REGION.id
applicable_payment_method
applicable_shipping_method
available_payment_methods
available_shipping_methods
city
comment
company_email
company_name
is_purchase_order_enabled
legal_name
postcode
region
reject_reason
rejected_at
reseller_id
sales_representative_id
status
street
super_user_id
telephone
use_config_settings
use_config_settings_shipping
vat_tax_id
quote_config_*
CART_ITEM_DISCOUNT ⇱
index 🔑
cart_id 🔑 ▶ CART_ITEM.cart_id
cart_item_item_id 🔑 ▶ CART_ITEM.item_id
discount_data
rule_id
rule_label
CART_ITEM ⇱
item_id 🔑
cart_id 🔑 ▶ CART
name
price
product_type
qty
quote_id
sku
negotiable_quote_item_*
CART ⇱
id 🔑
billing_address_id ▶ CUSTOMER_ADDRESS.id
customer_id ▶ CUSTOMER_ADDRESS.customer_id
orig_order_id ▶ ORDERS
reserved_order_id ▶ ORDERS
converted_at
created_at
currency_base_currency_code
currency_base_to_global_rate
currency_base_to_quote_rate
currency_global_currency_code
currency_quote_currency_code
currency_store_currency_code
currency_store_to_base_rate
currency_store_to_quote_rate
customer_is_guest
customer_note
customer_note_notify
customer_tax_class_id
is_active
is_virtual
items_count
items_qty
store_id
updated_at
negotiable_quote_*
Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
COUPON ⇱
coupon_id 🔑
code
created_at
expiration_date
is_primary
rule_id
times_used
type
usage_limit
usage_per_customer
TAX_RULE_TAX_RATE ⇱
tax_rate_id 🔑 ▶ TAX_RATE
tax_rule_id 🔑 ▶ TAX_RULE
TAX_RULE ⇱
id 🔑
calculate_subtotal
code
customer_tax_class_ids
position
priority
product_tax_class_ids
SALES_RULE_STORE_LABELS ⇱
store_id 🔑
sales_rule_rule_id 🔑 ▶ SALES_RULE
store_label
SALES_RULE ⇱
rule_id 🔑
action_condition_aggregator_type
action_condition_attribute_name
action_condition_condition_type
action_condition_conditions
action_condition_operator
action_condition_value
apply_to_shipping
condition_aggregator_type
condition_attribute_name
condition_condition_type
condition_conditions
condition_operator
condition_value
coupon_type
customer_group_ids
description
discount_amount
discount_qty
discount_step
extension_attributes_reward_points_delta
from_date
is_active
is_advanced
is_rss
name
product_ids
simple_action
simple_free_shipping
sort_order
stop_rules_processing
times_used
to_date
use_auto_generation
uses_per_coupon
uses_per_customer
website_ids
TAX_RATE_TITLE ⇱
index 🔑
tax_rate_id 🔑 ▶ TAX_RATE
store_id
value
TAX_RATE ⇱
id 🔑
code
rate
region_name
tax_country_id
tax_postcode
tax_region_id
zip_from
zip_is_range
zip_to
GIFT_WRAPPING ⇱
wrapping_id 🔑
base_currency_code
base_price
design
image_base_64_content
image_name
image_url
status
website_ids
TEAM ⇱
id 🔑
custom_attributes
description
name
custom_*
INVENTORY ⇱
_fivetran_id 🔑
quantity
sku
source_code
status