{"table_name":"faan_fields","full_table_name":"wp_faan_fields","description":"Stores faan fields data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_faan_fields ( session_id varchar(32) NOT NULL, field_key varchar(40) NOT NULL, label varchar(100) NOT NULL, field_type varchar(24) NOT NULL, position smallint(5) unsigned NOT NULL DEFAULT 0, step smallint(5) unsigned NOT NULL DEFAULT 1, reached tinyint(1) NOT NULL DEFAULT 0, completed tinyint(1) NOT NULL DEFAULT 0, errors smallint(5) unsigned NOT NULL DEFAULT 0, focus_count smallint(5) unsigned NOT NULL DEFAULT 0, time_ms int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (session_id,field_key) ) $charset;\" );","columns":[{"name":"session_id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"field_type","type":"varchar(24)","nullable":false,"primary_key":false},{"name":"position","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"step","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"reached","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"completed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"errors","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"focus_count","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"time_ms","type":"int(10) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"formvela-form-abandonment-analytics","name":"FormVela – Form Abandonment Analytics","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/formvela-form-abandonment-analytics/"}}