{"table_name":"ec_order_withdrawal","full_table_name":"wp_ec_order_withdrawal","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS ec_order_withdrawal ( withdrawal_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', order_ref varchar(64) NOT NULL DEFAULT '', customer_name varchar(255) NOT NULL DEFAULT '', customer_email varchar(255) NOT NULL DEFAULT '', reason text NULL, note text NULL, withdrawn_lines longtext NULL, withdrawal_source varchar(20) NOT NULL DEFAULT 'page', submitted_at datetime DEFAULT NULL, deadline_at datetime DEFAULT NULL, in_time tinyint(1) DEFAULT NULL, withdrawal_status varchar(20) NOT NULL DEFAULT 'received', handled_at datetime DEFAULT NULL, handled_by int(11) NOT NULL DEFAULT '0', ack_sent_at datetime DEFAULT NULL, store_sent_at datetime DEFAULT NULL, PRIMARY KEY (withdrawal_id), KEY order_id (order_id), KEY withdrawal_status (withdrawal_status) ) $collate;\" );","columns":[{"name":"withdrawal_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_ref","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"customer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"customer_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"reason","type":"text","nullable":true,"primary_key":false},{"name":"note","type":"text","nullable":true,"primary_key":false},{"name":"withdrawn_lines","type":"longtext","nullable":true,"primary_key":false},{"name":"withdrawal_source","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"submitted_at","type":"datetime","nullable":true,"primary_key":false},{"name":"deadline_at","type":"datetime","nullable":true,"primary_key":false},{"name":"in_time","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"withdrawal_status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"handled_at","type":"datetime","nullable":true,"primary_key":false},{"name":"handled_by","type":"int(11)","nullable":false,"primary_key":false},{"name":"ack_sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"store_sent_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"wp-easycart","name":"WP EasyCart: Shopping Cart and eCommerce Store","active_installs":3000,"version":"6.0.5","wp_org_url":"https://wordpress.org/plugins/wp-easycart/"}}