{"guide_id":10,"guide_group":"wordpress_operational_guides","guide_path":"Operations Manual / Operational Knowledge Base / Operational Schema Registry","slug":"operational-schema-registry","title":"Operational Schema Registry","wp_status":"private","content_html":"<h1>Operational Schema Registry</h1>\n\n<p><strong>Subsystem:</strong> WSAI_OperationalSchemaRegistry_v1</p>\n<p><strong>Status:</strong> Validated / Locked / Published to Knowledge Base</p>\n\n<h2>Purpose</h2>\n<p>The Operational Schema Registry documents and validates the MariaDB operational schema used by the WickedSpooky.ai control plane.</p>\n\n<h2>Operational Authority</h2>\n<p>MariaDB database <strong>wsai_ops</strong> remains the authoritative operational memory layer. WordPress presents schema documentation and bootstrap context but does not replace database authority.</p>\n\n<h2>Validated State</h2>\n<ul>\n<li>Registered tables: 67</li>\n<li>Registered fields: 701</li>\n<li>Registered views: 21</li>\n<li>Active dependencies: 34</li>\n<li>Open drift findings: 0</li>\n<li>Promotion-ready scenarios: 1</li>\n</ul>\n\n<h2>Primary Registry Objects</h2>\n<ul>\n<li>operational_schema_registry</li>\n<li>operational_schema_fields</li>\n<li>operational_schema_views</li>\n<li>operational_schema_dependencies</li>\n<li>operational_schema_drift_findings</li>\n</ul>\n\n<h2>Validation View</h2>\n<pre>SELECT * FROM v_operational_schema_registry_health;</pre>\n\n<h2>Known Good Validation Result</h2>\n<pre>\nregistered_tables: 67\nregistered_fields: 701\nregistered_views: 21\nactive_dependencies: 34\nopen_drift_findings: 0\npromotion_ready_scenarios: 1\n</pre>\n\n<h2>Bootstrap Usage</h2>\n<p>Future sessions may bootstrap schema authority using:</p>\n\n<pre>Bootstrap Repository:\nWSAI_OperationalSchemaRegistry_v1</pre>\n\n<h2>Related Subsystems</h2>\n<ul>\n<li>WSAI_OperationalKnowledgeBase_v1</li>\n<li>WSAI_OperationsManual_v1</li>\n<li>WSAI_MakePublishingOrchestration_v1</li>\n</ul>","content_text":"Operational Schema Registry\n\nSubsystem: WSAI_OperationalSchemaRegistry_v1\nStatus: Validated / Locked / Published to Knowledge Base\n\nPurpose\nThe Operational Schema Registry documents and validates the MariaDB operational schema used by the WickedSpooky.ai control plane.\n\nOperational Authority\nMariaDB database wsai_ops remains the authoritative operational memory layer. WordPress presents schema documentation and bootstrap context but does not replace database authority.\n\nValidated State\n\nRegistered tables: 67\nRegistered fields: 701\nRegistered views: 21\nActive dependencies: 34\nOpen drift findings: 0\nPromotion-ready scenarios: 1\n\n\nPrimary Registry Objects\n\noperational_schema_registry\noperational_schema_fields\noperational_schema_views\noperational_schema_dependencies\noperational_schema_drift_findings\n\n\nValidation View\nSELECT * FROM v_operational_schema_registry_health;\n\nKnown Good Validation Result\n\nregistered_tables: 67\nregistered_fields: 701\nregistered_views: 21\nactive_dependencies: 34\nopen_drift_findings: 0\npromotion_ready_scenarios: 1\n\n\nBootstrap Usage\nFuture sessions may bootstrap schema authority using:\n\nBootstrap Repository:\nWSAI_OperationalSchemaRegistry_v1\n\nRelated Subsystems\n\nWSAI_OperationalKnowledgeBase_v1\nWSAI_OperationsManual_v1\nWSAI_MakePublishingOrchestration_v1","content_sha256":"b85dc81b1cc006275e0a7e2bcd7f3c9a7d7da6443f4f6edec3d2cc94d7c2a2c0","source_system":"wordpress","source_post_id":33,"parent_source_post_id":29,"last_source_modified":"2026-05-31 04:03:28","imported_at":"2026-06-03 22:24:58","is_active":1}