Editing Corpus/Schema (section)

== Schema: corpus.tag_stats ==

<syntaxhighlight lang="sql">
CREATE TABLE corpus.tag_stats (
    kind          text NOT NULL,
    jurisdiction  text NOT NULL,
    tag_key       text NOT NULL,
    tag_value     text NOT NULL,
    count         integer DEFAULT 0,
    PRIMARY KEY (kind, jurisdiction, tag_key, tag_value)
);
</syntaxhighlight>

Refreshed post-ingest, incrementally per source. Provides instant faceted counts without scanning <code>documents</code>.

Must handle both scalar and array tag values. For scalar tags, count directly. For array tags (e.g., <code>tags.themes = ["droit civil", "responsabilite"]</code>), use <code>jsonb_array_elements_text</code> to explode the array and count each element individually.

----