Database Schema

Database Schema

📷

Add: screenshots/database-schema.png

TablePurpose`ewebecommerce_surcharge_rule`Stores all surcharge rules with conditions`ewebecommerce_surcharge_analytics`Tracks surcharge application analytics`ewebecommerce_surcharge_rule_history`Audit log of rule changes`ewebecommerce_surcharge_abandonment`Cart abandonment tracking data

The module also extends these Magento core tables:

• quote — Adds surcharge amount columns to cart
• sales_order — Adds surcharge totals to orders
• sales_invoice — Adds surcharge to invoices
• sales_creditmemo — Adds surcharge to credit memos
• sales_order_grid — Adds surcharge column to admin order grid