wp_emsb_bookings
StaticStores emsb bookings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) UNSIGNED | YES |
| approve_booking | varchar(20) | YES |
| service_id | int(11) | NO |
| service_name | varchar(200) | YES |
| service_price | text | YES |
| booked_date_id | text | YES |
| booked_slot_id | text | YES |
| booked_date | text | YES |
| booked_time_slot | text | YES |
| customer_name | varchar(200) | YES |
| customer_email | text | YES |
| customer_phone | text | YES |
| booking_time | TIMESTAMP | NO |
| customer_IP | VARCHAR(100) | NO |
| starting_time_ms | BIGINT | NO |
| available_orders | int(11) | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_emsb_bookings ( `id` int(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY, `approve_booking` varchar(20), `service_id` int(11) NOT NULL, `service_name` varchar(200), `service_price` text, `booked_date_id` text, `booked_slot_id` text, `booked_date` text, `booked_time_slot` text, `customer_name` varchar(200), `customer_email` text, `customer_phone` text, `booking_time` TIMESTAMP NOT NULL, `customer_IP` VARCHAR(100) NOT NULL, `starting_time_ms` BIGINT NOT NULL, `available_orders` int(11) NOT NULL ) ENGINE
Safe to delete?
If you have uninstalled Doctor Appointment Booking Plugin – EMSB, 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_emsb_bookings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Doctor Appointment Booking Plugin – EMSB