{"table_name":"wpbdp_payments","full_table_name":"wp_wpbdp_payments","description":"Stores wpbdp payments data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_wpbdp_payments ( id bigint(20) PRIMARY KEY AUTO_INCREMENT, listing_id bigint(20) NOT NULL DEFAULT 0, parent_id bigint(20) NOT NULL DEFAULT 0, payment_key varchar(255) NULL DEFAULT '', payment_type varchar(255) NULL DEFAULT '', payment_items longblob NULL, data longblob NULL, context varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_email varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_first_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_last_name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '', payer_data blob NULL, gateway varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, gateway_tx_id varchar(255) NULL DEFAULT '', currency_code varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'USD', amount decimal(10,2) NOT NULL DEFAULT 0.00, status varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, is_test boolean NULL, created_at datetime NOT NULL DEFAULT '0000-00-00 00:00:00', processed_on timestamp NULL DEFAULT NULL, processed_by varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL, KEY listing_id (listing_id), KEY status (status) ) DEFAULT CHARSET","columns":[{"name":"id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"listing_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"parent_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"payment_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payment_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payment_items","type":"longblob","nullable":true,"primary_key":false},{"name":"data","type":"longblob","nullable":true,"primary_key":false},{"name":"context","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_email","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_first_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_last_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"payer_data","type":"blob","nullable":true,"primary_key":false},{"name":"gateway","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"gateway_tx_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"currency_code","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_test","type":"boolean","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"processed_on","type":"timestamp","nullable":true,"primary_key":false},{"name":"processed_by","type":"varchar(255)","nullable":true,"primary_key":false}],"plugin":{"slug":"business-directory-plugin","name":"Business Directory Plugin – Easy Listing Directories for WordPress","active_installs":10000,"version":"6.4.24","wp_org_url":"https://wordpress.org/plugins/business-directory-plugin/"}}