{"table_name":"fct_subscriptions","full_table_name":"wp_fct_subscriptions","description":"Stores fct subscriptions data created by this plugin.","detection_method":"live","confidence":"high","create_sql":"CREATE TABLE `wp_fct_subscriptions` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `customer_id` bigint unsigned NOT NULL,\\n  `parent_order_id` bigint unsigned NOT NULL,\\n  `product_id` bigint unsigned NOT NULL,\\n  `item_name` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `quantity` int NOT NULL DEFAULT '1',\\n  `variation_id` bigint unsigned NOT NULL,\\n  `billing_interval` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `signup_fee` bigint unsigned NOT NULL DEFAULT '0',\\n  `initial_tax_total` bigint unsigned NOT NULL DEFAULT '0',\\n  `recurring_amount` bigint unsigned NOT NULL DEFAULT '0',\\n  `recurring_tax_total` bigint unsigned NOT NULL DEFAULT '0',\\n  `recurring_total` bigint unsigned NOT NULL DEFAULT '0',\\n  `bill_times` bigint unsigned NOT NULL DEFAULT '0',\\n  `bill_count` int unsigned NOT NULL DEFAULT '0',\\n  `expire_at` datetime DEFAULT NULL,\\n  `trial_ends_at` datetime DEFAULT NULL,\\n  `canceled_at` datetime DEFAULT NULL,\\n  `restored_at` datetime DEFAULT NULL,\\n  `collection_method` enum('automatic','manual','system') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'automatic',\\n  `next_billing_date` datetime DEFAULT NULL,\\n  `trial_days` int unsigned NOT NULL DEFAULT '0',\\n  `vendor_customer_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `vendor_plan_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `vendor_subscription_id` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `status` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `original_plan` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `vendor_response` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `current_payment_method` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `config` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_index__order_subscription_idx` (`parent_order_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/"}}