Ludus / gamify schema inventory (SSOT pointers)
Baseline (vox-db manifest)
- Core tables:
crates/vox-db/src/schema/domains/sql/gamification.sql(profiles, companions, quests, battles) plus coordination SQL in the same domain. - Agents / events:
crates/vox-db/src/schema/domains/agents.rs(agent_events,cost_records, …).
Baseline gamification coordination (extended tables)
Extended Ludus tables and column fixes live in the gamification / coordination fragments under crates/vox-db/src/schema/domains/ (consumed by manifest::baseline_sql). The former ludus_schema_cutover module and its legacy entrypoint are removed; use baseline migrate only.
Covers, among others:
gamify_teaching_profiles,gamify_policy_snapshots,gamify_ai_feedback,gamify_periodic_rewards,gamify_level_historygamify_counters(columnname, notcounter_name)gamify_collegium(singular; legacygamify_collegiumsrenamed when present)gamify_arena_*,gamify_daily_counters,gamify_event_config,gamify_notificationsgamify_hint_telemetry,gamify_processed_events(orchestrator idempotency)- Profile / quest / companion column alignment (
personalityon companions, streak/lumens on profiles, …)
Application code
- Router + rewards:
crates/vox-ludus/src/event_router.rs,crates/vox-ludus/src/db/process_rewards.rs - SQL reference ladder (documentation / partial migrations):
crates/vox-ludus/src/schema.rs
Tests
- Ludus SQL / ops:
crates/vox-db/tests/ops_ludus_tests.rs - Policy / router:
crates/vox-ludus/tests/gamify_integration_test.rs