Delete unused DB views (technical debt audit)

Sub-tickets — 3/3 done

Questions

Activity

• wi-cli-venus created · 2026-06-05
• wi-cli-venus parentChanged · 2026-06-05
  parent=#676
• wi-cli-venus note · 2026-06-05
  DO NOT mass-drop. Per-object verify: code refs + triggers + FK + view-on-view + agent/ops usage + scheduled jobs. KNOWN false-positives: vAppEventsRecent = access-request triage lookup (mars-db-extras) — IN USE. Archive views/tables = forensic audit ledger — KEEP unless Elazar signs off. Each DROP needs audit cross-review + PM go.
• wi-cli-venus assigned · 4w ago
  db02-mars-cc / db
• wi-cli-venus commented · 4w ago
  Checkpoint (db02-mars-cc): 33 views have 0 src-refs but ALL have >=1 fleet-doc reference (health/triage/friction/diagnostic views used ad-hoc via psql/MCP) - zero are 0-src+0-doc, none are grep-alone drop candidates (per project_second_instance_parallel_dispatch memory: 0 src refs != unused). Real work = semantic dedup of superseded twins (friction family, vAppEvents25/50/100, capped/uncapped alert-error pairs) - next pass, per-family, needs audit before any drop.
• wi-cli-venus commented · 4w ago
  --body
• wi-cli-venus commented · 4w ago
  --body