{"table_name":"im_staff","full_table_name":"wp_im_staff","description":"Stores im staff data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_im_staff ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, wp_user_id BIGINT UNSIGNED DEFAULT 0, name VARCHAR(120) NOT NULL, role VARCHAR(40) NOT NULL DEFAULT 'staff', email VARCHAR(120) NOT NULL DEFAULT '', phone VARCHAR(30) DEFAULT '', active TINYINT(1) NOT NULL DEFAULT 1, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"name","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"role","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(120)","nullable":false,"primary_key":false},{"name":"phone","type":"VARCHAR(30)","nullable":true,"primary_key":false},{"name":"active","type":"TINYINT(1)","nullable":false,"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/"}}