{"table_name":"dlm_order_item","full_table_name":"wp_dlm_order_item","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE IF NOT EXISTS `wp_dlm_order_item` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `order_id` INT UNSIGNED NOT NULL, `label` VARCHAR(255) NULL, `qty` INT NULL, `product_id` INT UNSIGNED NULL, `tax_class` VARCHAR(255) NULL, `tax_total` INT NULL, `subtotal` INT NULL, `total` INT NULL, PRIMARY KEY (`id`), CONSTRAINT `wp_fk_order_item_order1` FOREIGN KEY (`order_id`) REFERENCES `wp_dlm_order` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"order_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"qty","type":"INT","nullable":true,"primary_key":false},{"name":"product_id","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"tax_class","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"tax_total","type":"INT","nullable":true,"primary_key":false},{"name":"subtotal","type":"INT","nullable":true,"primary_key":false},{"name":"total","type":"INT","nullable":true,"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/"}}