{"table_name":"fct_customers","full_table_name":"wp_fct_customers","description":"Stores fct customers data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_fct_customers` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint unsigned DEFAULT NULL,\\n  `contact_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `email` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `first_name` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `last_name` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT 'active',\\n  `purchase_value` json DEFAULT NULL,\\n  `purchase_count` bigint unsigned NOT NULL DEFAULT '0',\\n  `ltv` bigint NOT NULL DEFAULT '0',\\n  `first_purchase_date` datetime DEFAULT NULL,\\n  `last_purchase_date` datetime DEFAULT NULL,\\n  `aov` decimal(18,2) DEFAULT NULL,\\n  `notes` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `country` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `city` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `state` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `postcode` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_cus__email` (`email`),\\n  KEY `wp_fct_cus__user_id` (`user_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"fluent-cart","name":"FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler","active_installs":5000,"version":"1.3.18","wp_org_url":"https://wordpress.org/plugins/fluent-cart/"}}