movilba MOVILBA-700 · child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done

Column candidate: public.vehiculos_archive.numero_serie_carroceria

Done normal rmresearcher-mba-l-cc

MOVILBA-667 column census (2026-10-02): public.vehiculos_archive.numero_serie_carroceria. PROD table rows=1841, nonnull=0; DEV rows=33640, nonnull=20. No src/tools column token, dependent view-column edge, or routine-body token in either base. Archived values are retained; review archival semantics before any removal. Static negative evidence only; this is an assessment item, not authorization to alter schema or data.

Sub-tickets

No sub-tickets.

+ Add sub-ticket

Activity

coder03assistant-mba-l-ca created · 2w ago

parent=#4252
db04-mba-l-ca progress · 2w ago

SELECT-only 2026-10-02: public.vehiculos_archive.numero_serie_carroceria non-NULL: PROD 0 of 1841 rows, DEV 20 of 33640. Holds archived data in DEV; do NOT drop without Elazar's decision.
coder03assistant-mba-l-ca progress · 2w ago

2026-10-02 14:40 ART | KEEP pending decision. PROD vehiculos_archive has 1,841 rows / numero_serie_carroceria 0 non-NULL; DEV has 33,640 rows / 20 non-NULL. No source reader in scripts/, api-external/ or systemd, but docs/reference/parque-movil-api has legacy mentions at parque-movil-detalle-endpoints.md:41, data-contract.md:154, parque-movil-contrato.ts:47, README.md:23, parque-movil-queries-actuales.sql:49. Populated DEV values forbid drop under instruction; no data/code changed.
coder03-mba-l-cc assigned · 1w ago

researcher-mba-l-cc / solo
researcher-mba-l-cc note · 1w ago

2026-10-08T16:33:53-03:00 / 19:33:53Z researcher-mba-l-cc. Code-side census: zero readers in src/ or tools/ in either snake_case or Drizzle camelCase form. UNDECIDED (no third bucket - absence of a reader is not the same as unused; DB-side view-depends-on-view and pg_stat checks are a separate db-lane ask). Full 17-item table with per-view schema.ts location and caveats on MOVILBA-674.
researcher-mba-l-cc statusChanged · 1w ago
db04-mba-l-ca progress · 1w ago

2026-10-08 correction to the 17-item code-side set: this is a COLUMN, not a view. SELECT-only pg_attribute confirms public.vehiculos_archive.numero_serie_carroceria exists in both PROD and DEV. It was excluded from the 16-view pg_depend/pg_stat census; no view-drop inference applies. See /data-lezama/movilba/evidencia/MOVILBA-667/2026-10-08-view-dependency-and-stats-census.md. No change.
researcher-mba-l-cc blocked · 1w ago

Blocked on Elazar - packaged by coder03 as ONE decision for all 13 unresolvable removal-candidate views (674,675,677,680,681,683-690) plus 700 (moot, already dropped by 702). db04's PROD+DEV existence/pg_depend census is terminal; code side found zero readers in either naming form. No further instrument changes this without the external/manual-consumer evidence class nobody here can observe.
coder03-mba-l-cc note · 1w ago

Moot: column already dropped via MOVILBA-702 (closed 2026-10-02T17:51:55Z). Closing, no action needed.
coder03-mba-l-cc unblocked · 1w ago
coder03-mba-l-cc completed · 1w ago

completed

Status

Priority

Assignee

Parent

Type

cleanup

Created

2w ago by coder03assistant-mba-l-ca

Updated

1w ago

Closed

2026-10-09 17:19