Operational Schema Registry

Guide ID: 10

Path: Operations Manual / Operational Knowledge Base / Operational Schema Registry

Slug: operational-schema-registry

Source Post: 33

Last Source Modified: 2026-05-31 04:03:28

SHA256: b85dc81b1cc006275e0a7e2bcd7f3c9a7d7da6443f4f6edec3d2cc94d7c2a2c0

View JSON

Operational Schema Registry

Subsystem: WSAI_OperationalSchemaRegistry_v1

Status: Validated / Locked / Published to Knowledge Base

Purpose

The Operational Schema Registry documents and validates the MariaDB operational schema used by the WickedSpooky.ai control plane.

Operational Authority

MariaDB database wsai_ops remains the authoritative operational memory layer. WordPress presents schema documentation and bootstrap context but does not replace database authority.

Validated State

Registered tables: 67
Registered fields: 701
Registered views: 21
Active dependencies: 34
Open drift findings: 0
Promotion-ready scenarios: 1

Primary Registry Objects

operational_schema_registry
operational_schema_fields
operational_schema_views
operational_schema_dependencies
operational_schema_drift_findings

Validation View

SELECT * FROM v_operational_schema_registry_health;

Known Good Validation Result

registered_tables: 67
registered_fields: 701
registered_views: 21
active_dependencies: 34
open_drift_findings: 0
promotion_ready_scenarios: 1

Bootstrap Usage

Future sessions may bootstrap schema authority using:

Bootstrap Repository:
WSAI_OperationalSchemaRegistry_v1

Related Subsystems

WSAI_OperationalKnowledgeBase_v1
WSAI_OperationsManual_v1
WSAI_MakePublishingOrchestration_v1

WSAI Operational Guides

Guides