{"table_name":"faan_sessions","full_table_name":"wp_faan_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_faan_sessions ( id varchar(32) NOT NULL, form_id bigint(20) unsigned NOT NULL, created_at datetime NOT NULL, updated_at datetime NOT NULL, device varchar(8) NOT NULL, started tinyint(1) NOT NULL DEFAULT 0, attempted tinyint(1) NOT NULL DEFAULT 0, submitted tinyint(1) NOT NULL DEFAULT 0, last_field varchar(40) NOT NULL DEFAULT '', steps smallint(5) unsigned NOT NULL DEFAULT 0, duration int(10) unsigned NOT NULL DEFAULT 0, sequence int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (id), KEY form_date (form_id,created_at), KEY created_at (created_at), KEY updated_at (updated_at) ) $charset;\" );","columns":[{"name":"id","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"form_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"device","type":"varchar(8)","nullable":false,"primary_key":false},{"name":"started","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"attempted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"submitted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"last_field","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"steps","type":"smallint(5) unsigned","nullable":false,"primary_key":false},{"name":"duration","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sequence","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/"}}