🗄️What WP Table Is This?
Home / Booking for Appointments and Events Calendar – Amelia / wp_amelia_payments

wp_amelia_payments

Live

Stores amelia payments data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_amelia_payments` (\n  `id` int NOT NULL AUTO_INCREMENT,\n  `customerBookingId` int DEFAULT NULL,\n  `amount` double NOT NULL DEFAULT '0',\n  `dateTime` datetime DEFAULT NULL,\n  `status` enum('paid','pending','partiallyPaid','refunded') NOT NULL,\n  `gateway` enum('onSite','payPal','stripe','wc','mollie','razorpay','square','barion') NOT NULL,\n  `gatewayTitle` varchar(255) DEFAULT NULL,\n  `data` text,\n  `packageCustomerId` int DEFAULT NULL,\n  `parentId` int DEFAULT NULL,\n  `entity` enum('appointment','event','package') DEFAULT NULL,\n  `created` datetime DEFAULT NULL,\n  `actionsCompleted` tinyint(1) DEFAULT NULL,\n  `triggeredActions` tinyint(1) DEFAULT NULL,\n  `wcOrderId` bigint DEFAULT NULL,\n  `wcOrderItemId` bigint DEFAULT NULL,\n  `transactionId` varchar(255) DEFAULT NULL,\n  `transfers` text,\n  `invoiceNumber` int DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3

Safe to delete?

If you have uninstalled Booking for Appointments and Events Calendar – Amelia, 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_amelia_payments`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from Booking for Appointments and Events Calendar – Amelia