{"table_name":"clearfund_donor_impact_sent","full_table_name":"wp_clearfund_donor_impact_sent","description":"Stores clearfund donor impact sent data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clearfund_donor_impact_sent ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `expense_id` bigint(20) unsigned NOT NULL DEFAULT 0, `donation_id` bigint(20) unsigned NOT NULL DEFAULT 0, `amount_cents` bigint(20) NOT NULL DEFAULT 0, `donor_email` varchar(100) NOT NULL DEFAULT '', `sent_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `slice` (`expense_id`, `donation_id`), KEY `donor_email` (`donor_email`) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"expense_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"donation_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount_cents","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"donor_email","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":false,"primary_key":false}],"plugin":{"slug":"clearfund","name":"ClearFund","active_installs":0,"version":"1.27.0","wp_org_url":"https://wordpress.org/plugins/clearfund/"}}