{"table_name":"ebay_transactions","full_table_name":"wp_ebay_transactions","description":"Stores ebay transactions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_ebay_transactions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `item_id` bigint(255) DEFAULT NULL, `transaction_id` bigint(255) DEFAULT NULL, `date_created` datetime DEFAULT NULL, `item_title` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `details` text, `post_id` int(11) DEFAULT NULL, `buyer_userid` varchar(255) DEFAULT NULL, `buyer_name` varchar(255) DEFAULT NULL, `buyer_email` varchar(255) DEFAULT NULL, `eBayPaymentStatus` varchar(50) DEFAULT NULL, `CheckoutStatus` varchar(50) DEFAULT NULL, `ShippingService` varchar(75) DEFAULT NULL, `PaymentMethod` varchar(50) DEFAULT NULL, `ShippingAddress_City` varchar(50) DEFAULT NULL, `CompleteStatus` varchar(50) DEFAULT NULL, `LastTimeModified` datetime DEFAULT NULL, PRIMARY KEY (`id`) );","columns":[{"name":"id","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"item_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"transaction_id","type":"bigint(255)","nullable":true,"primary_key":false},{"name":"date_created","type":"datetime","nullable":true,"primary_key":false},{"name":"item_title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"price","type":"float","nullable":true,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"details","type":"text","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"buyer_userid","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"buyer_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"buyer_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"eBayPaymentStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"CheckoutStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingService","type":"varchar(75)","nullable":true,"primary_key":false},{"name":"PaymentMethod","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"ShippingAddress_City","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"CompleteStatus","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"LastTimeModified","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-lister-for-ebay","name":"WP-Lister Lite for eBay","active_installs":2000,"version":"3.8.7","wp_org_url":"https://wordpress.org/plugins/wp-lister-for-ebay/"}}