[2.5] catalog.elitigation_judgment #22

New issue

Closed

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

dernbu commented

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

Owner

Parent

#2 — depends on [2.1]

Schema

CREATE TABLE catalog.elitigation_judgment (
  id               bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  judgment_id      bigint  NULL REFERENCES catalog.judgment ON DELETE RESTRICT,
  slug             text    NOT NULL UNIQUE,
  citation         text    NOT NULL,
  title            text    NULL,
  decision_date    date    NULL,
  court            text    NULL,
  case_number      text    NULL,
  version_text     text    NULL,
  is_available     boolean NOT NULL DEFAULT true,
  listing_payload  jsonb   NOT NULL,
  UNIQUE (slug)
);

Rules: slug is opaque; preserved exactly, never regenerated from the citation.

Done when

FK to catalog.judgment enforced (nullable, RESTRICT)
slug uniqueness enforced

## Parent #2 — depends on [2.1] ## Schema ```sql CREATE TABLE catalog.elitigation_judgment ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, judgment_id bigint NULL REFERENCES catalog.judgment ON DELETE RESTRICT, slug text NOT NULL UNIQUE, citation text NOT NULL, title text NULL, decision_date date NULL, court text NULL, case_number text NULL, version_text text NULL, is_available boolean NOT NULL DEFAULT true, listing_payload jsonb NOT NULL, UNIQUE (slug) ); ``` **Rules:** `slug` is opaque; preserved exactly, never regenerated from the citation. ## Done when - FK to `catalog.judgment` enforced (nullable, RESTRICT) - `slug` uniqueness 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#22

No description provided.

Rows
Columns