{"table_name":"dbcomw_rule_applications","full_table_name":"wp_dbcomw_rule_applications","description":"Stores dbcomw rule applications data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_dbcomw_rule_applications ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, rule_id bigint(20) unsigned NOT NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, user_id bigint(20) unsigned DEFAULT 0, discount_amount decimal(12,2) NOT NULL DEFAULT 0.00, original_subtotal decimal(12,2) NOT NULL DEFAULT 0.00, applied_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY idx_rule_id (rule_id), KEY idx_order_id (order_id), KEY idx_user_id (user_id) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"rule_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"order_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"original_subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"applied_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"debyendu-cart-offer-manager-woocommerce","name":"Cart Offer Manager for WooCommerce","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/debyendu-cart-offer-manager-woocommerce/"}}