{"table_name":"picks","full_table_name":"wp_picks","description":"Stores picks data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_picks` (\\n  `id` int NOT NULL AUTO_INCREMENT,\\n  `tipster_id` int NOT NULL,\\n  `pick_id` int NOT NULL,\\n  `bookie_id` varchar(255) NOT NULL,\\n  `sport_id` int NOT NULL,\\n  `competition_id` int NOT NULL,\\n  `pick_datetime` bigint DEFAULT NULL,\\n  `pick_cuote` double DEFAULT NULL,\\n  `pick_stake` double DEFAULT NULL,\\n  `pick_type` varchar(15) NOT NULL,\\n  `pick_result` varchar(15) NOT NULL,\\n  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_picks_tipster_id` (`tipster_id`),\\n  KEY `wp_picks_pick_id` (`pick_id`),\\n  KEY `wp_picks_bookie_id` (`bookie_id`(250)),\\n  KEY `wp_picks_tipster_id_datetime` (`tipster_id`,`pick_datetime`)\\n) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci","columns":[],"plugin":{"slug":"tipster-tap","name":"Tipster TAP","active_installs":20,"version":"4.2.2","wp_org_url":"https://wordpress.org/plugins/tipster-tap/"}}