wp_fct_orders

Live

Stores order records and related transaction data.

CREATE TABLE Statement

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

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_orders`;

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