wp_payment
StaticStores payment data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑payment_id | smallint(5) unsigned | NO |
| customer_id | smallint(5) unsigned | NO |
| staff_id | tinyint(3) unsigned | NO |
| rental_id | int(11) | YES |
| amount | decimal(5,2) | NO |
| payment_date | datetime | NO |
| last_update | timestamp | NO |
CREATE TABLE Statement
CREATE TABLE `payment` ( `payment_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT, `customer_id` smallint(5) unsigned NOT NULL, `staff_id` tinyint(3) unsigned NOT NULL, `rental_id` int(11) DEFAULT NULL, `amount` decimal(5,2) NOT NULL, `payment_date` datetime NOT NULL, `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`payment_id`), KEY `idx_fk_staff_id` (`staff_id`), KEY `idx_fk_customer_id` (`customer_id`), KEY `fk_payment_rental` (`rental_id`), CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE, CONSTRAINT `fk_payment_rental` FOREIGN KEY (`rental_id`) REFERENCES `rental` (`rental_id`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `fk_payment_staff` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`staff_id`) ON UPDATE CASCADE ) ENGINE
Safe to delete?
If you have uninstalled Rest Routes – Custom Endpoints for WordPress REST API, 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_payment`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Rest Routes – Custom Endpoints for WordPress REST API