{"slug":"fluent-cart","name":"FluentCart A New Era of eCommerce – Faster, Lighter, and Simpler","description":"Sell Subscriptions, Physical Products, Digital Downloads easier than ever. Built for performance, scalability, and flexibility.","author":"WPManageNinja","active_installs":5000,"version":"1.3.18","wp_org_url":"https://wordpress.org/plugins/fluent-cart/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_actions` (\\n  `action_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `hook` varchar(191) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `scheduled_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `scheduled_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `priority` tinyint unsigned NOT NULL DEFAULT '10',\\n  `args` varchar(191) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `schedule` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `group_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `attempts` int NOT NULL DEFAULT '0',\\n  `last_attempt_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `last_attempt_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  `claim_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `extended_args` varchar(8000) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  PRIMARY KEY (`action_id`),\\n  KEY `hook_status_scheduled_date_gmt` (`hook`(163),`status`,`scheduled_date_gmt`),\\n  KEY `status_scheduled_date_gmt` (`status`,`scheduled_date_gmt`),\\n  KEY `scheduled_date_gmt` (`scheduled_date_gmt`),\\n  KEY `args` (`args`),\\n  KEY `group_id` (`group_id`),\\n  KEY `last_attempt_gmt` (`last_attempt_gmt`),\\n  KEY `claim_id_status_priority_scheduled_date_gmt` (`claim_id`,`status`,`priority`,`scheduled_date_gmt`),\\n  KEY `status_last_attempt_gmt` (`status`,`last_attempt_gmt`),\\n  KEY `status_claim_id` (`status`,`claim_id`)\\n) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_claims","full_table_name":"wp_actionscheduler_claims","description":"Stores actionscheduler claims data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_claims` (\\n  `claim_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `date_created_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`claim_id`),\\n  KEY `date_created_gmt` (`date_created_gmt`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_groups","full_table_name":"wp_actionscheduler_groups","description":"Stores actionscheduler groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_groups` (\\n  `group_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `slug` varchar(255) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  PRIMARY KEY (`group_id`),\\n  KEY `slug` (`slug`(191))\\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_actionscheduler_logs` (\\n  `log_id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `action_id` bigint unsigned NOT NULL,\\n  `message` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `log_date_gmt` datetime DEFAULT '0000-00-00 00:00:00',\\n  `log_date_local` datetime DEFAULT '0000-00-00 00:00:00',\\n  PRIMARY KEY (`log_id`),\\n  KEY `action_id` (`action_id`),\\n  KEY `log_date_gmt` (`log_date_gmt`)\\n) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_activity","full_table_name":"wp_fct_activity","description":"Stores fct activity data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_activity` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'info' COMMENT 'success / warning / failed / info',\\n  `log_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'activity' COMMENT 'api',\\n  `module_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'order' COMMENT 'Full Model Path',\\n  `module_id` bigint DEFAULT NULL,\\n  `module_name` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'order' COMMENT 'order / product / user / coupon / subscription / payment / refund / shipment / activity',\\n  `user_id` bigint unsigned DEFAULT NULL,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `content` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `read_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'unread' COMMENT 'read / unread',\\n  `created_by` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'FCT-BOT' COMMENT 'FCT-BOT / usename',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_act__module_id_idx` (`module_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_applied_coupons","full_table_name":"wp_fct_applied_coupons","description":"Stores fct applied coupons data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_applied_coupons` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `coupon_id` bigint unsigned DEFAULT NULL,\\n  `code` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `amount` double NOT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `fct_acoup__code_idx` (`code`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_atts_groups","full_table_name":"wp_fct_atts_groups","description":"Stores fct atts groups data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_atts_groups` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `slug` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `description` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `settings` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `title` (`title`),\\n  UNIQUE KEY `slug` (`slug`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_atts_relations","full_table_name":"wp_fct_atts_relations","description":"Stores fct atts relations data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_atts_relations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `group_id` bigint unsigned NOT NULL,\\n  `term_id` bigint unsigned NOT NULL,\\n  `object_id` bigint unsigned NOT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_at_rel__group_id_idx` (`group_id`),\\n  KEY `wp_fct_at_rel__term_id_idx` (`term_id`),\\n  KEY `wp_fct_at_rel__obj_id_idx` (`object_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_atts_terms","full_table_name":"wp_fct_atts_terms","description":"Stores fct atts terms data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_atts_terms` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `group_id` bigint unsigned DEFAULT NULL,\\n  `serial` int unsigned DEFAULT NULL,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `slug` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `description` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `settings` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_attt__group_id_idx` (`group_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_carts","full_table_name":"wp_fct_carts","description":"Stores fct carts data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_carts` (\\n  `customer_id` bigint unsigned DEFAULT NULL,\\n  `user_id` bigint unsigned DEFAULT NULL,\\n  `order_id` bigint unsigned DEFAULT NULL,\\n  `cart_hash` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `checkout_data` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `cart_data` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `utm_data` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `coupons` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `first_name` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `last_name` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `email` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `stage` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'draft',\\n  `cart_group` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'global',\\n  `user_agent` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `ip_address` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `completed_at` timestamp NULL DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  `deleted_at` timestamp NULL DEFAULT NULL,\\n  UNIQUE KEY `cart_hash` (`cart_hash`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_coupons","full_table_name":"wp_fct_coupons","description":"Stores fct coupons data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_coupons` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(200) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `code` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `priority` int DEFAULT NULL,\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `conditions` json DEFAULT NULL,\\n  `amount` double NOT NULL,\\n  `use_count` int DEFAULT '0',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `notes` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `stackable` varchar(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'no',\\n  `show_on_checkout` varchar(3) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'yes',\\n  `start_date` timestamp NULL DEFAULT NULL,\\n  `end_date` timestamp NULL DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `code` (`code`),\\n  KEY `wp_fct_cpn__code_idx` (`code`),\\n  KEY `wp_fct_cpn__status_idx` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_customer_addresses","full_table_name":"wp_fct_customer_addresses","description":"Stores fct customer addresses data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_customer_addresses` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `customer_id` bigint unsigned NOT NULL,\\n  `is_primary` tinyint(1) NOT NULL DEFAULT '0',\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'billing',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'active',\\n  `label` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `name` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `address_1` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `address_2` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `city` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `state` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `phone` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `email` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `postcode` varchar(32) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `country` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_cus_ad__customer_is_primary` (`customer_id`,`is_primary`),\\n  KEY `wp_fct_cus_ad__type` (`type`),\\n  KEY `wp_fct_cus_ad__status` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_customer_meta","full_table_name":"wp_fct_customer_meta","description":"Stores additional metadata (key-value pairs) for fct customer records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_customer_meta` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `customer_id` bigint unsigned DEFAULT NULL,\\n  `meta_key` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_cm__meta_key` (`meta_key`),\\n  KEY `wp_fct_cm__customer_id` (`customer_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_customers","full_table_name":"wp_fct_customers","description":"Stores fct customers data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"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"},{"table_name":"fct_label","full_table_name":"wp_fct_label","description":"Stores fct label data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_label` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `value` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `value` (`value`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_label_relationships","full_table_name":"wp_fct_label_relationships","description":"Stores fct label relationships data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_label_relationships` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `label_id` bigint NOT NULL,\\n  `labelable_id` bigint NOT NULL,\\n  `labelable_type` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_labr__label_id_idx` (`label_id`),\\n  KEY `wp_fct_labr__labelable_id_idx` (`labelable_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_meta","full_table_name":"wp_fct_meta","description":"Stores additional metadata (key-value pairs) for fct records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_meta` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `object_type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `object_id` bigint DEFAULT NULL,\\n  `meta_key` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_mt__mt_idx` (`object_type`),\\n  KEY `wp_fct_mt__mto_id_idx` (`object_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_addresses","full_table_name":"wp_fct_order_addresses","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_addresses` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'billing',\\n  `name` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `address_1` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `address_2` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `city` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `state` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `postcode` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `country` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_download_permissions","full_table_name":"wp_fct_order_download_permissions","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_download_permissions` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `variation_id` bigint unsigned NOT NULL,\\n  `download_id` bigint unsigned NOT NULL,\\n  `download_count` int DEFAULT NULL,\\n  `download_limit` int DEFAULT NULL,\\n  `access_expires` datetime DEFAULT NULL,\\n  `customer_id` bigint unsigned NOT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_odp__order_id_idx` (`order_id`),\\n  KEY `wp_fct_odp__download_id_idx` (`download_id`),\\n  KEY `wp_fct_odp__variation_id_idx` (`variation_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_items","full_table_name":"wp_fct_order_items","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_items` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `post_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `fulfillment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'physical',\\n  `payment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'onetime',\\n  `post_title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `title` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `object_id` bigint unsigned DEFAULT NULL,\\n  `cart_index` bigint unsigned NOT NULL DEFAULT '0',\\n  `quantity` int NOT NULL DEFAULT '1',\\n  `unit_price` bigint NOT NULL DEFAULT '0',\\n  `cost` bigint NOT NULL DEFAULT '0',\\n  `subtotal` bigint NOT NULL DEFAULT '0',\\n  `tax_amount` bigint NOT NULL DEFAULT '0',\\n  `shipping_charge` bigint NOT NULL DEFAULT '0',\\n  `discount_total` bigint NOT NULL DEFAULT '0',\\n  `line_total` bigint NOT NULL DEFAULT '0',\\n  `refund_total` bigint NOT NULL DEFAULT '0',\\n  `rate` bigint NOT NULL DEFAULT '1',\\n  `other_info` json DEFAULT NULL,\\n  `line_meta` json DEFAULT NULL,\\n  `fulfilled_quantity` int NOT NULL DEFAULT '0',\\n  `referrer` text COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_oi__ord_id_var_id_idx` (`order_id`,`object_id`),\\n  KEY `wp_fct_oi__post_id_idx` (`post_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_meta","full_table_name":"wp_fct_order_meta","description":"Stores additional metadata (key-value pairs) for fct order records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_meta` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint DEFAULT NULL,\\n  `meta_key` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_om__ord_id_idx` (`order_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_operations","full_table_name":"wp_fct_order_operations","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_operations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `created_via` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `emails_sent` tinyint(1) DEFAULT '0',\\n  `sales_recorded` tinyint(1) DEFAULT '0',\\n  `utm_campaign` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `utm_term` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `utm_source` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `utm_medium` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `utm_content` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `utm_id` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `cart_hash` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `refer_url` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_oo__order_operations_idx` (`order_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_tax_rate","full_table_name":"wp_fct_order_tax_rate","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_tax_rate` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL,\\n  `tax_rate_id` bigint unsigned NOT NULL,\\n  `shipping_tax` bigint DEFAULT NULL,\\n  `order_tax` bigint DEFAULT NULL,\\n  `total_tax` bigint DEFAULT NULL,\\n  `meta` json DEFAULT NULL,\\n  `filed_at` datetime DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_order_transactions","full_table_name":"wp_fct_order_transactions","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_order_transactions` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `order_id` bigint unsigned NOT NULL DEFAULT '0',\\n  `order_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `transaction_type` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT 'charge',\\n  `subscription_id` int DEFAULT NULL,\\n  `card_last_4` int DEFAULT NULL,\\n  `card_brand` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `vendor_charge_id` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `payment_method` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `payment_mode` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `payment_method_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `total` bigint NOT NULL DEFAULT '0',\\n  `rate` bigint NOT NULL DEFAULT '1',\\n  `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_ot__ven_charge_id` (`vendor_charge_id`(64)),\\n  KEY `wp_fct_ot__payment_method_idx` (`payment_method`),\\n  KEY `wp_fct_ot__status_idx` (`status`),\\n  KEY `wp_fct_ot__order_id_idx` (`order_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_orders","full_table_name":"wp_fct_orders","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_orders` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'draft' COMMENT 'draft / pending / on-hold / processing / completed / failed / refunded / partial-refund',\\n  `parent_id` bigint unsigned DEFAULT NULL,\\n  `receipt_number` bigint unsigned DEFAULT NULL,\\n  `invoice_no` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT '',\\n  `fulfillment_type` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT 'physical',\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'payment',\\n  `mode` enum('live','test') COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'live' COMMENT 'live / test',\\n  `shipping_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '' COMMENT 'unshipped / shipped / delivered / unshippable',\\n  `customer_id` bigint unsigned DEFAULT NULL,\\n  `payment_method` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `payment_status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\\n  `payment_method_title` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `currency` varchar(10) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `subtotal` bigint NOT NULL DEFAULT '0',\\n  `discount_tax` bigint NOT NULL DEFAULT '0',\\n  `manual_discount_total` bigint NOT NULL DEFAULT '0',\\n  `coupon_discount_total` bigint NOT NULL DEFAULT '0',\\n  `shipping_tax` bigint NOT NULL DEFAULT '0',\\n  `shipping_total` bigint NOT NULL DEFAULT '0',\\n  `tax_total` bigint NOT NULL DEFAULT '0',\\n  `total_amount` bigint NOT NULL DEFAULT '0',\\n  `total_paid` bigint NOT NULL DEFAULT '0',\\n  `total_refund` bigint NOT NULL DEFAULT '0',\\n  `rate` decimal(12,4) NOT NULL DEFAULT '1.0000',\\n  `tax_behavior` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 => no_tax, 1 => exclusive, 2 => inclusive',\\n  `note` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `ip_address` text COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `completed_at` datetime DEFAULT NULL,\\n  `refunded_at` datetime DEFAULT NULL,\\n  `uuid` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT 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_ord__invoice_no` (`invoice_no`(191)),\\n  KEY `wp_fct_ord__status_type` (`type`),\\n  KEY `wp_fct_ord__customer_id` (`customer_id`),\\n  KEY `wp_fct_ord__date_created_completed` (`created_at`,`completed_at`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_product_details","full_table_name":"wp_fct_product_details","description":"Stores product records and related data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_product_details` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `fulfillment_type` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'physical',\\n  `min_price` double NOT NULL DEFAULT '0',\\n  `max_price` double NOT NULL DEFAULT '0',\\n  `default_variation_id` bigint unsigned DEFAULT NULL,\\n  `default_media` json DEFAULT NULL,\\n  `manage_stock` tinyint(1) DEFAULT '0',\\n  `stock_availability` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'in-stock',\\n  `variation_type` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'simple',\\n  `manage_downloadable` tinyint(1) DEFAULT '0',\\n  `other_info` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_pd__product_id_idx` (`post_id`),\\n  KEY `wp_fct_pd__product_stock_stockx` (`stock_availability`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_product_downloads","full_table_name":"wp_fct_product_downloads","description":"Stores product records and related data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_product_downloads` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `product_variation_id` longtext COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `download_identifier` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `type` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `driver` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'local',\\n  `file_name` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `file_path` text COLLATE utf8mb4_unicode_520_ci,\\n  `file_url` text COLLATE utf8mb4_unicode_520_ci,\\n  `file_size` text COLLATE utf8mb4_unicode_520_ci,\\n  `settings` text COLLATE utf8mb4_unicode_520_ci,\\n  `serial` int DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `download_identifier` (`download_identifier`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_product_meta","full_table_name":"wp_fct_product_meta","description":"Stores additional metadata (key-value pairs) for fct product records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_product_meta` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `object_id` bigint unsigned NOT NULL,\\n  `object_type` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_key` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_pm__meta_key` (`meta_key`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_product_variations","full_table_name":"wp_fct_product_variations","description":"Stores product records and related data.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_product_variations` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `post_id` bigint unsigned NOT NULL,\\n  `media_id` bigint unsigned DEFAULT NULL,\\n  `serial_index` int DEFAULT NULL,\\n  `sold_individually` tinyint unsigned DEFAULT '0',\\n  `variation_title` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `variation_identifier` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `sku` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `manage_stock` tinyint(1) DEFAULT '0',\\n  `payment_type` varchar(50) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `stock_status` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'out-of-stock',\\n  `backorders` tinyint unsigned DEFAULT '0',\\n  `total_stock` int DEFAULT '0',\\n  `on_hold` int DEFAULT '0',\\n  `committed` int DEFAULT '0',\\n  `available` int DEFAULT '0',\\n  `fulfillment_type` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT 'physical',\\n  `item_status` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'active',\\n  `manage_cost` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'false',\\n  `item_price` double NOT NULL DEFAULT '0',\\n  `item_cost` double NOT NULL DEFAULT '0',\\n  `compare_price` double DEFAULT '0',\\n  `shipping_class` bigint DEFAULT NULL,\\n  `other_info` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `downloadable` varchar(30) COLLATE utf8mb4_unicode_520_ci DEFAULT 'false',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `sku_unique` (`sku`),\\n  KEY `wp_fct_pd_var__post_id_idx` (`post_id`),\\n  KEY `wp_fct_pd_var__stock_status_idx` (`stock_status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_retention_snapshots","full_table_name":"wp_fct_retention_snapshots","description":"Stores fct retention snapshots data created by this plugin.","detection_method":"live","confidence":"high","columns":[{"name":"when","type":"customer","nullable":true,"primary_key":false},{"name":"the","type":"month","nullable":true,"primary_key":false}],"create_sql":"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"},{"table_name":"fct_scheduled_actions","full_table_name":"wp_fct_scheduled_actions","description":"Stores fct scheduled actions data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_scheduled_actions` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `scheduled_at` datetime DEFAULT NULL,\\n  `action` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `group` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `object_id` bigint unsigned DEFAULT NULL,\\n  `object_type` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `completed_at` timestamp NULL DEFAULT NULL,\\n  `retry_count` int unsigned DEFAULT '0',\\n  `data` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  `response_note` longtext COLLATE utf8mb4_unicode_520_ci,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_sch_var__scheduled_at_idx` (`scheduled_at`),\\n  KEY `wp_fct_sch_var__status_idx` (`status`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_shipping_classes","full_table_name":"wp_fct_shipping_classes","description":"Stores fct shipping classes data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_shipping_classes` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `cost` decimal(10,2) NOT NULL DEFAULT '0.00',\\n  `per_item` tinyint(1) NOT NULL DEFAULT '0',\\n  `type` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'fixed',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_sc__name_idx` (`name`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_shipping_methods","full_table_name":"wp_fct_shipping_methods","description":"Stores fct shipping methods data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_shipping_methods` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `zone_id` bigint unsigned NOT NULL,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `type` varchar(50) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `settings` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `is_enabled` tinyint(1) NOT NULL DEFAULT '1',\\n  `states` json DEFAULT NULL,\\n  `amount` bigint unsigned DEFAULT '0',\\n  `order` int unsigned NOT NULL DEFAULT '0',\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_sm__zone_id_idx` (`zone_id`),\\n  KEY `wp_fct_sm__order_idx` (`order`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_shipping_zones","full_table_name":"wp_fct_shipping_zones","description":"Stores fct shipping zones data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_shipping_zones` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `name` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `region` varchar(192) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `order` int unsigned NOT NULL DEFAULT '0',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_sz__order_idx` (`order`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_subscription_meta","full_table_name":"wp_fct_subscription_meta","description":"Stores additional metadata (key-value pairs) for fct subscription records.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_subscription_meta` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `subscription_id` bigint unsigned DEFAULT NULL,\\n  `meta_key` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `meta_value` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_sm__subs_id_key` (`subscription_id`),\\n  KEY `wp_fct_sm__meta_key` (`meta_key`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_subscriptions","full_table_name":"wp_fct_subscriptions","description":"Stores fct subscriptions data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"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"},{"table_name":"fct_tax_classes","full_table_name":"wp_fct_tax_classes","description":"Stores fct tax classes data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_tax_classes` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `title` varchar(192) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `slug` varchar(100) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `description` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `meta` json DEFAULT NULL,\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_tax_rates","full_table_name":"wp_fct_tax_rates","description":"Stores fct tax rates data created by this plugin.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_tax_rates` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `class_id` bigint unsigned NOT NULL,\\n  `country` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `state` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `postcode` text COLLATE utf8mb4_unicode_520_ci,\\n  `city` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `rate` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `name` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `group` varchar(45) COLLATE utf8mb4_unicode_520_ci DEFAULT NULL,\\n  `priority` int unsigned DEFAULT '1',\\n  `is_compound` tinyint unsigned DEFAULT '0',\\n  `for_shipping` tinyint unsigned DEFAULT NULL,\\n  `for_order` tinyint unsigned DEFAULT '0',\\n  PRIMARY KEY (`id`),\\n  KEY `wp_fct_txr__txr_class_idx` (`class_id`),\\n  KEY `wp_fct_txr__priority_idx` (`priority`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"},{"table_name":"fct_webhook_logger","full_table_name":"wp_fct_webhook_logger","description":"A logging table that records activity, events, or audit history.","detection_method":"live","confidence":"high","columns":[],"create_sql":"CREATE TABLE `wp_fct_webhook_logger` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `source` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `event_type` varchar(100) COLLATE utf8mb4_unicode_520_ci NOT NULL,\\n  `payload` longtext COLLATE utf8mb4_unicode_520_ci,\\n  `status` varchar(20) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT 'pending',\\n  `created_at` datetime DEFAULT NULL,\\n  `updated_at` datetime DEFAULT NULL,\\n  PRIMARY KEY (`id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci"}],"table_count":39}