{"table_name":"lbaic_chats","full_table_name":"wp_lbaic_chats","description":"Stores lbaic chats data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_lbaic_chats ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(256) DEFAULT NULL, uuid char(36) NOT NULL, chatbot_uuid char(36) NULL, /* TODO maybe only chatbot_id should be kept and uuid id should be only applied based on response logic */ chatbot_id bigint(20) unsigned NULL, /* TODO allowing null ? Considering that the default chatbot won't have any uuid */ type tinyint(1) DEFAULT 1 NOT NULL, status tinyint(1) DEFAULT 1 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY uuid (uuid), KEY chatbot_uuid (chatbot_uuid), KEY created_at (created_at), KEY `type` (type), KEY `status` (status) ) $collate; CREATE TABLE wp_lbaic_chat_participants ( id bigint unsigned NOT NULL AUTO_INCREMENT, chat_id bigint unsigned NOT NULL, user_id bigint unsigned NOT NULL, role varchar(128) DEFAULT 'user', joined_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY chat_id (chat_id), KEY user_id (user_id) ) $collate; CREATE TABLE wp_lbaic_chat_metas ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, chat_id bigint(20) unsigned NOT NULL, meta_key varchar(512) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY chat_id (chat_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_chat_message_metas ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, message_id bigint(20) unsigned NOT NULL, meta_key varchar(512) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY message_id (message_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_chat_messages ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uuid char(36) NOT NULL, chat_uuid char(36) NOT NULL, user_id bigint(20) unsigned NULL, role varchar(32) NULL, content longtext NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY uuid (uuid), KEY chat_uuid (chat_uuid), KEY user_id (user_id), KEY created_at (created_at) ) $collate; CREATE TABLE wp_lbaic_configs ( id int unsigned NOT NULL AUTO_INCREMENT, title varchar(256) NULL, description varchar(512) NULL, params longtext NOT NULL, related_to varchar(512) DEFAULT '' NOT NULL, `default` tinyint(1) DEFAULT 0 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY related_to (related_to), KEY `default` (`default`), KEY created_at (created_at) ) $collate; CREATE TABLE wp_lbaic_datasets ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name text NULL, type tinyint(1) DEFAULT 1 NOT NULL, status tinyint(1) DEFAULT 2 NOT NULL, instruction text NULL, source varchar(512) NULL, source_type varchar(256) NULL, source_sub_type varchar(256) NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY `source` (source), KEY source_type (source_type), KEY source_sub_type (source_sub_type), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; CREATE TABLE wp_lbaic_conversation_states ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, chat_uuid VARCHAR(64) NOT NULL, topic VARCHAR(255) NULL, entities TEXT NULL, summary TEXT NULL, confidence DECIMAL(5,4) NULL, sentiment VARCHAR(50) NULL, user_preferences TEXT NULL, user_intent_history TEXT NULL, PRIMARY KEY (id), KEY `xchat_uuid` (chat_uuid) ) $collate; CREATE TABLE wp_lbaic_dataset_metas ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, dataset_id bigint(20) unsigned NOT NULL, meta_key varchar(512) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY dataset_id (dataset_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_dataset_entries ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, dataset_id bigint(20) unsigned NOT NULL, entry longtext NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY dataset_id (dataset_id), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; CREATE TABLE wp_lbaic_ai_model_metas ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ai_model_id bigint(20) unsigned NOT NULL, meta_key varchar(512) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY ai_model_id (ai_model_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_ai_models ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, label varchar(128) NOT NULL, name varchar(128) NOT NULL, description text NULL, ai_provider_id varchar(64) NULL, `default` tinyint(1) DEFAULT 0 NOT NULL, modalities longtext NULL, endpoints longtext NULL, features longtext NULL, input_token_limit bigint(20) NULL, output_token_limit bigint(20) NULL, fine_tuned tinyint(1) DEFAULT 0 NOT NULL, status tinyint(1) DEFAULT 0 NOT NULL, PRIMARY KEY (id), KEY `name` (name), KEY label (label), KEY ai_provider_id (ai_provider_id), KEY `default` (ai_provider_id, `default`), KEY fine_tuned (`fine_tuned`), KEY `status` (`status`) ) $collate; CREATE TABLE wp_lbaic_vector_indexes ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, name varchar(256) NOT NULL, description text NULL, vector_db_id varchar(64) NULL, config_id int unsigned NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY vector_db_id (vector_db_id), KEY config_id (config_id) ) $collate; CREATE TABLE wp_lbaic_vector_index_metas ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, vector_index_id bigint(20) unsigned NOT NULL, meta_key varchar(512) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY vector_index_id (vector_index_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_vectors ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uuid char(36) NOT NULL, `values` longtext NULL, dimension int NULL, status tinyint(1) DEFAULT 1 NOT NULL, ai_model_id bigint(20) unsigned NULL, dataset_entry_id bigint(20) unsigned NULL, config_id int unsigned NULL, access_roles longtext NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY uuid (uuid), KEY ai_model_id (ai_model_id), KEY dataset_entry_id (dataset_entry_id), KEY config_id (config_id), KEY created_at (created_at), KEY `status` (status) ) $collate; CREATE TABLE `wp_lbaic_users` ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uuid varchar(36) NOT NULL, wp_user_id bigint(20) unsigned DEFAULT NULL, device_uuid varchar(255) NOT NULL, ip varchar(255) DEFAULT NULL, type tinyint(1) DEFAULT NULL, status tinyint(1) DEFAULT 1 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY uuid (uuid), KEY wp_user_id (wp_user_id), KEY device_uuid (device_uuid), KEY ip (ip) ) $collate; CREATE TABLE `wp_lbaic_user_metas` ( id bigint(20) NOT NULL AUTO_INCREMENT, chatbot_user_id bigint(20) NOT NULL, meta_key varchar(256) NOT NULL, meta_value longtext NULL, PRIMARY KEY (id), KEY chatbot_user_id (chatbot_user_id), KEY meta_key (meta_key) ) $collate; CREATE TABLE wp_lbaic_vector_indexes_vectors ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, vector_index_id bigint(20) unsigned NOT NULL, vector_id bigint(20) unsigned NOT NULL, PRIMARY KEY (id), KEY vector_index_id (vector_index_id), KEY vector_id (vector_id) ) $collate; CREATE TABLE wp_lbaic_actions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, type TINYINT(1) DEFAULT 1 NOT NULL, access_roles LONGTEXT NULL, config LONGTEXT NULL, ai_instructions TEXT NULL, status TINYINT(1) DEFAULT 1 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY name (name), UNIQUE KEY title (title), KEY status (status) ) $collate; CREATE TABLE wp_lbaic_parameters ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, action_id BIGINT NOT NULL, name VARCHAR(255) NOT NULL, label VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL DEFAULT 'text', `order` INT NOT NULL DEFAULT 1, question TEXT NULL, required VARCHAR(10) DEFAULT '0', default_value TEXT NULL, placeholder VARCHAR(255) NULL, validation_rules TEXT NULL, suggestions TEXT NULL, config TEXT NULL, PRIMARY KEY (id), KEY action_id (action_id), KEY `order` (`order`), KEY name (name) ) $collate; CREATE TABLE wp_lbaic_action_callbacks ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, action_id BIGINT UNSIGNED NOT NULL, name VARCHAR(255) NOT NULL, title VARCHAR(255) NOT NULL, description TEXT NULL, type VARCHAR(50) NOT NULL, config LONGTEXT NOT NULL, `order` INT NOT NULL DEFAULT 1, is_required TINYINT(1) DEFAULT 1 NOT NULL, status TINYINT(1) DEFAULT 1 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY name_action_unique (name, action_id), KEY action_id (action_id), KEY type (type), KEY `order` (`order`), KEY status (status) ) $collate; CREATE TABLE wp_lbaic_action_submissions ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, action_id bigint(20) unsigned NOT NULL, action_data longtext NULL, chatbot_user_id bigint(20) unsigned NULL, chat_uuid char(36) NULL, callback_results longtext NULL, extracted_vars longtext NULL, status varchar(50) DEFAULT 'pending' NOT NULL, error_message longtext NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY action_id (action_id), KEY chatbot_user_id (chatbot_user_id), KEY chat_uuid (chat_uuid), KEY status (status), KEY created_at (created_at) ) $collate; CREATE TABLE wp_lbaic_jobs ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, type VARCHAR(100) NOT NULL, sub_type VARCHAR(100) NOT NULL, status VARCHAR(50) NOT NULL DEFAULT 'pending', progress_percent DECIMAL(5,2) DEFAULT 0.00 NOT NULL, chatbot_uuid char(36) NULL, config LONGTEXT NULL, stats LONGTEXT NULL, errors LONGTEXT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, started_at datetime NULL, completed_at datetime NULL, PRIMARY KEY (id), KEY type (type), KEY sub_type (sub_type), KEY status (status), KEY chatbot_uuid (chatbot_uuid), KEY created_at (created_at), KEY status_type (status, type) ) $collate; CREATE TABLE wp_lbaic_job_tasks ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, job_id bigint(20) unsigned NOT NULL, parent_task_id bigint(20) unsigned NULL, payload LONGTEXT NOT NULL, status VARCHAR(50) NOT NULL DEFAULT 'pending', attempt_count INT DEFAULT 0 NOT NULL, error TEXT NULL, task_started_at datetime NULL, task_completed_at datetime NULL, PRIMARY KEY (id), KEY job_id (job_id), KEY parent_task_id (parent_task_id), KEY status (status), KEY job_status (job_id, status), KEY job_parent_status (job_id, parent_task_id, status) ) $collate; CREATE TABLE wp_lbaic_leads ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, chatbot_user_uuid varchar(36) NOT NULL, chatbot_uuid varchar(36) NULL, chat_uuid varchar(36) NULL, source_type varchar(50) NOT NULL, source varchar(255) NOT NULL, source_title varchar(255) NOT NULL, metadata LONGTEXT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, status varchar(50) DEFAULT 'new' NOT NULL, is_qualified tinyint(1) DEFAULT 0 NOT NULL, PRIMARY KEY (id), KEY chatbot_user_uuid (chatbot_user_uuid), KEY chatbot_uuid (chatbot_uuid), KEY source_type (source_type), KEY source (source), KEY status (status), KEY is_qualified (is_qualified), KEY created_at (created_at), KEY source_type_status (source_type, status) ) $collate; CREATE TABLE wp_lbaic_lead_fields ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, field_key varchar(255) NOT NULL, label varchar(255) NOT NULL, status tinyint(1) NOT NULL DEFAULT 1, data_type varchar(50) NOT NULL DEFAULT 'text', PRIMARY KEY (id), UNIQUE KEY field_key (field_key), KEY label (label), KEY data_type (data_type) ) $collate; CREATE TABLE wp_lbaic_lead_values ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, lead_id bigint(20) unsigned NOT NULL, field_id bigint(20) unsigned NOT NULL, value_string longtext NULL, value_number decimal(19,4) NULL, value_date datetime NULL, PRIMARY KEY (id), KEY lead_id (lead_id), KEY field_id (field_id), KEY lead_field (lead_id, field_id) ) $collate; CREATE TABLE wp_lbaic_notification_log ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, chatbot_user_id bigint(20) unsigned NOT NULL, type_key varchar(100) NOT NULL, channel varchar(50) NOT NULL, status varchar(20) NOT NULL DEFAULT 'pending', sent_at datetime NULL DEFAULT NULL, fail_reason TEXT NULL DEFAULT NULL, content_type varchar(100) NULL DEFAULT NULL, content LONGTEXT NULL DEFAULT NULL, PRIMARY KEY (id), KEY chatbot_user_id (chatbot_user_id), KEY type_key (type_key), KEY channel (channel), KEY status (status), KEY sent_at (sent_at) ) $collate; CREATE TABLE wp_lbaic_ip_blocks ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip varchar(45) NOT NULL, location varchar(255) NULL, reason text NULL, type varchar(20) DEFAULT 'manual' NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, blocked_until datetime NULL, chatbot_user_id bigint(20) unsigned NULL, PRIMARY KEY (id), KEY ip (ip), KEY chatbot_user_id (chatbot_user_id), KEY blocked_until (blocked_until), KEY type (type), KEY created_at (created_at) ) $collate; CREATE TABLE wp_lbaic_widgets ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, uuid char(36) NOT NULL, type varchar(64) NOT NULL, published tinyint(1) DEFAULT 1 NOT NULL, config longtext NULL, locations longtext NULL, visibility longtext NULL, `order` int(11) DEFAULT 0 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, updated_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY uuid (uuid), KEY type (type), KEY published (published), KEY `order` (`order`), KEY created_at (created_at), KEY updated_at (updated_at) ) $collate; CREATE TABLE wp_lbaic_channel_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_type varchar(64) NOT NULL, chat_uuid char(36) NULL, chatbot_user_uuid char(36) NULL, recipient_wp_user_id bigint(20) unsigned NOT NULL, payload longtext NOT NULL, is_read tinyint(1) DEFAULT 0 NOT NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY event_type (event_type), KEY chat_uuid (chat_uuid), KEY chatbot_user_uuid (chatbot_user_uuid), KEY recipient_wp_user_id (recipient_wp_user_id), KEY is_read (is_read), KEY created_at (created_at) ) $collate; CREATE TABLE wp_lbaic_ratings ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, from_type varchar(100) NULL, from_id bigint(20) unsigned NULL, target_type varchar(100) NULL, target_id bigint(20) unsigned NULL, rate int(11) NOT NULL, notes text NULL, metadata longtext NULL, chatbot_user_id bigint(20) unsigned NULL, created_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, source_id varchar(191) NULL, PRIMARY KEY (id), KEY from_type (from_type), KEY from_id (from_id), KEY target_type (target_type), KEY target_id (target_id), KEY chatbot_user_id (chatbot_user_id), KEY created_at (created_at), KEY source_id (source_id) ) $collate;\"; } /** * Returns the list of all table names used by the plugin. * * @return array List of table names. * @since 1.0.0 */ public static function get_tables() { $wpdb = self::instance()->wpdb; $tables = array( \"wp_lbaic_chats\", \"wp_lbaic_chat_metas\", \"wp_lbaic_chat_messages\", \"wp_lbaic_chat_message_metas\", \"wp_lbaic_configs\", \"wp_lbaic_datasets\", \"wp_lbaic_dataset_entries\", \"wp_lbaic_ai_models\", \"wp_lbaic_ai_model_metas\", \"wp_lbaic_users\", \"wp_lbaic_user_metas\", \"wp_lbaic_vector_indexes\", \"wp_lbaic_vector_index_metas\", \"wp_lbaic_vectors\", \"wp_lbaic_vector_indexes_vectors\", \"wp_lbaic_conversation_states\", \"wp_lbaic_chat_participants\", \"wp_lbaic_dataset_metas\", \"wp_lbaic_actions\", \"wp_lbaic_parameters\", \"wp_lbaic_action_callbacks\", \"wp_lbaic_action_submissions\", \"wp_lbaic_jobs\", \"wp_lbaic_job_tasks\", \"wp_lbaic_leads\", \"wp_lbaic_lead_fields\", \"wp_lbaic_lead_values\", \"wp_lbaic_notification_log\", \"wp_lbaic_ip_blocks\", \"wp_lbaic_widgets\", \"wp_lbaic_channel_events\", \"wp_lbaic_ratings\", );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"name","type":"varchar(256)","nullable":true,"primary_key":false},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"chatbot_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"chat_id","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint unsigned","nullable":false,"primary_key":false},{"name":"role","type":"varchar(128)","nullable":true,"primary_key":false},{"name":"joined_at","type":"datetime","nullable":false,"primary_key":false},{"name":"chat_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"message_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"chat_uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"role","type":"varchar(32)","nullable":true,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"title","type":"varchar(256)","nullable":true,"primary_key":false},{"name":"description","type":"varchar(512)","nullable":true,"primary_key":false},{"name":"params","type":"longtext","nullable":false,"primary_key":false},{"name":"related_to","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"default","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"name","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"instruction","type":"text","nullable":true,"primary_key":false},{"name":"source","type":"varchar(512)","nullable":true,"primary_key":false},{"name":"source_type","type":"varchar(256)","nullable":true,"primary_key":false},{"name":"source_sub_type","type":"varchar(256)","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},{"name":"chat_uuid","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"topic","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"entities","type":"TEXT","nullable":true,"primary_key":false},{"name":"summary","type":"TEXT","nullable":true,"primary_key":false},{"name":"confidence","type":"DECIMAL(5,4)","nullable":true,"primary_key":false},{"name":"sentiment","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"user_preferences","type":"TEXT","nullable":true,"primary_key":false},{"name":"user_intent_history","type":"TEXT","nullable":true,"primary_key":false},{"name":"dataset_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"dataset_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"entry","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"ai_model_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"label","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"ai_provider_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"default","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"modalities","type":"longtext","nullable":true,"primary_key":false},{"name":"endpoints","type":"longtext","nullable":true,"primary_key":false},{"name":"features","type":"longtext","nullable":true,"primary_key":false},{"name":"input_token_limit","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"output_token_limit","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"fine_tuned","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"vector_db_id","type":"varchar(64)","nullable":true,"primary_key":false},{"name":"config_id","type":"int 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},{"name":"vector_index_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"values","type":"longtext","nullable":true,"primary_key":false},{"name":"dimension","type":"int","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"ai_model_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"dataset_entry_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"config_id","type":"int unsigned","nullable":true,"primary_key":false},{"name":"access_roles","type":"longtext","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},{"name":"uuid","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"wp_user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"device_uuid","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ip","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"type","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"chatbot_user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(256)","nullable":false,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"vector_index_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"vector_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"type","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"access_roles","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"config","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"ai_instructions","type":"TEXT","nullable":true,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"action_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"order","type":"INT","nullable":false,"primary_key":false},{"name":"question","type":"TEXT","nullable":true,"primary_key":false},{"name":"required","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"default_value","type":"TEXT","nullable":true,"primary_key":false},{"name":"placeholder","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"validation_rules","type":"TEXT","nullable":true,"primary_key":false},{"name":"suggestions","type":"TEXT","nullable":true,"primary_key":false},{"name":"config","type":"TEXT","nullable":true,"primary_key":false},{"name":"action_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"config","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"order","type":"INT","nullable":false,"primary_key":false},{"name":"is_required","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"status","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"action_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"action_data","type":"longtext","nullable":true,"primary_key":false},{"name":"chatbot_user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"chat_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"callback_results","type":"longtext","nullable":true,"primary_key":false},{"name":"extracted_vars","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"error_message","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"sub_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"progress_percent","type":"DECIMAL(5,2)","nullable":false,"primary_key":false},{"name":"chatbot_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"config","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"stats","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"errors","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"started_at","type":"datetime","nullable":true,"primary_key":false},{"name":"completed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"job_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"parent_task_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"payload","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(50)","nullable":false,"primary_key":false},{"name":"attempt_count","type":"INT","nullable":false,"primary_key":false},{"name":"error","type":"TEXT","nullable":true,"primary_key":false},{"name":"task_started_at","type":"datetime","nullable":true,"primary_key":false},{"name":"task_completed_at","type":"datetime","nullable":true,"primary_key":false},{"name":"chatbot_user_uuid","type":"varchar(36)","nullable":false,"primary_key":false},{"name":"chatbot_uuid","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"chat_uuid","type":"varchar(36)","nullable":true,"primary_key":false},{"name":"source_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"source","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"source_title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"metadata","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"is_qualified","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"field_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"status","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"data_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"lead_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"field_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"value_string","type":"longtext","nullable":true,"primary_key":false},{"name":"value_number","type":"decimal(19,4)","nullable":true,"primary_key":false},{"name":"value_date","type":"datetime","nullable":true,"primary_key":false},{"name":"chatbot_user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"type_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"channel","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"sent_at","type":"datetime","nullable":true,"primary_key":false},{"name":"fail_reason","type":"TEXT","nullable":true,"primary_key":false},{"name":"content_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"ip","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"location","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"reason","type":"text","nullable":true,"primary_key":false},{"name":"type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"blocked_until","type":"datetime","nullable":true,"primary_key":false},{"name":"chatbot_user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"uuid","type":"char(36)","nullable":false,"primary_key":false},{"name":"type","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"published","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"config","type":"longtext","nullable":true,"primary_key":false},{"name":"locations","type":"longtext","nullable":true,"primary_key":false},{"name":"visibility","type":"longtext","nullable":true,"primary_key":false},{"name":"order","type":"int(11)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":false,"primary_key":false},{"name":"event_type","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"chat_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"chatbot_user_uuid","type":"char(36)","nullable":true,"primary_key":false},{"name":"recipient_wp_user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"payload","type":"longtext","nullable":false,"primary_key":false},{"name":"is_read","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"from_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"from_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"target_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"target_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"rate","type":"int(11)","nullable":false,"primary_key":false},{"name":"notes","type":"text","nullable":true,"primary_key":false},{"name":"metadata","type":"longtext","nullable":true,"primary_key":false},{"name":"chatbot_user_id","type":"bigint(20) unsigned","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"source_id","type":"varchar(191)","nullable":true,"primary_key":false}],"plugin":{"slug":"limb-chatbot","name":"Limb AI Chatbot","active_installs":70,"version":"2.0.0","wp_org_url":"https://wordpress.org/plugins/limb-chatbot/"}}