{"table_name":"clientoctopus_lead_reminder_log","full_table_name":"wp_clientoctopus_lead_reminder_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_clientoctopus_lead_reminder_log ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT UNSIGNED NOT NULL, trigger_event VARCHAR(40) NOT NULL, sent_at DATETIME NOT NULL, PRIMARY KEY (id), UNIQUE KEY lead_trigger (lead_id, trigger_event), KEY lead_id (lead_id) ) $charset_collate;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"lead_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"trigger_event","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"sent_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"clientoctopus","name":"Client Octopus","active_installs":0,"version":"1.4.1","wp_org_url":"https://wordpress.org/plugins/clientoctopus/"}}