wp_fct_retention_snapshots
LiveStores fct retention snapshots data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| when | customer | YES |
| the | month | YES |
CREATE TABLE Statement
CREATE TABLE `wp_fct_retention_snapshots` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `cohort` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'YYYY-MM format, when customer first subscribed',\n `period` varchar(7) COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT 'YYYY-MM format, the month being measured',\n `product_id` bigint unsigned DEFAULT NULL COMMENT 'NULL means all products combined',\n `cohort_customers` int unsigned NOT NULL DEFAULT '0',\n `cohort_mrr` bigint unsigned NOT NULL DEFAULT '0',\n `retained_customers` int unsigned NOT NULL DEFAULT '0',\n `retained_mrr` bigint unsigned NOT NULL DEFAULT '0',\n `new_customers` int unsigned NOT NULL DEFAULT '0' COMMENT 'Recyclers who came back this period',\n `churned_customers` int unsigned NOT NULL DEFAULT '0' COMMENT 'Left this period',\n `retention_rate_customers` decimal(5,2) DEFAULT NULL,\n `retention_rate_mrr` decimal(5,2) DEFAULT NULL,\n `period_offset` int unsigned NOT NULL DEFAULT '0',\n `created_at` datetime DEFAULT NULL,\n `updated_at` datetime DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `wp_fct_rs_cohort_period_product_idx` (`cohort`,`period`,`product_id`),\n KEY `wp_fct_rs_cohort_idx` (`cohort`),\n KEY `wp_fct_rs_period_idx` (`period`),\n KEY `wp_fct_rs_product_idx` (`product_id`),\n KEY `wp_fct_rs_offset_idx` (`period_offset`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Safe to delete?
If you have uninstalled FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_fct_retention_snapshots`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler