{"table_name":"ec_review_request","full_table_name":"wp_ec_review_request","description":"Stores ec review request data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_review_request ( request_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', email varchar(255) NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', token varchar(64) NOT NULL DEFAULT '', scheduled_at datetime DEFAULT NULL, sent_at datetime DEFAULT NULL, reminded_at datetime DEFAULT NULL, opened_at datetime DEFAULT NULL, reviewed_at datetime DEFAULT NULL, review_id int(11) NOT NULL DEFAULT '0', unsubscribed tinyint(1) NOT NULL DEFAULT '0', created_at datetime DEFAULT NULL, PRIMARY KEY (request_id), UNIQUE KEY token (token), KEY order_id (order_id), KEY product_id (product_id), KEY email_product (email(100), product_id), KEY scheduled_at (scheduled_at) ) $collate;\" );","columns":[{"name":"request_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_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":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"token","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"scheduled_at","type":"datetime","nullable":true,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"reminded_at","type":"datetime","nullable":true,"primary_key":false},{"name":"opened_at","type":"datetime","nullable":true,"primary_key":false},{"name":"reviewed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"review_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"unsubscribed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","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/"}}