m-2.4.7
Tables (86)
admin_passwords
- password_id — int(10) — Primary key — NOT NULL — Password Id
- user_id — int(10) — Foreign key → admin_user.user_id — NOT NULL — User Id
- password_hash — varchar(100) — Password Hash
- expires — int(10) — NOT NULL — Expires
- last_updated — int(10) — NOT NULL — Last Updated
admin_user
- user_id — int(10) — Primary key — NOT NULL — User ID
- firstname — varchar(32) — User First Name
- lastname — varchar(32) — User Last Name
- email — varchar(128) — User Email
- username — varchar(40) — User Login
- password — varchar(255) — NOT NULL — User Password
- created — timestamp — NOT NULL — User Created Time
- modified — timestamp — NOT NULL — User Modified Time
- logdate — timestamp — User Last Login Time
- lognum — smallint(5) — NOT NULL — User Login Number
- reload_acl_flag — smallint(6) — NOT NULL — Reload ACL
- is_active — smallint(6) — NOT NULL — User Is Active
- extra — text — User Extra Data
- rp_token — text — Reset Password Link Token
- rp_token_created_at — timestamp — Reset Password Link Token Creation Date
- interface_locale — varchar(16) — NOT NULL — Backend interface locale
- failures_num — smallint(6) — Failure Number
- first_failure — timestamp — First Failure
- lock_expires — timestamp — Expiration Lock Dates
admin_user_session
- id — int(10) — Primary key — NOT NULL — Entity ID
- session_id — varchar(128) — NOT NULL — Session id value
- user_id — int(10) — Admin User ID
- status — smallint(5) — NOT NULL — Current Session status
- created_at — timestamp — NOT NULL — Created Time
- updated_at — timestamp — NOT NULL — Update Time
- ip — varchar(15) — NOT NULL — Remote user IP
adminnotification_inbox
- notification_id — int(10) — Primary key — NOT NULL — Notification id
- severity — smallint(5) — NOT NULL — Problem type
- date_added — timestamp — NOT NULL — Create date
- title — varchar(255) — NOT NULL — Title
- description — text — Description
- url — varchar(255) — Url
- is_read — smallint(5) — NOT NULL — Flag if notification read
- is_remove — smallint(5) — NOT NULL — Flag if notification might be removed
authorization_role
- role_id — int(10) — Primary key — NOT NULL — Role ID
- parent_id — int(10) — NOT NULL — Parent Role ID
- tree_level — smallint(5) — NOT NULL — Role Tree Level
- sort_order — smallint(5) — NOT NULL — Role Sort Order
- role_type — varchar(1) — NOT NULL — Role Type
- user_id — int(10) — NOT NULL — User ID
- user_type — varchar(16) — User Type
- role_name — varchar(50) — Role Name
authorization_rule
- rule_id — int(10) — Primary key — NOT NULL — Rule ID
- role_id — int(10) — Foreign key → authorization_role.role_id — NOT NULL — Role ID
- resource_id — varchar(255) — Resource ID
- privileges — varchar(20) — Privileges
- permission — varchar(10) — Permission
catalog_product_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
catalog_product_entity_datetime
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — datetime — Value
catalog_product_entity_decimal
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — decimal(12, 4) — Value
catalog_product_entity_gallery
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- position — int(11) — NOT NULL — Position
- value — varchar(255) — Value
catalog_product_entity_int
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — int(11) — Value
catalog_product_entity_media_gallery
- value_id — int(10) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- value — varchar(255) — Value
- media_type — varchar(32) — NOT NULL — Media entry type
- disabled — smallint(5) — NOT NULL — Visibility status
catalog_product_entity_media_gallery_value
- value_id — int(10) — NOT NULL — Value ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- label — varchar(255) — Label
- position — int(10) — Position
- disabled — smallint(5) — NOT NULL — Is Disabled
- record_id — int(10) — NOT NULL — Record Id
catalog_product_entity_media_gallery_value_to_entity
- value_id — int(10) — NOT NULL — Value media Entry ID
- entity_id — int(10) — NOT NULL — Product entity ID
catalog_product_entity_media_gallery_value_video
- value_id — int(10) — NOT NULL — Media Entity ID
- store_id — smallint(5) — NOT NULL — Store ID
- provider — varchar(32) — Video provider ID
- url — text — Video URL
- title — varchar(255) — Title
- description — text — Page Meta Description
- metadata — text — Video meta data
catalog_product_entity_text
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — text — Value
catalog_product_entity_tier_price
- value_id — int(11) — NOT NULL — Value ID
- entity_id — int(10) — NOT NULL — Entity ID
- all_groups — smallint(5) — NOT NULL — Is Applicable To All Customer Groups
- customer_group_id — int(10) — NOT NULL — Customer Group ID
- qty — decimal(12, 4) — NOT NULL — QTY
- value — decimal(12, 4) — NOT NULL — Value
- percentage_value — decimal(5, 2) — Percentage value
- website_id — smallint(5) — NOT NULL — Website ID
catalog_product_entity_varchar
- value_id — int(11) — NOT NULL — Value ID
- attribute_id — smallint(5) — NOT NULL — Attribute ID
- store_id — smallint(5) — NOT NULL — Store ID
- entity_id — int(10) — NOT NULL — Entity ID
- value — varchar(255) — Value
cms_block
- block_id — smallint(6) — Primary key — NOT NULL — Block ID
- title — varchar(255) — NOT NULL — Block Title
- identifier — varchar(255) — NOT NULL — Block String Identifier
- content — mediumtext — Block Content
- creation_time — timestamp — NOT NULL — Block Creation Time
- update_time — timestamp — NOT NULL — Block Modification Time
- is_active — smallint(6) — NOT NULL — Is Block Active
- FULLTEXT — KEY
cms_page
- page_id — smallint(6) — Primary key — NOT NULL — Page ID
- title — varchar(255) — Page Title
- page_layout — varchar(255) — Page Layout
- meta_keywords — text — Page Meta Keywords
- meta_description — text — Page Meta Description
- identifier — varchar(100) — Page String Identifier
- content_heading — varchar(255) — Page Content Heading
- content — mediumtext — Page Content
- creation_time — timestamp — NOT NULL — Page Creation Time
- update_time — timestamp — NOT NULL — Page Modification Time
- is_active — smallint(6) — NOT NULL — Is Page Active
- sort_order — smallint(6) — NOT NULL — Page Sort Order
- layout_update_xml — text — Page Layout Update Content
- custom_theme — varchar(100) — Page Custom Theme
- custom_root_template — varchar(255) — Page Custom Template
- custom_layout_update_xml — text — Page Custom Layout Update Content
- custom_theme_from — date — Page Custom Theme Active From Date
- custom_theme_to — date — Page Custom Theme Active To Date
- meta_title — varchar(255) — Page Meta Title
- FULLTEXT — KEY
cms_page_store
- page_id — smallint(6) — Foreign key → cms_page.page_id — NOT NULL — Page ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
core_config_data
- config_id — int(10) — Primary key — NOT NULL — Config Id
- scope — varchar(8) — NOT NULL — Config Scope
- scope_id — int(11) — NOT NULL — Config Scope Id
- path — varchar(255) — NOT NULL — Config Path
- value — text — Config Value
cron_schedule
- schedule_id — int(10) — Primary key — NOT NULL — Schedule Id
- job_code — varchar(255) — NOT NULL — Job Code
- status — varchar(7) — NOT NULL — Status
- messages — text — Messages
- created_at — timestamp — NOT NULL — Created At
- scheduled_at — timestamp — Scheduled At
- executed_at — timestamp — Executed At
- finished_at — timestamp — Finished At
customer_address_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- increment_id — varchar(50) — Increment Id
- parent_id — int(10) — Parent Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- is_active — smallint(5) — NOT NULL — Is Active
- city — varchar(255) — NOT NULL — City
- company — varchar(255) — Company
- country_id — varchar(255) — NOT NULL — Country
- fax — varchar(255) — Fax
- firstname — varchar(255) — NOT NULL — First Name
- lastname — varchar(255) — NOT NULL — Last Name
- middlename — varchar(255) — Middle Name
- postcode — varchar(255) — Zip/Postal Code
- prefix — varchar(40) — Name Prefix
- region — varchar(255) — State/Province
- region_id — int(10) — State/Province
- street — text — NOT NULL — Street Address
- suffix — varchar(40) — Name Suffix
- telephone — varchar(255) — NOT NULL — Phone Number
- vat_id — varchar(255) — VAT number
- vat_is_valid — int(10) — VAT number validity
- vat_request_date — varchar(255) — VAT number validation request date
- vat_request_id — varchar(255) — VAT number validation request ID
- vat_request_success — int(10) — VAT number validation request success
customer_address_entity_datetime
- 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 → customer_address_entity.entity_id — NOT NULL — Entity Id
- value — datetime — Value
customer_address_entity_decimal
- 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 → customer_address_entity.entity_id — NOT NULL — Entity Id
- value — decimal(12, 4) — NOT NULL — Value
customer_address_entity_int
- 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 → customer_address_entity.entity_id — NOT NULL — Entity Id
- value — int(11) — NOT NULL — Value
customer_address_entity_text
- 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 → customer_address_entity.entity_id — NOT NULL — Entity Id
- value — text — NOT NULL — Value
customer_address_entity_varchar
- 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 → customer_address_entity.entity_id — NOT NULL — Entity Id
- value — varchar(255) — Value
customer_eav_attribute
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- is_visible — smallint(5) — NOT NULL — Is Visible
- input_filter — varchar(255) — Input Filter
- multiline_count — smallint(5) — NOT NULL — Multiline Count
- validate_rules — text — Validate Rules
- is_system — smallint(5) — NOT NULL — Is System
- sort_order — int(10) — NOT NULL — Sort Order
- data_model — varchar(255) — Data Model
- is_used_in_grid — smallint(5) — NOT NULL — Is Used in Grid
- is_visible_in_grid — smallint(5) — NOT NULL — Is Visible in Grid
- is_filterable_in_grid — smallint(5) — NOT NULL — Is Filterable in Grid
- is_searchable_in_grid — smallint(5) — NOT NULL — Is Searchable in Grid
customer_eav_attribute_website
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
- website_id — smallint(5) — Foreign key — NOT NULL — Website Id
- is_visible — smallint(5) — Is Visible
- is_required — smallint(5) — Is Required
- default_value — text — Default Value
- multiline_count — smallint(5) — Multiline Count
customer_entity
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
customer_entity_datetime
- 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 — NOT NULL — Entity Id
- value — datetime — Value
customer_entity_decimal
- 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 — NOT NULL — Entity Id
- value — decimal(12, 4) — NOT NULL — Value
customer_entity_int
- 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 — NOT NULL — Entity Id
- value — int(11) — NOT NULL — Value
customer_entity_text
- 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 — NOT NULL — Entity Id
- value — text — NOT NULL — Value
customer_entity_varchar
- 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 — NOT NULL — Entity Id
- value — varchar(255) — Value
customer_form_attribute
- form_code — varchar(32) — Primary key — NOT NULL — Form Code
- attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
customer_grid_flat
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- name — text — Name
- email — varchar(255) — Email
- group_id — int(11) — Group_id
- created_at — timestamp — Created_at
- website_id — int(11) — Website_id
- confirmation — varchar(255) — Confirmation
- created_in — text — Created_in
- dob — date — Dob
- gender — int(11) — Gender
- taxvat — varchar(255) — Taxvat
- lock_expires — timestamp — Lock_expires
- shipping_full — text — Shipping_full
- billing_full — text — Billing_full
- billing_firstname — varchar(255) — Billing_firstname
- billing_lastname — varchar(255) — Billing_lastname
- billing_telephone — varchar(255) — Billing_telephone
- billing_postcode — varchar(255) — Billing_postcode
- billing_country_id — varchar(255) — Billing_country_id
- billing_region — varchar(255) — Billing_region
- billing_street — varchar(255) — Billing_street
- billing_city — varchar(255) — Billing_city
- billing_fax — varchar(255) — Billing_fax
- billing_vat_id — varchar(255) — Billing_vat_id
- billing_company — varchar(255) — Billing_company
- FULLTEXT — KEY
customer_group
- customer_group_id — int(10) — Primary key — NOT NULL
- customer_group_code — varchar(32) — NOT NULL — Customer Group Code
- tax_class_id — int(10) — NOT NULL — Tax Class Id
customer_log
- log_id — int(11) — Primary key — NOT NULL — Log ID
- customer_id — int(11) — NOT NULL — Customer ID
- last_login_at — timestamp — Last Login Time
- last_logout_at — timestamp — Last Logout Time
customer_visitor
- visitor_id — bigint(20) — Primary key — NOT NULL — Visitor ID
- customer_id — int(11) — Customer Id
- session_id — varchar(64) — Session ID
- last_visit_at — timestamp — NOT NULL — Last Visit Time
directory_country
- country_id — varchar(2) — Primary key — NOT NULL — Country Id in ISO-2
- iso2_code — varchar(2) — Country ISO-2 format
- iso3_code — varchar(3) — Country ISO-3
directory_country_format
- country_format_id — int(10) — Primary key — NOT NULL — Country Format Id
- country_id — varchar(2) — Country Id in ISO-2
- type — varchar(30) — Country Format Type
- format — text — NOT NULL — Country Format
directory_country_region
- region_id — int(10) — Primary key — NOT NULL — Region Id
- country_id — varchar(4) — NOT NULL — Country Id in ISO-2
- code — varchar(32) — Region code
- default_name — varchar(255) — Region Name
directory_country_region_name
- locale — varchar(8) — Primary key — NOT NULL — Locale
- region_id — int(10) — Foreign key → directory_country_region.region_id — NOT NULL — Region Id
- name — varchar(255) — Region Name
directory_currency_rate
- currency_from — varchar(3) — Primary key — NOT NULL — Currency Code Convert From
- currency_to — varchar(3) — Primary key — NOT NULL — Currency Code Convert To
- rate — decimal(24, 12) — NOT NULL — Currency Conversion Rate
eav_attribute
- attribute_id — smallint(5) — Primary key — NOT NULL — Attribute Id
indexer_state
- state_id — int(10) — Primary key — NOT NULL — Indexer State Id
- indexer_id — varchar(255) — Indexer Id
- status — varchar(16) — Indexer Status
- updated — datetime — Indexer Status
- hash_config — varchar(32) — NOT NULL — Hash of indexer config
- table_suffix — varchar(255) — NOT NULL — Suffix for indexer table used for read operations
oauth_consumer
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — Updated At
- name — varchar(255) — NOT NULL — Name of consumer
- key — varchar(32) — NOT NULL — Key code
- secret — varchar(32) — NOT NULL — Secret code
- callback_url — text — Callback URL
- rejected_callback_url — text — NOT NULL — Rejected callback URL
oauth_token
- entity_id — int(10) — Primary key — NOT NULL — Entity ID
- consumer_id — int(10) — Oauth Consumer ID
- admin_id — int(10) — Admin user ID
- customer_id — int(10) — Customer user ID
- type — varchar(16) — NOT NULL — Token Type
- token — varchar(32) — NOT NULL — Token
- secret — varchar(32) — NOT NULL — Token Secret
- verifier — varchar(32) — Token Verifier
- callback_url — text — NOT NULL — Token Callback URL
- revoked — smallint(5) — NOT NULL — Is Token revoked
- authorized — smallint(5) — NOT NULL — Is Token authorized
- user_type — int(11) — User type
- created_at — timestamp — NOT NULL — Token creation timestamp
oauth_token_request_log
- log_id — int(10) — Primary key — NOT NULL — Log Id
- user_name — varchar(255) — NOT NULL — Customer email or admin login
- user_type — smallint(5) — NOT NULL — User type (admin or customer)
- failures_count — smallint(5) — Number of failed authentication attempts in a row
- lock_expires_at — timestamp — NOT NULL — Lock expiration time
password_reset_request_event
- id — int(10) — Primary key — NOT NULL — Entity ID
- request_type — smallint(5) — NOT NULL — Type of the event under a security control
- account_reference — varchar(255) — An identifier for existing account or another target
- created_at — timestamp — NOT NULL — Timestamp when the event occurs
- ip — varchar(15) — NOT NULL — Remote user IP
sales_bestsellers_aggregated_yearly
- id — int(10) — Primary key — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — Store Id
- product_id — int(10) — Product Id
- product_name — varchar(255) — Product Name
- product_price — decimal(12, 4) — NOT NULL — Product Price
- qty_ordered — decimal(12, 4) — NOT NULL — Qty Ordered
- rating_pos — smallint(5) — NOT NULL — Rating Pos
sales_creditmemo_comment
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- is_customer_notified — int(11) — Is Customer Notified
- is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
- comment — text — Comment
- created_at — timestamp — NOT NULL — Created At
sales_invoice
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- order_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Order Id
- store_id — smallint(5) — Store Id
- base_grand_total — decimal(12, 4) — Base Grand Total
- shipping_tax_amount — decimal(12, 4) — Shipping Tax Amount
- tax_amount — decimal(12, 4) — Tax Amount
- base_tax_amount — decimal(12, 4) — Base Tax Amount
- store_to_order_rate — decimal(12, 4) — Store To Order Rate
- base_shipping_tax_amount — decimal(12, 4) — Base Shipping Tax Amount
- base_discount_amount — decimal(12, 4) — Base Discount Amount
- base_to_order_rate — decimal(12, 4) — Base To Order Rate
- grand_total — decimal(12, 4) — Grand Total
- shipping_amount — decimal(12, 4) — Shipping Amount
- subtotal_incl_tax — decimal(12, 4) — Subtotal Incl Tax
- base_subtotal_incl_tax — decimal(12, 4) — Base Subtotal Incl Tax
- store_to_base_rate — decimal(12, 4) — Store To Base Rate
- base_shipping_amount — decimal(12, 4) — Base Shipping Amount
- total_qty — decimal(12, 4) — Total Qty
- base_to_global_rate — decimal(12, 4) — Base To Global Rate
- subtotal — decimal(12, 4) — Subtotal
- base_subtotal — decimal(12, 4) — Base Subtotal
- discount_amount — decimal(12, 4) — Discount Amount
- billing_address_id — int(11) — Billing Address Id
- is_used_for_refund — smallint(5) — Is Used For Refund
- email_sent — smallint(5) — Email Sent
- send_email — smallint(5) — Send Email
- can_void_flag — smallint(5) — Can Void Flag
- state — int(11) — State
- shipping_address_id — int(11) — Shipping Address Id
- store_currency_code — varchar(3) — Store Currency Code
- transaction_id — varchar(255) — Transaction Id
- order_currency_code — varchar(3) — Order Currency Code
- base_currency_code — varchar(3) — Base Currency Code
- global_currency_code — varchar(3) — Global Currency Code
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- discount_tax_compensation_amount — decimal(12, 4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12, 4) — Base Discount Tax Compensation Amount
- shipping_discount_tax_compensation_amount — decimal(12, 4) — Shipping Discount Tax Compensation Amount
- base_shipping_discount_tax_compensation_amnt — decimal(12, 4) — Base Shipping Discount Tax Compensation Amount
- shipping_incl_tax — decimal(12, 4) — Shipping Incl Tax
- base_shipping_incl_tax — decimal(12, 4) — Base Shipping Incl Tax
- base_total_refunded — decimal(12, 4) — Base Total Refunded
- discount_description — varchar(255) — Discount Description
- customer_note — text — Customer Note
- customer_note_notify — smallint(5) — Customer Note Notify
sales_invoice_item
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- parent_id — int(10) — Foreign key → sales_invoice.entity_id — NOT NULL — Parent Id
- base_price — decimal(12, 4) — Base Price
- tax_amount — decimal(12, 4) — Tax Amount
- base_row_total — decimal(12, 4) — Base Row Total
- discount_amount — decimal(12, 4) — Discount Amount
- row_total — decimal(12, 4) — Row Total
- base_discount_amount — decimal(12, 4) — Base Discount Amount
- price_incl_tax — decimal(12, 4) — Price Incl Tax
- base_tax_amount — decimal(12, 4) — Base Tax Amount
- base_price_incl_tax — decimal(12, 4) — Base Price Incl Tax
- qty — decimal(12, 4) — Qty
- base_cost — decimal(12, 4) — Base Cost
- price — decimal(12, 4) — Price
- base_row_total_incl_tax — decimal(12, 4) — Base Row Total Incl Tax
- row_total_incl_tax — decimal(12, 4) — Row Total Incl Tax
- product_id — int(11) — Product Id
- order_item_id — int(11) — Order Item Id
- additional_data — text — Additional Data
- description — text — Description
- sku — varchar(255) — Sku
- name — varchar(255) — Name
- discount_tax_compensation_amount — decimal(12, 4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12, 4) — Base Discount Tax Compensation Amount
- tax_ratio — text — Ratio of tax invoiced over tax of the order item
- weee_tax_applied — text — Weee Tax Applied
- weee_tax_applied_amount — decimal(12, 4) — Weee Tax Applied Amount
- weee_tax_applied_row_amount — decimal(12, 4) — Weee Tax Applied Row Amount
- weee_tax_disposition — decimal(12, 4) — Weee Tax Disposition
- weee_tax_row_disposition — decimal(12, 4) — Weee Tax Row Disposition
- base_weee_tax_applied_amount — decimal(12, 4) — Base Weee Tax Applied Amount
- base_weee_tax_applied_row_amnt — decimal(12, 4) — Base Weee Tax Applied Row Amnt
- base_weee_tax_disposition — decimal(12, 4) — Base Weee Tax Disposition
- base_weee_tax_row_disposition — decimal(12, 4) — Base Weee Tax Row Disposition
sales_order
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- state — varchar(32) — State
- status — varchar(32) — Status
- coupon_code — varchar(255) — Coupon Code
- protect_code — varchar(255) — Protect Code
- shipping_description — varchar(255) — Shipping Description
- is_virtual — smallint(5) — Is Virtual
- store_id — smallint(5) — Store Id
- customer_id — int(10) — Customer Id
- base_discount_amount — decimal(12, 4) — Base Discount Amount
- base_discount_canceled — decimal(12, 4) — Base Discount Canceled
- base_discount_invoiced — decimal(12, 4) — Base Discount Invoiced
- base_discount_refunded — decimal(12, 4) — Base Discount Refunded
- base_grand_total — decimal(12, 4) — Base Grand Total
- base_shipping_amount — decimal(12, 4) — Base Shipping Amount
- base_shipping_canceled — decimal(12, 4) — Base Shipping Canceled
- base_shipping_invoiced — decimal(12, 4) — Base Shipping Invoiced
- base_shipping_refunded — decimal(12, 4) — Base Shipping Refunded
- base_shipping_tax_amount — decimal(12, 4) — Base Shipping Tax Amount
- base_shipping_tax_refunded — decimal(12, 4) — Base Shipping Tax Refunded
- base_subtotal — decimal(12, 4) — Base Subtotal
- base_subtotal_canceled — decimal(12, 4) — Base Subtotal Canceled
- base_subtotal_invoiced — decimal(12, 4) — Base Subtotal Invoiced
- base_subtotal_refunded — decimal(12, 4) — Base Subtotal Refunded
- base_tax_amount — decimal(12, 4) — Base Tax Amount
- base_tax_canceled — decimal(12, 4) — Base Tax Canceled
- base_tax_invoiced — decimal(12, 4) — Base Tax Invoiced
- base_tax_refunded — decimal(12, 4) — Base Tax Refunded
- base_to_global_rate — decimal(12, 4) — Base To Global Rate
- base_to_order_rate — decimal(12, 4) — Base To Order Rate
- base_total_canceled — decimal(12, 4) — Base Total Canceled
- base_total_invoiced — decimal(12, 4) — Base Total Invoiced
- base_total_invoiced_cost — decimal(12, 4) — Base Total Invoiced Cost
- base_total_offline_refunded — decimal(12, 4) — Base Total Offline Refunded
- base_total_online_refunded — decimal(12, 4) — Base Total Online Refunded
- base_total_paid — decimal(12, 4) — Base Total Paid
- base_total_qty_ordered — decimal(12, 4) — Base Total Qty Ordered
- base_total_refunded — decimal(12, 4) — Base Total Refunded
- discount_amount — decimal(12, 4) — Discount Amount
- discount_canceled — decimal(12, 4) — Discount Canceled
- discount_invoiced — decimal(12, 4) — Discount Invoiced
- discount_refunded — decimal(12, 4) — Discount Refunded
- grand_total — decimal(12, 4) — Grand Total
- shipping_amount — decimal(12, 4) — Shipping Amount
- shipping_canceled — decimal(12, 4) — Shipping Canceled
- shipping_invoiced — decimal(12, 4) — Shipping Invoiced
- shipping_refunded — decimal(12, 4) — Shipping Refunded
- shipping_tax_amount — decimal(12, 4) — Shipping Tax Amount
- shipping_tax_refunded — decimal(12, 4) — Shipping Tax Refunded
- store_to_base_rate — decimal(12, 4) — Store To Base Rate
- store_to_order_rate — decimal(12, 4) — Store To Order Rate
- subtotal — decimal(12, 4) — Subtotal
- subtotal_canceled — decimal(12, 4) — Subtotal Canceled
- subtotal_invoiced — decimal(12, 4) — Subtotal Invoiced
- subtotal_refunded — decimal(12, 4) — Subtotal Refunded
- tax_amount — decimal(12, 4) — Tax Amount
- tax_canceled — decimal(12, 4) — Tax Canceled
- tax_invoiced — decimal(12, 4) — Tax Invoiced
- tax_refunded — decimal(12, 4) — Tax Refunded
- total_canceled — decimal(12, 4) — Total Canceled
- … +78
sales_order_address
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- parent_id — int(10) — Parent Id
- customer_address_id — int(11) — Customer Address Id
- quote_address_id — int(11) — Quote Address Id
- region_id — int(11) — Region Id
- customer_id — int(11) — Customer Id
- fax — varchar(255) — Fax
- region — varchar(255) — Region
- postcode — varchar(255) — Postcode
- lastname — varchar(255) — Lastname
- street — varchar(255) — Street
- city — varchar(255) — City
- email — varchar(255) — Email
- telephone — varchar(255) — Phone Number
- country_id — varchar(2) — Country Id
- firstname — varchar(255) — Firstname
- address_type — varchar(255) — Address Type
- prefix — varchar(255) — Prefix
- middlename — varchar(255) — Middlename
- suffix — varchar(255) — Suffix
- company — varchar(255) — Company
- vat_id — text — Vat Id
- vat_is_valid — smallint(6) — Vat Is Valid
- vat_request_id — text — Vat Request Id
- vat_request_date — text — Vat Request Date
- vat_request_success — smallint(6) — Vat Request Success
sales_order_item
- item_id — int(10) — Primary key — NOT NULL — Item Id
- order_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Order Id
- parent_item_id — int(10) — Parent Item Id
- quote_item_id — int(10) — Quote Item Id
- store_id — smallint(5) — Store Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- product_id — int(10) — Product Id
- product_type — varchar(255) — Product Type
- product_options — text — Product Options
- weight — decimal(12, 4) — Weight
- is_virtual — smallint(5) — Is Virtual
- sku — varchar(255) — Sku
- name — varchar(255) — Name
- description — text — Description
- applied_rule_ids — text — Applied Rule Ids
- additional_data — text — Additional Data
- is_qty_decimal — smallint(5) — Is Qty Decimal
- no_discount — smallint(5) — NOT NULL — No Discount
- qty_backordered — decimal(12, 4) — Qty Backordered
- qty_canceled — decimal(12, 4) — Qty Canceled
- qty_invoiced — decimal(12, 4) — Qty Invoiced
- qty_ordered — decimal(12, 4) — Qty Ordered
- qty_refunded — decimal(12, 4) — Qty Refunded
- qty_shipped — decimal(12, 4) — Qty Shipped
- base_cost — decimal(12, 4) — Base Cost
- price — decimal(12, 4) — NOT NULL — Price
- base_price — decimal(12, 4) — NOT NULL — Base Price
- original_price — decimal(12, 4) — Original Price
- base_original_price — decimal(12, 4) — Base Original Price
- tax_percent — decimal(12, 4) — Tax Percent
- tax_amount — decimal(12, 4) — Tax Amount
- base_tax_amount — decimal(12, 4) — Base Tax Amount
- tax_invoiced — decimal(12, 4) — Tax Invoiced
- base_tax_invoiced — decimal(12, 4) — Base Tax Invoiced
- discount_percent — decimal(12, 4) — Discount Percent
- discount_amount — decimal(12, 4) — Discount Amount
- base_discount_amount — decimal(12, 4) — Base Discount Amount
- discount_invoiced — decimal(12, 4) — Discount Invoiced
- base_discount_invoiced — decimal(12, 4) — Base Discount Invoiced
- amount_refunded — decimal(12, 4) — Amount Refunded
- base_amount_refunded — decimal(12, 4) — Base Amount Refunded
- row_total — decimal(12, 4) — NOT NULL — Row Total
- base_row_total — decimal(12, 4) — NOT NULL — Base Row Total
- row_invoiced — decimal(12, 4) — NOT NULL — Row Invoiced
- base_row_invoiced — decimal(12, 4) — NOT NULL — Base Row Invoiced
- row_weight — decimal(12, 4) — Row Weight
- base_tax_before_discount — decimal(12, 4) — Base Tax Before Discount
- tax_before_discount — decimal(12, 4) — Tax Before Discount
- ext_order_item_id — varchar(255) — Ext Order Item Id
- locked_do_invoice — smallint(5) — Locked Do Invoice
- locked_do_ship — smallint(5) — Locked Do Ship
- price_incl_tax — decimal(12, 4) — Price Incl Tax
- base_price_incl_tax — decimal(12, 4) — Base Price Incl Tax
- row_total_incl_tax — decimal(12, 4) — Row Total Incl Tax
- base_row_total_incl_tax — decimal(12, 4) — Base Row Total Incl Tax
- discount_tax_compensation_amount — decimal(12, 4) — Discount Tax Compensation Amount
- base_discount_tax_compensation_amount — decimal(12, 4) — Base Discount Tax Compensation Amount
- discount_tax_compensation_invoiced — decimal(12, 4) — Discount Tax Compensation Invoiced
- base_discount_tax_compensation_invoiced — decimal(12, 4) — Base Discount Tax Compensation Invoiced
- … +20
sales_order_payment
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- parent_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Parent Id
- base_shipping_captured — decimal(12, 4) — Base Shipping Captured
- shipping_captured — decimal(12, 4) — Shipping Captured
- amount_refunded — decimal(12, 4) — Amount Refunded
- base_amount_paid — decimal(12, 4) — Base Amount Paid
- amount_canceled — decimal(12, 4) — Amount Canceled
- base_amount_authorized — decimal(12, 4) — Base Amount Authorized
- base_amount_paid_online — decimal(12, 4) — Base Amount Paid Online
- base_amount_refunded_online — decimal(12, 4) — Base Amount Refunded Online
- base_shipping_amount — decimal(12, 4) — Base Shipping Amount
- shipping_amount — decimal(12, 4) — Shipping Amount
- amount_paid — decimal(12, 4) — Amount Paid
- amount_authorized — decimal(12, 4) — Amount Authorized
- base_amount_ordered — decimal(12, 4) — Base Amount Ordered
- base_shipping_refunded — decimal(12, 4) — Base Shipping Refunded
- shipping_refunded — decimal(12, 4) — Shipping Refunded
- base_amount_refunded — decimal(12, 4) — Base Amount Refunded
- amount_ordered — decimal(12, 4) — Amount Ordered
- base_amount_canceled — decimal(12, 4) — Base Amount Canceled
- quote_payment_id — int(11) — Quote Payment Id
- additional_data — text — Additional Data
- cc_exp_month — varchar(12) — Cc Exp Month
- cc_ss_start_year — varchar(12) — Cc Ss Start Year
- echeck_bank_name — varchar(128) — Echeck Bank Name
- method — varchar(128) — Method
- cc_debug_request_body — varchar(32) — Cc Debug Request Body
- cc_secure_verify — varchar(32) — Cc Secure Verify
- protection_eligibility — varchar(32) — Protection Eligibility
- cc_approval — varchar(32) — Cc Approval
- cc_last_4 — varchar(100) — Cc Last 4
- cc_status_description — varchar(32) — Cc Status Description
- echeck_type — varchar(32) — Echeck Type
- cc_debug_response_serialized — varchar(32) — Cc Debug Response Serialized
- cc_ss_start_month — varchar(128) — Cc Ss Start Month
- echeck_account_type — varchar(255) — Echeck Account Type
- last_trans_id — varchar(32) — Last Trans Id
- cc_cid_status — varchar(32) — Cc Cid Status
- cc_owner — varchar(128) — Cc Owner
- cc_type — varchar(32) — Cc Type
- po_number — varchar(32) — Po Number
- cc_exp_year — varchar(4) — Cc Exp Year
- cc_status — varchar(4) — Cc Status
- echeck_routing_number — varchar(32) — Echeck Routing Number
- account_status — varchar(32) — Account Status
- anet_trans_method — varchar(32) — Anet Trans Method
- cc_debug_response_body — varchar(32) — Cc Debug Response Body
- cc_ss_issue — varchar(32) — Cc Ss Issue
- echeck_account_name — varchar(32) — Echeck Account Name
- cc_avs_status — varchar(32) — Cc Avs Status
- cc_number_enc — varchar(128)
- cc_trans_id — varchar(32) — Cc Trans Id
- address_status — varchar(32) — Address Status
- additional_information — text — Additional Information
sales_order_status
- status — varchar(32) — Primary key — NOT NULL — Status
- label — varchar(128) — NOT NULL — Label
sales_order_status_state
- state — varchar(32) — Primary key — NOT NULL — Label
- status — varchar(32) — Foreign key → sales_order_status.status — NOT NULL — Status
- is_default — smallint(5) — NOT NULL — Is Default
- visible_on_front — smallint(5) — NOT NULL — Visible on front
sales_order_tax
- tax_id — int(10) — Primary key — NOT NULL — Tax Id
- order_id — int(10) — NOT NULL — Order Id
- code — varchar(255) — Code
- title — varchar(255) — Title
- percent — decimal(12, 4) — Percent
- amount — decimal(12, 4) — Amount
- priority — int(11) — NOT NULL — Priority
- position — int(11) — NOT NULL — Position
- base_amount — decimal(12, 4) — Base Amount
- process — smallint(6) — NOT NULL — Process
- base_real_amount — decimal(12, 4) — Base Real Amount
sales_order_tax_item
- tax_item_id — int(10) — Primary key — NOT NULL — Tax Item Id
- tax_id — int(10) — Foreign key → sales_order_tax.tax_id — NOT NULL — Tax Id
- item_id — int(10) — Item Id
- tax_percent — decimal(12, 4) — NOT NULL — Real Tax Percent For Item
- amount — decimal(12, 4) — NOT NULL — Tax amount for the item and tax rate
- base_amount — decimal(12, 4) — NOT NULL — Base tax amount for the item and tax rate
- real_amount — decimal(12, 4) — NOT NULL — Real tax amount for the item and tax rate
- real_base_amount — decimal(12, 4) — NOT NULL — Real base tax amount for the item and tax rate
- associated_item_id — int(10) — Id of the associated item
- taxable_item_type — varchar(32) — NOT NULL — Type of the taxable item
sales_payment_transaction
- transaction_id — int(10) — Primary key — NOT NULL — Transaction Id
- order_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Order Id
- payment_id — int(10) — Foreign key → sales_order_payment.entity_id — NOT NULL — Payment Id
- parent_id — int(10) — Parent Id
- txn_id — varchar(100) — Txn Id
- parent_txn_id — varchar(100) — Parent Txn Id
- txn_type — varchar(15) — Txn Type
- is_closed — smallint(5) — NOT NULL — Is Closed
- additional_information — blob — Additional Information
- created_at — timestamp — NOT NULL — Created At
sales_refunded_aggregated
- id — int(10) — Primary key — NOT NULL — Id
- period — date — Period
- store_id — smallint(5) — Store Id
- order_status — varchar(50) — NOT NULL — Order Status
- orders_count — int(11) — NOT NULL — Orders Count
- refunded — decimal(12, 4) — Refunded
- online_refunded — decimal(12, 4) — Online Refunded
- offline_refunded — decimal(12, 4) — Offline Refunded
sales_shipment
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- order_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Order Id
- store_id — smallint(5) — Store Id
- total_weight — decimal(12, 4) — Total Weight
- total_qty — decimal(12, 4) — Total Qty
- email_sent — smallint(5) — Email Sent
- send_email — smallint(5) — Send Email
- customer_id — int(11) — Customer Id
- shipping_address_id — int(11) — Shipping Address Id
- billing_address_id — int(11) — Billing Address Id
- shipment_status — int(11) — Shipment Status
- increment_id — varchar(50) — Increment Id
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
- packages — text — Packed Products in Packages
- shipping_label — mediumblob — Shipping Label Content
- customer_note — text — Customer Note
- customer_note_notify — smallint(5) — Customer Note Notify
sales_shipment_item
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- parent_id — int(10) — Foreign key → sales_shipment.entity_id — NOT NULL — Parent Id
- row_total — decimal(12, 4) — Row Total
- price — decimal(12, 4) — Price
- weight — decimal(12, 4) — Weight
- qty — decimal(12, 4) — Qty
- product_id — int(11) — Product Id
- order_item_id — int(11) — Order Item Id
- additional_data — text — Additional Data
- description — text — Description
- name — varchar(255) — Name
- sku — varchar(255) — Sku
sales_shipment_track
- entity_id — int(10) — Primary key — NOT NULL — Entity Id
- parent_id — int(10) — Foreign key → sales_shipment.entity_id — NOT NULL — Parent Id
- weight — decimal(12, 4) — Weight
- qty — decimal(12, 4) — Qty
- order_id — int(10) — NOT NULL — Order Id
- track_number — text — Number
- description — text — Description
- title — varchar(255) — Title
- carrier_code — varchar(32) — Carrier Code
- created_at — timestamp — NOT NULL — Created At
- updated_at — timestamp — NOT NULL — Updated At
salesrule
- rule_id — int(10) — Primary key — NOT NULL — Rule Id
- name — varchar(255) — Name
- description — text — Description
- from_date — date — From
- to_date — date — To
- uses_per_customer — int(11) — NOT NULL — Uses Per Customer
- is_active — smallint(6) — NOT NULL — Is Active
- conditions_serialized — mediumtext — Conditions Serialized
- actions_serialized — mediumtext — Actions Serialized
- stop_rules_processing — smallint(6) — NOT NULL — Stop Rules Processing
- is_advanced — smallint(5) — NOT NULL — Is Advanced
- product_ids — text — Product Ids
- sort_order — int(10) — NOT NULL — Sort Order
- simple_action — varchar(32) — Simple Action
- discount_amount — decimal(12, 4) — NOT NULL — Discount Amount
- discount_qty — decimal(12, 4) — Discount Qty
- discount_step — int(10) — NOT NULL — Discount Step
- apply_to_shipping — smallint(5) — NOT NULL — Apply To Shipping
- times_used — int(10) — NOT NULL — Times Used
- is_rss — smallint(6) — NOT NULL — Is Rss
- coupon_type — smallint(5) — NOT NULL — Coupon Type
- use_auto_generation — smallint(6) — NOT NULL — Use Auto Generation
- uses_per_coupon — int(11) — NOT NULL — User Per Coupon
- simple_free_shipping — smallint(6)
salesrule_coupon
- coupon_id — int(10) — Primary key — NOT NULL — Coupon Id
- rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
- code — varchar(255) — Code
- usage_limit — int(10) — Usage Limit
- usage_per_customer — int(10) — Usage Per Customer
- times_used — int(10) — NOT NULL — Times Used
- expiration_date — timestamp — Expiration Date
- is_primary — smallint(5) — Is Primary
- created_at — timestamp — Coupon Code Creation Date
- type — smallint(6) — Coupon Code Type
salesrule_coupon_aggregated_order
- id — int(10) — Primary key — NOT NULL — Id
- period — date — NOT NULL — Period
- store_id — smallint(5) — Store Id
- order_status — varchar(50) — Order Status
- coupon_code — varchar(50) — Coupon Code
- coupon_uses — int(11) — NOT NULL — Coupon Uses
- subtotal_amount — decimal(12, 4) — NOT NULL — Subtotal Amount
- discount_amount — decimal(12, 4) — NOT NULL — Discount Amount
- total_amount — decimal(12, 4) — NOT NULL — Total Amount
- rule_name — varchar(255) — Rule Name
salesrule_label
- label_id — int(10) — Primary key — NOT NULL — Label Id
- rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
- store_id — smallint(5) — Foreign key — NOT NULL — Store Id
- label — varchar(255) — Label
salesrule_product_attribute
- attribute_id — smallint(5) — Foreign key — NOT NULL — Attribute Id
- customer_group_id — int(10) — Foreign key — NOT NULL — Customer Group Id
- rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
- website_id — smallint(5) — Foreign key — NOT NULL — Website Id
search_query
- query_id — int(10) — Primary key — NOT NULL — Query ID
- store_id — smallint(5) — Foreign key — NOT NULL — Store ID
- query_text — varchar(255) — Query text
- num_results — int(10) — NOT NULL — Num results
- popularity — int(10) — NOT NULL — Popularity
- redirect — varchar(255) — Redirect
- display_in_terms — smallint(6) — NOT NULL — Display in terms
- is_active — smallint(6) — Active status
- is_processed — smallint(6) — Processed status
- updated_at — timestamp — NOT NULL — Updated at
session
- session_id — varchar(255) — Primary key — NOT NULL — Session Id
- session_expires — int(10) — NOT NULL — Date of Session Expiration
- session_data — mediumblob — NOT NULL — Session Data
setup_module
- module — varchar(50) — Primary key — NOT NULL — Module
- schema_version — varchar(50) — Schema Version
- data_version — varchar(50) — Data Version
store
- store_id — smallint(5) — Primary key — NOT NULL — Store Id
store_website
- website_id — smallint(5) — Primary key — NOT NULL — Website Id
- code — varchar(32) — Code
- name — varchar(64) — Website Name
- sort_order — smallint(5) — NOT NULL — Sort Order
- default_group_id — smallint(5) — NOT NULL — Default Group Id
- is_default — smallint(5) — Defines Is Website Default
and 6 more tables