{"table_name":"fct_product_variations","full_table_name":"wp_fct_product_variations","description":"Stores product records and related data.","detection_method":"live","confidence":"high","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","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/"}}