{"table_name":"crpay_transactions","full_table_name":"wp_crpay_transactions","description":"Stores crpay transactions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS crpay_transactions (id INT NOT NULL AUTO_INCREMENT, `from` VARCHAR(191) NOT NULL DEFAULT \"\", `to` VARCHAR(191), hash VARCHAR(191) NOT NULL DEFAULT \"\", `title` VARCHAR(500) NOT NULL DEFAULT \"\", description VARCHAR(1000) NOT NULL DEFAULT \"\", amount VARCHAR(100) NOT NULL, amount_fiat VARCHAR(100) NOT NULL, cryptocurrency VARCHAR(10) NOT NULL, currency VARCHAR(10) NOT NULL, external_reference VARCHAR(1000) NOT NULL DEFAULT \"\", creation_time DATETIME NOT NULL, status VARCHAR(1) NOT NULL, webhook TINYINT NOT NULL, billing TINYTEXT, vat FLOAT, vat_details TINYTEXT, checkout_id INT, type TINYINT, PRIMARY KEY (id), FOREIGN KEY (checkout_id) REFERENCES crpay_checkouts(id) ON DELETE CASCADE) ENGINE","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"from","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"to","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"description","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"amount","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"amount_fiat","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"cryptocurrency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"external_reference","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"creation_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(1)","nullable":false,"primary_key":false},{"name":"webhook","type":"TINYINT","nullable":false,"primary_key":false},{"name":"billing","type":"TINYTEXT","nullable":true,"primary_key":false},{"name":"vat","type":"FLOAT","nullable":true,"primary_key":false},{"name":"vat_details","type":"TINYTEXT","nullable":true,"primary_key":false},{"name":"type","type":"TINYINT","nullable":true,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false}],"plugin":{"slug":"cryptopayment-gateway","name":"CryptoPayment Gateway","active_installs":0,"version":"1.2.2","wp_org_url":"https://wordpress.org/plugins/cryptopayment-gateway/"}}