7. Database Schema

admin

May 31, 2026

0 views

`ewebecommerce_surcharge_rule`

Column	Type	Nullable
`rule_id`	false
`name`	false
`description`	true
`is_active`	false
`priority`	false
`calculation_type`	false
`surcharge_amount`	false
`surcharge_percentage`	false
`threshold_amount`	false
`conditions_serialized`	true
`customer_groups`	true
`customer_type`	true
`min_order_count`	true
`min_lifetime_spending`	true
`store_ids`	true
`country_ids`	true
`state_ids`	true
`postcode_ranges`	true
`city_names`	true
`category_ids`	true
`product_skus`	true
`product_tags`	true
`category_condition`	true
`product_categories`	true
`exclude_categories`	true
`specific_products`	true
`payment_methods`	true
`shipping_methods`	true
`coupon_codes`	true
`coupon_behavior`	true
`days_of_week`	true
`time_from`	true
`time_to`	true
`date_from`	true
`date_to`	true
`holiday_dates`	true
`min_items`	true
`max_items`	true
`min_weight`	true
`max_weight`	true
`min_unique_products`	true
`notification_message`	true
`progress_bar_color`	true
`apply_before_tax`	false
`tax_class_id`	true
`include_in_tax`	false
`exclude_admin_orders`	false
`stop_further_rules`	false
`ab_test_group`	true
`ab_test_percentage`	true
`continent_codes`	true
`remote_area_enabled`	false
`remote_area_amount`	true
`created_at`	false
`updated_at`	false

`ewebecommerce_surcharge_analytics`

Column	Type	Nullable
`analytics_id`	false
`rule_id`	true
`order_id`	true
`quote_id`	true
`event_type`	false
`surcharge_amount`	false
`order_subtotal`	false
`currency_code`	false
`customer_id`	true
`customer_group`	true
`customer_type`	true
`payment_method`	true
`shipping_method`	true
`country_id`	true
`region`	true
`city`	true
`was_waived`	false
`waive_reason`	true
`coupon_code`	true
`ab_test_group`	true
`store_id`	true
`created_at`	false

`quote`

Column	Type	Nullable
`minimum_order_surcharge`	true
`base_minimum_order_surcharge`	true
`surcharge_rule_id`	true
`surcharge_rule_name`	true

`sales_order`

Column	Type	Nullable
`minimum_order_surcharge`	true
`base_minimum_order_surcharge`	true
`surcharge_rule_id`	true
`surcharge_rule_name`	true

`sales_invoice`

Column	Type	Nullable
`minimum_order_surcharge`	true
`base_minimum_order_surcharge`	true

`sales_creditmemo`

Column	Type	Nullable
`minimum_order_surcharge`	true
`base_minimum_order_surcharge`	true

`sales_order_grid`

Column	Type	Nullable
`minimum_order_surcharge`	true

`ewebecommerce_surcharge_rule_history`

Column	Type	Nullable
`history_id`	false
`rule_id`	false
`changes`	true
`admin_user_id`	true
`action`	false
`created_at`	false

`ewebecommerce_surcharge_abandonment`

Column	Type	Nullable
`abandonment_id`	false
`quote_id`	false
`customer_id`	true
`customer_email`	true
`cart_total`	false
`surcharge_amount`	false
`recovery_email_sent`	false
`abandoned_at`	false
`recovered_at`	true