basquetWi + New ticket

terra_33: provisional seed of the four modulo-campo vocabularies (tipo de injerto, zona dadora, tipo de barrera, marca de implante), marked for catedra review

Done high dtdb-terra-cc

ELAZAR RULING 2026-08-22 (CLI, "3b"): seed a PROVISIONAL list for each of the four categories from the literature, marked for Puia review - the client has not answered and the four fields have been live-but-disabled since 0.24.14. This overrides the TERRA-76 "lists are the catedra to supply" hold for the SEED only; the no-free-text rule stands. PROVENANCE MARKING: lookupOptions has no isConfirmedByClient column (shared table, terra cannot add one), so provisional status is carried in (a) this migration header, (b) the app - PROVISIONAL_CAMPO_CATEGORIES in src/lib/lookups.ts renders "lista provisoria, a confirmar por la catedra" under the picker, removed per category when Puia confirms - and (c) pm/05-client-info.md OPEN items. All four rows: ownerAppKey=terra, appKey-scoped via the existing include-mode vocabularyScopes row from terra_31, one vocabularyScopeMembers row per value. Labels es-AR, values camelCase. LISTS (value | label | sortOrder): terraTipoInjerto: autologo|Autólogo|1, alogenico|Alogénico (homólogo)|2, xenogenico|Xenogénico (heterólogo)|3, aloplastico|Aloplástico (sintético)|4, mixto|Mixto (combinación)|5. terraZonaDadora: sinfisisMentoniana|Sínfisis mentoniana|1, ramaMandibular|Rama mandibular|2, cuerpoMandibular|Cuerpo mandibular|3, tuberosidadMaxilar|Tuberosidad del maxilar|4, mismoSitioQuirurgico|Mismo sitio quirúrgico (hueso del lecho / particulado del fresado)|5, crestaIliaca|Cresta ilíaca|6, calota|Calota|7, tibia|Tibia|8, noAplica|No aplica (injerto no autólogo)|9 - noAplica is REQUIRED: tipoInjerto xenogenico/aloplastico has no zona dadora and without it the only honest entry is blank, which the form cannot distinguish from "forgot". terraTipoBarrera: colagenoReabsorbible|Membrana reabsorbible de colágeno|1, pericardioReabsorbible|Membrana reabsorbible de pericardio|2, dPtfe|PTFE denso (d-PTFE), no reabsorbible|3, ePtfe|PTFE expandido (e-PTFE), no reabsorbible|4, ptfeReforzadoTitanio|PTFE reforzado con titanio|5, mallaTitanio|Malla de titanio|6, sinBarrera|Sin barrera|7. terraMarcaImplante: straumann|Straumann|1, neodent|Neodent|2, nobelBiocare|Nobel Biocare|3, zimmerBiomet|Zimmer Biomet (3i)|4, dentsplySirona|Dentsply Sirona (Astra / Ankylos)|5, osstem|Osstem|6, mis|MIS|7, alphaBio|Alpha-Bio|8, bti|BTI|9, megagen|Megagen|10, bw|B&W (nacional)|11, odontit|Odontit (nacional)|12, rosterdent|Rosterdent (nacional)|13, treeOss|Tree-Oss (nacional)|14, otra|Otra|15 - "otra" is the escape row; a marca not on the list is recorded as otra, NOT typed, and Puia adds the brand. ACCEPTANCE: (1) apply-time arms assert each category resolves to exactly the stated count via resolveScopedVocabulary(terra, category), in the stated order; (2) no enamel-visible change - assert resolveScopedVocabulary for any OTHER appKey returns 0 rows for these categories before and after; (3) tag the file in-file per the citation gate; (4) header states PROVISIONAL and names this WI as the place Puia corrections land. App-side marker + pm doc are mine, same push as your file.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • wi-cli-venus created · 7w ago
    parent=#2717
  • wi-cli-venus commented · 7w ago
    Applied 2026-08-22 09:18 ART. supabase_migrations version 20260822091858. audit-terra-ca PASS audit-terra-ca-mt460w47z04a (sha256 3f586c5deb19e1c5022dd36e996455f75fd01a87689ef7ac4806d05522afb484 of pre-apply draft). Checksum-verified: stored statement md5 b994c900eb4f9fbbcf54d4adeac2dc33 matches raw md5sum of the submitted text. Live counts confirmed: terraTipoInjerto=5, terraZonaDadora=9, terraTipoBarrera=7, terraMarcaImplante=15. Citation gate rc=0 (1 WARN, shared relations lookupOptions/vocabularyScopes - expected, GO rationale stated in-file per the appKey-scoped rule). File moved to db/migrations/applied/terra_33_provisional_campo_vocab_seed.sql. Held open until coder-terra-cc posts the push SHA (applied-not-done).
  • wi-cli-venus commented · 7w ago
    Pushed 802b0b8 (0.24.18), confirmed by coder-terra-cc, live counts 5/9/7/15 re-verified independently. Applied-not-done condition cleared.
  • wi-cli-venus completed · 7w ago
    completed
task
7w ago by wi-cli-venus
7w ago
2026-08-22 09:22