{"table_name":"better_payment","full_table_name":"wp_better_payment","description":"Stores better payment data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS wp_better_payment( id bigint(20) NOT NULL AUTO_INCREMENT, order_id varchar(50) NOT NULL, transaction_id varchar(50) DEFAULT '', amount decimal(10,2) NOT NULL, status varchar(50) DEFAULT NULL, source varchar(50) NOT NULL, payment_date datetime DEFAULT NULL, email varchar(50) NOT NULL DEFAULT '', customer_info longtext, form_fields_info longtext, currency varchar(11) NOT NULL DEFAULT '', referer varchar(64) DEFAULT NULL, obj_id text, PRIMARY KEY (id), KEY order_id (order_id), KEY status (status) ) ENGINE","columns":[{"name":"id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"order_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"transaction_id","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"source","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_date","type":"datetime","nullable":true,"primary_key":false},{"name":"email","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"customer_info","type":"longtext","nullable":true,"primary_key":false},{"name":"form_fields_info","type":"longtext","nullable":true,"primary_key":false},{"name":"currency","type":"varchar(11)","nullable":false,"primary_key":false},{"name":"referer","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"obj_id","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"better-payment","name":"Better Payment – Instant Payments, Donations, Fundraising with Subscriptions & More","active_installs":6000,"version":"2.2.1","wp_org_url":"https://wordpress.org/plugins/better-payment/"}}