{"table_name":"dlm_order_transaction","full_table_name":"wp_dlm_order_transaction","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order_transaction` ( `id` INT NOT NULL AUTO_INCREMENT, `date_created` DATETIME NULL, `date_modified` DATETIME NULL, `amount` INT NULL, `status` VARCHAR(50) NULL, `processor` VARCHAR(255) NULL, `processor_nice_name` VARCHAR(255) NULL, `processor_transaction_id` VARCHAR(255) NULL, `processor_status` VARCHAR(255) NULL, `order_id` INT UNSIGNED NOT NULL, PRIMARY KEY (`id`), CONSTRAINT `wp_fk_transaction_order1` FOREIGN KEY (`order_id`) REFERENCES `wp_dlm_order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"date_created","type":"DATETIME","nullable":true,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":true,"primary_key":false},{"name":"amount","type":"INT","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"processor","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_nice_name","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_transaction_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"processor_status","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"order_id","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"plugin":{"slug":"download-monitor","name":"Download Monitor","active_installs":90000,"version":"5.1.13","wp_org_url":"https://wordpress.org/plugins/download-monitor/"}}