{"table_name":"emsb_bookings","full_table_name":"wp_emsb_bookings","description":"Stores emsb bookings data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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","columns":[{"name":"id","type":"int(11) UNSIGNED","nullable":true,"primary_key":true},{"name":"approve_booking","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"service_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"service_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"service_price","type":"text","nullable":true,"primary_key":false},{"name":"booked_date_id","type":"text","nullable":true,"primary_key":false},{"name":"booked_slot_id","type":"text","nullable":true,"primary_key":false},{"name":"booked_date","type":"text","nullable":true,"primary_key":false},{"name":"booked_time_slot","type":"text","nullable":true,"primary_key":false},{"name":"customer_name","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"customer_email","type":"text","nullable":true,"primary_key":false},{"name":"customer_phone","type":"text","nullable":true,"primary_key":false},{"name":"booking_time","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"customer_IP","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"starting_time_ms","type":"BIGINT","nullable":false,"primary_key":false},{"name":"available_orders","type":"int(11)","nullable":false,"primary_key":false}],"plugin":{"slug":"emsb-service-booking","name":"Doctor Appointment Booking Plugin – EMSB","active_installs":70,"version":"1.2.2","wp_org_url":"https://wordpress.org/plugins/emsb-service-booking/"}}