{"table_name":"ec_offer_redemption","full_table_name":"wp_ec_offer_redemption","description":"Stores ec offer redemption data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_offer_redemption ( offer_redemption_id int(11) NOT NULL AUTO_INCREMENT, offer_id int(11) NOT NULL DEFAULT '0', offer_code_id int(11) NOT NULL DEFAULT '0', code varchar($max_index_length) NOT NULL DEFAULT '', order_id int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', email varchar(255) NOT NULL DEFAULT '', discount_amount float(15,3) NOT NULL DEFAULT '0.000', redemption_status varchar(20) NOT NULL DEFAULT 'completed', redemption_date timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (offer_redemption_id), KEY offer_redemption_offer_id (offer_id), KEY offer_redemption_order_id (order_id), KEY offer_redemption_user_id (user_id), KEY offer_redemption_offer_email (offer_id,email(100)) ) $collate;\" );","columns":[{"name":"offer_redemption_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"offer_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"offer_code_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"code","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"redemption_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"redemption_date","type":"timestamp","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}