wp_booktics_schedules
StaticStores booktics schedules data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | mediumint(9) | NO |
| team_member_id | int(11) | NO |
| service_id | int(11) | NO |
| location_id | int(11) | NO |
| start_time | varchar(100) | NO |
| end_time | varchar(100) | NO |
| week_day | varchar(100) | NO |
| custom_date | varchar(100) | NO |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| uuid | varchar(36) | NO |
| user_id | int(11) | NO |
| coupon_code | varchar(100) | YES |
| total | decimal(10,2) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| uuid | varchar(36) | NO |
| cart_id | mediumint(9) | NO |
| team_member_id | int(11) | YES |
| service_id | int(11) | YES |
| location_id | int(11) | YES |
| date | date | YES |
| start_time | varchar(100) | YES |
| end_time | varchar(100) | YES |
| price | VARCHAR(100) | YES |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| order_no | VARCHAR(100) | NO |
| customer_id | BIGINT UNSIGNED | NO |
| customer_note | VARCHAR(100) | YES |
| status | VARCHAR(50) | YES |
| payment_status | VARCHAR(50) | YES |
| timezone | VARCHAR(50) | YES |
| currency | VARCHAR(10) | YES |
| price_breakdown | JSON | YES |
| tax_total | VARCHAR(100) | YES |
| coupon_code | VARCHAR(100) | YES |
| coupon_discount | VARCHAR(100) | YES |
| subtotal | VARCHAR(100) | YES |
| total | VARCHAR(100) | YES |
| payment_method | VARCHAR(50) | YES |
| payment_intent_id | VARCHAR(250) | YES |
| payment_transaction_id | VARCHAR(250) | YES |
| directorist_id | BIGINT UNSIGNED | YES |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
| order_id | BIGINT UNSIGNED | NO |
| customer_id | BIGINT UNSIGNED | NO |
| amount | VARCHAR(20) | NO |
| currency | VARCHAR(10) | YES |
| intent_id | VARCHAR(255) | YES |
| transaction_id | VARCHAR(255) | YES |
| status | varchar(100) | NO |
| payment_method | VARCHAR(50) | NO |
| refunded_amount | VARCHAR(20) | YES |
| failure_reason | TEXT | YES |
| date | DATE | NO |
| date_time | DATETIME | NO |
| wp_user_id | BIGINT UNSIGNED | YES |
| first_name | VARCHAR(100) | YES |
| last_name | VARCHAR(100) | YES |
| user_login | VARCHAR(100) | YES |
| VARCHAR(100) | YES | |
| phone | VARCHAR(10) | YES |
| description | VARCHAR(250) | YES |
| image | VARCHAR(250) | YES |
| status | INT | YES |
| created_at | DATETIME | YES |
| updated_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_booktics_schedules ( id mediumint(9) NOT NULL AUTO_INCREMENT, team_member_id int(11) NOT NULL, service_id int(11) NOT NULL, location_id int(11) NOT NULL, start_time varchar(100) NOT NULL, end_time varchar(100) NOT NULL, week_day varchar(100) NOT NULL, custom_date varchar(100) NOT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_booktics_carts ( id mediumint(9) NOT NULL AUTO_INCREMENT, uuid varchar(36) NOT NULL, user_id int(11) NOT NULL, coupon_code varchar(100) DEFAULT NULL, total decimal(10,2) DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_booktics_cart_items ( id mediumint(9) NOT NULL AUTO_INCREMENT, uuid varchar(36) NOT NULL, cart_id mediumint(9) NOT NULL, team_member_id int(11) DEFAULT NULL, service_id int(11) DEFAULT NULL, location_id int(11) DEFAULT NULL, date date DEFAULT NULL, start_time varchar(100) DEFAULT NULL, end_time varchar(100) DEFAULT NULL, price VARCHAR(100) DEFAULT NULL, created_at datetime DEFAULT NULL, updated_at datetime DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_booktics_orders ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, order_no VARCHAR(100) NOT NULL, customer_id BIGINT UNSIGNED NOT NULL, customer_note VARCHAR(100) DEFAULT NULL, status VARCHAR(50) DEFAULT 'pending', payment_status VARCHAR(50) DEFAULT NULL, timezone VARCHAR(50) DEFAULT 'UTC', currency VARCHAR(10) DEFAULT NULL, price_breakdown JSON DEFAULT NULL, tax_total VARCHAR(100) DEFAULT NULL, coupon_code VARCHAR(100) DEFAULT NULL, coupon_discount VARCHAR(100) DEFAULT NULL, subtotal VARCHAR(100) DEFAULT 0, total VARCHAR(100) DEFAULT 0, payment_method VARCHAR(50) DEFAULT NULL, payment_intent_id VARCHAR(250) DEFAULT NULL, payment_transaction_id VARCHAR(250) DEFAULT NULL, directorist_id BIGINT UNSIGNED DEFAULT NULL, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), INDEX (order_no), INDEX (directorist_id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_booktics_payments ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, order_id BIGINT UNSIGNED NOT NULL, customer_id BIGINT UNSIGNED NOT NULL, amount VARCHAR(20) NOT NULL, currency VARCHAR(10) DEFAULT 'usd', intent_id VARCHAR(255), transaction_id VARCHAR(255), status varchar(100) NOT NULL DEFAULT 'pending', payment_method VARCHAR(50) NOT NULL, refunded_amount VARCHAR(20) DEFAULT '0.00', failure_reason TEXT, date DATE NOT NULL, date_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, INDEX (order_id), INDEX (customer_id), INDEX (intent_id), INDEX (transaction_id) ) $charset_collate;", "CREATE TABLE IF NOT EXISTS wp_booktics_guests ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, wp_user_id BIGINT UNSIGNED DEFAULT NULL, first_name VARCHAR(100) DEFAULT NULL, last_name VARCHAR(100) DEFAULT NULL, user_login VARCHAR(100) DEFAULT NULL, email VARCHAR(100) DEFAULT NULL, phone VARCHAR(10) DEFAULT NULL, description VARCHAR(250) DEFAULT NULL, image VARCHAR(250) DEFAULT NULL, status INT DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, INDEX (wp_user_id), INDEX (email), INDEX (first_name) ) $charset_collate;", );
Safe to delete?
If you have uninstalled Booktics – Booking Calendar for Appointments and Service Businesses, 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_booktics_schedules`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Booktics – Booking Calendar for Appointments and Service Businesses