Magento2 etc

Magento2 erd

Tables (80)

catalog_product_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity ID

checkout_agreement

  • agreement_id — int(10) — Primary key — NOT NULL — Agreement Id
  • name — varchar(255) — Name
  • content — text — Content
  • content_height — varchar(25) — Content Height
  • checkbox_text — text — Checkbox Text
  • is_active — smallint(6) — NOT NULL — Is Active
  • is_html — smallint(6) — NOT NULL — Is Html
  • mode — smallint(6) — NOT NULL — Applied mode

checkout_agreement_store

  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • agreement_id — int(10) — Foreign key → checkout_agreement.agreement_id — NOT NULL — Agreement Id

customer_entity

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id

directory_country

  • country_id — varchar(2) — Primary key — NOT NULL — Country Id in ISO-2

downloadable_link

  • link_id — int(10) — Primary key — NOT NULL — Link ID
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
  • sort_order — int(10) — NOT NULL — Sort order
  • number_of_downloads — int(11) — Number of downloads
  • is_shareable — smallint(5) — NOT NULL — Shareable flag
  • link_url — varchar(255) — Link Url
  • link_file — varchar(255) — Link File
  • link_type — varchar(20) — Link Type
  • sample_url — varchar(255) — Sample Url
  • sample_file — varchar(255) — Sample File
  • sample_type — varchar(20) — Sample Type

downloadable_link_price

  • price_id — int(10) — Primary key — NOT NULL — Price ID
  • link_id — int(10) — Foreign key → downloadable_link.link_id — NOT NULL — Link ID
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website ID
  • price — decimal(12,4) — NOT NULL — Price

downloadable_link_purchased

  • purchased_id — int(10) — Primary key — NOT NULL — Purchased ID
  • order_id — int(10) — Foreign key → sales_order.entity_id — Order ID
  • order_increment_id — varchar(50) — Order Increment ID
  • order_item_id — int(10) — NOT NULL — Order Item ID
  • created_at — timestamp — NOT NULL — Date of creation
  • updated_at — timestamp — NOT NULL — Date of modification
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer ID
  • product_name — varchar(255) — Product name
  • product_sku — varchar(255) — Product sku
  • link_section_title — varchar(255) — Link_section_title

downloadable_link_purchased_item

  • item_id — int(10) — Primary key — NOT NULL — Item ID
  • purchased_id — int(10) — Foreign key → downloadable_link_purchased.purchased_id — NOT NULL — Purchased ID
  • order_item_id — int(10) — Foreign key → sales_order_item.item_id — Order Item ID
  • product_id — int(10) — Product ID
  • link_hash — varchar(255) — Link hash
  • number_of_downloads_bought — int(10) — NOT NULL — Number of downloads bought
  • number_of_downloads_used — int(10) — NOT NULL — Number of downloads used
  • link_id — int(10) — NOT NULL — Link ID
  • link_title — varchar(255) — Link Title
  • is_shareable — smallint(5) — NOT NULL — Shareable Flag
  • link_url — varchar(255) — Link Url
  • link_file — varchar(255) — Link File
  • link_type — varchar(255) — Link Type
  • status — varchar(50) — Status
  • created_at — timestamp — NOT NULL — Creation Time
  • updated_at — timestamp — NOT NULL — Update Time

downloadable_link_title

  • title_id — int(10) — Primary key — NOT NULL — Title ID
  • link_id — int(10) — Foreign key → downloadable_link.link_id — NOT NULL — Link ID
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store ID
  • title — varchar(255) — Title

downloadable_sample

  • sample_id — int(10) — Primary key — NOT NULL — Sample ID
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product ID
  • sample_url — varchar(255) — Sample URL
  • sample_file — varchar(255) — Sample file
  • sample_type — varchar(20) — Sample Type
  • sort_order — int(10) — NOT NULL — Sort Order

downloadable_sample_title

  • title_id — int(10) — Primary key — NOT NULL — Title ID
  • sample_id — int(10) — Foreign key → downloadable_sample.sample_id — NOT NULL — Sample ID
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store ID
  • title — varchar(255) — Title

eav_attribute

  • attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id

gift_message

  • gift_message_id — int(10) — Primary key — NOT NULL — GiftMessage Id
  • customer_id — int(10) — NOT NULL — Customer id
  • sender — varchar(255) — Sender
  • recipient — varchar(255) — Registrant
  • message — text — Message

integration

  • integration_id — int(10) — Primary key — NOT NULL — Integration ID
  • name — varchar(255) — NOT NULL — Integration name is displayed in the admin interface
  • email — varchar(255) — NOT NULL — Email address of the contact person
  • endpoint — varchar(255) — Endpoint for posting consumer credentials
  • status — smallint(5) — NOT NULL — Integration status
  • consumer_id — int(10) — Foreign key → oauth_consumer.entity_id — Oauth consumer
  • created_at — timestamp — NOT NULL — Creation Time
  • updated_at — timestamp — NOT NULL — Update Time
  • setup_type — smallint(5) — NOT NULL — Integration type - manual or config file
  • identity_link_url — varchar(255) — Identity linking Url

newsletter_problem

  • problem_id — int(10) — Primary key — NOT NULL — Problem Id
  • queue_id — int(10) — Foreign key → newsletter_queue.queue_id — NOT NULL — Queue Id
  • subscriber_id — int(10) — Foreign key → newsletter_subscriber.subscriber_id — Subscriber Id
  • problem_error_code — int(10) — Problem Error Code
  • problem_error_text — varchar(200) — Problem Error Text

newsletter_queue

  • queue_id — int(10) — Primary key — NOT NULL — Queue Id
  • template_id — int(10) — Foreign key → newsletter_template.template_id — NOT NULL — Template ID
  • newsletter_type — int(11) — Newsletter Type
  • newsletter_text — text — Newsletter Text
  • newsletter_styles — text — Newsletter Styles
  • newsletter_subject — varchar(200) — Newsletter Subject
  • newsletter_sender_name — varchar(200) — Newsletter Sender Name
  • newsletter_sender_email — varchar(200) — Newsletter Sender Email
  • queue_status — int(10) — NOT NULL — Queue Status
  • queue_start_at — timestamp — Queue Start At
  • queue_finish_at — timestamp — Queue Finish At

newsletter_queue_link

  • queue_link_id — int(10) — Primary key — NOT NULL — Queue Link Id
  • queue_id — int(10) — Foreign key → newsletter_queue.queue_id — NOT NULL — Queue Id
  • subscriber_id — int(10) — Foreign key → newsletter_subscriber.subscriber_id — NOT NULL — Subscriber Id
  • letter_sent_at — timestamp — Letter Sent At

newsletter_queue_store_link

  • queue_id — int(10) — Foreign key → newsletter_queue.queue_id — NOT NULL — Queue Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id

newsletter_subscriber

  • subscriber_id — int(10) — Primary key — NOT NULL — Subscriber Id
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • change_status_at — timestamp — Change Status At
  • customer_id — int(10) — NOT NULL — Customer Id
  • subscriber_email — varchar(150) — Subscriber Email
  • subscriber_status — int(11) — NOT NULL — Subscriber Status
  • subscriber_confirm_code — varchar(32) — Subscriber Confirm Code

newsletter_template

  • template_id — int(10) — Primary key — NOT NULL — Template ID
  • template_code — varchar(150) — Template Code
  • template_text — text — Template Text
  • template_styles — text — Template Styles
  • template_type — int(10) — Template Type
  • template_subject — varchar(200) — Template Subject
  • template_sender_name — varchar(200) — Template Sender Name
  • template_sender_email — varchar(200) — Template Sender Email
  • template_actual — smallint(5) — Template Actual
  • added_at — timestamp — Added At
  • modified_at — timestamp — Modified At

oauth_consumer

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id

paypal_billing_agreement

  • agreement_id — int(10) — Primary key — NOT NULL — Agreement Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Customer Id
  • method_code — varchar(32) — NOT NULL — Method Code
  • reference_id — varchar(32) — NOT NULL — Reference Id
  • status — varchar(20) — NOT NULL — Status
  • created_at — timestamp — NOT NULL — Created At
  • updated_at — timestamp — Updated At
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • agreement_label — varchar(255) — Agreement Label

paypal_billing_agreement_order

  • order_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Order Id
  • agreement_id — int(10) — Foreign key → paypal_billing_agreement.agreement_id — NOT NULL — Agreement Id

paypal_cert

  • cert_id — smallint(5) — Primary key — NOT NULL — Cert Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website Id
  • content — text — Content
  • updated_at — timestamp — Updated At

paypal_payment_transaction

  • transaction_id — int(10) — Primary key — NOT NULL — Entity Id
  • txn_id — varchar(100) — Txn Id
  • additional_information — blob — Additional Information
  • created_at — timestamp — Created At

paypal_settlement_report

  • report_id — int(10) — Primary key — NOT NULL — Report Id
  • report_date — date — Report Date
  • account_id — varchar(64) — Account Id
  • filename — varchar(24) — Filename
  • last_modified — timestamp — Last Modified

paypal_settlement_report_row

  • row_id — int(10) — Primary key — NOT NULL — Row Id
  • report_id — int(10) — Foreign key → paypal_settlement_report.report_id — NOT NULL — Report Id
  • transaction_id — varchar(19) — Transaction Id
  • invoice_id — varchar(127) — Invoice Id
  • paypal_reference_id — varchar(19) — Paypal Reference Id
  • paypal_reference_id_type — varchar(3) — Paypal Reference Id Type
  • transaction_event_code — varchar(5) — Transaction Event Code
  • transaction_initiation_date — timestamp — Transaction Initiation Date
  • transaction_completion_date — timestamp — Transaction Completion Date
  • transaction_debit_or_credit — varchar(2) — NOT NULL — Transaction Debit Or Credit
  • gross_transaction_amount — decimal(20,6) — NOT NULL — Gross Transaction Amount
  • gross_transaction_currency — varchar(3) — Gross Transaction Currency
  • fee_debit_or_credit — varchar(2) — Fee Debit Or Credit
  • fee_amount — decimal(20,6) — NOT NULL — Fee Amount
  • fee_currency — varchar(3) — Fee Currency
  • custom_field — varchar(255) — Custom Field
  • consumer_id — varchar(127) — Consumer Id
  • payment_tracking_id — varchar(255) — Payment Tracking ID
  • store_id — varchar(50) — Store ID

persistent_session

  • persistent_id — int(10) — Primary key — NOT NULL — Session id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website ID
  • key — varchar(50) — NOT NULL — Unique cookie key
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer id
  • info — text — Session Data
  • updated_at — timestamp — NOT NULL — Updated At

product_alert_price

  • alert_price_id — int(10) — Primary key — NOT NULL — Product alert price id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Customer id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website id
  • price — decimal(12,4) — NOT NULL — Price amount
  • add_date — timestamp — NOT NULL — Product alert add date
  • last_send_date — timestamp — Product alert last send date
  • send_count — smallint(5) — NOT NULL — Product alert send count
  • status — smallint(5) — NOT NULL — Product alert status

product_alert_stock

  • alert_stock_id — int(10) — Primary key — NOT NULL — Product alert stock id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Customer id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website id
  • add_date — timestamp — NOT NULL — Product alert add date
  • send_date — timestamp — Product alert send date
  • send_count — smallint(5) — NOT NULL — Send Count
  • status — smallint(5) — NOT NULL — Product alert status

rating

  • rating_id — smallint(5) — Primary key — NOT NULL — Rating Id
  • entity_id — smallint(5) — Foreign key → rating_entity.entity_id — NOT NULL — Entity Id
  • rating_code — varchar(64) — NOT NULL — Rating Code
  • position — smallint(5) — NOT NULL — Rating Position On Storefront
  • is_active — smallint(6) — NOT NULL — Rating is active.

rating_entity

  • entity_id — smallint(5) — Primary key — NOT NULL — Entity Id
  • entity_code — varchar(64) — NOT NULL — Entity Code

rating_option

  • option_id — int(10) — Primary key — NOT NULL — Rating Option Id
  • rating_id — smallint(5) — Foreign key → rating.rating_id — NOT NULL — Rating Id
  • code — varchar(32) — NOT NULL — Rating Option Code
  • value — smallint(5) — NOT NULL — Rating Option Value
  • position — smallint(5) — NOT NULL — Ration option position on Storefront

rating_option_vote

  • vote_id — bigint(20) — Primary key — NOT NULL — Vote id
  • option_id — int(10) — Foreign key → rating_option.option_id — NOT NULL — Vote option id
  • remote_ip — varchar(16) — NOT NULL — Customer IP
  • remote_ip_long — bigint(20) — NOT NULL — Customer IP converted to long integer format
  • customer_id — int(10) — Customer Id
  • entity_pk_value — bigint(20) — NOT NULL — Product id
  • rating_id — smallint(5) — NOT NULL — Rating id
  • review_id — bigint(20) — Foreign key → review.review_id — Review id
  • percent — smallint(6) — NOT NULL — Percent amount
  • value — smallint(6) — NOT NULL — Vote option value

rating_option_vote_aggregated

  • primary_id — int(11) — Primary key — NOT NULL — Vote aggregation id
  • rating_id — smallint(5) — Foreign key → rating.rating_id — NOT NULL — Rating id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • entity_pk_value — bigint(20) — NOT NULL — Product id
  • vote_count — int(10) — NOT NULL — Vote dty
  • vote_value_sum — int(10) — NOT NULL — General vote sum
  • percent — smallint(6) — NOT NULL — Vote percent
  • percent_approved — smallint(6) — Vote percent approved by admin

rating_store

  • rating_id — smallint(5) — Foreign key → rating.rating_id — NOT NULL — Rating id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store id

rating_title

  • rating_id — smallint(5) — Foreign key → rating.rating_id — NOT NULL — Rating Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • value — varchar(255) — NOT NULL — Rating Label

report_compared_product_index

  • index_id — bigint(20) — Primary key — NOT NULL — Index Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product Id
  • visitor_id — int(10) — Visitor Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer Id
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • added_at — timestamp — NOT NULL — Added At

report_event

  • event_id — bigint(20) — Primary key — NOT NULL — Event Id
  • event_type_id — smallint(5) — Foreign key → report_event_types.event_type_id — NOT NULL — Event Type Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • logged_at — timestamp — NOT NULL — Logged At
  • object_id — int(10) — NOT NULL — Object Id
  • subject_id — int(10) — NOT NULL — Subject Id
  • subtype — smallint(5) — NOT NULL — Subtype

report_event_types

  • event_type_id — smallint(5) — Primary key — NOT NULL — Event Type Id
  • event_name — varchar(64) — NOT NULL — Event Name
  • customer_login — smallint(5) — NOT NULL — Customer Login

report_viewed_product_aggregated_daily

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — Product Id
  • product_name — varchar(255) — Product Name
  • product_price — decimal(12,4) — NOT NULL — Product Price
  • views_num — int(11) — NOT NULL — Number of Views
  • rating_pos — smallint(5) — NOT NULL — Rating Pos

report_viewed_product_aggregated_monthly

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — Product Id
  • product_name — varchar(255) — Product Name
  • product_price — decimal(12,4) — NOT NULL — Product Price
  • views_num — int(11) — NOT NULL — Number of Views
  • rating_pos — smallint(5) — NOT NULL — Rating Pos

report_viewed_product_aggregated_yearly

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — Product Id
  • product_name — varchar(255) — Product Name
  • product_price — decimal(12,4) — NOT NULL — Product Price
  • views_num — int(11) — NOT NULL — Number of Views
  • rating_pos — smallint(5) — NOT NULL — Rating Pos

report_viewed_product_index

  • index_id — bigint(20) — Primary key — NOT NULL — Index Id
  • product_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Product Id
  • visitor_id — int(10) — Visitor Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer Id
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • added_at — timestamp — NOT NULL — Added At

reporting_counts

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • type — varchar(255) — Item Reported
  • count — int(10) — Count Value
  • updated_at — timestamp — NOT NULL — Updated At

reporting_module_status

  • entity_id — int(10) — Primary key — NOT NULL — Module Id
  • name — varchar(255) — Module Name
  • active — varchar(255) — Module Active Status
  • setup_version — varchar(255) — Module Version
  • state — varchar(255) — Module State
  • updated_at — timestamp — NOT NULL — Updated At

reporting_orders

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_id — int(10) — Customer Id
  • total — decimal(20,2) — Total From Store
  • total_base — decimal(20,2) — Total From Base Currency
  • item_count — int(10) — NOT NULL — Line Item Count
  • updated_at — timestamp — NOT NULL — Updated At

reporting_system_updates

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • type — varchar(255) — Update Type
  • action — varchar(255) — Action Performed
  • updated_at — timestamp — NOT NULL — Updated At

reporting_users

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • type — varchar(255) — User Type
  • action — varchar(255) — Action Performed
  • updated_at — timestamp — NOT NULL — Updated At

review

  • review_id — bigint(20) — Primary key — NOT NULL — Review id
  • entity_id — smallint(5) — Foreign key → review_entity.entity_id — NOT NULL — Entity id
  • status_id — smallint(5) — Foreign key → review_status.status_id — NOT NULL — Status code
  • created_at — timestamp — NOT NULL — Review create date
  • entity_pk_value — int(10) — NOT NULL — Product id

review_detail

  • detail_id — bigint(20) — Primary key — NOT NULL — Review detail id
  • review_id — bigint(20) — Foreign key → review.review_id — NOT NULL — Review id
  • store_id — smallint(5) — Foreign key → store.store_id — Store id
  • title — varchar(255) — NOT NULL — Title
  • detail — text — NOT NULL — Detail description
  • nickname — varchar(128) — NOT NULL — User nickname
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer Id

review_entity

  • entity_id — smallint(5) — Primary key — NOT NULL — Review entity id
  • entity_code — varchar(32) — NOT NULL — Review entity code

review_entity_summary

  • primary_id — bigint(20) — Primary key — NOT NULL — Summary review entity id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store id
  • entity_pk_value — bigint(20) — NOT NULL — Product id
  • entity_type — smallint(6) — NOT NULL — Entity type id
  • reviews_count — smallint(6) — NOT NULL — Qty of reviews
  • rating_summary — smallint(6) — NOT NULL — Summarized rating

review_status

  • status_id — smallint(5) — Primary key — NOT NULL — Status id
  • status_code — varchar(32) — NOT NULL — Status code

review_store

  • review_id — bigint(20) — Foreign key → review.review_id — NOT NULL — Review Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id

sales_order

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id

sales_order_item

  • item_id — int(10) — Primary key — NOT NULL — Item Id

sales_order_payment

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id

sequence_creditmemo_0

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_creditmemo_1

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_invoice_0

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_invoice_1

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_order_0

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_order_1

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_shipment_0

  • sequence_value — int(10) — Primary key — NOT NULL

sequence_shipment_1

  • sequence_value — int(10) — Primary key — NOT NULL

shipping_tablerate

  • pk — int(10) — Primary key — NOT NULL — Primary key
  • website_id — int(11) — NOT NULL — Website Id
  • dest_country_id — varchar(4) — NOT NULL — Destination coutry ISO/2 or ISO/3 code
  • dest_region_id — int(11) — NOT NULL — Destination Region Id
  • dest_zip — varchar(10) — NOT NULL — Destination Post Code (Zip)
  • condition_name — varchar(20) — NOT NULL — Rate Condition name
  • condition_value — decimal(12,4) — NOT NULL — Rate condition value
  • price — decimal(12,4) — NOT NULL — Price
  • cost — decimal(12,4) — NOT NULL — Cost

store

  • store_id — smallint(5) — Primary key — NOT NULL — Store Id

store_website

  • website_id — smallint(5) — Primary key — NOT NULL — Website Id

tax_calculation

  • tax_calculation_id — int(11) — Primary key — NOT NULL — Tax Calculation Id
  • customer_tax_class_id — smallint(6) — Foreign key → tax_class.class_id — NOT NULL — Customer Tax Class Id
  • product_tax_class_id — smallint(6) — Foreign key → tax_class.class_id — NOT NULL — Product Tax Class Id
  • tax_calculation_rate_id — int(11) — Foreign key → tax_calculation_rate.tax_calculation_rate_id — NOT NULL — Tax Calculation Rate Id
  • tax_calculation_rule_id — int(11) — Foreign key → tax_calculation_rule.tax_calculation_rule_id — NOT NULL — Tax Calculation Rule Id

tax_calculation_rate

  • tax_calculation_rate_id — int(11) — Primary key — NOT NULL — Tax Calculation Rate Id
  • tax_country_id — varchar(2) — NOT NULL — Tax Country Id
  • tax_region_id — int(11) — NOT NULL — Tax Region Id
  • tax_postcode — varchar(21) — Tax Postcode
  • code — varchar(255) — NOT NULL — Code
  • rate — decimal(12,4) — NOT NULL — Rate
  • zip_is_range — smallint(6) — Zip Is Range
  • zip_from — int(10) — Zip From
  • zip_to — int(10) — Zip To

tax_calculation_rate_title

  • tax_calculation_rate_title_id — int(11) — Primary key — NOT NULL — Tax Calculation Rate Title Id
  • tax_calculation_rate_id — int(11) — Foreign key → tax_calculation_rate.tax_calculation_rate_id — NOT NULL — Tax Calculation Rate Id
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • value — varchar(255) — NOT NULL — Value

tax_calculation_rule

  • tax_calculation_rule_id — int(11) — Primary key — NOT NULL — Tax Calculation Rule Id
  • code — varchar(255) — NOT NULL — Code
  • priority — int(11) — NOT NULL — Priority
  • position — int(11) — NOT NULL — Position
  • calculate_subtotal — int(11) — NOT NULL — Calculate off subtotal option

tax_class

  • class_id — smallint(6) — Primary key — NOT NULL — Class Id
  • class_name — varchar(255) — NOT NULL — Class Name
  • class_type — varchar(8) — NOT NULL — Class Type

tax_order_aggregated_created

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • code — varchar(255) — NOT NULL — Code
  • order_status — varchar(50) — NOT NULL — Order Status
  • percent — float — Percent
  • orders_count — int(10) — NOT NULL — Orders Count
  • tax_base_amount_sum — float — Tax Base Amount Sum

tax_order_aggregated_updated

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • code — varchar(255) — NOT NULL — Code
  • order_status — varchar(50) — NOT NULL — Order Status
  • percent — float — Percent
  • orders_count — int(10) — NOT NULL — Orders Count
  • tax_base_amount_sum — float — Tax Base Amount Sum

vault_payment_token

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — Customer Id
  • public_hash — varchar(128) — NOT NULL — Hash code for using on frontend
  • payment_method_code — varchar(128) — NOT NULL — Payment method code
  • type — varchar(128) — NOT NULL — Type
  • created_at — timestamp — NOT NULL — Created At
  • expires_at — timestamp — Expires At
  • gateway_token — varchar(255) — NOT NULL — Gateway Token
  • details — text — Details
  • is_active — tinyint(1) — NOT NULL — Is active flag
  • is_visible — tinyint(1) — NOT NULL — Is visible flag

vault_payment_token_order_payment_link

  • payment_token_id — int(10) — Foreign key → vault_payment_token.entity_id — NOT NULL — Payment token Id
  • order_payment_id — int(10) — Foreign key → sales_order_payment.entity_id — NOT NULL — Order payment Id

weee_tax

  • value_id — int(11) — Primary key — NOT NULL — Value Id
  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • entity_id — int(10) — Foreign key → catalog_product_entity.entity_id — NOT NULL — Entity Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website Id
  • country — varchar(2) — Foreign key → directory_country.country_id — Country
  • value — decimal(12,4) — NOT NULL — Value
  • state — int(11) — NOT NULL — State