{"table_name":"fe_event_entries","full_table_name":"wp_fe_event_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fe_event_entries ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, qrcode_id BIGINT(20) UNSIGNED NOT NULL, scancode VARCHAR(16) NOT NULL DEFAULT '', tracking_lap INT NOT NULL DEFAULT '0', scan_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, scan_location VARCHAR(32) NOT NULL DEFAULT '', scan_level TINYINT(1) NOT NULL DEFAULT '1', PRIMARY KEY (id), UNIQUE KEY scan_entry (qrcode_id, scancode, tracking_lap) ) ENGINE","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"qrcode_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"scancode","type":"VARCHAR(16)","nullable":false,"primary_key":false},{"name":"tracking_lap","type":"INT","nullable":false,"primary_key":false},{"name":"scan_date","type":"DATETIME","nullable":false,"primary_key":false},{"name":"scan_location","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"scan_level","type":"TINYINT(1)","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/"}}