{"table_name":"semantic_analyses","full_table_name":"wp_semantic_analyses","description":"Stores semantic analyses data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_semantic_analyses ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, post_id bigint(20) UNSIGNED NOT NULL, phase varchar(20) NOT NULL DEFAULT 'full', status varchar(20) NOT NULL DEFAULT 'pending', content_analysis longtext, summary text, citable_snippet text, llm_tags text, author_credentials text, audience text, compact_howto text, summaries longtext, llm_context_block longtext, llm_title text, llm_description text, content_sections longtext, cleaned_content longtext, primary_topic_entity varchar(255), page_type varchar(50), primary_intent varchar(255), secondary_intents longtext, user_stage varchar(50), difficulty varchar(50), entity_relationships longtext, external_job_id varchar(255), error_message text, started_at datetime, finished_at datetime, created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id), KEY status (status) ) $charset;\" );","columns":[{"name":"id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"bigint(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"phase","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"content_analysis","type":"longtext","nullable":true,"primary_key":false},{"name":"summary","type":"text","nullable":true,"primary_key":false},{"name":"citable_snippet","type":"text","nullable":true,"primary_key":false},{"name":"llm_tags","type":"text","nullable":true,"primary_key":false},{"name":"author_credentials","type":"text","nullable":true,"primary_key":false},{"name":"audience","type":"text","nullable":true,"primary_key":false},{"name":"compact_howto","type":"text","nullable":true,"primary_key":false},{"name":"summaries","type":"longtext","nullable":true,"primary_key":false},{"name":"llm_context_block","type":"longtext","nullable":true,"primary_key":false},{"name":"llm_title","type":"text","nullable":true,"primary_key":false},{"name":"llm_description","type":"text","nullable":true,"primary_key":false},{"name":"content_sections","type":"longtext","nullable":true,"primary_key":false},{"name":"cleaned_content","type":"longtext","nullable":true,"primary_key":false},{"name":"primary_topic_entity","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"page_type","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"primary_intent","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"secondary_intents","type":"longtext","nullable":true,"primary_key":false},{"name":"user_stage","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"difficulty","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"entity_relationships","type":"longtext","nullable":true,"primary_key":false},{"name":"external_job_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"started_at","type":"datetime","nullable":true,"primary_key":false},{"name":"finished_at","type":"datetime","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}],"plugin":{"slug":"ai-data-layer","name":"AI Data Layer – AI SEO & AI Search Optimization: llms.txt, MCP Server, Schema (AEO/GEO)","active_installs":0,"version":"1.13.0","wp_org_url":"https://wordpress.org/plugins/ai-data-layer/"}}