{"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","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","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/"}}