{"table_name":"botbee_abandoned_carts","full_table_name":"wp_botbee_abandoned_carts","description":"Stores botbee abandoned carts data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_botbee_abandoned_carts ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT UNSIGNED DEFAULT NULL, session_key VARCHAR(200) NOT NULL DEFAULT '', email VARCHAR(200) DEFAULT NULL, phone VARCHAR(50) DEFAULT NULL, first_name VARCHAR(100) DEFAULT NULL, last_name VARCHAR(100) DEFAULT NULL, cart_contents LONGTEXT NOT NULL, cart_total DECIMAL(19,4) NOT NULL DEFAULT '0.0000', currency VARCHAR(10) DEFAULT NULL, applied_coupons TEXT, status VARCHAR(20) NOT NULL DEFAULT 'active', recover_token VARCHAR(100) DEFAULT NULL, coupon_code VARCHAR(100) DEFAULT NULL, last_activity DATETIME NOT NULL, abandoned_at DATETIME DEFAULT NULL, recovered_at DATETIME DEFAULT NULL, notified_at DATETIME DEFAULT NULL, stage TINYINT NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY session_key (session_key), KEY user_id (user_id), KEY email (email), KEY status (status), KEY abandoned_at (abandoned_at) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"session_key","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(200)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"cart_contents","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"cart_total","type":"DECIMAL(19,4)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"applied_coupons","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"recover_token","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"coupon_code","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_activity","type":"DATETIME","nullable":false,"primary_key":false},{"name":"abandoned_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"recovered_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"notified_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"stage","type":"TINYINT","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_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/"}}