{"table_name":"dwdpm_orders","full_table_name":"wp_dwdpm_orders","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_dwdpm_orders ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_key varchar(64) NOT NULL, user_id bigint(20) unsigned NOT NULL DEFAULT 0, email varchar(190) NOT NULL DEFAULT '', status varchar(30) NOT NULL DEFAULT 'pending', currency varchar(10) NOT NULL DEFAULT 'AUD', subtotal decimal(12,2) NOT NULL DEFAULT 0.00, discount_code varchar(80) NOT NULL DEFAULT '', discount_amount decimal(12,2) NOT NULL DEFAULT 0.00, total decimal(12,2) NOT NULL DEFAULT 0.00, payment_provider varchar(30) NOT NULL DEFAULT '', payment_reference varchar(190) NOT NULL DEFAULT '', fulfilled_at datetime NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY order_key (order_key), KEY user_id (user_id), KEY email (email), KEY status (status) ) $c;\");","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"order_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"email","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"subtotal","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"discount_code","type":"varchar(80)","nullable":false,"primary_key":false},{"name":"discount_amount","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"total","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"payment_provider","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"payment_reference","type":"varchar(190)","nullable":false,"primary_key":false},{"name":"fulfilled_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"delicious-digital-product-manager","name":"Delicious Digital Product Manager","active_installs":0,"version":"2.3.7","wp_org_url":"https://wordpress.org/plugins/delicious-digital-product-manager/"}}