{"table_name":"fcwg_analytics","full_table_name":"wp_fcwg_analytics","description":"Stores analytics or statistics data.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fcwg_analytics ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, widget_id BIGINT UNSIGNED NOT NULL, channel_key VARCHAR(60) NOT NULL, event_date DATE NOT NULL, clicks INT NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY widget_channel_date (widget_id, channel_key, event_date), KEY widget_id (widget_id), KEY event_date (event_date) ) $c;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"widget_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"channel_key","type":"VARCHAR(60)","nullable":false,"primary_key":false},{"name":"event_date","type":"DATE","nullable":false,"primary_key":false},{"name":"clicks","type":"INT","nullable":false,"primary_key":false}],"plugin":{"slug":"pb-floats-contact-widget","name":"PB Floats Contact Widget","active_installs":0,"version":"1.3.1","wp_org_url":"https://wordpress.org/plugins/pb-floats-contact-widget/"}}