Resolving locale, route permissions, and workspace projection.
Current scope: Guest
Category: 10_normative | Version: v1.0.0
Owner: DOCUMENT_CUSTODIAN | Review cycle: 90 days
Approval authority: GOVERNANCE_ADMIN
Documentation portal is read-only. Editing and mutation endpoints are disabled.
Kvary platform is originally created in Georgian. Where a Georgian version exists, Georgian is authoritative for platform UI, documentation, and legal interpretation.
Translations into other languages are provided for convenience. Some records may originate in other languages and carry their own source or legal locale for a specific flow, but where a Georgian version is available, the Georgian version prevails for platform-level wording and interpretation.
Metadata incomplete: Document ID, Version, Status, Owner Role, Last Review Date, Next Review Date, Change Log
svc-tenders Data Ownership MapThis document assigns the durable data surfaces currently hosted by services/svc-tenders to their likely long-term domain owners.
Where ownership is ambiguous, it is marked explicitly.
VERIFIED: direct code or migration evidence.
INFERRED: likely from code shape, but not fully proven across all consumers.
UNVERIFIED: not proven strongly enough.
REAL: durable write/read surface exists.
MIXED: mixed with legacy or compatibility data paths.
UI-FIRST: not durably backend-owned from the user-facing path.
SHELL: structure exists but is lightly used.
MISSING: not present as a real backend data surface.
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| tenders | services/svc-tenders/migrations/0001_tenders.sql; services/svc-tenders/src/repository.ts | Tender domain, keep in svc-tenders | services/api tender routes; web tender pages | HIGH | HIGH | VERIFIED / REAL | Canonical tender registry table |
| tenders_events | services/svc-tenders/migrations/0028_tenders_events_outbox.sql | Tender domain plus shared event contract surface | KES outbox relay / projection consumer | HIGH | HIGH | VERIFIED / REAL | Emits to kes_outbox_events via DB trigger |
| legacy_tender_events | services/svc-tenders/migrations/0031_legacy_tender_events_outbox.sql | Tender domain legacy residue | KES outbox relay / legacy compatibility consumers | MEDIUM | MEDIUM | VERIFIED / REAL | Legacy event stream still tied into outbox |
| tender_declarations | services/svc-tenders/migrations/0037_tender_declarations_v1.sql | Tender domain, keep in svc-tenders | admin/internal tender declaration routes | HIGH | HIGH | VERIFIED / REAL | Canonical declaration payload store |
| tender_declaration_events | same migration | Tender domain | internal admin declaration workflow | MEDIUM | MEDIUM | VERIFIED / REAL | Declaration audit trail |
| tender_declaration_evidence | services/svc-tenders/migrations/0038_tender_declaration_evidence.sql | Tender domain | admin declaration evidence routes | MEDIUM | MEDIUM | VERIFIED / REAL | Tender-specific evidence attachments |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| auctions | services/svc-tenders/migrations/0002_auctions.sql; repository auction queries | Future auctions domain | services/api auctions routes; web portal auction readers | HIGH | HIGH | VERIFIED / MIXED | Canonical durable row exists, but public read path is mixed with gateway/web compatibility |
| auction_declarations | services/svc-tenders/migrations/0032_auction_declaration_v1.sql | Future auctions domain | admin/internal auction declaration workflow | HIGH | HIGH | VERIFIED / REAL | Canonical auction declaration payload store |
| auction_declaration_events | same migration | Future auctions domain | admin/internal declaration workflow | MEDIUM | MEDIUM | VERIFIED / REAL | Declaration audit trail |
| auction_declaration_evidence | services/svc-tenders/migrations/0034_auction_declaration_evidence.sql | Future auctions domain | admin evidence routes | MEDIUM | MEDIUM | VERIFIED / REAL | Auction-specific evidence attachments |
| output_allocations | services/svc-tenders/migrations/0035_output_allocations_v1.sql | UNVERIFIED: future auctions vs financial/settlement/shared registry | auction admin routes and settlement-adjacent workflows | HIGH | HIGH | VERIFIED / REAL | This is the highest-risk ownership ambiguity in current durable auction data |
| entitlement_id columns on auctions and linked declarations | migrations 0047_output_allocations_linked_auction.sql, 0048_add_entitlement_ids.sql | likely future auctions domain with financial/backbone touchpoint | web detail/read, settlement linkage | HIGH | HIGH | INFERRED / REAL | Strong cross-domain settlement coupling |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| vacancies | services/svc-tenders/migrations/0005_vacancies_accommodations.sql; legacy repository queries | Legacy future workstay platform residue | public vacancy list/detail | MEDIUM | MEDIUM | VERIFIED / MIXED | Still used as fallback when projection rows do not exist |
| vacancy_postings | services/svc-tenders/migrations/0032_vacancy_write_model.sql; vacancy command handlers | Future accommodation/worker/travel platform | owner/employer vacancy management; public vacancy reads through projection | MEDIUM | MEDIUM | VERIFIED / REAL | Real write model |
| vacancy_applications | same migration | Future accommodation/worker/travel platform | applicant and owner review routes | MEDIUM | MEDIUM | VERIFIED / REAL | Real application write model |
| vacancy_postings_view | same migration; vacancy projections | Future accommodation/worker/travel platform | public list reads, owner lookup fallback | MEDIUM | MEDIUM | VERIFIED / REAL | Projection table, not a SQL view despite name |
| vacancy_posting_detail_view | same migration; vacancy projections/read model | Future accommodation/worker/travel platform | public detail reads | MEDIUM | MEDIUM | VERIFIED / REAL | Projection table mapped back into legacy summary shape |
| my_vacancy_applications_view | same migration; services/svc-tenders/src/vacancy/projections.ts | Future accommodation/worker/travel platform | applicant “my applications” route | MEDIUM | LOW | VERIFIED / REAL | Projection table |
| vacancy_applications_by_posting_view | same migration; vacancy projections | Future accommodation/worker/travel platform | owner posting-level application reads | MEDIUM | LOW | VERIFIED / REAL | Projection table |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| accommodations | services/svc-tenders/migrations/0005_vacancies_accommodations.sql; repository public list/detail queries | Legacy future workstay platform residue | public accommodation list/detail/quote | MEDIUM | MEDIUM | VERIFIED / MIXED | Public discovery still reads this table, not the newer listing model |
| accommodation_listings | services/svc-tenders/migrations/0041_accommodation_write_model.sql; accommodation command handlers | Future accommodation/worker/travel platform | owner listing editor/manage flows | MEDIUM | MEDIUM | VERIFIED / REAL | Real write model |
| accommodation_bookings | same migration | Future accommodation/worker/travel platform | booking request/confirm/reject/cancel flows | MEDIUM | MEDIUM | VERIFIED / REAL | Real booking write model |
| accommodation_listings_view | same migration; services/svc-tenders/src/accommodation/projections.ts | Future accommodation/worker/travel platform | owner listing workspace; read repository | MEDIUM | LOW | VERIFIED / REAL | Projection table, despite _view suffix |
| accommodation_listing_detail_view | same migration; accommodation projections/read model | Future accommodation/worker/travel platform | listing detail reads in owner/private path | MEDIUM | LOW | VERIFIED / REAL | Real projection table |
| my_accommodation_bookings_view | same migration; accommodation projections/read model | Future accommodation/worker/travel platform | should back /my-accommodation-bookings, but route is not fully wired | MEDIUM | LOW | VERIFIED / MIXED | Data exists, route truth is partial |
| accommodation_bookings_by_listing_view | same migration; accommodation projections/read model | Future accommodation/worker/travel platform | should back listing booking reads, but route is not fully wired | MEDIUM | LOW | VERIFIED / MIXED | Data exists, route truth is partial |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| icpi_price_points | services/svc-icpi/migrations/0007_icpi_price_points.sql; extracted ICPI repository methods | Future ICPI platform | services/api ICPI proxy; web ICPI portal page | LOW | LOW | VERIFIED / REAL | Now canonically owned by extracted ICPI runtime |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| butkhuzi_norms | services/svc-tenders/migrations/0009_butkhuzi_norms.sql plus 0010, 0011; repository methods | Future Butkhuzi platform | services/api Butkhuzi proxy; KES/admin web consumers | LOW | LOW | VERIFIED / REAL | Single-table core, extended with coefficients and i18n JSON |
| butkhuzi_chunks | services/svc-tenders/migrations/0012_butkhuzi_chunks.sql; repository search/rebuild methods | Future Butkhuzi platform | search/suggest/rebuild endpoints; KES-facing search | MEDIUM | LOW | VERIFIED / REAL | Chunk/search substrate is real but still KES-adjacent in product use |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| kes_orchestrator_cases | services/svc-tenders/migrations/0024_kes_orchestrator.sql; repository KES methods | Shared Kvary execution backbone | KES routes, KES UI, Kafka/event flows | HIGH | HIGH | VERIFIED / REAL | Not tender-only in product meaning |
| kes_orchestrator_tasks | same migration | Shared Kvary execution backbone | KES case task flows | HIGH | MEDIUM | VERIFIED / REAL | Operational orchestration data |
| kes_orchestrator_inspections | same migration | Shared Kvary execution backbone | KES inspections | HIGH | MEDIUM | VERIFIED / REAL | Operational orchestration data |
| kes_orchestrator_payments | same migration | Shared Kvary execution backbone | KES payment approval/settlement flows | HIGH | HIGH | VERIFIED / REAL | Closely tied to workflow and hash-chain event append |
| kes_orchestrator_events | same migration | Shared Kvary execution backbone | outbox trigger, KES event history, consumers | HIGH | HIGH | VERIFIED / REAL | Feeds kes_outbox_events |
| kes_orchestrator_process_maps | services/svc-tenders/migrations/0025_kes_orchestrator_process_map.sql | Shared Kvary execution/backbone configuration | KES control-plane routes | MEDIUM | MEDIUM | VERIFIED / REAL | Runtime orchestration config, not tender domain |
| kes_outbox_events | services/svc-tenders/migrations/0027_kes_outbox.sql | Shared event backbone | Kafka relay / replay / monitoring | HIGH | HIGH | VERIFIED / REAL | Canonical outbox for KES + tender streams |
| kafka_consumer_idempotency | services/svc-tenders/migrations/0026_kafka_consumer_idempotency.sql | Shared event backbone | Kafka consumers | MEDIUM | LOW | VERIFIED / REAL | Cross-stream idempotency, not business-domain data |
| kes_domain_event_projection_events | services/svc-tenders/migrations/0029_kes_domain_event_projection.sql | Shared event backbone | KES domain event consumer | MEDIUM | LOW | VERIFIED / REAL | Projection event log |
| kes_domain_event_projection_counters | same migration | Shared event backbone | KES dashboards/control-plane | MEDIUM | LOW | VERIFIED / REAL | Derived projection state |
| kes_domain_event_projection_aggregates | same migration | Shared event backbone | KES dashboards/control-plane | MEDIUM | LOW | VERIFIED / REAL | Derived projection state |
| Table / model / entity | File path(s) | Domain owner verdict | External consumers | Extraction difficulty | Migration risk | Confidence / state | Notes |
| --- | --- | --- | --- | --- | --- | --- | --- |
| outbox_events | services/svc-tenders/migrations/0032_vacancy_write_model.sql; inserts in vacancy/accommodation command handlers | likely future workstay platform internal event log, not shared backbone | vacancy/accommodation in-process projection only | MEDIUM | MEDIUM | VERIFIED / MIXED | Name suggests generic backbone, but actual use is local and partial |
| giant mixed repository layer | services/svc-tenders/src/repository.ts | temporary hosting location, not a domain owner | nearly every API surface | HIGH | HIGH | VERIFIED / MIXED | One file currently spans tender, auction, vacancy, accommodation, ICPI, Butkhuzi, and KES persistence |
VERIFIED: tender and KES tables are the most obviously canonical, durable, and internal to current svc-tenders reality.VERIFIED: ICPI and Butkhuzi are already data-distinct enough to separate with relatively low schema risk.VERIFIED: vacancy and accommodation have real new write models, but public discovery still depends on older compatibility tables and fallback catalogs.VERIFIED: auctions are durable on the declaration/admin side, but the public user journey still has non-durable bidder mutation gaps outside this schema.VERIFIED: outbox_events is not yet a trustworthy shared event backbone; it is a local subdomain projection aid.