wp_hr_rag_docs
StaticStores hr rag docs data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| title | varchar(255) | NO |
| source_type | varchar(50) | NO |
| content | longtext | NO |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| doc_id | int(11) | NO |
| chunk_text | longtext | NO |
| embedding | longtext | YES |
| tokens_count | int(11) | YES |
| created_at | datetime | YES |
| user_id | int(11) | YES |
| question | text | NO |
| answer | longtext | NO |
| llm_used | varchar(50) | NO |
| context_docs | longtext | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
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');
Safe to delete?
If you have uninstalled HR RAG Chatbot, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_hr_rag_docs`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from HR RAG Chatbot