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