Substrate Schema Catalog

Every substrate migration carried by the Franklin cell, generated from cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV*.swift. Each migration is append-only by substrate doctrine: rows are sealed with a canonical witness and federation signature quintet, never updated or deleted.

Substrate-mathematical context: see Substrate-Mathematical Foundation — V160/V178 carry computational irreducibility, V184 the observer-dependent Second Law, V200/V201/V203 the mechanoidal phase, V187 effective irreversibility.

201 migrations · 124 define tables · 147 carry a federation cosignature.

---

All migrations

Version	Table	Kind	Append-only	Cosigned	NATS subject	Purpose
V15	—	modifies				gap-audit v0.2 closures
V16	—	modifies				gap-audit v0.3 closures
V17	—	modifies				Standing CURE Ledger + signed-receipt columns
V18	—	modifies				de-drift the narrator subsystem to macOS-only scope
V19	—	modifies				Klein-Bottle Truth-Coherence substrate
V20	—	modifies				Live-Operation Evidence substrate
V21	—	modifies				quorum_context_live_attestations
V22	—	modifies	✓			substrate append-only enforcement + audit-violation
V23	—	modifies	✓			substrate append-only enforcement (correctly named)
V24	—	modifies	✓			trust lives in the cell, not in Keychain
V25	—	modifies				alignment turn key-claims, substrate-resident
V26	—	modifies	✓			full-catalog coverage infrastructure
V27	—	modifies	✓			language-game substrate for the full catalog
V28	—	modifies	✓			guided self-reflection
V29	—	modifies	✓			Active Learning · Active Thinking · Full Coverage
V30	outside	defines	✓			closed-bottle longitudinal run management
V31	—	modifies	✓			S⁴ embodiment: the USD scene is the language game's body
V32	—	modifies	✓			c1..c4 constraint-crystal binding source correction
V33	—	modifies	✓			Meaning-substrate / Language-projection separation
V34	—	modifies				Directive 3 substrate seed: quantum + fusion + health
V35	—	modifies				shared-meaning support: room-intro atoms + meaning gate
V36	—	modifies				Quantum room teaching enrichment
V37	—	modifies				Fusion + Health + Lithography teaching enrichment
V38	—	modifies	✓			Quantum C4 workflow closure: per-algorithm walks,
V39	—	modifies				fixes the v38 QC-NNN-WALK warrant queries
V40	—	modifies	✓			Seven Scenes C⁴ training: substrate witness + receipts
V41	—	modifies				Seven Scenes narration corpus + witness columns
V42	—	modifies	✓			ERIC corpus import
V43	—	modifies	✓			GFTCL-LICENSING-MESH-001
V44	—	modifies				Licensing seed
V45	—	modifies	✓			cell boot recall
V46	—	modifies	✓	✓		wiki PQ receipts
V47	—	modifies	✓			corpus_patent_xref row-specific claim text re-seed
V48	—	modifies	✓	✓		GFTCL-TEACHING-SURFACE-001 substrate side
V49	—	modifies	✓	✓		GFTCL-CELL-LEGIBILITY-001 substrate side
V50	—	modifies	✓	✓		GFTCL-CELL-LEGIBILITY-002 substrate side
V51	—	modifies				every ERIC-corpus discovery walks every cycle
V52	—	modifies		✓		wire measurement claims for every DISC scenario
V53	—	modifies	✓	✓		GFTCL-DISC-COMPLETENESS-001 Move 1
V54	—	modifies				GFTCL-DISC-COMPLETENESS-001 Move 2
V55	—	modifies	✓	✓		GFTCL-DISC-COMPLETENESS-001 Move 3
V56	—	modifies	✓	✓		GFTCL-DISC-COMPLETENESS-001 Move 5
V57	—	modifies	✓	✓		GFTCL-DISC-COMPLETENESS-001 Move 6
V58	—	modifies				fix v51's NULL-domain bug on existing substrates
V59	—	modifies				backfill usd_assets for the 83 missing scenarios
V60	—	modifies	✓	✓		GFTCL-VQBIT-WORKBENCH-001 substrate side
V61	—	modifies	✓	✓		GFTCL-CLINICAL-TB-TRIAL-GLOBAL-001 substrate side
V62	cell_node_catalog	defines	✓	✓		GFTCL-WORKBENCH-AS-PEOPLETOOLS-METAPHOR-001
V63	—	modifies	✓	✓		Workbench made live on macOS
V64	wb_meaning_atoms	defines	✓	✓		Multilingual + visionOS + iPad + Siri/App Intent
V65	workbench_locale_interactions	defines	✓	✓		Dynamic meaning-atom resolver substrate
V66	ui_surface_registry	defines	✓	✓		Workbench manages the entire UI, PeopleTools-style
V67	composition_canvas_layouts	defines	✓	✓		Workbench surface that earns the name
V68	composition_projection_assets	defines	✓	✓		Compositions project through RealityKit / USD
V69	workbench_ui_analytic_cycles	defines	✓	✓		Workbench UI analytic review folds into the
V70	language_game_simulated_walks	defines	✓	✓		Language-game simulator + friction evaluator
V71	workbench_guide_stories	defines	✓	✓		Franklin as Guide + constitutional ethics gate
V72	cell_self_reflection_cycles	defines	✓	✓		The CURE → CALORIE self-reflection loop
V73	discovery_game_definitions	defines	✓	✓		Discovery-Inventory-as-Game
V74	cell_self_repair_recipes	defines	✓	✓		Cell self-repair
V75	discovery_game_node_assets	defines	✓	✓		Dynamic Game Walks + Traveler Drill-In
V76	franklin_actor_script_recipes	defines	✓	✓		Franklin AppleScript Actor
V77	workbench_turn_ledger	defines	✓	✓		Turn Bus + Per-Element Story/Meaning Audit
V78	discovery_bulk_loader_sessions	defines	✓	✓		Discovery Game Bulk Loader sessions + events
V79	franklin_rendered_state_reports	defines	✓	✓		Franklin's "what am I showing?" reporter + operator disputes
V80	workbench_animation_events	defines	✓	✓		Living workbench: every rail breathes on its turn,
V81	discovery_game_narrative_steps	defines	✓	✓		Generic Narrative Flow + Franklin's per-step think-out-loud review
V82	discovery_narrative_bulk_sessions	defines	✓	✓		Bulk narrative cycle (every game, one step at a time)
V83	immersive_navigator_sessions	defines	✓	✓		Immersive Game Navigator (Spider / Octopus / Owl)
V84	c4_field_explanations	defines	✓	✓		Meaning Navigator: C⁴ ↔ S⁴ invariant mappings + constraints
V85	witness_axis_definitions	defines	✓	✓		8-axis first-person witness context navigator
V86	projection_focus_events	defines	✓	✓		Substrate-truth on the RealityKit composition projection
V87	workbench_drift_refusals	defines	✓	✓		Cell seals UI drift REFUSED; ships auto-teaching narrator
V88	workbench_architectural_doctrine	defines	✓	✓		Epistemic Doom Workbench doctrine + retirement of
V89	franklin_install_locations	defines	✓	✓		Permission domicile
V90	mathematical_conjectures	defines	✓	✓		Mathematical Proof Rail (on-device) +
V93	workbench_ui_success_criteria	defines	✓	✓		Successful Workbench UI definition, cinema mode
V94	workbench_story_scenes	defines	✓	✓		Per-story rendered visuals; AML inv(3) as the
V95	workbench_game_steering	defines	✓	✓		Game-end completeness: GAMP 5 + clinical
V96	franklin_voice_state	defines	✓	✓		Voice toggle, game validation lifecycle, PDF
V97	cfr21_part11_audit	defines	✓	✓		CFR 21 Part 11-controlled receipts + GAMP 5
V98	franklin_narrator_mode	defines	✓	✓		Non-stop random-domain walk + dossier as
V99	workbench_dossier_presentations	defines	✓	✓		Surface the dossier. Per-domain backdrops
V100	—	modifies	✓	✓		De-brand the dossier title. Strip the "ERIC
V102	reflective_mesh_observations	defines	✓	✓		The Workbench Made A Workbench
V103	workbench_active_compositions	defines	✓	✓		USD story-flow substrate: active compositions,
V104	atom_vqbit_fields	defines	✓	✓		vQbit Atom promotion: atoms become nodes, not strings
V105	cure_game_judging_persons	defines	✓	✓		Internal UI Listener (the self-testing human player)
V107	game_authoring_jobs	defines	✓	✓		Every cure becomes a language game
V109	—	modifies		✓		Space Hard Workbench Language Game
V110	listener_iteration_runs	defines	✓	✓		Iterative Discovery Refinement Loop
V112	lean_proof_runs	defines	✓	✓		Lion Math substrate
V113	workbench_rcp_placements	defines	✓	✓		Reality Composer Pro editor + composite
V114	lion_math_chains	defines		✓		M⁸ Frequency Sweep substrate (provenance side)
V115	lion_gate_agreement	defines		✓		Dual-Gate Agreement Log + Swift-Gate Trust View
V116	lion_math_roar_templates	defines		✓		Dynamic autonomous Lion Math roar queue
V117	alert_domain_registry	defines	✓	✓		GFTCL-WITNESS-ALERT-001
V118	energy_ledger_traces	defines	✓	✓	gaiaftcl.energy.ledger.input	GFTCL-LION-ENERGY-LEDGER-001
V119	summit_states	defines	✓	✓		GFTCL-LION-ENERGY-LEDGER-001 UI substrate
V120	benchtop_sessions	defines	✓	✓		GFTCL-LION-ENERGY-LEDGER-001 / Benchtop tool
V121	domain_meaning_audits	defines	✓	✓		GFTCL-LION-MEANING-AUDIT-001
V122	meaning_trajectories	defines	✓	✓	gaiaftcl.lvc.receipt.sealed	GFTCL-LION-LVC-001
V123	materials_specs	defines	✓	✓		GFTCL-LION-MATERIALS-001
V124	patient_cases	defines	✓	✓		GFTCL-LION-MEDICAL-001
V125	pq_implementations	defines	✓	✓		GFTCL-LION-SECURITY-001
V126	drug_trials	defines	✓	✓		GFTCL-LION-DRUG-001
V127	—	modifies	✓	✓		GFTCL-LION-LOGISTICS-001
V128	climate_food_chains	defines	✓	✓	gaiaftcl.climate_food.chain.sealed	GFTCL-LION-CLIMATE-FOOD-001
V129	—	modifies		✓		GFTCL-LION-FEDERATION-RETROFIT-001
V130	—	modifies	✓	✓		GFTCL-LION-FEDERATION-RETROFIT-001 fix
V131	federation_emissions	defines		✓		GFTCL-LION-FEDERATION-EMISSION-001
V132	—	modifies		✓		V131 trigger fix
V133	—	modifies		✓		federation_emissions backfill
V134	—	modifies	✓	✓		audit drift correction for LVC
V135	lvc_receipts	defines	✓	✓	gaiaftcl.lvc.collapse.sealed	GFTCL-LION-LVC-003 substrate
V136	—	modifies	✓	✓		GFTCL-LION-LVC-007 — Fix 4
V137	flourishing_floor	defines	✓	✓	gaiaftcl.lvc.constitutional.sealed	GFTCL-LION-LVC-008
V138	ui_language_game_drift_receipts	defines	✓	✓	gaiaftcl.lvc.ui_language_game.sealed	GFTCL-LION-LVC-009 — recursive LVC on the cell's own UI
V139	striving_proposals	defines	✓	✓		GFTCL-LION-LVC-010
V140	striving_authorization_policy	defines	✓	✓		GFTCL-LION-LVC-011
V141	striving_proposals	defines	✓	✓		GFTCL-LION-LVC-012
V142	origin_geometry_profiles	defines	✓	✓	gaiaftcl.franklin.telling.sealed	GFTCL-LION-FRANKLIN-001
V143	chat_turns	defines	✓	✓	gaiaftcl.franklin.chat.turn.sealed	GFTCL-LION-FRANKLIN-001 (chat)
V144	franklin_closure_registry	defines	✓	✓		GFTCL-LION-FRANKLIN-001 (auto-mode)
V145	—	modifies		✓		GFTCL-LION-MATH-001 (LVC foundation)
V146	—	modifies		✓		GFTCL-LION-LVC (workbench reset, loop integration)
V147	striving_proposals	defines		✓		GFTCL-LION-LVC (always-make-better-UI)
V148	—	modifies		✓		GFTCL-LION-LVC (ERIC inventory → language games)
V149	—	modifies		✓		GFTCL-LION-LVC (ERIC arcs: make the inventory gate-ready)
V150	lvc_score_memory	defines				GFTCL-LION-LVC (the constant LVC-scoring loop's memory)
V151	—	modifies		✓		GFTCL-LION-LVC (batteries + water: same shape, two new domains)
V152	qc020_difficulty_ledger	defines	✓			QC-020 BTC Preimage (large): difficulty ledger
V153	—	modifies	✓			corrective: fix block-100000 header hex in
V154	qc020_miner_heartbeats	defines	✓			QC-020 BTC Substrate Miner: heartbeats, capture
V155	—	modifies	✓			QC-020 solve-time telemetry on every capture
V156	—	modifies				QC-020 M⁸ amplification telemetry
V157	—	modifies				substrate-binding vs liveness telemetry
V158	—	modifies				QC-020 production-path telemetry for the
V159	—	modifies	✓	✓	gaiaftcl.qc020.capture.sealed	bring QC-020's per-tick narration into
V160	qc020_substrate_research_telemetry	defines	✓	✓	gaiaftcl.qc020.research.sealed	QC-020 substrate research telemetry
V161	qc020_window_summaries	defines	✓	✓	gaiaftcl.qc020.window.summary.sealed	QC-020 substrate window summaries
V162	qc020_franklin_observations	defines	✓	✓	gaiaftcl.qc020.franklin.observation.sealed	Franklin's observations on the substrate's
V163	qc020_franklin_commissions	defines	✓	✓	gaiaftcl.qc020.franklin.commission.sealed	Franklin's commission table
V164	qc020_franklin_commission_history	defines	✓	✓	gaiaftcl.qc020.franklin.commission.history.sealed	Franklin's commission state-transition
V165	qc020_franklin_commissions	defines	✓	✓	gaiaftcl.qc020.franklin.commission.sealed	extend qc020_franklin_commissions CHECK
V166	—	modifies				extend qc020_franklin_commission_history
V167	—	modifies				projection-state columns on
V168	qc020_franklin_tuning_history	defines	✓	✓	gaiaftcl.qc020.franklin.tuning.sealed	Franklin's adaptive-tuner history
V170	franklin_window_filtering	defines	✓	✓	gaiaftcl.qc020.franklin.window_filtering.sealed	Franklin's between-collapse filtering
V171	—	modifies				research telemetry hardware-aware
V172	qc020_substrate_session_replay_anchors	defines	✓	✓	gaiaftcl.qc020.substrate.replay_anchor.sealed	substrate session replay anchors
V173	qc020_franklin_commissions	defines	✓	✓	gaiaftcl.qc020.franklin.commission.sealed	extend franklin commission tunable_name
V174	substrate_constitutional_evaluations	defines	✓	✓	gaiaftcl.substrate.constitutional_evaluation.sealed	substrate_constitutional_evaluations
V175	qc020_anchor_confidence_derivative	defines	✓	✓	gaiaftcl.qc020.substrate.anchor_derivative.sealed	anchor confidence-derivative companion
V176	—	modifies	✓			extend V172 anchors with
V177	substrate_per_algorithm_allocation_audit	defines	✓	✓	gaiaftcl.substrate.per_algorithm_allocation_audit.sealed	per-algorithm allocation audit
V178	qc020_joint_variation_evidence	defines	✓	✓	gaiaftcl.qc020.substrate.joint_variation_evidence.sealed	substrate joint variation evidence
V179	—	modifies				ALTER V170 franklin_window_filtering to
V180	qc020_franklin_commissions	defines	✓	✓	gaiaftcl.qc020.franklin.commission.sealed	extend qc020_franklin_commissions
V181	qc_algorithm_evaluation_history	defines	✓	✓	gaiaftcl.substrate.algorithm_evaluation.sealed	qc_algorithm_evaluation_history
V182	substrate_health_observations	defines	✓	✓	gaiaftcl.substrate.health_observation.sealed	substrate_health_observations
V183	substrate_healing_actions	defines	✓	✓	gaiaftcl.substrate.healing_action.sealed	substrate_healing_actions
V184	franklin_heartbeat_history	defines	✓	✓	gaiaftcl.substrate.franklin_heartbeat.sealed	franklin_heartbeat_history
V185	substrate_healing_actions_sovereign	defines	✓	✓	gaiaftcl.substrate.healing_action.sealed	sovereign substrate authority migration
V186	qc020_franklin_commissions	defines	✓	✓	gaiaftcl.substrate.healing_action.sealed	substrate-development vocabulary
V187	substrate_post_quantum_signatures	defines	✓	✓	gaiaftcl.substrate.post_quantum_signature.sealed	post-quantum signature provenance
V188	substrate_shor_demonstration_history	defines	✓	✓	gaiaftcl.substrate.shor_demonstration.sealed	substrate Shor demonstration history
V189	substrate_pq_wallet_migration_history	defines	✓	✓	gaiaftcl.substrate.pq_wallet_migration.sealed	substrate PQ wallet migration history
V190	substrate_shor_pq_safety_demonstration_history	defines	✓	✓	gaiaftcl.substrate.shor_pq_safety_demonstration.sealed	substrate Shor PQ-safety demonstration
V193	substrate_pq_ownership_verification_history	defines	✓	✓	gaiaftcl.substrate.pq_ownership_verification.sealed	substrate PQ ownership verification
V194	substrate_pq_migration_demonstration	defines	✓	✓	gaiaftcl.substrate.pq_migration_demonstration.sealed	substrate PQ migration demonstration
V195	substrate_qfot_ledger	defines	✓	✓	gaiaftcl.substrate.qfot_ledger.sealed	substrate QFOT ledger
V196	substrate_cell_sprout_history	defines	✓	✓	gaiaftcl.substrate.cell_sprout.sealed	substrate cell sprout history
V197	substrate_cell_mooring_history	defines	✓	✓	gaiaftcl.substrate.cell_mooring.sealed	substrate cell mooring history
V198	substrate_subscription_payment_history	defines	✓	✓	gaiaftcl.substrate.subscription_payment.sealed	substrate subscription payment history
V199	substrate_qfot_mesh_dispatch_history	defines	✓	✓	gaiaftcl.substrate.qfot_mesh_dispatch.sealed	substrate QFOT mesh dispatch history
V200	substrate_franklin_wound_ledger	defines	✓	✓	gaiaftcl.substrate.franklin_wound.sealed	substrate Franklin wound ledger
V201	substrate_franklin_reward_gradient	defines	✓	✓	gaiaftcl.substrate.franklin_reward_gradient.sealed	substrate Franklin reward gradient
V202	substrate_block_submission_outcomes	defines	✓	✓	gaiaftcl.substrate.block_submission_outcome.sealed	substrate block submission outcomes
V203	substrate_franklin_strategic_shift	defines	✓	✓	gaiaftcl.substrate.franklin_strategic_shift.sealed	substrate Franklin strategic shift
V204	substrate_franklin_wound_ledger	defines	✓	✓	gaiaftcl.substrate.franklin_wound.sealed	extends V200 substrate_franklin_wound_ledger
V205	—	modifies				extends V200 substrate_franklin_wound_ledger
V206	—	modifies				extends V201 substrate_franklin_reward_gradient
V207	—	modifies				extends V203 substrate_franklin_strategic_shift
V208	substrate_franklin_comms_projection	defines	✓	✓	gaiaftcl.substrate.franklin_comms_projection.sealed	substrate Franklin comms projection
V209	substrate_franklin_local_wallet	defines	✓	✓	gaiaftcl.substrate.franklin_local_wallet.sealed	substrate Franklin local wallet state
V210	substrate_franklin_local_wallet_ledger	defines	✓	✓	gaiaftcl.substrate.franklin_local_wallet_ledger.sealed	substrate Franklin local wallet ledger
V211	substrate_internal_randomness_provenance	defines	✓	✓	gaiaftcl.substrate.internal_randomness_provenance.sealed	substrate internal randomness provenance
V212	substrate_discrete_continuum_bridge	defines	✓	✓	gaiaftcl.substrate.discrete_continuum_bridge.sealed	substrate discrete-to-continuum bridge
V213	substrate_multicomputational_operation	defines	✓	✓	gaiaftcl.substrate.multicomputational_operation.sealed	substrate multicomputational operation
V214	substrate_federation_cosignature_depth_evidence	defines	✓	✓	gaiaftcl.substrate.federation_cosignature_depth.sealed	substrate federation cosignature depth
V215	substrate_demonstration_wallet_tracking	defines	✓	✓	gaiaftcl.substrate.demonstration_wallet_tracking.sealed	substrate demonstration wallet tracking
V216	—	modifies				V188 + V190 demonstration_wallet_id
V217	substrate_wallet_backup_history	defines	✓	✓	gaiaftcl.substrate.wallet_backup_history.sealed	substrate wallet backup + restore history
V218	substrate_founder_cell_wallets	defines	✓	✓	gaiaftcl.substrate.founder_cell_wallets.sealed	substrate founder cell wallets
V219	substrate_franklin_cross_algorithm_learning	defines	✓	✓	gaiaftcl.substrate.franklin_cross_algorithm_learning.sealed	substrate Franklin cross-algorithm
V220	substrate_franklin_local_wallet_ledger	defines	✓	✓	gaiaftcl.substrate.franklin_local_wallet_ledger.sealed	V210 entry_type CHECK extension for
V221	substrate_franklin_local_wallet_ledger	defines	✓	✓	gaiaftcl.substrate.franklin_local_wallet_ledger.sealed	V210 asset_class + entry_type CHECK
V222	substrate_founder_cell_wallets	defines	✓	✓	gaiaftcl.substrate.founder_cell_wallets.sealed	V218 substrate_founder_cell_wallets
V223	substrate_founder_cell_wallets	defines	✓	✓	gaiaftcl.substrate.founder_cell_wallets.sealed	V218 substrate_founder_cell_wallets
V224	—	modifies	✓			QC-032 substrate-mathematical correction

---

Table-defining migrations — columns

V30 — outside

closed-bottle longitudinal run management.

append-only· migration v30_longitudinal_run_closed_bottle

Column	Type
run_id	TEXT
started_at_tau_block	INTEGER
target_duration_hours	INTEGER
expected_completion_iso	TEXT
checkpoint_count	INTEGER
closed_at_tau_block	INTEGER
sentinel_walks_at_t0	INTEGER
cell_health_snapshots_at_t0	INTEGER
coherence_snapshots_at_t0	INTEGER
narrator_event_receipts_at_t0	INTEGER
truth_measurements_at_t0	INTEGER
klein_verifs_at_t0	INTEGER
frame_artifacts_at_t0	INTEGER
sentinel_walks_at_close	INTEGER
cell_health_snapshots_at_close	INTEGER
coherence_snapshots_at_close	INTEGER
narrator_event_receipts_at_close	INTEGER
truth_measurements_at_close	INTEGER
klein_verifs_at_close	INTEGER
frame_artifacts_at_close	INTEGER
composite_health_at_t0	REAL
composite_health_at_close	REAL
composite_coherence_at_t0	REAL
composite_coherence_at_close	REAL
quorum_signatures_json	TEXT
timestamp_iso_t0	TEXT
timestamp_iso_close	TEXT
signed_by_cell	TEXT
signed_by_context	TEXT
signature	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV30.swift

V62 — cell_node_catalog

GFTCL-WORKBENCH-AS-PEOPLETOOLS-METAPHOR-001.

append-only· federation-cosigned· migration v62_cell_graph_and_parallel_worlds_schema

Column	Type
node_id	TEXT
node_kind	TEXT
node_name	TEXT
display_label	TEXT
description	TEXT
substrate_ref	TEXT
parent_node_id	TEXT
level	INTEGER
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV62.swift

V64 — wb_meaning_atoms

Multilingual + visionOS + iPad + Siri/App Intent.

append-only· federation-cosigned· migration v64_meaning_atoms_schema

Column	Type
atom_id	TEXT
semantic_concept	TEXT
canonical_description	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV64.swift

V65 — workbench_locale_interactions

Dynamic meaning-atom resolver substrate.

append-only· federation-cosigned· migration v65_dynamic_locale_resolver_schema

Column	Type
interaction_id	TEXT
atom_id	TEXT
operator_locale	TEXT
canonical_definition	TEXT
rendered_label	TEXT
rendered_description	TEXT
entropy_source	TEXT
fm_inference_time_ms	REAL
entropy_delta_estimate	REAL
sealed_at_iso	TEXT
sealed_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV65.swift

V66 — ui_surface_registry

Workbench manages the entire UI, PeopleTools-style.

append-only· federation-cosigned· migration v66_ui_registry_schema

Column	Type
surface_id	TEXT
surface_kind	TEXT
display_atom_id	TEXT
source_file_path	TEXT
source_symbol	TEXT
parent_surface_id	TEXT
description	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV66.swift

V67 — composition_canvas_layouts

Workbench surface that earns the name.

append-only· federation-cosigned· migration v67_workbench_canvas_schema

Column	Type
layout_id	TEXT
composition_id	TEXT
layout_kind	TEXT
nodes_json	TEXT
edges_json	TEXT
authored_by_operator	TEXT
sealed_at_iso	TEXT
sealed_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV67.swift

V68 — composition_projection_assets

Compositions project through RealityKit / USD.

append-only· federation-cosigned· migration v68_projection_schema

Column	Type
projection_id	TEXT
composition_id	TEXT
canvas_node_id	TEXT
node_kind	TEXT
asset_kind	TEXT
asset_ref	TEXT
primitive_kind	TEXT
position_x	REAL
position_y	REAL
position_z	REAL
rotation_x	REAL
rotation_y	REAL
rotation_z	REAL
scale_x	REAL
scale_y	REAL
scale_z	REAL
material_token	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV68.swift

V69 — workbench_ui_analytic_cycles

Workbench UI analytic review folds into the.

append-only· federation-cosigned· migration v69_ui_analytic_review_schema

Column	Type
cycle_id	TEXT
loop_index	INTEGER
triggered_by_scene_index	INTEGER
surfaces_observed	INTEGER
elements_observed	INTEGER
elements_operator_editable	INTEGER
elements_hardcoded	INTEGER
compositions_observed	INTEGER
compositions_with_canvas	INTEGER
compositions_with_projection	INTEGER
drift_cures_emitted	INTEGER
terminal_state	TEXT
summary_text	TEXT
cycle_started_at_iso	TEXT
cycle_finished_at_iso	TEXT
cycle_duration_ms	REAL
cycle_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV69.swift

V70 — language_game_simulated_walks

Language-game simulator + friction evaluator.

append-only· federation-cosigned· migration v70_language_game_simulator_schema

Column	Type
walk_id	TEXT
composition_id	TEXT
triggered_by_cycle_id	TEXT
triggered_by_loop_index	INTEGER
step_count	INTEGER
friction_count	INTEGER
high_severity_count	INTEGER
foundation_model_used	TEXT
fm_inference_total_ms	REAL
walk_summary	TEXT
started_at_iso	TEXT
finished_at_iso	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV70.swift

V71 — workbench_guide_stories

Franklin as Guide + constitutional ethics gate.

append-only· federation-cosigned· migration v71_franklin_guide_schema

Column	Type
story_id	TEXT
story_order_index	INTEGER
story_title_atom	TEXT
story_subtitle_atom	TEXT
story_color_hex	TEXT
bounded_to_seven	INTEGER
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV71.swift

V72 — cell_self_reflection_cycles

The CURE → CALORIE self-reflection loop.

append-only· federation-cosigned· migration v72_self_reflection_schema

Column	Type
cycle_id	TEXT
triggered_by_loop_index	INTEGER
input_drift_count	INTEGER
input_friction_count	INTEGER
input_violation_count	INTEGER
proposed_goal_ids_json	TEXT
fm_inference_time_ms	REAL
cycle_terminal_state	TEXT
reflection_summary	TEXT
reflection_started_at_iso	TEXT
reflection_finished_at_iso	TEXT
cycle_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV72.swift

V73 — discovery_game_definitions

Discovery-Inventory-as-Game.

append-only· federation-cosigned· migration v73_discovery_game_schema

Column	Type
game_id	TEXT
discovery_subject_kind	TEXT
discovery_subject_id	TEXT
story_title_atom	TEXT
intent_atom	TEXT
cure_atom	TEXT
story_arc_kind	TEXT
story_node_count	INTEGER
licensing_scope_json	TEXT
bounded_to_story_id	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV73.swift

V74 — cell_self_repair_recipes

Cell self-repair.

append-only· federation-cosigned· migration v74_self_repair_schema

Column	Type
recipe_id	TEXT
binary_name	TEXT
swift_product_name	TEXT
source_root_absolute_path	TEXT
artifact_relative_path	TEXT
build_timeout_seconds	INTEGER
max_repair_attempts	INTEGER
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV74.swift

V75 — discovery_game_node_assets

Dynamic Game Walks + Traveler Drill-In.

append-only· federation-cosigned· migration v75_game_walk_schema

Column	Type
asset_binding_id	TEXT
story_node_id	TEXT
usd_inventory_id	TEXT
usd_primitive_path	TEXT
zoom_level	TEXT
context_label	TEXT
rigging_kind	TEXT
rigging_json	TEXT
drill_in_target_kind	TEXT
drill_in_target_id	TEXT
authored_status	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV75.swift

V76 — franklin_actor_script_recipes

Franklin AppleScript Actor.

append-only· federation-cosigned· migration v76_franklin_actor_schema

Column	Type
recipe_id	TEXT
recipe_name	TEXT
purpose	TEXT
applescript_text	TEXT
target_app_name	TEXT
target_window_pattern	TEXT
max_duration_seconds	INTEGER
cooldown_seconds	INTEGER
c007_certified	INTEGER
c008_certified	INTEGER
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV76.swift

V77 — workbench_turn_ledger

Turn Bus + Per-Element Story/Meaning Audit.

append-only· federation-cosigned· migration v77_turn_bus_schema

Column	Type
turn_id	TEXT
sequence_index	INTEGER
triggered_by	TEXT
trigger_detail	TEXT
started_at_iso	TEXT
completed_at_iso	TEXT
expected_rails	INTEGER
observed_rails	INTEGER
expected_elements	INTEGER
observed_elements	INTEGER
calorie_count	INTEGER
refused_count	INTEGER
terminal_state	TEXT
refusal_reasons_json	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV77.swift

V78 — discovery_bulk_loader_sessions

Discovery Game Bulk Loader sessions + events.

append-only· federation-cosigned· migration v78_bulk_loader_schema

Column	Type
session_id	TEXT
started_at_iso	TEXT
completed_at_iso	TEXT
total_games	INTEGER
total_loops	INTEGER
current_loop	INTEGER
current_game_index	INTEGER
games_opened_count	INTEGER
dwell_seconds	REAL
transition_delay_seconds	REAL
config_snapshot_json	TEXT
terminal_state	TEXT
triggered_by	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV78.swift

V79 — franklin_rendered_state_reports

Franklin's "what am I showing?" reporter + operator disputes.

append-only· federation-cosigned· migration v79_state_reporter_schema

Column	Type
report_id	TEXT
generated_at_iso	TEXT
triggered_by	TEXT
current_turn_id	TEXT
active_game_id	TEXT
active_walk_id	TEXT
active_walk_step_index	INTEGER
active_walk_arc_position	TEXT
bulk_loader_session_id	TEXT
bulk_loader_running	INTEGER
actor_loop_running	INTEGER
actor_last_recipe	TEXT
c4_scene	TEXT
c4_loop_index	INTEGER
c4_scene_index	INTEGER
rails_calorie_count	INTEGER
rails_refused_count	INTEGER
narrative_text	TEXT
substrate_citations_json	TEXT
generated_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV79.swift

V80 — workbench_animation_events

Living workbench: every rail breathes on its turn,.

append-only· federation-cosigned· migration v80_vitality_schema

Column	Type
event_id	TEXT
rail_id	TEXT
element_id	TEXT
s4_axis	TEXT
c4_context	TEXT
animation_kind	TEXT
intensity	REAL
duration_ms	INTEGER
triggered_by_turn_id	TEXT
triggered_by_step_id	TEXT
s4_story_text	TEXT
fired_at_iso	TEXT
fired_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV80.swift

V81 — discovery_game_narrative_steps

Generic Narrative Flow + Franklin's per-step think-out-loud review.

append-only· federation-cosigned· migration v81_narrative_flow_schema

Column	Type
step_id	TEXT
game_id	TEXT
step_index	INTEGER
stage	TEXT
title_atom	TEXT
body_atom	TEXT
prompt_atom	TEXT
supporting_citations_json	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV81.swift

V82 — discovery_narrative_bulk_sessions

Bulk narrative cycle (every game, one step at a time).

append-only· federation-cosigned· migration v82_narrative_bulk_schema

Column	Type
session_id	TEXT
started_at_iso	TEXT
completed_at_iso	TEXT
total_games	INTEGER
current_game_index	INTEGER
current_step_index	INTEGER
auto_advance_seconds	REAL
include_stub_games	INTEGER
games_visited	INTEGER
steps_visited	INTEGER
terminal_state	TEXT
triggered_by	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV82.swift

V83 — immersive_navigator_sessions

Immersive Game Navigator (Spider / Octopus / Owl).

append-only· federation-cosigned· migration v83_immersive_navigator_schema

Column	Type
session_id	TEXT
game_id	TEXT
started_at_iso	TEXT
completed_at_iso	TEXT
initial_view_mode	TEXT
current_view_mode	TEXT
spatial_audio_enabled	INTEGER
hand_tracking_enabled	INTEGER
mode_switches	INTEGER
node_visits	INTEGER
terminal_state	TEXT
triggered_by	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV83.swift

V84 — c4_field_explanations

Meaning Navigator: C⁴ ↔ S⁴ invariant mappings + constraints.

append-only· federation-cosigned· migration v84_meaning_navigator_schema

Column	Type
explanation_id	TEXT
game_id	TEXT
c4_layer	TEXT
field_id	TEXT
field_name	TEXT
field_value	TEXT
meaning_atom	TEXT
why_matters_atom	TEXT
example_atom	TEXT
maps_to_substrates_json	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV84.swift

V85 — witness_axis_definitions

8-axis first-person witness context navigator.

append-only· federation-cosigned· migration v85_witness_context_schema

Column	Type
axis_id	TEXT
axis_kind	TEXT
short_name	TEXT
spatial_metaphor	TEXT
motion_axis_label	TEXT
description_atom	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV85.swift

V86 — projection_focus_events

Substrate-truth on the RealityKit composition projection.

append-only· federation-cosigned· migration v86_projection_truth_schema

Column	Type
event_id	TEXT
composition_id	TEXT
canvas_node_id	TEXT
node_terminal_state	TEXT
primitive_kind	TEXT
focused_at_iso	TEXT
triggered_by	TEXT
focused_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV86.swift

V87 — workbench_drift_refusals

Cell seals UI drift REFUSED; ships auto-teaching narrator.

append-only· federation-cosigned· migration v87_ui_drift_refusal_schema

Column	Type
refusal_id	TEXT
drift_pattern	TEXT
evidence_text	TEXT
constitutional_test	TEXT
terminal_state	TEXT
cure_replacement	TEXT
sealed_at_iso	TEXT
sealed_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV87.swift

V88 — workbench_architectural_doctrine

Epistemic Doom Workbench doctrine + retirement of.

append-only· federation-cosigned· migration v88_epistemic_doom_schema

Column	Type
doctrine_id	TEXT
doctrine_title	TEXT
source	TEXT
doctrine_text	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV88.swift

V89 — franklin_install_locations

Permission domicile.

append-only· federation-cosigned· migration v89_permission_domicile_schema

Column	Type
location_id	TEXT
bundle_path	TEXT
codesign_identifier	TEXT
is_tcc_domicile	INTEGER
first_seen_iso	TEXT
first_seen_tau_block	INTEGER
last_seen_iso	TEXT
last_seen_tau_block	INTEGER
note	TEXT
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV89.swift

V90 — mathematical_conjectures

Mathematical Proof Rail (on-device) +.

append-only· federation-cosigned· migration v90_proof_rail_schema

Column	Type
conjecture_id	TEXT
title	TEXT
statement	TEXT
background	TEXT
known_approaches	TEXT
related_theorems	TEXT
difficulty_class	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV90.swift

V93 — workbench_ui_success_criteria

Successful Workbench UI definition, cinema mode.

append-only· federation-cosigned· migration v93_successful_ui_definition_schema

Column	Type
criterion_id	TEXT
criterion_kind	TEXT
definition_text	TEXT
failure_state	TEXT
success_state	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV93.swift

V94 — workbench_story_scenes

Per-story rendered visuals; AML inv(3) as the.

append-only· federation-cosigned· migration v94_per_story_scenes_schema

Column	Type
scene_id	TEXT
game_id	TEXT
scene_type	TEXT
authoring_state	TEXT
renderer	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
evidence_text	TEXT
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV94.swift

V95 — workbench_game_steering

Game-end completeness: GAMP 5 + clinical.

append-only· federation-cosigned· migration v95_game_end_completeness_schema

Column	Type
steering_id	TEXT
steering_kind	TEXT
from_game_id	TEXT
to_game_id	TEXT
operator_text	TEXT
issued_at_iso	TEXT
issued_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV95.swift

V96 — franklin_voice_state

Voice toggle, game validation lifecycle, PDF.

append-only· federation-cosigned· migration v96_voice_validation_dossier_schema

Column	Type
id	INTEGER
voice_enabled	INTEGER
last_toggled_iso	TEXT
last_toggled_tau_block	INTEGER
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV96.swift

V97 — cfr21_part11_audit

CFR 21 Part 11-controlled receipts + GAMP 5.

append-only· federation-cosigned· migration v97_cfr21_part11_gamp5_schema

Column	Type
audit_id	TEXT
dossier_id	TEXT
game_id	TEXT
record_kind	TEXT
record_sha256	TEXT
record_sequence_index	INTEGER
who	TEXT
what	TEXT
when_iso	TEXT
when_tau_block	INTEGER
why	TEXT
prior_record_sha256	TEXT
system_state_snapshot	TEXT
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV97.swift

V98 — franklin_narrator_mode

Non-stop random-domain walk + dossier as.

append-only· federation-cosigned· migration v98_nonstop_random_domain_schema

Column	Type
id	INTEGER
nonstop_mode_enabled	INTEGER
random_domain_walk_enabled	INTEGER
ignore_validation_gate	INTEGER
last_changed_iso	TEXT
last_changed_tau_block	INTEGER
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV98.swift

V99 — workbench_dossier_presentations

Surface the dossier. Per-domain backdrops.

append-only· federation-cosigned· migration v99_surface_dossier_backdrops_counter_schema

Column	Type
presentation_id	TEXT
dossier_id	TEXT
game_id	TEXT
file_path	TEXT
surfaced_kind	TEXT
held_seconds	REAL
surfaced_at_iso	TEXT
surfaced_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV99.swift

V102 — reflective_mesh_observations

The Workbench Made A Workbench.

append-only· federation-cosigned· migration v102_workbench_as_workbench_schema

Column	Type
observation_id	TEXT
agent_kind	TEXT
headline	TEXT
detail	TEXT
urgency	REAL
action_hint	TEXT
context_game_id	TEXT
observed_at_iso	TEXT
observed_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV102.swift

V103 — workbench_active_compositions

USD story-flow substrate: active compositions,.

append-only· federation-cosigned· migration v103_usd_story_flow_schema

Column	Type
composition_slot_id	TEXT
domain_slug	TEXT
usda_reference_path	TEXT
active	INTEGER
position_x	REAL
position_y	REAL
position_z	REAL
active_arc_index	INTEGER
pinned_at_iso	TEXT
pinned_at_tau_block	INTEGER
last_walked_at_iso	TEXT
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV103.swift

V104 — atom_vqbit_fields

vQbit Atom promotion: atoms become nodes, not strings.

append-only· federation-cosigned· migration v104_atom_vqbit_promotion_schema

Column	Type
atom_id	TEXT
c4_binding	TEXT
s4_projection_json	TEXT
entropy_delta	REAL
terminal_state_to_human	TEXT
provenance	TEXT
edge_count_observed	INTEGER
last_measured_at_iso	TEXT
last_measured_at_tau_block	INTEGER
first_authored_at_iso	TEXT
first_authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV104.swift

V105 — cure_game_judging_persons

Internal UI Listener (the self-testing human player).

append-only· federation-cosigned· migration v105_listener_schema

Column	Type
person_id	TEXT
game_id	TEXT
person_role	TEXT
display_name	TEXT
background	TEXT
language_register	TEXT
substrate_provenance	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV105.swift

V107 — game_authoring_jobs

Every cure becomes a language game.

append-only· federation-cosigned· migration v107_register_quantum_games

Column	Type
job_id	TEXT
game_id	TEXT
source_kind	TEXT
source_path	TEXT
started_at_iso	TEXT
completed_at_iso	TEXT
started_at_tau_block	INTEGER
arcs_authored	INTEGER
persons_authored	INTEGER
terminal_state	TEXT
reason	TEXT
fm_calls_total	INTEGER
fm_calls_failed	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV107.swift

V110 — listener_iteration_runs

Iterative Discovery Refinement Loop.

append-only· federation-cosigned· migration v110_iteration_substrate_schema

Column	Type
iteration_id	TEXT
game_id	TEXT
iteration_n	INTEGER
listener_session_id	TEXT
calorie_count	INTEGER
cure_count	INTEGER
refused_count	INTEGER
timeout_count	INTEGER
distinct_what_dark_count	INTEGER
improvement_over_prev	INTEGER
saturation_flag	INTEGER
selected_as_canonical	INTEGER
started_at_iso	TEXT
completed_at_iso	TEXT
started_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV110.swift

V112 — lean_proof_runs

Lion Math substrate.

append-only· federation-cosigned· migration v112_lion_math_substrate

Column	Type
run_id	TEXT
file_path	TEXT
sorry_count	INTEGER
axiom_count	INTEGER
opaque_count	INTEGER
currency_clean	INTEGER
falsifier_named	INTEGER
sha256	TEXT
lake_build_exit_code	INTEGER
terminal_state	TEXT
wiki_word	TEXT
observed_at_iso	TEXT
observed_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV112.swift

V113 — workbench_rcp_placements

Reality Composer Pro editor + composite.

append-only· federation-cosigned· migration v113_rcp_workbench_substrate

Column	Type
actor_binding_id	TEXT
tool_kind	TEXT
scene_name	TEXT
pos_x	REAL
pos_y	REAL
pos_z	REAL
substrate_query	TEXT
active	INTEGER
placed_at_iso	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV113.swift

V114 — lion_math_chains

M⁸ Frequency Sweep substrate (provenance side).

federation-cosigned· migration v114_m8_frequency_sweep_substrate

Column	Type
chain_id	TEXT
theorem_id	TEXT
ingested_at_iso	TEXT
chain_canonical	TEXT
chain_canonical_sha256	TEXT
bond_count	INTEGER
source_artifact_path	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV114.swift

V115 — lion_gate_agreement

Dual-Gate Agreement Log + Swift-Gate Trust View.

federation-cosigned· migration v115_dual_gate_agreement_log

Column	Type
agreement_id	TEXT
theorem_id	TEXT
artifact_path	TEXT
swift_verdict	TEXT
swift_forced_output	TEXT
swift_gap_diff	TEXT
lean_verdict	TEXT
lean_build_exit_code	INTEGER
lean_sorry_count	INTEGER
lean_axiom_count	INTEGER
lean_opaque_count	INTEGER
agree	INTEGER
is_public_artifact	INTEGER
swift_checker_version	TEXT
lean_toolchain_pinned	TEXT
checked_at_iso	TEXT
checked_at_tau_block	INTEGER
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV115.swift

V116 — lion_math_roar_templates

Dynamic autonomous Lion Math roar queue.

federation-cosigned· migration v116_lion_math_autonomous_queue

Column	Type
template_id	TEXT
name	TEXT
summary	TEXT
theorem_kind	TEXT
lean_artifact_path	TEXT
parameter_schema_json	TEXT
swift_int64_safe	INTEGER
decidable	INTEGER
status	TEXT
blocking_primitive	TEXT
registered_at_iso	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV116.swift

V117 — alert_domain_registry

GFTCL-WITNESS-ALERT-001.

append-only· federation-cosigned· migration v117_witness_alert_primitive

Column	Type
domain_id	TEXT
human_name	TEXT
watched_subjects_json	TEXT
first_registered_iso	TEXT
last_seen_iso	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV117.swift

V118 — energy_ledger_traces

GFTCL-LION-ENERGY-LEDGER-001.

NATS: gaiaftcl.energy.ledger.input· append-only· federation-cosigned· migration v118_energy_ledger_breaker

Column	Type
trace_id	TEXT
ingested_at_iso	TEXT
ingested_at_tau_block	INTEGER
source	TEXT
s4_in_quanta	INTEGER
sc_in_quanta	INTEGER
nats_subject_in	TEXT
payload_sha256	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV118.swift

V119 — summit_states

GFTCL-LION-ENERGY-LEDGER-001 UI substrate.

append-only· federation-cosigned· migration v119_energy_ui_substrate

Column	Type
summit_id	TEXT
human_name	TEXT
domain	TEXT
ring	INTEGER
status	TEXT
depends_on_summit_id	TEXT
effect_summary	TEXT
predicted_values_json	TEXT
success_criterion	TEXT
null_result_clause	TEXT
required_controls_json	TEXT
preregistered_at_iso	TEXT
registered_in_artifact	TEXT
created_at_iso	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV119.swift

V120 — benchtop_sessions

GFTCL-LION-ENERGY-LEDGER-001 / Benchtop tool.

append-only· federation-cosigned· migration v120_benchtop_sessions

Column	Type
session_id	TEXT
summit_id	TEXT
lab_identity	TEXT
apparatus_id	TEXT
apparatus_calibration_json	TEXT
measured_values_json	TEXT
preregistration_sha256	TEXT
preregistration_at_iso	TEXT
status	TEXT
started_at_iso	TEXT
last_updated_at_iso	TEXT
submitted_submission_id	TEXT
session_hash	TEXT
notes	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV120.swift

V121 — domain_meaning_audits

GFTCL-LION-MEANING-AUDIT-001.

append-only· federation-cosigned· migration v121_domain_meaning_audits

Column	Type
audit_id	TEXT
domain_id	TEXT
human_name	TEXT
audit_at_iso	TEXT
goal_statement	TEXT
ui_affordance_paths	TEXT
verdict	TEXT
missing_pieces_json	TEXT
remediation_summit_ids	TEXT
auditor	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV121.swift

V122 — meaning_trajectories

GFTCL-LION-LVC-001.

NATS: gaiaftcl.lvc.receipt.sealed· append-only· federation-cosigned· migration v122_lvc_substrate

Column	Type
trajectory_id	TEXT
domain_id	TEXT
quantizer_id	TEXT
source_text_sha256	TEXT
trajectory_json	TEXT
length	INTEGER
human_label	TEXT
recorded_at_iso	TEXT
recorded_by	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV122.swift

V123 — materials_specs

GFTCL-LION-MATERIALS-001.

append-only· federation-cosigned· migration v123_materials_domain_surface

Column	Type
spec_id	TEXT
human_name	TEXT
material_kind	TEXT
i_num	INTEGER
i_den	INTEGER
length_mm	INTEGER
human_description	TEXT
source_lean_file	TEXT
created_at_iso	TEXT
created_by	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV123.swift

V124 — patient_cases

GFTCL-LION-MEDICAL-001.

append-only· federation-cosigned· migration v124_medical_domain_surface

Column	Type
case_id	TEXT
human_label	TEXT
dose_mg	INTEGER
t_half_hours	INTEGER
safety_threshold_pct	INTEGER
drug_kind	TEXT
human_description	TEXT
source_lean_file	TEXT
created_at_iso	TEXT
created_by	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV124.swift

V125 — pq_implementations

GFTCL-LION-SECURITY-001.

append-only· federation-cosigned· migration v125_security_domain_surface

Column	Type
impl_id	TEXT
human_label	TEXT
algorithm	TEXT
vendor	TEXT
version_pin	TEXT
kat_file_sha256	TEXT
constant_time_claim	INTEGER
created_at_iso	TEXT
created_by	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV125.swift

V126 — drug_trials

GFTCL-LION-DRUG-001.

append-only· federation-cosigned· migration v126_drug_discovery_surface

Column	Type
trial_id	TEXT
compound_id	TEXT
compound_name	TEXT
indication	TEXT
primary_endpoint	TEXT
threshold_per_mille	INTEGER
arm_treatment_n	INTEGER
arm_placebo_n	INTEGER
sponsor	TEXT
preregistered_at_iso	TEXT
preregistration_sha256	TEXT
source_lean_file	TEXT
created_at_iso	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV126.swift

V128 — climate_food_chains

GFTCL-LION-CLIMATE-FOOD-001.

NATS: gaiaftcl.climate_food.chain.sealed· append-only· federation-cosigned· migration v128_climate_food_surface

Column	Type
chain_id	TEXT
human_label	TEXT
producer	TEXT
commodity	TEXT
initial_payload_nat	INTEGER
actor_1	INTEGER
actor_2	INTEGER
actor_3	INTEGER
announced_final_nat	INTEGER
registered_at_iso	TEXT
registration_sha256	TEXT
source_lean_file	TEXT
created_at_iso	TEXT
snapshot_hash	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV128.swift

V131 — federation_emissions

GFTCL-LION-FEDERATION-EMISSION-001.

federation-cosigned· migration v131_federation_emissions_queue

Column	Type
emission_id	TEXT
domain_id	TEXT
source_table	TEXT
source_row_id	TEXT
nats_subject	TEXT
witness_canonical	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
lean_artifact_path	TEXT
emitted_at_iso	TEXT
ack_received_at_iso	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV131.swift

V135 — lvc_receipts

GFTCL-LION-LVC-003 substrate.

NATS: gaiaftcl.lvc.collapse.sealed· append-only· federation-cosigned· migration v135_lvc_v3_substrate

Column	Type
receipt_id	TEXT
operative_json	TEXT
enacted_json	TEXT
gtwed_num	INTEGER
gtwed_den	INTEGER
epsilon	INTEGER
verdict	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT
nats_broadcast_at_iso	TEXT
sealed_at_iso	TEXT
sealed_by	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV135.swift

V137 — flourishing_floor

GFTCL-LION-LVC-008.

NATS: gaiaftcl.lvc.constitutional.sealed· append-only· federation-cosigned· migration v137_lvc_constitutional_floor

Column	Type
id	INTEGER
c1_trust	INTEGER
c2_identity	INTEGER
c3_closure	INTEGER
c4_consequence	INTEGER
floor_canonical	TEXT
floor_canonical_sha256	TEXT
source_lean_artifact	TEXT
sealed_at_iso	TEXT
sealed_at_tau_block	INTEGER
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV137.swift

V138 — ui_language_game_drift_receipts

GFTCL-LION-LVC-009 — recursive LVC on the cell's own UI.

NATS: gaiaftcl.lvc.ui_language_game.sealed· append-only· federation-cosigned· migration v138_ui_language_game_drift

Column	Type
receipt_id	TEXT
surface_id	TEXT
operative_canonical	TEXT
operative_sha256	TEXT
enacted_canonical	TEXT
enacted_sha256	TEXT
element_count	INTEGER
total_drift	INTEGER
hottest_element_index	INTEGER
hottest_element_drift	INTEGER
hottest_element_id	TEXT
drift_map_json	TEXT
tolerance_epsilon	INTEGER
verdict	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT
nats_broadcast_at_iso	TEXT
sweeper_kernel_sha	TEXT
sealed_at_iso	TEXT
sealed_by	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV138.swift

V139 — striving_proposals

GFTCL-LION-LVC-010.

append-only· federation-cosigned· migration v139_perpetual_striving

Column	Type
proposal_id	TEXT
surface_id	TEXT
element_id	TEXT
action_kind	TEXT
action_description	TEXT
drift_now	INTEGER
expected_drift_after	INTEGER
expected_delta	INTEGER
status	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
first_seen_at_iso	TEXT
last_seen_at_iso	TEXT
status_changed_at_iso	TEXT
proposer_kernel_sha	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV139.swift

V140 — striving_authorization_policy

GFTCL-LION-LVC-011.

append-only· federation-cosigned· migration v140_supervised_closing

Column	Type
policy_id	TEXT
policy_iso	TEXT
authorized_kinds_csv	TEXT
max_closures_per_tick	INTEGER
issued_by	TEXT
reason	TEXT
policy_canonical	TEXT
policy_hash_sha256	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV140.swift

V141 — striving_proposals

GFTCL-LION-LVC-012.

append-only· federation-cosigned· migration v141_localization_axis

Column	Type
proposal_id	TEXT
surface_id	TEXT
element_id	TEXT
action_kind	TEXT
action_description	TEXT
drift_now	INTEGER
expected_drift_after	INTEGER
expected_delta	INTEGER
status	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
first_seen_at_iso	TEXT
last_seen_at_iso	TEXT
status_changed_at_iso	TEXT
proposer_kernel_sha	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV141.swift

V142 — origin_geometry_profiles

GFTCL-LION-FRANKLIN-001.

NATS: gaiaftcl.franklin.telling.sealed· append-only· federation-cosigned· migration v142_franklin_storyteller

Column	Type
geometry_id	TEXT
human_name	TEXT
prior_knowledge_frame	TEXT
meaning_in_use_vocab	TEXT
decision_to_act	TEXT
voice_register_id	TEXT
expected_meaning_json	TEXT
canonical	TEXT
canonical_sha256	TEXT
authored_at_iso	TEXT
authored_at_tau_block	INTEGER
signature_quintet	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV142.swift

V143 — chat_turns

GFTCL-LION-FRANKLIN-001 (chat).

NATS: gaiaftcl.franklin.chat.turn.sealed· append-only· federation-cosigned· migration v143_franklin_chat

Column	Type
turn_id	TEXT
session_id	TEXT
turn_index	INTEGER
instruction_text	TEXT
operative_canonical	TEXT
enacted_canonical	TEXT
geometry_id	TEXT
discovery_id	TEXT
modality	TEXT
c1_trust	INTEGER
c2_identity	INTEGER
c3_closure	INTEGER
c4_consequence	INTEGER
axis_fidelity	INTEGER
axis_transfer	INTEGER
axis_completeness	INTEGER
axis_frontier_honest	INTEGER
verdict	TEXT
refuse_axis	TEXT
redraft_count	INTEGER
model_confidence	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT
nats_broadcast_at_iso	TEXT
gate_kernel_sha	TEXT
sealed_at_iso	TEXT
sealed_by	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV143.swift

V144 — franklin_closure_registry

GFTCL-LION-FRANKLIN-001 (auto-mode).

append-only· federation-cosigned· migration v144_franklin_automode

Column	Type
closure_id	TEXT
subject_id	TEXT
subject_kind	TEXT
tier	TEXT
closed_canonical	TEXT
closed_hash_sha256	TEXT
asserted_by	TEXT
first_asserted_iso	TEXT
promoted_to_witnessed_iso	TEXT
promoted_by	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV144.swift

V147 — striving_proposals

GFTCL-LION-LVC (always-make-better-UI).

federation-cosigned· migration v147_teach_in_context_axis

Column	Type
proposal_id	TEXT
surface_id	TEXT
element_id	TEXT
action_kind	TEXT
action_description	TEXT
drift_now	INTEGER
expected_drift_after	INTEGER
expected_delta	INTEGER
status	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
first_seen_at_iso	TEXT
last_seen_at_iso	TEXT
status_changed_at_iso	TEXT
proposer_kernel_sha	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV147.swift

V150 — lvc_score_memory

GFTCL-LION-LVC (the constant LVC-scoring loop's memory).

migration v150_lvc_score_memory

Column	Type
mem_id	TEXT
game_id	TEXT
geometry_id	TEXT
best_blend	INTEGER
best_min_margin	INTEGER
fidelity	INTEGER
transfer	INTEGER
completeness	INTEGER
frontier_honest	INTEGER
verdict	TEXT
attempts	INTEGER
improved_last	INTEGER
last_improved_iso	TEXT
last_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV150.swift

V152 — qc020_difficulty_ledger

QC-020 BTC Preimage (large): difficulty ledger.

append-only· migration v152_qc020_btc_difficulty_ledger

Column	Type
rung_id	INTEGER
header_hex	TEXT
target_decimal	TEXT
digest_decimal	TEXT
digest_hex	TEXT
nonce	INTEGER
kind	TEXT
note	TEXT
captured_at_iso	TEXT
captured_at_tau	INTEGER
witness_signature	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV152.swift

V154 — qc020_miner_heartbeats

QC-020 BTC Substrate Miner: heartbeats, capture.

append-only· migration v154_qc020_miner_runtime_tables

Column	Type
session_id	TEXT
pid	INTEGER
started_at_iso	TEXT
last_heartbeat_iso	TEXT
wallet_address	TEXT
node_url	TEXT
current_height	INTEGER
current_target_hex	TEXT
gate_invocations	INTEGER
candidates_emitted	INTEGER
blocks_found	INTEGER
last_error	TEXT
timestamp_iso	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV154.swift

V160 — qc020_substrate_research_telemetry

QC-020 substrate research telemetry.

NATS: gaiaftcl.qc020.research.sealed· append-only· federation-cosigned· migration v160_qc020_substrate_research_telemetry

Column	Type
row_id	INTEGER
sealed_at_iso	TEXT
daemon_session_id	TEXT
window_id	TEXT
tick_within_window	INTEGER
substrate_iteration_count	INTEGER
theta_zero_num	INTEGER
theta_zero_den	INTEGER
theta_current_num	INTEGER
theta_current_den	INTEGER
marker_density_num	INTEGER
marker_density_den	INTEGER
theta_zero_bits	TEXT
theta_current_bits	TEXT
room_shrinkage_bits	TEXT
state_hash_before	TEXT
state_hash_after	TEXT
gtwed_to_prior_num	INTEGER
gtwed_to_prior_den	INTEGER
aggregate_c4_truth_num	INTEGER
aggregate_c4_truth_den	INTEGER
dominant_region_bucket	INTEGER
region_co_closure_json	TEXT
klein_topology_signature	TEXT
conservation_residual_num	INTEGER
conservation_residual_den	INTEGER
constitutional_floor_state	TEXT
meaning_binding_hash	TEXT
measurement_terminal	TEXT
measurement_basis_hex	TEXT
measurement_wall_clock_ns	INTEGER
header_prefix_hex	TEXT
network_target_hex	TEXT
block_height	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV160.swift

V161 — qc020_window_summaries

QC-020 substrate window summaries.

NATS: gaiaftcl.qc020.window.summary.sealed· append-only· federation-cosigned· migration v161_qc020_window_summaries

Column	Type
row_id	INTEGER
window_id	TEXT
daemon_session_id	TEXT
opened_at_iso	TEXT
closed_at_iso	TEXT
closure_reason	TEXT
total_ticks	INTEGER
total_substrate_iterations	INTEGER
mean_measurement_wall_clock_ns	INTEGER
gtwed_curve_json	TEXT
theta_trajectory_json	TEXT
aggregate_c4_truth_initial_num	INTEGER
aggregate_c4_truth_initial_den	INTEGER
aggregate_c4_truth_final_num	INTEGER
aggregate_c4_truth_final_den	INTEGER
dominant_region_distribution	TEXT
final_terminal	TEXT
lvc_nonce_hex	TEXT
header_prefix_hex	TEXT
network_target_hex	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV161.swift

V162 — qc020_franklin_observations

Franklin's observations on the substrate's.

NATS: gaiaftcl.qc020.franklin.observation.sealed· append-only· federation-cosigned· migration v162_qc020_franklin_observations

Column	Type
row_id	INTEGER
observation_id	TEXT
window_id	TEXT
observed_at_iso	TEXT
classification	TEXT
gtwed_trend_num	INTEGER
gtwed_trend_den	INTEGER
theta_growth_rate_num	INTEGER
theta_growth_rate_den	INTEGER
aggregate_c4_truth_delta_num	INTEGER
aggregate_c4_truth_delta_den	INTEGER
dominant_region_entropy_num	INTEGER
dominant_region_entropy_den	INTEGER
observation_summary	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV162.swift

V163 — qc020_franklin_commissions

Franklin's commission table.

NATS: gaiaftcl.qc020.franklin.commission.sealed· append-only· federation-cosigned· migration v163_qc020_franklin_commissions

Column	Type
row_id	INTEGER
commission_id	TEXT
proposed_at_iso	TEXT
franklin_observation_evidence_json	TEXT
tunable_name	TEXT
rationale	TEXT
substrate_spec_json	TEXT
bounded_range_json	TEXT
priority_score_num	INTEGER
priority_score_den	INTEGER
status	TEXT
operator_decision_at_iso	TEXT
operator_decision_by	TEXT
agent_completion_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV163.swift

V164 — qc020_franklin_commission_history

Franklin's commission state-transition.

NATS: gaiaftcl.qc020.franklin.commission.history.sealed· append-only· federation-cosigned· migration v164_qc020_franklin_commission_history

Column	Type
row_id	INTEGER
commission_id	TEXT
transitioned_at_iso	TEXT
from_status	TEXT
to_status	TEXT
decision_metadata_json	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV164.swift

V165 — qc020_franklin_commissions

extend qc020_franklin_commissions CHECK.

NATS: gaiaftcl.qc020.franklin.commission.sealed· append-only· federation-cosigned· migration v165_qc020_franklin_commissions_add_sample_budget

Column	Type
row_id	INTEGER
commission_id	TEXT
proposed_at_iso	TEXT
franklin_observation_evidence_json	TEXT
tunable_name	TEXT
rationale	TEXT
substrate_spec_json	TEXT
bounded_range_json	TEXT
priority_score_num	INTEGER
priority_score_den	INTEGER
status	TEXT
operator_decision_at_iso	TEXT
operator_decision_by	TEXT
agent_completion_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV165.swift

V168 — qc020_franklin_tuning_history

Franklin's adaptive-tuner history.

NATS: gaiaftcl.qc020.franklin.tuning.sealed· append-only· federation-cosigned· migration v168_qc020_franklin_tuning_history

Column	Type
row_id	INTEGER
tuning_id	TEXT
adjusted_at_iso	TEXT
tunable_name	TEXT
prior_value_json	TEXT
new_value_json	TEXT
rationale	TEXT
observation_evidence_json	TEXT
expected_metric_effect_json	TEXT
accepted_or_rolled_back	TEXT
post_adjustment_metric_json	TEXT
accept_or_rollback_at_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV168.swift

V170 — franklin_window_filtering

Franklin's between-collapse filtering.

NATS: gaiaftcl.qc020.franklin.window_filtering.sealed· append-only· federation-cosigned· migration v170_franklin_window_filtering

Column	Type
row_id	INTEGER
filtering_id	TEXT
applied_at_iso	TEXT
prior_window_id	TEXT
next_window_fingerprint	TEXT
beta_num	INTEGER
beta_den	INTEGER
prior_final_top_cell	TEXT
prior_final_state_hash	TEXT
next_initial_state_hash	TEXT
next_initial_cells_canonical	TEXT
projection_active_cells	INTEGER
substrate_capacity_cells	INTEGER
rationale	TEXT
accepted_or_rolled_back	TEXT
post_filtering_metric_json	TEXT
accept_or_rollback_at_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV170.swift

V172 — qc020_substrate_session_replay_anchors

substrate session replay anchors.

NATS: gaiaftcl.qc020.substrate.replay_anchor.sealed· append-only· federation-cosigned· migration v172_qc020_substrate_session_replay_anchors

Column	Type
row_id	INTEGER
anchor_id	TEXT
anchor_at_iso	TEXT
daemon_session_id	TEXT
window_id	TEXT
measurement_index_within_session	INTEGER
m8_measurement_state_canonical	TEXT
projection_cells_canonical	TEXT
meaning_binding_hash	TEXT
gtwed_window_state_canonical	TEXT
klein_chart_observations_canonical	TEXT
prior_anchor_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV172.swift

V173 — qc020_franklin_commissions

extend franklin commission tunable_name.

NATS: gaiaftcl.qc020.franklin.commission.sealed· append-only· federation-cosigned· migration v173_qc020_commissions_admit_beta_tunable

Column	Type
row_id	INTEGER
commission_id	TEXT
proposed_at_iso	TEXT
franklin_observation_evidence_json	TEXT
tunable_name	TEXT
rationale	TEXT
substrate_spec_json	TEXT
bounded_range_json	TEXT
priority_score_num	INTEGER
priority_score_den	INTEGER
status	TEXT
operator_decision_at_iso	TEXT
operator_decision_by	TEXT
agent_completion_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV173.swift

V174 — substrate_constitutional_evaluations

substrate_constitutional_evaluations.

NATS: gaiaftcl.substrate.constitutional_evaluation.sealed· append-only· federation-cosigned· migration v174_substrate_constitutional_evaluations

Column	Type
row_id	INTEGER
evaluation_id	TEXT
evaluated_at_iso	TEXT
daemon_session_id	TEXT
algorithm_id	TEXT
window_id	TEXT
measurement_index_within_window	INTEGER
c007_intended_use	TEXT
c007_predicate_result	INTEGER
c008_environmental_score_num	INTEGER
c008_environmental_score_den	INTEGER
c008_threshold_num	INTEGER
c008_threshold_den	INTEGER
c008_predicate_result	INTEGER
c009_license_id	TEXT
c009_license_present	INTEGER
c009_license_valid	INTEGER
c009_predicate_result	INTEGER
c010_substrate_stress_num	INTEGER
c010_substrate_stress_den	INTEGER
c010_predicate_result	INTEGER
aggregate_result	INTEGER
refusal_reason	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV174.swift

V175 — qc020_anchor_confidence_derivative

anchor confidence-derivative companion.

NATS: gaiaftcl.qc020.substrate.anchor_derivative.sealed· append-only· federation-cosigned· migration v175_qc020_anchor_confidence_derivative

Column	Type
row_id	INTEGER
anchor_id	TEXT
computed_at_iso	TEXT
confidence_derivative_canonical	TEXT
derivative_num	INTEGER
derivative_den	INTEGER
samples_used_for_derivative	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV175.swift

V177 — substrate_per_algorithm_allocation_audit

per-algorithm allocation audit.

NATS: gaiaftcl.substrate.per_algorithm_allocation_audit.sealed· append-only· federation-cosigned· migration v177_substrate_per_algorithm_allocation_audit

Column	Type
row_id	INTEGER
audit_id	TEXT
audited_at_iso	TEXT
daemon_session_id	TEXT
algorithm_id	TEXT
projection_active_allocation	INTEGER
substrate_capacity_cells	INTEGER
resolution_source	TEXT
resolution_path_json	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV177.swift

V178 — qc020_joint_variation_evidence

substrate joint variation evidence.

NATS: gaiaftcl.qc020.substrate.joint_variation_evidence.sealed· append-only· federation-cosigned· migration v178_qc020_joint_variation_evidence

Column	Type
row_id	INTEGER
evidence_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
window_id	TEXT
measurement_index_within_window	INTEGER
cursor_nonce	INTEGER
cursor_extranonce	INTEGER
cursor_ntime	INTEGER
cursor_mempool_inclusion_mask	INTEGER
bias_strength_num	INTEGER
bias_strength_den	INTEGER
header_canonical	TEXT
digest_hex	TEXT
leading_zero_nibble_count	INTEGER
projection_concentration_top_cell	TEXT
target_inequality_satisfied	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV178.swift

V180 — qc020_franklin_commissions

extend qc020_franklin_commissions.

NATS: gaiaftcl.qc020.franklin.commission.sealed· append-only· federation-cosigned· migration v180_commissions_admit_joint_variation_bias

Column	Type
row_id	INTEGER
commission_id	TEXT
proposed_at_iso	TEXT
franklin_observation_evidence_json	TEXT
tunable_name	TEXT
rationale	TEXT
substrate_spec_json	TEXT
bounded_range_json	TEXT
priority_score_num	INTEGER
priority_score_den	INTEGER
status	TEXT
operator_decision_at_iso	TEXT
operator_decision_by	TEXT
agent_completion_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV180.swift

V181 — qc_algorithm_evaluation_history

qc_algorithm_evaluation_history.

NATS: gaiaftcl.substrate.algorithm_evaluation.sealed· append-only· federation-cosigned· migration v181_qc_algorithm_evaluation_history

Column	Type
row_id	INTEGER
evaluation_id	TEXT
evaluation_at_iso	TEXT
daemon_session_id	TEXT
algorithm_id	TEXT
pre_refactor_witness_hash	TEXT
post_refactor_witness_hash	TEXT
bit_exact_equivalence_verified	INTEGER
measurement_receipt_canonical	TEXT
detected_deviations_json	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV181.swift

V182 — substrate_health_observations

substrate_health_observations.

NATS: gaiaftcl.substrate.health_observation.sealed· append-only· federation-cosigned· migration v182_substrate_health_observations

Column	Type
row_id	INTEGER
observation_id	TEXT
observed_at_iso	TEXT
daemon_session_id	TEXT
measurement_composition_healthy	INTEGER
invariant_preservation_healthy	INTEGER
anchor_accumulation_healthy	INTEGER
algorithm_evaluation_healthy	INTEGER
federation_cosignature_healthy	INTEGER
nats_broadcast_healthy	INTEGER
resource_consumption_healthy	INTEGER
bitcoin_rpc_healthy	INTEGER
detected_deviations_json	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV182.swift

V183 — substrate_healing_actions

substrate_healing_actions.

NATS: gaiaftcl.substrate.healing_action.sealed· append-only· federation-cosigned· migration v183_substrate_healing_actions

Column	Type
row_id	INTEGER
healing_id	TEXT
applied_at_iso	TEXT
daemon_session_id	TEXT
triggering_observation_id	TEXT
healing_action_type	TEXT
authority_path	TEXT
action_parameters_json	TEXT
outcome	TEXT
outcome_at_iso	TEXT
post_healing_health_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV183.swift

V184 — franklin_heartbeat_history

franklin_heartbeat_history.

NATS: gaiaftcl.substrate.franklin_heartbeat.sealed· append-only· federation-cosigned· migration v184_franklin_heartbeat_history

Column	Type
row_id	INTEGER
heartbeat_id	TEXT
tick_at_iso	TEXT
daemon_session_id	TEXT
tick_cadence_seconds	INTEGER
observations_count	INTEGER
classifications_count	INTEGER
commission_proposals_count	INTEGER
tuning_adjustments_applied	INTEGER
tuning_adjustments_held	INTEGER
filtering_decisions_applied	INTEGER
game_evaluations_run	INTEGER
healing_escalations_processed	INTEGER
invariant_set_evolution_actions	INTEGER
substrate_state_summary_json	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV184.swift

V185 — substrate_healing_actions_sovereign

sovereign substrate authority migration.

NATS: gaiaftcl.substrate.healing_action.sealed· append-only· federation-cosigned· migration v185_sovereign_substrate_authority

Column	Type
row_id	INTEGER
healing_id	TEXT
applied_at_iso	TEXT
daemon_session_id	TEXT
triggering_observation_id	TEXT
healing_action_type	TEXT
authority_path	TEXT
action_parameters_json	TEXT
outcome	TEXT
outcome_at_iso	TEXT
post_healing_health_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV185.swift

V186 — qc020_franklin_commissions

substrate-development vocabulary.

NATS: gaiaftcl.substrate.healing_action.sealed· append-only· federation-cosigned· migration v186_substrate_development_vocabulary

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV186.swift

V187 — substrate_post_quantum_signatures

post-quantum signature provenance.

NATS: gaiaftcl.substrate.post_quantum_signature.sealed· append-only· federation-cosigned· migration v187_substrate_post_quantum_signatures

Column	Type
row_id	INTEGER
pq_signature_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_witness_hash	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
pq_signature_hex	TEXT
pq_signature_byte_length	INTEGER
nist_security_category	INTEGER
federation_quintet_position	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV187.swift

V188 — substrate_shor_demonstration_history

substrate Shor demonstration history.

NATS: gaiaftcl.substrate.shor_demonstration.sealed· append-only· federation-cosigned· migration v188_substrate_shor_demonstration_history

Column	Type
row_id	INTEGER
demonstration_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
wallet_label	TEXT
secp256k1_public_key_hex	TEXT
operator_confirmation_witness	TEXT
substrate_measurement_count	INTEGER
substrate_cadence_seconds	REAL
shor_period_canonical	TEXT
recovered_private_key_hex	TEXT
verification_match	INTEGER
demonstration_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV188.swift

V189 — substrate_pq_wallet_migration_history

substrate PQ wallet migration history.

NATS: gaiaftcl.substrate.pq_wallet_migration.sealed· append-only· federation-cosigned· migration v189_substrate_pq_wallet_migration_history

Column	Type
row_id	INTEGER
migration_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
secp256k1_wallet_label	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
p2pqh_address	TEXT
associated_v187_signature_id	TEXT
associated_v188_demonstration_id	TEXT
one_gate_closure_witness_hash	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV189.swift

V190 — substrate_shor_pq_safety_demonstration_history

substrate Shor PQ-safety demonstration.

NATS: gaiaftcl.substrate.shor_pq_safety_demonstration.sealed· append-only· federation-cosigned· migration v190_substrate_shor_pq_safety_demonstration_history

Column	Type
row_id	INTEGER
safety_demonstration_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_v189_migration_id	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
substrate_measurement_count	INTEGER
substrate_measurement_budget	INTEGER
substrate_cadence_seconds	REAL
period_structure_detected	INTEGER
substrate_mathematical_rationale	TEXT
demonstration_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV190.swift

V193 — substrate_pq_ownership_verification_history

substrate PQ ownership verification.

NATS: gaiaftcl.substrate.pq_ownership_verification.sealed· append-only· federation-cosigned· migration v193_substrate_pq_ownership_verification_history

Column	Type
row_id	INTEGER
verification_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_v189_migration_id	TEXT
challenge_canonical	TEXT
challenge_witness_hash	TEXT
source_secp256k1_public_key_hex	TEXT
source_secp256k1_signature_hex	TEXT
source_secp256k1_verification	INTEGER
destination_pq_public_key_hex	TEXT
destination_pq_signature_hex	TEXT
destination_pq_signature_byte_length	INTEGER
destination_pq_verification	INTEGER
destination_pq_scheme_identifier	TEXT
verification_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV193.swift

V194 — substrate_pq_migration_demonstration

substrate PQ migration demonstration.

NATS: gaiaftcl.substrate.pq_migration_demonstration.sealed· append-only· federation-cosigned· migration v194_substrate_pq_migration_demonstration

Column	Type
row_id	INTEGER
demonstration_receipt_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
operator_identifier	TEXT
wallet_label	TEXT
associated_v188_demonstration_id	TEXT
associated_v189_migration_id	TEXT
associated_v190_safety_id	TEXT
associated_v193_verification_id	TEXT
source_secp256k1_public_key_hex	TEXT
destination_p2pqh_address	TEXT
pq_scheme_identifier	TEXT
demonstration_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV194.swift

V195 — substrate_qfot_ledger

substrate QFOT ledger.

NATS: gaiaftcl.substrate.qfot_ledger.sealed· append-only· federation-cosigned· migration v195_substrate_qfot_ledger

Column	Type
row_id	INTEGER
ledger_entry_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
operator_cell_id	TEXT
entry_type	TEXT
amount_canonical	TEXT
balance_after_canonical	TEXT
associated_substrate_development_id	TEXT
associated_payment_reference	TEXT
associated_mesh_dispatch_id	TEXT
rationale	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV195.swift

V196 — substrate_cell_sprout_history

substrate cell sprout history.

NATS: gaiaftcl.substrate.cell_sprout.sealed· append-only· federation-cosigned· migration v196_substrate_cell_sprout_history

Column	Type
row_id	INTEGER
sprout_id	TEXT
sprouted_at_iso	TEXT
cell_id	TEXT
operator_machine_identifier_hash	TEXT
federation_context_public_key_hex	TEXT
sprout_tau_block	INTEGER
sprout_fingerprint	TEXT
trial_qfot_grant_canonical	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV196.swift

V197 — substrate_cell_mooring_history

substrate cell mooring history.

NATS: gaiaftcl.substrate.cell_mooring.sealed· append-only· federation-cosigned· migration v197_substrate_cell_mooring_history

Column	Type
row_id	INTEGER
mooring_id	TEXT
moored_at_iso	TEXT
cell_id	TEXT
associated_v196_sprout_id	TEXT
federation_mesh_endpoint	TEXT
federation_acceptance_quintet	TEXT
mooring_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV197.swift

V198 — substrate_subscription_payment_history

substrate subscription payment history.

NATS: gaiaftcl.substrate.subscription_payment.sealed· append-only· federation-cosigned· migration v198_substrate_subscription_payment_history

Column	Type
row_id	INTEGER
payment_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
cell_id	TEXT
operator_payment_reference	TEXT
payment_amount_eur_canonical	TEXT
qfot_credit_amount_canonical	TEXT
operator_email_at_iso	TEXT
rick_verification_at_iso	TEXT
payment_verification_status	TEXT
mesh_dispatch_at_iso	TEXT
associated_mesh_dispatch_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV198.swift

V199 — substrate_qfot_mesh_dispatch_history

substrate QFOT mesh dispatch history.

NATS: gaiaftcl.substrate.qfot_mesh_dispatch.sealed· append-only· federation-cosigned· migration v199_substrate_qfot_mesh_dispatch_history

Column	Type
row_id	INTEGER
dispatch_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
issuer_cell_id	TEXT
recipient_cell_id	TEXT
associated_v198_payment_id	TEXT
qfot_amount_canonical	TEXT
rationale	TEXT
nats_dispatched_at_iso	TEXT
recipient_acknowledged_at_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV199.swift

V200 — substrate_franklin_wound_ledger

substrate Franklin wound ledger.

NATS: gaiaftcl.substrate.franklin_wound.sealed· append-only· federation-cosigned· migration v200_substrate_franklin_wound_ledger

Column	Type
row_id	INTEGER
wound_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_window_id	TEXT
gate_invocations_in_window	INTEGER
terminal_distribution_canonical	TEXT
wound_severity_canonical	TEXT
cumulative_wound_debt_canonical	TEXT
franklin_response_action	TEXT
associated_v168_tuning_id	TEXT
associated_v183_healing_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV200.swift

V201 — substrate_franklin_reward_gradient

substrate Franklin reward gradient.

NATS: gaiaftcl.substrate.franklin_reward_gradient.sealed· append-only· federation-cosigned· migration v201_substrate_franklin_reward_gradient

Column	Type
row_id	INTEGER
gradient_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
direction_canonical	TEXT
cumulative_leading_zero_canonical	TEXT
measurement_count_in_direction	INTEGER
constitutional_pass_rate_canonical	TEXT
l1_conservation_canonical	TEXT
reward_gradient_canonical	TEXT
franklin_selected	INTEGER
associated_v200_wound_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV201.swift

V202 — substrate_block_submission_outcomes

substrate block submission outcomes.

NATS: gaiaftcl.substrate.block_submission_outcome.sealed· append-only· federation-cosigned· migration v202_substrate_block_submission_outcomes

Column	Type
row_id	INTEGER
submission_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_v178_evidence_id	TEXT
block_hash	TEXT
block_height	INTEGER
submission_terminal	TEXT
rpc_response_canonical	TEXT
payout_address	TEXT
payout_satoshis	INTEGER
franklin_wound_debt_pre_canonical	TEXT
franklin_wound_debt_post_canonical	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV202.swift

V203 — substrate_franklin_strategic_shift

substrate Franklin strategic shift.

NATS: gaiaftcl.substrate.franklin_strategic_shift.sealed· append-only· federation-cosigned· migration v203_substrate_franklin_strategic_shift

Column	Type
row_id	INTEGER
shift_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_v200_wound_id	TEXT
saturation_signal_canonical	TEXT
shift_response_letter	TEXT
shift_target_canonical	TEXT
expected_exploration_gain_canonical	TEXT
pre_shift_lz_mean_canonical	TEXT
post_shift_lz_mean_canonical	TEXT
shift_validation_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV203.swift

V204 — substrate_franklin_wound_ledger

extends V200 substrate_franklin_wound_ledger.

NATS: gaiaftcl.substrate.franklin_wound.sealed· append-only· federation-cosigned· migration v204_substrate_franklin_wound_ledger_extended_check

Column	Type
row_id	INTEGER
wound_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
associated_window_id	TEXT
gate_invocations_in_window	INTEGER
terminal_distribution_canonical	TEXT
wound_severity_canonical	TEXT
cumulative_wound_debt_canonical	TEXT
franklin_response_action	TEXT
associated_v168_tuning_id	TEXT
associated_v183_healing_id	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV204.swift

V208 — substrate_franklin_comms_projection

substrate Franklin comms projection.

NATS: gaiaftcl.substrate.franklin_comms_projection.sealed· append-only· federation-cosigned· migration v208_substrate_franklin_comms_projection

Column	Type
row_id	INTEGER
projection_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
projection_direction	TEXT
projection_canonical	TEXT
associated_franklin_response	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV208.swift

V209 — substrate_franklin_local_wallet

substrate Franklin local wallet state.

NATS: gaiaftcl.substrate.franklin_local_wallet.sealed· append-only· federation-cosigned· migration v209_substrate_franklin_local_wallet

Column	Type
row_id	INTEGER
wallet_id	TEXT
cell_id	TEXT
composed_at_iso	TEXT
qfot_balance_canonical	TEXT
euro_stablecoin_balance_canonical	TEXT
euro_stablecoin_identifier	TEXT
euro_stablecoin_receiving_address	TEXT
qfot_keypair_public_key_hex	TEXT
qfot_keypair_uum8d_witness_hash	TEXT
initial_qfot_grant_canonical	TEXT
initial_euro_balance_canonical	TEXT
total_qfot_credited_canonical	TEXT
total_qfot_debited_canonical	TEXT
total_euro_received_canonical	TEXT
total_qfot_minted_from_euro_canonical	TEXT
last_sync_at_iso	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV209.swift

V210 — substrate_franklin_local_wallet_ledger

substrate Franklin local wallet ledger.

NATS: gaiaftcl.substrate.franklin_local_wallet_ledger.sealed· append-only· federation-cosigned· migration v210_substrate_franklin_local_wallet_ledger

Column	Type
row_id	INTEGER
ledger_entry_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
wallet_id	TEXT
asset_class	TEXT
entry_type	TEXT
amount_canonical	TEXT
qfot_balance_after_canonical	TEXT
euro_balance_after_canonical	TEXT
exchange_rate_canonical	TEXT
associated_external_tx_hash	TEXT
associated_v195_ledger_id	TEXT
associated_v198_payment_id	TEXT
associated_v199_mesh_dispatch_id	TEXT
rationale	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV210.swift

V211 — substrate_internal_randomness_provenance

substrate internal randomness provenance.

NATS: gaiaftcl.substrate.internal_randomness_provenance.sealed· append-only· federation-cosigned· migration v211_substrate_internal_randomness_provenance

Column	Type
row_id	INTEGER
randomness_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
consumer_substrate_operation	TEXT
byte_count	INTEGER
rule30_seed_canonical	TEXT
rule30_iteration_count	INTEGER
output_witness_hash	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV211.swift

V212 — substrate_discrete_continuum_bridge

substrate discrete-to-continuum bridge.

NATS: gaiaftcl.substrate.discrete_continuum_bridge.sealed· append-only· federation-cosigned· migration v212_substrate_discrete_continuum_bridge

Column	Type
row_id	INTEGER
bridge_composition_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
algorithm_id	TEXT
substrate_evidence_window	INTEGER
discrete_cell_count	INTEGER
continuum_statistic_type	TEXT
continuum_statistic_canonical	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV212.swift

V213 — substrate_multicomputational_operation

substrate multicomputational operation.

NATS: gaiaftcl.substrate.multicomputational_operation.sealed· append-only· federation-cosigned· migration v213_substrate_multicomputational_operation

Column	Type
row_id	INTEGER
multicomputational_operation_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
operation_type	TEXT
participating_cells	TEXT
causal_threads_canonical	TEXT
convergence_witness_hash	TEXT
convergence_terminal	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV213.swift

V214 — substrate_federation_cosignature_depth_evidence

substrate federation cosignature depth.

NATS: gaiaftcl.substrate.federation_cosignature_depth.sealed· append-only· federation-cosigned· migration v214_substrate_federation_cosignature_depth_evidence

Column	Type
row_id	INTEGER
depth_evidence_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
originating_substrate_operation	TEXT
originating_witness_hash	TEXT
substrate_development_depth_canonical	TEXT
substrate_iteration_count_at_composition	INTEGER
substrate_internal_randomness_hash	TEXT
depth_witness_hash	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV214.swift

V215 — substrate_demonstration_wallet_tracking

substrate demonstration wallet tracking.

NATS: gaiaftcl.substrate.demonstration_wallet_tracking.sealed· append-only· federation-cosigned· migration v215_substrate_demonstration_wallet_tracking

Column	Type
row_id	INTEGER
wallet_id	TEXT
wallet_label	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
cell_id	TEXT
wallet_classification	TEXT
bit_size	INTEGER
cryptographic_scheme	TEXT
public_key_hex	TEXT
private_key_storage_path	TEXT
uum8d_witness_hash	TEXT
paired_demonstration_wallet_id	TEXT
substrate_demonstration_outcome	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV215.swift

V217 — substrate_wallet_backup_history

substrate wallet backup + restore history.

NATS: gaiaftcl.substrate.wallet_backup_history.sealed· append-only· federation-cosigned· migration v217_substrate_wallet_backup_history

Column	Type
row_id	INTEGER
backup_event_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
cell_id	TEXT
event_type	TEXT
backup_file_path	TEXT
backup_file_witness_hash	TEXT
included_wallet_count	INTEGER
wallet_id_list_canonical	TEXT
keychain_master_key_account_id	TEXT
substrate_internal_randomness_hash	TEXT
aes_gcm_nonce_hex	TEXT
ciphertext_byte_count	INTEGER
rationale	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV217.swift

V218 — substrate_founder_cell_wallets

substrate founder cell wallets.

NATS: gaiaftcl.substrate.founder_cell_wallets.sealed· append-only· federation-cosigned· migration v218_substrate_founder_cell_wallets

Column	Type
row_id	INTEGER
founder_wallet_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
founder_cell_id	TEXT
wallet_purpose	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
receiving_address	TEXT
uum8d_witness_hash	TEXT
pq_private_key_storage_path	TEXT
chain_compatibility	TEXT
issuer_authority_unlimited	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV218.swift

V219 — substrate_franklin_cross_algorithm_learning

substrate Franklin cross-algorithm.

NATS: gaiaftcl.substrate.franklin_cross_algorithm_learning.sealed· append-only· federation-cosigned· migration v219_substrate_franklin_cross_algorithm_learning

Column	Type
row_id	INTEGER
learning_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
source_algorithm_id	TEXT
target_algorithm_id	TEXT
learning_type	TEXT
learning_canonical	TEXT
substrate_validation_terminal	TEXT
associated_source_evidence	TEXT
associated_target_evidence	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV219.swift

V220 — substrate_franklin_local_wallet_ledger

V210 entry_type CHECK extension for.

NATS: gaiaftcl.substrate.franklin_local_wallet_ledger.sealed· append-only· federation-cosigned· migration v220_v210_entry_type_check_extended

Column	Type
row_id	INTEGER
ledger_entry_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
wallet_id	TEXT
asset_class	TEXT
entry_type	TEXT
amount_canonical	TEXT
qfot_balance_after_canonical	TEXT
euro_balance_after_canonical	TEXT
exchange_rate_canonical	TEXT
associated_external_tx_hash	TEXT
associated_v195_ledger_id	TEXT
associated_v198_payment_id	TEXT
associated_v199_mesh_dispatch_id	TEXT
rationale	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV220.swift

V221 — substrate_franklin_local_wallet_ledger

V210 asset_class + entry_type CHECK.

NATS: gaiaftcl.substrate.franklin_local_wallet_ledger.sealed· append-only· federation-cosigned· migration v221_v210_asset_class_btc_plus_two_way_demo

Column	Type
row_id	INTEGER
ledger_entry_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
wallet_id	TEXT
asset_class	TEXT
entry_type	TEXT
amount_canonical	TEXT
qfot_balance_after_canonical	TEXT
euro_balance_after_canonical	TEXT
exchange_rate_canonical	TEXT
associated_external_tx_hash	TEXT
associated_v195_ledger_id	TEXT
associated_v198_payment_id	TEXT
associated_v199_mesh_dispatch_id	TEXT
rationale	TEXT
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV221.swift

V222 — substrate_founder_cell_wallets

V218 substrate_founder_cell_wallets.

NATS: gaiaftcl.substrate.founder_cell_wallets.sealed· append-only· federation-cosigned· migration v222_v218_wallet_purpose_finance_grade_extended

Column	Type
row_id	INTEGER
founder_wallet_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
founder_cell_id	TEXT
wallet_purpose	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
receiving_address	TEXT
uum8d_witness_hash	TEXT
pq_private_key_storage_path	TEXT
chain_compatibility	TEXT
issuer_authority_unlimited	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV222.swift

V223 — substrate_founder_cell_wallets

V218 substrate_founder_cell_wallets.

NATS: gaiaftcl.substrate.founder_cell_wallets.sealed· append-only· federation-cosigned· migration v223_v218_pq_scheme_identifier_check_enforced

Column	Type
row_id	INTEGER
founder_wallet_id	TEXT
composed_at_iso	TEXT
daemon_session_id	TEXT
founder_cell_id	TEXT
wallet_purpose	TEXT
pq_scheme_identifier	TEXT
pq_public_key_hex	TEXT
receiving_address	TEXT
uum8d_witness_hash	TEXT
pq_private_key_storage_path	TEXT
chain_compatibility	TEXT
issuer_authority_unlimited	INTEGER
canonical_witness	TEXT
witness_hash_sha256	TEXT
signature_quintet	TEXT
nats_subject_sealed	TEXT

Source: cells/xcode/Sources/GaiaFTCLCore/NarratorSchemaV223.swift

---

Federation-cosigned

This page's source is sealed in the GaiaFTCL federation manifest — page SHA-256 940e2f7e99278d3f…, manifest witness a090592e0609adc8…, signed 2026-06-02T18:58:22Z by cell gaiaftcl-mac-cell. Verify with gaiaftcl wiki sign --all and compare wiki-all-signatures.json.