{"table_name":"botbee_review_requests","full_table_name":"wp_botbee_review_requests","description":"Stores botbee review requests data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_botbee_review_requests ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_id BIGINT UNSIGNED NOT NULL, status VARCHAR(20) NOT NULL DEFAULT 'pending', token VARCHAR(100) DEFAULT NULL, trigger_status VARCHAR(50) NOT NULL DEFAULT 'completed', scheduled_at DATETIME NOT NULL, sent_at DATETIME DEFAULT NULL, used_at DATETIME DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY order_id (order_id), KEY status (status), KEY token (token), KEY scheduled_at (scheduled_at) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"token","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"trigger_status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"scheduled_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"used_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"botbee-webhook-automation","name":"BotBee Webhook Automation for WooCommerce","active_installs":0,"version":"1.3.0","wp_org_url":"https://wordpress.org/plugins/botbee-webhook-automation/"}}