{"table_name":"hr_rag_docs","full_table_name":"wp_hr_rag_docs","description":"Stores hr rag docs data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_hr_rag_docs ( id int(11) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, source_type varchar(50) NOT NULL, content longtext NOT NULL, created_at datetime DEFAULT CURRENT_TIMESTAMP, updated_at datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate; CREATE TABLE wp_hr_rag_chunks ( id int(11) NOT NULL AUTO_INCREMENT, doc_id int(11) NOT NULL, chunk_text longtext NOT NULL, embedding longtext, tokens_count int(11) DEFAULT 0, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY doc_id (doc_id) ) $charset_collate; CREATE TABLE wp_hr_rag_chats ( id int(11) NOT NULL AUTO_INCREMENT, user_id int(11), question text NOT NULL, answer longtext NOT NULL, llm_used varchar(50) NOT NULL, context_docs longtext, created_at datetime DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;\"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php');","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"source_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"content","type":"longtext","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"doc_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"chunk_text","type":"longtext","nullable":false,"primary_key":false},{"name":"embedding","type":"longtext","nullable":true,"primary_key":false},{"name":"tokens_count","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"question","type":"text","nullable":false,"primary_key":false},{"name":"answer","type":"longtext","nullable":false,"primary_key":false},{"name":"llm_used","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"context_docs","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"hr-rag-chatbot","name":"HR RAG Chatbot","active_installs":0,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/hr-rag-chatbot/"}}