{"table_name":"bingocr_payments","full_table_name":"wp_bingocr_payments","description":"Stores bingocr payments data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_bingocr_payments ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, reservation_id bigint(20) unsigned NOT NULL, method varchar(20) NOT NULL DEFAULT 'paypal', amount decimal(10,2) NOT NULL DEFAULT 0.00, currency varchar(10) NOT NULL DEFAULT 'EUR', status varchar(20) NOT NULL DEFAULT 'pending', paypal_order_id varchar(64) DEFAULT NULL, paypal_capture_id varchar(64) DEFAULT NULL, payer_email varchar(200) DEFAULT NULL, gateway_response longtext DEFAULT NULL, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, completed_at datetime DEFAULT NULL, PRIMARY KEY (id), KEY reservation_id (reservation_id), KEY paypal_order_id (paypal_order_id) ) $c;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"reservation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"method","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"amount","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"paypal_order_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"paypal_capture_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"payer_email","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"gateway_response","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"completed_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"bingocar","name":"Bingo Car Rental","active_installs":0,"version":"1.0.59","wp_org_url":"https://wordpress.org/plugins/bingocar/"}}