Osmanlıca private API kataloğu
Geliştirme · 0.0.0-dev
Yayın
- Doküman
- 0.0.0-dev
- Uygulama
- 0.0.0
Bu sayfa
- Uygulama
- 0.0.0
- Şema
- f5-033
Bu sayfa, kabul edilmiş migration closure network’süz PostgreSQL 17 üzerinde
uygulandıktan sonra seçilmiş private function kimliklerini doğrudan pg_catalog
üzerinden üretir. Signature, return type, execution attributes ve ACL değerleri
elle düzenlenmez. Allowlist yalnız hangi routine’lerin developer kataloğunda yer
alacağını belirler; DB gerçeğini yeniden tarif etmez.
Kavramsal veri akışı, authority sınırları ve düzeltme yaşam döngüsü için
Osmanlıca ve lexical mimari rehberine
bakın. Bu katalogdaki hiçbir routine public PostgREST API değildir. Public
api_v1 wrapper’ları Faz 8’de ayrıca yayımlanacaktır.
Üretim otoritesi
Bölüm başlığı “Üretim otoritesi”| Alan | Değer |
|---|---|
| Sözleşme | munderecat-ottoman-private-api-catalog-v1 |
| PostgreSQL major | 17 |
| Routine sayısı | 35 |
| Config | config/ottoman-api-catalog.yml |
| Config SHA-256 | 15136e90f0a5ba95e1e128ba7f872c8577cd6f847460830febcf838e71f2a519 |
| Migration closure SHA-256 | a08a3a5284a1ef5b0746421837133221309490824036c4e1695aa9ef79b4705f |
| Catalog SHA-256 | d0188e868a6a759c7b3424c6476c4d1d72cb2ac80179d9aac642e7f6586d9ac1 |
| Public/runtime EXECUTE | Yok; generator forbidden role görürse başarısız olur |
Function kataloğu
Bölüm başlığı “Function kataloğu”Mapping ve publication helper’ları
Bölüm başlığı “Mapping ve publication helper’ları”| Routine | Identity arguments | Return | Attributes | Owner | Direct EXECUTE | Effective/member EXECUTE | Config | DB comment | Source |
|---|---|---|---|---|---|---|---|---|---|
ottoman_control.mapping_pattern_payload_sha256 |
p_matcher_profile_id text, p_match_mode text, p_token_key_path ottoman_control.matcher_token_key[], p_quality_policy_id text, p_quality_status text, p_priority integer |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Canonical matcher payload digest; priority is not acceptance and broad Latin match keys are outside this authority. |
db/supabase/migrations/20260822100000_f5_012_ottoman_mapping_patterns.sql |
ottoman_control.mapping_pattern_package_uuid |
p_identity_release_key text, p_matcher_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
ADR-002 UUIDv5 over canonical mapping-pattern identity path. |
db/supabase/migrations/20260822100000_f5_012_ottoman_mapping_patterns.sql |
ottoman_control.display_style_rule_payload_sha256 |
p_scope text, p_action text, p_display_category text, p_required_marks text[] |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.display_style_rule_package_uuid |
p_identity_release_key text, p_style_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.orthographic_form_payload_sha256 |
p_display_style_rule_id uuid, p_raw_script text, p_display_script text |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.orthographic_form_package_uuid |
p_identity_release_key text, p_form_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.pattern_output_payload_sha256 |
p_mapping_pattern_id uuid, p_orthographic_form_id uuid, p_display_style_rule_id uuid, p_quality_policy_id text, p_quality_status text |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.pattern_output_package_uuid |
p_identity_release_key text, p_output_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822113000_f5_015_ottoman_forms_outputs.sql |
ottoman_control.rendering_occurrence_payload_sha256 |
p_span_id uuid, p_pattern_output_id uuid, p_mapping_status text |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.rendering_occurrence_package_uuid |
p_identity_release_key text, p_occurrence_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.ottoman_release_payload_sha256 |
p_core_release_id uuid, p_core_root_sha256 sha256_hex, p_coverage_policy_id text, p_pattern_root_sha256 sha256_hex, p_occurrence_root_sha256 sha256_hex, p_occurrence_count bigint |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.ottoman_release_package_uuid |
p_identity_release_key text, p_release_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.pattern_inventory_root |
p_pattern_output_ids uuid[] |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.occurrence_inventory_root |
p_rendering_occurrence_ids uuid[] |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.calculate_release_pattern_root |
p_ottoman_release_id uuid |
sha256_hex |
sql, stable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.calculate_release_occurrence_root |
p_ottoman_release_id uuid |
sha256_hex |
sql, stable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.reader_unit_payload_sha256 |
p_span_id uuid, p_rendering_occurrence_id uuid, p_reader_status text |
sha256_hex |
sql, immutable, safe, non-strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reader_unit_package_uuid |
p_identity_release_key text, p_unit_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reader_unit_inventory_root |
p_reader_unit_ids uuid[] |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reader_release_payload_sha256 |
p_ottoman_release_id uuid, p_core_release_id uuid, p_core_root_sha256 sha256_hex, p_coverage_policy_id text, p_unit_root_sha256 sha256_hex, p_unit_count bigint |
sha256_hex |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reader_release_package_uuid |
p_identity_release_key text, p_release_payload_sha256 sha256_hex |
uuid |
sql, immutable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.calculate_reader_release_unit_root |
p_reader_release_id uuid |
sha256_hex |
sql, stable, safe, strict, security definer |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
Reader reconstruction
Bölüm başlığı “Reader reconstruction”| Routine | Identity arguments | Return | Attributes | Owner | Direct EXECUTE | Effective/member EXECUTE | Config | DB comment | Source |
|---|---|---|---|---|---|---|---|---|---|
ottoman_control.reconstruct_ottoman_sentence |
p_ottoman_release_id uuid, p_sentence_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Release-bound exact-span Ottoman sentence reconstruction; strict gaps return NULL. |
db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.reconstruct_ottoman_paragraph |
p_ottoman_release_id uuid, p_paragraph_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Release-bound Ottoman paragraph reconstruction preserving sentence following text. |
db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.reconstruct_ottoman_chapter |
p_ottoman_release_id uuid, p_chapter_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Release-bound Ottoman chapter reconstruction preserving hierarchy separators. |
db/supabase/migrations/20260822130000_f5_016_ottoman_reconstruction.sql |
ottoman_control.reconstruct_ottoman_reader_sentence |
p_reader_release_id uuid, p_sentence_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reconstruct_ottoman_reader_paragraph |
p_reader_release_id uuid, p_paragraph_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
ottoman_control.reconstruct_ottoman_reader_chapter |
p_reader_release_id uuid, p_chapter_id uuid, p_strict boolean |
text |
plpgsql, stable, safe, strict, security invoker |
munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
auditor, munderecat_ottoman_owner |
search_path=pg_catalog, pg_temp |
Yok | db/supabase/migrations/20260822150000_f5_017_ottoman_reader_units.sql |
Occurrence lookup
Bölüm başlığı “Occurrence lookup”| Routine | Identity arguments | Return | Attributes | Owner | Direct EXECUTE | Effective/member EXECUTE | Config | DB comment | Source |
|---|---|---|---|---|---|---|---|---|---|
lexical_control.list_exact_token_occurrences_v1 |
p_lexical_release_id uuid, p_token_form_id uuid, p_after_sentence_id uuid, p_after_occurrence_id uuid, p_limit integer |
SETOF lexical_control.token_occurrence_lookup_row_v1 |
plpgsql, stable, unsafe, non-strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
munderecat:rpc=private;lookup=exact_token_form;public_wrapper=F8 |
db/supabase/migrations/20260822210000_f5_022_occurrence_lookup.sql |
lexical_control.list_semantic_token_occurrences_v1 |
p_lexical_release_id uuid, p_lexeme_id uuid, p_after_sentence_id uuid, p_after_occurrence_id uuid, p_limit integer |
SETOF lexical_control.token_occurrence_lookup_row_v1 |
plpgsql, stable, unsafe, non-strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
munderecat:rpc=private;lookup=selected_lexeme;public_wrapper=F8 |
db/supabase/migrations/20260822210000_f5_022_occurrence_lookup.sql |
lexical_control.list_root_token_occurrences_v1 |
p_lexical_release_id uuid, p_lexical_root_id uuid, p_after_sentence_id uuid, p_after_occurrence_id uuid, p_limit integer |
SETOF lexical_control.token_occurrence_lookup_row_v1 |
plpgsql, stable, unsafe, non-strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
munderecat:rpc=private;lookup=selected_root;public_wrapper=F8 |
db/supabase/migrations/20260822210000_f5_022_occurrence_lookup.sql |
lexical_control.list_exact_compound_occurrences_v1 |
p_lexical_release_id uuid, p_compound_variant_id uuid, p_after_sentence_id uuid, p_after_occurrence_id uuid, p_limit integer |
SETOF lexical_control.compound_occurrence_lookup_row_v1 |
plpgsql, stable, unsafe, non-strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
munderecat:rpc=private;lookup=exact_compound_variant;public_wrapper=F8 |
db/supabase/migrations/20260822210000_f5_022_occurrence_lookup.sql |
lexical_control.list_semantic_compound_occurrences_v1 |
p_lexical_release_id uuid, p_compound_entry_id uuid, p_after_sentence_id uuid, p_after_occurrence_id uuid, p_limit integer |
SETOF lexical_control.compound_occurrence_lookup_row_v1 |
plpgsql, stable, unsafe, non-strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
munderecat:rpc=private;lookup=whole_compound_entry;public_wrapper=F8 |
db/supabase/migrations/20260822210000_f5_022_occurrence_lookup.sql |
Curation ve history
Bölüm başlığı “Curation ve history”| Routine | Identity arguments | Return | Attributes | Owner | Direct EXECUTE | Effective/member EXECUTE | Config | DB comment | Source |
|---|---|---|---|---|---|---|---|---|---|
provenance_control.apply_lexical_curation_transaction_v1 |
p_curation_decision_id uuid, p_operation_channel text, p_idempotency_key text, p_actor_id uuid, p_reason_code provenance_control.profile_id, p_expected_state_root provenance_control.sha256_hex, p_core_witness_root provenance_control.sha256_hex, p_compensates_transaction_id uuid |
TABLE(operation_id uuid, curation_transaction_id uuid, terminal_status text, failure_code text, transaction_result_root provenance_control.sha256_hex, replayed boolean, compensation_event_id uuid) |
plpgsql, volatile, unsafe, non-strict, security definer |
munderecat_provenance_owner |
curation_executor, munderecat_provenance_owner |
curation_executor, munderecat_provenance_owner |
search_path=pg_catalog, pg_temp, statement_timeout=8000ms |
Yok | db/supabase/migrations/20260822231000_f5_033_curation_transactions.sql |
lexical_control.list_compound_supersession_history_v1 |
p_entity_kind text, p_entity_id uuid |
TABLE(supersession_event_id uuid, event_kind text, reason_code text, evidence_assertion_id uuid, curation_transaction_id uuid, participant_side text, participant_position bigint, predecessor_ids uuid[], successor_ids uuid[], event_root_sha256 sha256_hex) |
plpgsql, stable, unsafe, strict, security definer |
munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
auditor, munderecat_lexical_owner |
search_path=pg_catalog, pg_temp, statement_timeout=1500ms |
Yok | db/supabase/migrations/20260822220000_f5_023_compound_curation.sql |