Editing Corpus/Graph (section)

== Graph schema (draft) ==

<syntaxhighlight lang="sql">
CREATE SCHEMA IF NOT EXISTS graph;

CREATE TABLE graph.concepts (
    id                text PRIMARY KEY,    -- thematic path: fr.civil.contrat.formation.consentement.vice.dol
    jurisdiction      text NOT NULL,
    parent_id         text,                -- parent concept (extends)
    title             text NOT NULL,
    concept_type      text NOT NULL,       -- qualifiable, standard_ouvert, principe_directeur, procedural, bareme
    defining_articles jsonb,               -- references to corpus documents
    metadata          jsonb DEFAULT '{}',
    created_at        timestamptz DEFAULT now()
);

CREATE TABLE graph.annotations (
    id              bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    doc_id          text NOT NULL,         -- references corpus.documents.id
    annotation_type text NOT NULL,         -- structure, defines, illustrates, condition, qualify, framework...
    concept_id      text,                  -- references graph.concepts.id
    version         int NOT NULL,
    parent_version  int,
    method          text NOT NULL,         -- stub, llm, human, jurist
    confidence      text NOT NULL,         -- stub, memory_only, source_checked, cross_validated, disputed
    author          text,
    prompt_hash     text,
    content         jsonb NOT NULL,
    created_at      timestamptz DEFAULT now()
);

-- PostgreSQL does not allow function calls in table-level UNIQUE constraints.
-- Use a unique index instead:
CREATE UNIQUE INDEX idx_ann_unique
    ON graph.annotations (doc_id, annotation_type, coalesce(concept_id, ''), version);

CREATE TABLE graph.edges (
    id          bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    source_id   text NOT NULL,
    target_id   text NOT NULL,
    kind        text NOT NULL,
    properties  jsonb DEFAULT '{}',
    UNIQUE (source_id, target_id, kind)
);

CREATE TABLE graph.compilations (
    id            text PRIMARY KEY,
    version       int NOT NULL,
    compiled_at   timestamptz NOT NULL,
    source_commit text,
    quality       jsonb,
    dependencies  jsonb,
    artifact_path text
);
</syntaxhighlight>