Sir Tariq E-commerce

Magento2 sales erd

Tables (54)

customer_entity

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

customer_group

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

eav_attribute

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

sales_bestsellers_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) — 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_bestsellers_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) — 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_bestsellers_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) — 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

  • 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) — Foreign key → store.store_id — Store Id
  • adjustment_positive — decimal(12,4) — Adjustment Positive
  • base_shipping_tax_amount — decimal(12,4) — Base Shipping Tax Amount
  • store_to_order_rate — decimal(12,4) — Store To Order Rate
  • 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
  • base_adjustment_negative — decimal(12,4) — Base Adjustment Negative
  • base_subtotal_incl_tax — decimal(12,4) — Base Subtotal Incl Tax
  • shipping_amount — decimal(12,4) — Shipping Amount
  • subtotal_incl_tax — decimal(12,4) — Subtotal Incl Tax
  • adjustment_negative — decimal(12,4) — Adjustment Negative
  • base_shipping_amount — decimal(12,4) — Base Shipping Amount
  • store_to_base_rate — decimal(12,4) — Store To Base Rate
  • base_to_global_rate — decimal(12,4) — Base To Global Rate
  • base_adjustment — decimal(12,4) — Base Adjustment
  • base_subtotal — decimal(12,4) — Base Subtotal
  • discount_amount — decimal(12,4) — Discount Amount
  • subtotal — decimal(12,4) — Subtotal
  • adjustment — decimal(12,4) — Adjustment
  • base_grand_total — decimal(12,4) — Base Grand Total
  • base_adjustment_positive — decimal(12,4) — Base Adjustment Positive
  • base_tax_amount — decimal(12,4) — Base Tax Amount
  • shipping_tax_amount — decimal(12,4) — Shipping Tax Amount
  • tax_amount — decimal(12,4) — Tax Amount
  • email_sent — smallint(5) — Email Sent
  • send_email — smallint(5) — Send Email
  • creditmemo_status — int(11) — Creditmemo Status
  • state — int(11) — State
  • shipping_address_id — int(11) — Shipping Address Id
  • billing_address_id — int(11) — Billing Address Id
  • invoice_id — int(11) — Invoice Id
  • store_currency_code — varchar(3) — Store Currency Code
  • order_currency_code — varchar(3) — Order Currency Code
  • base_currency_code — varchar(3) — Base Currency Code
  • global_currency_code — varchar(3) — Global Currency Code
  • transaction_id — varchar(255) — Transaction Id
  • 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
  • discount_description — varchar(255) — Discount Description
  • customer_note — text — Customer Note
  • customer_note_notify — smallint(5) — Customer Note Notify

sales_creditmemo_comment

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • parent_id — int(10) — Foreign key → sales_creditmemo.entity_id — NOT NULL — Parent 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_creditmemo_grid

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • increment_id — varchar(50) — Increment Id
  • created_at — timestamp — Created At
  • updated_at — timestamp — Updated At
  • order_id — int(10) — NOT NULL — Order Id
  • order_increment_id — varchar(50) — Order Increment Id
  • order_created_at — timestamp — Order Created At
  • billing_name — varchar(255) — Billing Name
  • state — int(11) — Status
  • base_grand_total — decimal(12,4) — Base Grand Total
  • order_status — varchar(32) — Order Status
  • store_id — smallint(5) — Store Id
  • billing_address — varchar(255) — Billing Address
  • shipping_address — varchar(255) — Shipping Address
  • customer_name — varchar(128) — NOT NULL — Customer Name
  • customer_email — varchar(128) — Customer Email
  • customer_group_id — smallint(6) — Customer Group Id
  • payment_method — varchar(32) — Payment Method
  • shipping_information — varchar(255) — Shipping Method Name
  • subtotal — decimal(12,4) — Subtotal
  • shipping_and_handling — decimal(12,4) — Shipping and handling amount
  • adjustment_positive — decimal(12,4) — Adjustment Positive
  • adjustment_negative — decimal(12,4) — Adjustment Negative
  • order_base_grand_total — decimal(12,4) — Order Grand Total
  • FULLTEXT — KEY

sales_creditmemo_item

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • parent_id — int(10) — Foreign key → sales_creditmemo.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 in the creditmemo item 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_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) — Foreign key → store.store_id — 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_comment

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • parent_id — int(10) — Foreign key → sales_invoice.entity_id — NOT NULL — Parent Id
  • is_customer_notified — smallint(5) — 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_grid

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • increment_id — varchar(50) — Increment Id
  • state — int(11) — State
  • store_id — smallint(5) — Store Id
  • store_name — varchar(255) — Store Name
  • order_id — int(10) — NOT NULL — Order Id
  • order_increment_id — varchar(50) — Order Increment Id
  • order_created_at — timestamp — Order Created At
  • customer_name — varchar(255) — Customer Name
  • customer_email — varchar(255) — Customer Email
  • customer_group_id — int(11)
  • payment_method — varchar(128) — Payment Method
  • store_currency_code — varchar(3) — Store Currency Code
  • order_currency_code — varchar(3) — Order Currency Code
  • base_currency_code — varchar(3) — Base Currency Code
  • global_currency_code — varchar(3) — Global Currency Code
  • billing_name — varchar(255) — Billing Name
  • billing_address — varchar(255) — Billing Address
  • shipping_address — varchar(255) — Shipping Address
  • shipping_information — varchar(255) — Shipping Method Name
  • subtotal — decimal(12,4) — Subtotal
  • shipping_and_handling — decimal(12,4) — Shipping and handling amount
  • grand_total — decimal(12,4) — Grand Total
  • base_grand_total — decimal(12,4) — Base Grand Total
  • created_at — timestamp — Created At
  • updated_at — timestamp — Updated At
  • FULLTEXT — KEY

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_invoiced_aggregated

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — Order Status
  • orders_count — int(11) — NOT NULL — Orders Count
  • orders_invoiced — decimal(12,4) — Orders Invoiced
  • invoiced — decimal(12,4) — Invoiced
  • invoiced_captured — decimal(12,4) — Invoiced Captured
  • invoiced_not_captured — decimal(12,4) — Invoiced Not Captured

sales_invoiced_aggregated_order

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — NOT NULL — Order Status
  • orders_count — int(11) — NOT NULL — Orders Count
  • orders_invoiced — decimal(12,4) — Orders Invoiced
  • invoiced — decimal(12,4) — Invoiced
  • invoiced_captured — decimal(12,4) — Invoiced Captured
  • invoiced_not_captured — decimal(12,4) — Invoiced Not Captured

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) — Foreign key → store.store_id — Store Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — 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) — Foreign key → sales_order.entity_id — 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_aggregated_created

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — NOT NULL — Order Status
  • orders_count — int(11) — NOT NULL — Orders Count
  • total_qty_ordered — decimal(12,4) — NOT NULL — Total Qty Ordered
  • total_qty_invoiced — decimal(12,4) — NOT NULL — Total Qty Invoiced
  • total_income_amount — decimal(12,4) — NOT NULL — Total Income Amount
  • total_revenue_amount — decimal(12,4) — NOT NULL — Total Revenue Amount
  • total_profit_amount — decimal(12,4) — NOT NULL — Total Profit Amount
  • total_invoiced_amount — decimal(12,4) — NOT NULL — Total Invoiced Amount
  • total_canceled_amount — decimal(12,4) — NOT NULL — Total Canceled Amount
  • total_paid_amount — decimal(12,4) — NOT NULL — Total Paid Amount
  • total_refunded_amount — decimal(12,4) — NOT NULL — Total Refunded Amount
  • total_tax_amount — decimal(12,4) — NOT NULL — Total Tax Amount
  • total_tax_amount_actual — decimal(12,4) — NOT NULL — Total Tax Amount Actual
  • total_shipping_amount — decimal(12,4) — NOT NULL — Total Shipping Amount
  • total_shipping_amount_actual — decimal(12,4) — NOT NULL — Total Shipping Amount Actual
  • total_discount_amount — decimal(12,4) — NOT NULL — Total Discount Amount
  • total_discount_amount_actual — decimal(12,4) — NOT NULL — Total Discount Amount Actual

sales_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
  • order_status — varchar(50) — NOT NULL — Order Status
  • orders_count — int(11) — NOT NULL — Orders Count
  • total_qty_ordered — decimal(12,4) — NOT NULL — Total Qty Ordered
  • total_qty_invoiced — decimal(12,4) — NOT NULL — Total Qty Invoiced
  • total_income_amount — decimal(12,4) — NOT NULL — Total Income Amount
  • total_revenue_amount — decimal(12,4) — NOT NULL — Total Revenue Amount
  • total_profit_amount — decimal(12,4) — NOT NULL — Total Profit Amount
  • total_invoiced_amount — decimal(12,4) — NOT NULL — Total Invoiced Amount
  • total_canceled_amount — decimal(12,4) — NOT NULL — Total Canceled Amount
  • total_paid_amount — decimal(12,4) — NOT NULL — Total Paid Amount
  • total_refunded_amount — decimal(12,4) — NOT NULL — Total Refunded Amount
  • total_tax_amount — decimal(12,4) — NOT NULL — Total Tax Amount
  • total_tax_amount_actual — decimal(12,4) — NOT NULL — Total Tax Amount Actual
  • total_shipping_amount — decimal(12,4) — NOT NULL — Total Shipping Amount
  • total_shipping_amount_actual — decimal(12,4) — NOT NULL — Total Shipping Amount Actual
  • total_discount_amount — decimal(12,4) — NOT NULL — Total Discount Amount
  • total_discount_amount_actual — decimal(12,4) — NOT NULL — Total Discount Amount Actual

sales_order_grid

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • status — varchar(32) — Status
  • store_id — smallint(5) — Store Id
  • store_name — varchar(255) — Store Name
  • customer_id — int(10) — Customer Id
  • base_grand_total — decimal(12,4) — Base Grand Total
  • base_total_paid — decimal(12,4) — Base Total Paid
  • grand_total — decimal(12,4) — Grand Total
  • total_paid — decimal(12,4) — Total Paid
  • increment_id — varchar(50) — Increment Id
  • base_currency_code — varchar(3) — Base Currency Code
  • order_currency_code — varchar(255) — Order Currency Code
  • shipping_name — varchar(255) — Shipping Name
  • billing_name — varchar(255) — Billing Name
  • created_at — timestamp — Created At
  • updated_at — timestamp — Updated At
  • billing_address — varchar(255) — Billing Address
  • shipping_address — varchar(255) — Shipping Address
  • shipping_information — varchar(255) — Shipping Method Name
  • customer_email — varchar(255) — Customer Email
  • customer_group — varchar(255) — Customer Group
  • subtotal — decimal(12,4) — Subtotal
  • shipping_and_handling — decimal(12,4) — Shipping and handling amount
  • customer_name — varchar(255) — Customer Name
  • payment_method — varchar(255) — Payment Method
  • total_refunded — decimal(12,4) — Total Refunded
  • FULLTEXT — KEY

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) — Foreign key → store.store_id — 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_history

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • parent_id — int(10) — Foreign key → sales_order.entity_id — NOT NULL — Parent Id
  • is_customer_notified — int(11) — Is Customer Notified
  • is_visible_on_front — smallint(5) — NOT NULL — Is Visible On Front
  • comment — text — Comment
  • status — varchar(32) — Status
  • created_at — timestamp — NOT NULL — Created At
  • entity_name — varchar(32) — Shows what entity history is bind to.

sales_order_status_label

  • status — varchar(32) — Foreign key → sales_order_status.status — NOT NULL — Status
  • store_id — smallint(5) — Foreign key → store.store_id — NOT NULL — Store Id
  • 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) — Foreign key → sales_order_item.item_id — 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) — Foreign key → sales_order_item.item_id — 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) — Foreign key → sales_payment_transaction.transaction_id — 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) — Foreign key → store.store_id — 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_refunded_aggregated_order

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — 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_sequence_meta

  • meta_id — int(10) — Primary key — NOT NULL — Id
  • entity_type — varchar(32) — NOT NULL — Prefix
  • store_id — smallint(5) — NOT NULL — Store Id
  • sequence_table — varchar(32) — NOT NULL — table for sequence

sales_sequence_profile

  • profile_id — int(10) — Primary key — NOT NULL — Id
  • meta_id — int(10) — Foreign key → sales_sequence_meta.meta_id — NOT NULL — Meta_id
  • prefix — varchar(32) — Prefix
  • suffix — varchar(32) — Suffix
  • start_value — int(10) — NOT NULL — Start value for sequence
  • step — int(10) — NOT NULL — Step for sequence
  • max_value — int(10) — NOT NULL — MaxValue for sequence
  • warning_value — int(10) — NOT NULL — WarningValue for sequence
  • is_active — tinyint(1) — NOT NULL — isActive flag

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) — Foreign key → store.store_id — 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_comment

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • parent_id — int(10) — Foreign key → sales_shipment.entity_id — NOT NULL — Parent 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_shipment_grid

  • entity_id — int(10) — Primary key — NOT NULL — Entity Id
  • increment_id — varchar(50) — Increment Id
  • store_id — smallint(5) — Store Id
  • order_increment_id — varchar(32) — NOT NULL — Order Increment Id
  • order_id — int(10) — NOT NULL — Order Id
  • order_created_at — timestamp — NOT NULL — Order Increment Id
  • customer_name — varchar(128) — NOT NULL — Customer Name
  • total_qty — decimal(12,4) — Total Qty
  • shipment_status — int(11) — Shipment Status
  • order_status — varchar(32) — Order
  • billing_address — varchar(255) — Billing Address
  • shipping_address — varchar(255) — Shipping Address
  • billing_name — varchar(128) — Billing Name
  • shipping_name — varchar(128) — Shipping Name
  • customer_email — varchar(128) — Customer Email
  • customer_group_id — int(11)
  • payment_method — varchar(32) — Payment Method
  • shipping_information — varchar(255) — Shipping Method Name
  • created_at — timestamp — Created At
  • updated_at — timestamp — Updated At
  • FULLTEXT — KEY

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

sales_shipping_aggregated

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — Order Status
  • shipping_description — varchar(255) — Shipping Description
  • orders_count — int(11) — NOT NULL — Orders Count
  • total_shipping — decimal(12,4) — Total Shipping
  • total_shipping_actual — decimal(12,4) — Total Shipping Actual

sales_shipping_aggregated_order

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — Period
  • store_id — smallint(5) — Foreign key → store.store_id — Store Id
  • order_status — varchar(50) — Order Status
  • shipping_description — varchar(255) — Shipping Description
  • orders_count — int(11) — NOT NULL — Orders Count
  • total_shipping — decimal(12,4) — Total Shipping
  • total_shipping_actual — decimal(12,4) — Total Shipping Actual

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

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — NOT NULL — Period
  • store_id — smallint(5) — Foreign key → store.store_id — 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
  • subtotal_amount_actual — decimal(12,4) — NOT NULL — Subtotal Amount Actual
  • discount_amount_actual — decimal(12,4) — NOT NULL — Discount Amount Actual
  • total_amount_actual — decimal(12,4) — NOT NULL — Total Amount Actual
  • rule_name — varchar(255) — Rule Name

salesrule_coupon_aggregated_order

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — NOT NULL — Period
  • store_id — smallint(5) — Foreign key → store.store_id — 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_coupon_aggregated_updated

  • id — int(10) — Primary key — NOT NULL — Id
  • period — date — NOT NULL — Period
  • store_id — smallint(5) — Foreign key → store.store_id — 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
  • subtotal_amount_actual — decimal(12,4) — NOT NULL — Subtotal Amount Actual
  • discount_amount_actual — decimal(12,4) — NOT NULL — Discount Amount Actual
  • total_amount_actual — decimal(12,4) — NOT NULL — Total Amount Actual
  • rule_name — varchar(255) — Rule Name

salesrule_coupon_usage

  • coupon_id — int(10) — Foreign key → salesrule_coupon.coupon_id — NOT NULL — Coupon Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Customer Id
  • times_used — int(10) — NOT NULL — Times Used

salesrule_customer

  • rule_customer_id — int(10) — Primary key — NOT NULL — Rule Customer Id
  • customer_id — int(10) — Foreign key → customer_entity.entity_id — NOT NULL — Customer Id
  • rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
  • times_used — smallint(5) — NOT NULL — Times Used

salesrule_customer_group

  • customer_group_id — int(10) — Foreign key → customer_group.customer_group_id — NOT NULL — Customer Group Id
  • rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id

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 → store.store_id — NOT NULL — Store Id
  • label — varchar(255) — Label

salesrule_product_attribute

  • attribute_id — smallint(5) — Foreign key → eav_attribute.attribute_id — NOT NULL — Attribute Id
  • customer_group_id — int(10) — Foreign key → customer_group.customer_group_id — NOT NULL — Customer Group Id
  • rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website Id

salesrule_website

  • rule_id — int(10) — Foreign key → salesrule.rule_id — NOT NULL — Rule Id
  • website_id — smallint(5) — Foreign key → store_website.website_id — NOT NULL — Website Id

store

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

store_website

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