{"table_name":"fe_event_email_log","full_table_name":"wp_fe_event_email_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_fe_event_email_log ( id BIGINT NOT NULL AUTO_INCREMENT, event_id BIGINT(20) UNSIGNED NOT NULL, order_id BIGINT(20) UNSIGNED NOT NULL, date_created DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, date_modified DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, provider_id ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost') NOT NULL DEFAULT 'local', email_type ENUM('normal','confirm','free') NOT NULL DEFAULT 'normal', provider_email_id VARCHAR(100) NOT NULL, sender_email VARCHAR(100) NOT NULL, receiver_email VARCHAR(100) NOT NULL, email_subject VARCHAR(100) NOT NULL, email_events TEXT NOT NULL, PRIMARY KEY (id), UNIQUE KEY provider_email_id_index (provider_email_id), UNIQUE KEY order_date_index (order_id, date_created) ) ENGINE","columns":[{"name":"id","type":"BIGINT","nullable":false,"primary_key":true},{"name":"event_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"order_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"date_created","type":"DATETIME","nullable":false,"primary_key":false},{"name":"date_modified","type":"DATETIME","nullable":false,"primary_key":false},{"name":"provider_id","type":"ENUM('local','smtp','amazon','brevo','mailgun','mailjet','postmark','sendgrid','smtp2go','sparkpost')","nullable":false,"primary_key":false},{"name":"email_type","type":"ENUM('normal','confirm','free')","nullable":false,"primary_key":false},{"name":"provider_email_id","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"sender_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"receiver_email","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_subject","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"email_events","type":"TEXT","nullable":false,"primary_key":false}],"plugin":{"slug":"fast-events","name":"Fast Events","active_installs":20,"version":"3.0.0","wp_org_url":"https://wordpress.org/plugins/fast-events/"}}