{"table_name":"poptics_analytics_meta","full_table_name":"wp_poptics_analytics_meta","description":"Stores additional metadata (key-value pairs) for poptics analytics records.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS `wp_poptics_analytics_meta` ( `id` int(11) NOT NULL AUTO_INCREMENT, `analytics_id` int(11) DEFAULT NULL, `campaign_id` bigint(20) UNSIGNED DEFAULT NULL, `date` date DEFAULT NULL, `meta_key` varchar(150) DEFAULT NULL, `meta_value` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK_wp_poptics_analytics_with_meta` (`analytics_id`), KEY `campaign_id` (`campaign_id`), KEY `date` (`date`), KEY `meta_key` (`meta_key`) ) ENGINE","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"analytics_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"campaign_id","type":"bigint(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(150)","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false}],"plugin":{"slug":"poptics","name":"Poptics – Popup Builder, Email Opt-ins, Exit-Intent & WooCommerce Popups Sales","active_installs":2000,"version":"1.0.22","wp_org_url":"https://wordpress.org/plugins/poptics/"}}