wp_semantic_entity_registry
StaticStores semantic entity registry data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| entity_id | varchar(255) | NO |
| label | varchar(255) | NO |
| canonical_label | varchar(255) | YES |
| type | varchar(50) | YES |
| wikidata_qid | varchar(50) | YES |
| same_as | longtext | YES |
| synonyms | longtext | YES |
| definition | text | YES |
| canonical_roles | longtext | YES |
| role_frequency | longtext | YES |
| typical_contexts | longtext | YES |
| occurrence_count | int | NO |
| mention_count | int | NO |
| created_at | datetime | NO |
| updated_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_semantic_entity_registry ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, entity_id varchar(255) NOT NULL, label varchar(255) NOT NULL, canonical_label varchar(255), type varchar(50), wikidata_qid varchar(50), same_as longtext, synonyms longtext, definition text, canonical_roles longtext, role_frequency longtext, typical_contexts longtext, occurrence_count int NOT NULL DEFAULT 0, mention_count int NOT NULL 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), UNIQUE KEY entity_id (entity_id(191)), KEY type (type), KEY label (label(191)) ) $charset;" );
Safe to delete?
If you have uninstalled AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO), 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_semantic_entity_registry`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO)