{"table_name":"cb_transactions","full_table_name":"wp_cb_transactions","description":"Stores cb transactions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `cb_transactions` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `customerId` BIGINT(20) UNSIGNED NOT NULL, `transactionTime` TEXT NULL, `receipt` VARCHAR(255) NULL , `transactionType` VARCHAR(255) NULL , `currency` VARCHAR(255) NULL, `totalOrderAmount` VARCHAR(255) NULL, `totalTaxAmount` VARCHAR(255) NULL, `transaction` MEDIUMBLOB NULL, PRIMARY KEY (`id`), UNIQUE KEY `arv_cb_customers_uq` (`customerId`, `receipt` ASC)) ENGINE","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"customerId","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"transactionTime","type":"TEXT","nullable":true,"primary_key":false},{"name":"receipt","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"transactionType","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"totalOrderAmount","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"totalTaxAmount","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"transaction","type":"MEDIUMBLOB","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-clickbank-vendor","name":"WP ClickBank Vendor","active_installs":10,"version":"0.9.1","wp_org_url":"https://wordpress.org/plugins/wp-clickbank-vendor/"}}