[2.8] catalog.lawnet_artifact #25

New issue

Closed

opened 2026-06-13 23:54:28 +02:00 by dernbu · 0 comments

dernbu commented

2026-06-13 23:54:28 +02:00

Owner

Parent

#2 — depends on [2.2]

Schema

CREATE TABLE catalog.lawnet_artifact (
  id                 bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  source_judgment_id bigint NOT NULL REFERENCES catalog.lawnet_judgment,
  kind               text   NOT NULL CHECK (kind IN (raw_html, judgment_html, sanitized_html, pdf)),
  rendition_key      text   NOT NULL,
  rendition_type     text   NULL CHECK (rendition_type IN (judgment, slr, unknown)),
  source_uri         text   NULL,
  is_selected        boolean NOT NULL DEFAULT false,
  content            bytea  NOT NULL,
  content_type       text   NOT NULL,
  sha256             bytea  NOT NULL,
  size_bytes         bigint NOT NULL,
  source_url         text   NULL,
  fetched_at         timestamptz NOT NULL,
  UNIQUE (source_judgment_id, kind, rendition_key)
);

Rendition keys: HTML → source URI (e.g. /Judgment/4-M.xml), PDF → official-pdf.

Done when

kind CHECK constrains to 4 allowed values
rendition_type CHECK constrains to 3 LawNet-specific values
Composite UNIQUE enforced

## Parent #2 — depends on [2.2] ## Schema ```sql CREATE TABLE catalog.lawnet_artifact ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, source_judgment_id bigint NOT NULL REFERENCES catalog.lawnet_judgment, kind text NOT NULL CHECK (kind IN (raw_html, judgment_html, sanitized_html, pdf)), rendition_key text NOT NULL, rendition_type text NULL CHECK (rendition_type IN (judgment, slr, unknown)), source_uri text NULL, is_selected boolean NOT NULL DEFAULT false, content bytea NOT NULL, content_type text NOT NULL, sha256 bytea NOT NULL, size_bytes bigint NOT NULL, source_url text NULL, fetched_at timestamptz NOT NULL, UNIQUE (source_judgment_id, kind, rendition_key) ); ``` **Rendition keys:** HTML → source URI (e.g. `/Judgment/4-M.xml`), PDF → `official-pdf`. ## Done when - `kind` CHECK constrains to 4 allowed values - `rendition_type` CHECK constrains to 3 LawNet-specific values - Composite UNIQUE enforced

dernbu closed this issue

2026-06-14 05:22:59 +02:00

No labels

No milestone

No project

No assignees

1 participant

Notifications

Due date

The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference

dernbu/lawnet-scraper#25

No description provided.

Rows
Columns