{"table_name":"fct_orders","full_table_name":"wp_fct_orders","description":"Stores order records and related transaction data.","detection_method":"live","confidence":"high","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","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/"}}