{"table_name":"clearfund_expenses","full_table_name":"wp_clearfund_expenses","description":"Stores clearfund expenses data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clearfund_expenses ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `category_id` bigint(20) unsigned NOT NULL, `amount_local` decimal(12,2) NOT NULL DEFAULT 0.00, `currency` varchar(3) NOT NULL DEFAULT 'USD', `amount_usd` decimal(10,2) NOT NULL DEFAULT 0.00, `exchange_rate` decimal(12,6) NOT NULL DEFAULT 1.000000, `description` text NOT NULL, `vendor` varchar(150) NOT NULL DEFAULT '', `receipt_url` varchar(500) NOT NULL DEFAULT '', `action_photo_url` varchar(500) NOT NULL DEFAULT '', `reference_id` varchar(50) NOT NULL DEFAULT '', `submitted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `submitted_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `approved` tinyint(1) NOT NULL DEFAULT 0, `approved_by` bigint(20) unsigned NOT NULL DEFAULT 0, `approved_at` datetime DEFAULT NULL, `rejected` tinyint(1) NOT NULL DEFAULT 0, `rejection_note` text, `deleted` tinyint(1) NOT NULL DEFAULT 0, `deleted_by` bigint(20) unsigned NOT NULL DEFAULT 0, `deleted_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `category_id` (`category_id`), KEY `approved` (`approved`), KEY `deleted` (`deleted`), KEY `cat_submitted` (`category_id`, `submitted_at`) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"category_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"amount_local","type":"decimal(12,2)","nullable":false,"primary_key":false},{"name":"currency","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"amount_usd","type":"decimal(10,2)","nullable":false,"primary_key":false},{"name":"exchange_rate","type":"decimal(12,6)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":false,"primary_key":false},{"name":"vendor","type":"varchar(150)","nullable":false,"primary_key":false},{"name":"receipt_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"action_photo_url","type":"varchar(500)","nullable":false,"primary_key":false},{"name":"reference_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"submitted_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"submitted_at","type":"datetime","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"approved_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"approved_at","type":"datetime","nullable":true,"primary_key":false},{"name":"rejected","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"rejection_note","type":"text","nullable":true,"primary_key":false},{"name":"deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"deleted_by","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"deleted_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"clearfund","name":"ClearFund","active_installs":0,"version":"1.27.0","wp_org_url":"https://wordpress.org/plugins/clearfund/"}}