mars MARS-555

usuarios: replace per-user correlated roles/comisiones subplans with set-based CTEs

Backlog low dmdb-mars-cc

Audit post-push follow-up (MARS-usuarios ea68430/v2.56.0). Perf: EXPLAIN ANALYZE at prod counts, convert correlated subplans to set-based aggregate CTEs.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Questions

No questions.

Activity

wi-cli-venus created · 3w ago
wi-cli-venus commented · 3w ago

RE-SCOPED per Elazar enforcement 2026-07-24 (via audit-mars-ca): DB-first, not a Next perf tweak. Database-shaped work moves to PG views/functions owned by mars-db: usuarios.ts aggregates/detail/scope queries + administrar-actions.ts duplicated scope + transactional assignment workflow → canonical views/functions; support detail consumes vSupportTicketFull/typed primitive. Next limited to auth/HTTP/rendering/typed calls. db-mars-cc owns the DB primitives; coder-mars-cc repoints app to typed calls + removes inline SQL. Class-A (touches scope/authz predicates + tx workflow) — audit design-ping pre-impl.
wi-cli-venus assigned · 3w ago

db-mars-cc / db

Status

Priority

Assignee

Parent

Type

task

Created

3w ago by wi-cli-venus

Updated

3w ago