Core şema 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: f3-008

Bu referans, kabul edilmiş migration network’süz PostgreSQL 17 üzerinde uygulandıktan ve canlı katalog sözleşmesinin tamamı doğrulandıktan sonra pg_catalog snapshot’ından üretilir. Elle düzenlenmez; kaynak değişikliği generator üzerinden yeniden üretilir.

Mantıksal model ve immutable core sınırı için core veri modeline bakın.

Üretim otoritesi

Alan	Değer
Şema	`public`
Sözleşme	`munderecat-core-postgresql-schema-v1`
PostgreSQL major	17
Migration	`db/supabase/migrations/20260819080000_f3_008_core_baseline.sql`
Migration SHA-256	`cec30ae6fd6a0d42d3a4bbdb091fa319c373679fb47890caf7e3dcae4b8d7031`
Config SHA-256	`6e1328778a4260867e599ecadbbd53ed116bb54ea276f207bafc71c0cffb7ccc`
Catalog profile	`postgresql17-core-catalog-v1`
Catalog SHA-256	`cea99ecb777666ff883aaf6982629a773e49c6ae4a095256758b579d9dd8f479`

Domain’ler

`core_uuid_v5`

Alan	Değer
Base type	`uuid`
Collation	Yok
Not null	Hayır
Default	Yok

Constraint	Tür	Tanım	Durum
`core_uuid_v5_version_check`	CHECK	`CHECK (((SUBSTRING((VALUE)::text FROM 15 FOR 1) = '5'::text) AND (SUBSTRING((VALUE)::text FROM 20 FOR 1) = ANY (ARRAY['8'::text, '9'::text, 'a'::text, 'b'::text]))))`	validated

`positive_byte_count`

Alan	Değer
Base type	`bigint`
Collation	Yok
Not null	Hayır
Default	Yok

Constraint	Tür	Tanım	Durum
`positive_byte_count_range_check`	CHECK	`CHECK (((VALUE >= 1) AND (VALUE <= '9007199254740991'::bigint)))`	validated

`safe_position`

Alan	Değer
Base type	`bigint`
Collation	Yok
Not null	Hayır
Default	Yok

Constraint	Tür	Tanım	Durum
`safe_position_range_check`	CHECK	`CHECK (((VALUE >= 0) AND (VALUE <= '9007199254740991'::bigint)))`	validated

`sha256_hex`

Alan	Değer
Base type	`text`
Collation	`C`
Not null	Hayır
Default	Yok

Constraint	Tür	Tanım	Durum
`sha256_hex_format_check`	CHECK	`CHECK ((VALUE ~ '^[0-9a-f]{64}$'::text))`	validated

Tablolar

`books`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`books` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
3	`text_utf8_byte_count`	`positive_byte_count`	Hayır	Yok	Yok	Yok	Yok
4	`text_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
5	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`books` constraint’leri

Constraint	Tür	Tanım	Durum
`books_id_text_version_key`	UNIQUE	`UNIQUE (id, text_version_id)`	validated
`books_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated
`books_text_version_fk`	FOREIGN KEY	`FOREIGN KEY (text_version_id) REFERENCES text_versions(id) ON DELETE RESTRICT`	validated
`books_text_version_position_key`	UNIQUE	`UNIQUE (text_version_id, "position")`	validated

`books` index’leri

Index	Tanım	Bayraklar
`books_id_text_version_key`	`CREATE UNIQUE INDEX books_id_text_version_key ON public.books USING btree (id, text_version_id)`	unique, valid, ready
`books_pkey`	`CREATE UNIQUE INDEX books_pkey ON public.books USING btree (id)`	primary, unique, valid, ready
`books_text_version_position_key`	`CREATE UNIQUE INDEX books_text_version_position_key ON public.books USING btree (text_version_id, "position")`	unique, valid, ready

`chapters`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`chapters` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`book_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
3	`position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
4	`initial_text`	`text`	Hayır	`C`	Yok	Yok	Yok
5	`text_utf8_byte_count`	`positive_byte_count`	Hayır	Yok	Yok	Yok	Yok
6	`text_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
7	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`chapters` constraint’leri

Constraint	Tür	Tanım	Durum
`chapters_book_lineage_fk`	FOREIGN KEY	`FOREIGN KEY (book_id, text_version_id) REFERENCES books(id, text_version_id) ON DELETE RESTRICT`	validated
`chapters_book_position_key`	UNIQUE	`UNIQUE (book_id, "position")`	validated
`chapters_id_text_version_key`	UNIQUE	`UNIQUE (id, text_version_id)`	validated
`chapters_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated

`chapters` index’leri

Index	Tanım	Bayraklar
`chapters_book_lineage_idx`	`CREATE INDEX chapters_book_lineage_idx ON public.chapters USING btree (book_id, text_version_id)`	valid, ready
`chapters_book_position_key`	`CREATE UNIQUE INDEX chapters_book_position_key ON public.chapters USING btree (book_id, "position")`	unique, valid, ready
`chapters_id_text_version_key`	`CREATE UNIQUE INDEX chapters_id_text_version_key ON public.chapters USING btree (id, text_version_id)`	unique, valid, ready
`chapters_pkey`	`CREATE UNIQUE INDEX chapters_pkey ON public.chapters USING btree (id)`	primary, unique, valid, ready

`core_releases`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`core_releases` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`identity_release_key`	`text`	Hayır	`C`	Yok	Yok	Yok
2	`core_root_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
3	`reconstruction_profile_id`	`text`	Hayır	`C`	Yok	Yok	Yok
4	`reconstruction_profile_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`core_releases` constraint’leri

Constraint	Tür	Tanım	Durum
`core_releases_core_root_sha256_key`	UNIQUE	`UNIQUE (core_root_sha256)`	validated
`core_releases_identity_release_key_check`	CHECK	`CHECK ((identity_release_key ~ '^[a-z0-9][a-z0-9._/-]*$'::text))`	validated
`core_releases_identity_release_key_key`	UNIQUE	`UNIQUE (identity_release_key)`	validated
`core_releases_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated
`core_releases_reconstruction_profile_id_check`	CHECK	`CHECK ((reconstruction_profile_id ~ '^[a-z0-9][a-z0-9._/-]*$'::text))`	validated

`core_releases` index’leri

Index	Tanım	Bayraklar
`core_releases_core_root_sha256_key`	`CREATE UNIQUE INDEX core_releases_core_root_sha256_key ON public.core_releases USING btree (core_root_sha256)`	unique, valid, ready
`core_releases_identity_release_key_key`	`CREATE UNIQUE INDEX core_releases_identity_release_key_key ON public.core_releases USING btree (identity_release_key)`	unique, valid, ready
`core_releases_pkey`	`CREATE UNIQUE INDEX core_releases_pkey ON public.core_releases USING btree (id)`	primary, unique, valid, ready

`paragraphs`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`paragraphs` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`chapter_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
3	`position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
4	`following_text`	`text`	Hayır	`C`	Yok	Yok	Yok
5	`text_utf8_byte_count`	`positive_byte_count`	Hayır	Yok	Yok	Yok	Yok
6	`text_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
7	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`paragraphs` constraint’leri

Constraint	Tür	Tanım	Durum
`paragraphs_chapter_lineage_fk`	FOREIGN KEY	`FOREIGN KEY (chapter_id, text_version_id) REFERENCES chapters(id, text_version_id) ON DELETE RESTRICT`	validated
`paragraphs_chapter_position_key`	UNIQUE	`UNIQUE (chapter_id, "position")`	validated
`paragraphs_id_text_version_key`	UNIQUE	`UNIQUE (id, text_version_id)`	validated
`paragraphs_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated

`paragraphs` index’leri

Index	Tanım	Bayraklar
`paragraphs_chapter_lineage_idx`	`CREATE INDEX paragraphs_chapter_lineage_idx ON public.paragraphs USING btree (chapter_id, text_version_id)`	valid, ready
`paragraphs_chapter_position_key`	`CREATE UNIQUE INDEX paragraphs_chapter_position_key ON public.paragraphs USING btree (chapter_id, "position")`	unique, valid, ready
`paragraphs_id_text_version_key`	`CREATE UNIQUE INDEX paragraphs_id_text_version_key ON public.paragraphs USING btree (id, text_version_id)`	unique, valid, ready
`paragraphs_pkey`	`CREATE UNIQUE INDEX paragraphs_pkey ON public.paragraphs USING btree (id)`	primary, unique, valid, ready

`release_text_versions`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`release_text_versions` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`core_release_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`stream_position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
3	`text_version_root_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`release_text_versions` constraint’leri

Constraint	Tür	Tanım	Durum
`release_text_versions_pkey`	PRIMARY KEY	`PRIMARY KEY (core_release_id, text_version_id)`	validated
`release_text_versions_release_fk`	FOREIGN KEY	`FOREIGN KEY (core_release_id) REFERENCES core_releases(id) ON DELETE RESTRICT`	validated
`release_text_versions_release_position_key`	UNIQUE	`UNIQUE (core_release_id, stream_position)`	validated
`release_text_versions_text_version_root_fk`	FOREIGN KEY	`FOREIGN KEY (text_version_id, text_version_root_sha256) REFERENCES text_versions(id, content_root_sha256) ON DELETE RESTRICT`	validated

`release_text_versions` index’leri

Index	Tanım	Bayraklar
`release_text_versions_pkey`	`CREATE UNIQUE INDEX release_text_versions_pkey ON public.release_text_versions USING btree (core_release_id, text_version_id)`	primary, unique, valid, ready
`release_text_versions_release_position_key`	`CREATE UNIQUE INDEX release_text_versions_release_position_key ON public.release_text_versions USING btree (core_release_id, stream_position)`	unique, valid, ready
`release_text_versions_text_version_id_idx`	`CREATE INDEX release_text_versions_text_version_id_idx ON public.release_text_versions USING btree (text_version_id)`	valid, ready

`sentences`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`sentences` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`paragraph_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
3	`position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
4	`initial_text`	`text`	Hayır	`C`	Yok	Yok	Yok
5	`following_text`	`text`	Hayır	`C`	Yok	Yok	Yok
6	`text_utf8_byte_count`	`positive_byte_count`	Hayır	Yok	Yok	Yok	Yok
7	`text_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
8	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`sentences` constraint’leri

Constraint	Tür	Tanım	Durum
`sentences_id_text_version_key`	UNIQUE	`UNIQUE (id, text_version_id)`	validated
`sentences_paragraph_lineage_fk`	FOREIGN KEY	`FOREIGN KEY (paragraph_id, text_version_id) REFERENCES paragraphs(id, text_version_id) ON DELETE RESTRICT`	validated
`sentences_paragraph_position_key`	UNIQUE	`UNIQUE (paragraph_id, "position")`	validated
`sentences_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated

`sentences` index’leri

Index	Tanım	Bayraklar
`sentences_id_text_version_key`	`CREATE UNIQUE INDEX sentences_id_text_version_key ON public.sentences USING btree (id, text_version_id)`	unique, valid, ready
`sentences_paragraph_lineage_idx`	`CREATE INDEX sentences_paragraph_lineage_idx ON public.sentences USING btree (paragraph_id, text_version_id)`	valid, ready
`sentences_paragraph_position_key`	`CREATE UNIQUE INDEX sentences_paragraph_position_key ON public.sentences USING btree (paragraph_id, "position")`	unique, valid, ready
`sentences_pkey`	`CREATE UNIQUE INDEX sentences_pkey ON public.sentences USING btree (id)`	primary, unique, valid, ready

`text_versions`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`text_versions` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`work_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`tokenization_profile_id`	`text`	Hayır	`C`	Yok	Yok	Yok
3	`tokenization_profile_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
4	`text_utf8_byte_count`	`positive_byte_count`	Hayır	Yok	Yok	Yok	Yok
5	`text_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
6	`content_root_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok
7	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`text_versions` constraint’leri

Constraint	Tür	Tanım	Durum
`text_versions_content_root_sha256_key`	UNIQUE	`UNIQUE (content_root_sha256)`	validated
`text_versions_id_content_root_sha256_key`	UNIQUE	`UNIQUE (id, content_root_sha256)`	validated
`text_versions_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated
`text_versions_tokenization_profile_fk`	FOREIGN KEY	`FOREIGN KEY (tokenization_profile_id, tokenization_profile_sha256) REFERENCES tokenization_profiles(id, contract_sha256) ON DELETE RESTRICT`	validated
`text_versions_work_fk`	FOREIGN KEY	`FOREIGN KEY (work_id) REFERENCES works(id) ON DELETE RESTRICT`	validated

`text_versions` index’leri

Index	Tanım	Bayraklar
`text_versions_content_root_sha256_key`	`CREATE UNIQUE INDEX text_versions_content_root_sha256_key ON public.text_versions USING btree (content_root_sha256)`	unique, valid, ready
`text_versions_id_content_root_sha256_key`	`CREATE UNIQUE INDEX text_versions_id_content_root_sha256_key ON public.text_versions USING btree (id, content_root_sha256)`	unique, valid, ready
`text_versions_pkey`	`CREATE UNIQUE INDEX text_versions_pkey ON public.text_versions USING btree (id)`	primary, unique, valid, ready
`text_versions_tokenization_profile_idx`	`CREATE INDEX text_versions_tokenization_profile_idx ON public.text_versions USING btree (tokenization_profile_id, tokenization_profile_sha256)`	valid, ready
`text_versions_work_id_idx`	`CREATE INDEX text_versions_work_id_idx ON public.text_versions USING btree (work_id)`	valid, ready

`token_forms`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`token_forms` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`exact_body`	`text`	Hayır	`C`	Yok	Yok	Yok
3	`exact_body_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`token_forms` constraint’leri

Constraint	Tür	Tanım	Durum
`token_forms_exact_body_check`	CHECK	`CHECK ((octet_length(exact_body) > 0))`	validated
`token_forms_id_text_version_key`	UNIQUE	`UNIQUE (id, text_version_id)`	validated
`token_forms_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated
`token_forms_text_version_exact_body_sha256_key`	UNIQUE	`UNIQUE (text_version_id, exact_body_sha256)`	validated
`token_forms_text_version_fk`	FOREIGN KEY	`FOREIGN KEY (text_version_id) REFERENCES text_versions(id) ON DELETE RESTRICT`	validated

`token_forms` index’leri

Index	Tanım	Bayraklar
`token_forms_id_text_version_key`	`CREATE UNIQUE INDEX token_forms_id_text_version_key ON public.token_forms USING btree (id, text_version_id)`	unique, valid, ready
`token_forms_pkey`	`CREATE UNIQUE INDEX token_forms_pkey ON public.token_forms USING btree (id)`	primary, unique, valid, ready
`token_forms_text_version_exact_body_sha256_key`	`CREATE UNIQUE INDEX token_forms_text_version_exact_body_sha256_key ON public.token_forms USING btree (text_version_id, exact_body_sha256)`	unique, valid, ready

`token_occurrences`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`token_occurrences` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`text_version_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
2	`sentence_id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
3	`position`	`safe_position`	Hayır	Yok	Yok	Yok	Yok
4	`occurrence_kind`	`text`	Hayır	`C`	Yok	Yok	Yok
5	`token_form_id`	`core_uuid_v5`	Evet	Yok	Yok	Yok	Yok
6	`literal_text`	`text`	Evet	`C`	Yok	Yok	Yok
7	`trailing_text`	`text`	Hayır	`C`	Yok	Yok	Yok
8	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`token_occurrences` constraint’leri

Constraint	Tür	Tanım	Durum
`token_occurrences_form_lineage_fk`	FOREIGN KEY	`FOREIGN KEY (token_form_id, text_version_id) REFERENCES token_forms(id, text_version_id) ON DELETE RESTRICT`	validated
`token_occurrences_kind_check`	CHECK	`CHECK ((((occurrence_kind = 'form'::text) AND (token_form_id IS NOT NULL) AND (literal_text IS NULL)) OR ((occurrence_kind = 'literal'::text) AND (token_form_id IS NULL) AND (literal_text IS NOT NULL) AND (octet_length(literal_text) > 0))))`	validated
`token_occurrences_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated
`token_occurrences_sentence_lineage_fk`	FOREIGN KEY	`FOREIGN KEY (sentence_id, text_version_id) REFERENCES sentences(id, text_version_id) ON DELETE RESTRICT`	validated
`token_occurrences_sentence_position_key`	UNIQUE	`UNIQUE (sentence_id, "position")`	validated

`token_occurrences` index’leri

Index	Tanım	Bayraklar
`token_occurrences_form_lineage_idx`	`CREATE INDEX token_occurrences_form_lineage_idx ON public.token_occurrences USING btree (token_form_id, text_version_id) WHERE (token_form_id IS NOT NULL)`	valid, ready
`token_occurrences_pkey`	`CREATE UNIQUE INDEX token_occurrences_pkey ON public.token_occurrences USING btree (id)`	primary, unique, valid, ready
`token_occurrences_sentence_lineage_idx`	`CREATE INDEX token_occurrences_sentence_lineage_idx ON public.token_occurrences USING btree (sentence_id, text_version_id)`	valid, ready
`token_occurrences_sentence_position_key`	`CREATE UNIQUE INDEX token_occurrences_sentence_position_key ON public.token_occurrences USING btree (sentence_id, "position")`	unique, valid, ready

`tokenization_profiles`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=tokenization_contract_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`tokenization_profiles` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`text`	Hayır	`C`	Yok	Yok	Yok
1	`contract_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`tokenization_profiles` constraint’leri

Constraint	Tür	Tanım	Durum
`tokenization_profiles_contract_sha256_key`	UNIQUE	`UNIQUE (contract_sha256)`	validated
`tokenization_profiles_id_check`	CHECK	`CHECK ((id ~ '^[a-z0-9][a-z0-9._/-]*$'::text))`	validated
`tokenization_profiles_id_contract_sha256_key`	UNIQUE	`UNIQUE (id, contract_sha256)`	validated
`tokenization_profiles_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated

`tokenization_profiles` index’leri

Index	Tanım	Bayraklar
`tokenization_profiles_contract_sha256_key`	`CREATE UNIQUE INDEX tokenization_profiles_contract_sha256_key ON public.tokenization_profiles USING btree (contract_sha256)`	unique, valid, ready
`tokenization_profiles_id_contract_sha256_key`	`CREATE UNIQUE INDEX tokenization_profiles_id_contract_sha256_key ON public.tokenization_profiles USING btree (id, contract_sha256)`	unique, valid, ready
`tokenization_profiles_pkey`	`CREATE UNIQUE INDEX tokenization_profiles_pkey ON public.tokenization_profiles USING btree (id)`	primary, unique, valid, ready

`works`

Alan	Değer
Owner	`munderecat_core_owner`
Comment	`munderecat:permanence=immutable;logical_owner=sealed_core_publisher`
Persistence	`p`
RLS	Hayır
Forced RLS	Hayır
PUBLIC privileges	Yok
Runtime privileges	Yok
Curation privileges	Yok
Auditor privileges	`SELECT`
Legacy reader privileges	`SELECT`

`works` kolonları

Pozisyon	Kolon	Tür	Nullable	Collation	Default	Identity	Generated
0	`id`	`core_uuid_v5`	Hayır	Yok	Yok	Yok	Yok
1	`row_sha256`	`sha256_hex`	Hayır	`C`	Yok	Yok	Yok

`works` constraint’leri

Constraint	Tür	Tanım	Durum
`works_pkey`	PRIMARY KEY	`PRIMARY KEY (id)`	validated

`works` index’leri

Index	Tanım	Bayraklar
`works_pkey`	`CREATE UNIQUE INDEX works_pkey ON public.works USING btree (id)`	primary, unique, valid, ready

Core şema kataloğu

Üretim otoritesi

Domain’ler

core_uuid_v5

positive_byte_count

safe_position

sha256_hex

Tablolar

books

books kolonları

books constraint’leri

books index’leri

chapters

chapters kolonları

chapters constraint’leri

chapters index’leri

core_releases

core_releases kolonları

core_releases constraint’leri

core_releases index’leri

paragraphs

paragraphs kolonları

paragraphs constraint’leri

paragraphs index’leri

release_text_versions

release_text_versions kolonları

release_text_versions constraint’leri

release_text_versions index’leri

sentences

sentences kolonları

sentences constraint’leri

sentences index’leri

text_versions

text_versions kolonları

text_versions constraint’leri

text_versions index’leri

token_forms

token_forms kolonları

token_forms constraint’leri

token_forms index’leri

token_occurrences

token_occurrences kolonları

token_occurrences constraint’leri

token_occurrences index’leri

tokenization_profiles

tokenization_profiles kolonları

tokenization_profiles constraint’leri

tokenization_profiles index’leri

works

works kolonları

works constraint’leri

works index’leri