{"table_name":"booktics_schedules","full_table_name":"wp_booktics_schedules","description":"Stores booktics schedules data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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;\", );","columns":[{"name":"id","type":"mediumint(9)","nullable":false,"primary_key":true},{"name":"team_member_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"service_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"start_time","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"end_time","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"week_day","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"custom_date","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"uuid","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"coupon_code","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"total","type":"decimal(10,2)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"uuid","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"cart_id","type":"mediumint(9)","nullable":false,"primary_key":false},{"name":"team_member_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"service_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"date","type":"date","nullable":true,"primary_key":false},{"name":"start_time","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"end_time","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"price","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"order_no","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"customer_note","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"payment_status","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"timezone","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"price_breakdown","type":"JSON","nullable":true,"primary_key":false},{"name":"tax_total","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"coupon_code","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"coupon_discount","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"subtotal","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"total","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"payment_method","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"payment_intent_id","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"payment_transaction_id","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"directorist_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"order_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"customer_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"amount","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"intent_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"transaction_id","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"payment_method","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"refunded_amount","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"failure_reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"date","type":"DATE","nullable":false,"primary_key":false},{"name":"date_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"first_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"last_name","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"user_login","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"description","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"image","type":"VARCHAR(250)","nullable":true,"primary_key":false},{"name":"status","type":"INT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":true,"primary_key":false}],"plugin":{"slug":"booktics","name":"Booktics – Booking Calendar for Appointments and Service Businesses","active_installs":700,"version":"1.0.22","wp_org_url":"https://wordpress.org/plugins/booktics/"}}