wp_semantic_suggested_entities
StaticStores semantic suggested entities data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) UNSIGNED | NO |
| analysis_id | bigint(20) UNSIGNED | NO |
| post_id | bigint(20) UNSIGNED | NO |
| name | varchar(255) | NO |
| type | varchar(50) | YES |
| definition | text | YES |
| relevance_score | float | YES |
| model_confidence | float | YES |
| contextual_confidence | float | YES |
| related_entities | longtext | YES |
| mentions | longtext | YES |
| schema_reasoning | text | YES |
| exclusion_reasoning | text | YES |
| wikidata_qid | varchar(50) | YES |
| wikidata_verified | tinyint(1) | YES |
| aliases | longtext | YES |
| same_as | longtext | YES |
| roles | longtext | YES |
| canonical_entity_id | varchar(255) | YES |
| entity_registry_id | bigint(20) UNSIGNED | YES |
| salience | float | YES |
| approval_status | varchar(20) | NO |
| created_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_semantic_suggested_entities ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, analysis_id bigint(20) UNSIGNED NOT NULL, post_id bigint(20) UNSIGNED NOT NULL, name varchar(255) NOT NULL, type varchar(50), definition text, relevance_score float DEFAULT 0, model_confidence float DEFAULT 0, contextual_confidence float DEFAULT 0, related_entities longtext, mentions longtext, schema_reasoning text, exclusion_reasoning text, wikidata_qid varchar(50), wikidata_verified tinyint(1) DEFAULT 0, aliases longtext, same_as longtext, roles longtext, canonical_entity_id varchar(255), entity_registry_id bigint(20) UNSIGNED, salience float DEFAULT 0.5, approval_status varchar(20) NOT NULL DEFAULT 'pending', created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY analysis_id (analysis_id), KEY post_id (post_id), KEY approval_status (approval_status), KEY canonical_entity_id (canonical_entity_id(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_suggested_entities`;
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)