{"table_name":"im_bookings","full_table_name":"wp_im_bookings","description":"Stores im bookings data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_im_bookings ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, lead_id BIGINT UNSIGNED DEFAULT NULL, patient_name VARCHAR(120) NOT NULL DEFAULT '', patient_phone VARCHAR(30) NOT NULL DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', booking_date DATE NOT NULL, booking_time TIME NOT NULL, duration_min SMALLINT UNSIGNED NOT NULL DEFAULT 30, status VARCHAR(20) NOT NULL DEFAULT 'Pending', notes TEXT DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY booking_date (booking_date), KEY status (status) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"lead_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"patient_name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"patient_phone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"service","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"staff","type":"VARCHAR(80)","nullable":true,"primary_key":false},{"name":"booking_date","type":"DATE","nullable":false,"primary_key":false},{"name":"booking_time","type":"TIME","nullable":false,"primary_key":false},{"name":"duration_min","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"intometrics-booking-crm-light","name":"IntoMetrics Booking & CRM Light","active_installs":0,"version":"1.0.52","wp_org_url":"https://wordpress.org/plugins/intometrics-booking-crm-light/"}}