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