{"table_name":"im_leads","full_table_name":"wp_im_leads","description":"Stores im leads data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_im_leads ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(120) NOT NULL DEFAULT '', phone VARCHAR(30) NOT NULL DEFAULT '', email VARCHAR(120) DEFAULT '', service VARCHAR(80) NOT NULL DEFAULT '', staff VARCHAR(80) DEFAULT '', urgency VARCHAR(20) NOT NULL DEFAULT 'Flexible', status VARCHAR(20) NOT NULL DEFAULT 'New', source VARCHAR(40) NOT NULL DEFAULT 'Website', score TINYINT UNSIGNED NOT NULL DEFAULT 0, tier VARCHAR(10) NOT NULL DEFAULT 'cold', appointment_date DATE DEFAULT NULL, appointment_time VARCHAR(10) DEFAULT NULL, addons TEXT DEFAULT '', total_amount DECIMAL(10,2) DEFAULT 0.00, payment_status VARCHAR(20) NOT NULL DEFAULT 'unpaid', payment_gateway VARCHAR(30) DEFAULT '', payment_ref VARCHAR(120) DEFAULT '', form_id VARCHAR(60) DEFAULT '', form_name VARCHAR(120) DEFAULT '', form_seq INT UNSIGNED NOT NULL DEFAULT 0, notes TEXT DEFAULT '', assigned_to BIGINT UNSIGNED DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY status (status), KEY tier (tier), KEY appointment_date (appointment_date), KEY created_at (created_at) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"service","type":"VARCHAR(80)","nullable":false,"primary_key":false},{"name":"staff","type":"VARCHAR(80)","nullable":true,"primary_key":false},{"name":"urgency","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"score","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"tier","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"appointment_date","type":"DATE","nullable":true,"primary_key":false},{"name":"appointment_time","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"addons","type":"TEXT","nullable":true,"primary_key":false},{"name":"total_amount","type":"DECIMAL(10,2)","nullable":true,"primary_key":false},{"name":"payment_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"payment_gateway","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"payment_ref","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"form_id","type":"VARCHAR(60)","nullable":true,"primary_key":false},{"name":"form_name","type":"VARCHAR(120)","nullable":true,"primary_key":false},{"name":"form_seq","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"notes","type":"TEXT","nullable":true,"primary_key":false},{"name":"assigned_to","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_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/"}}