dernbu/lawnet-scraper
1
0
Fork 0
Code Issues 8 Pull requests Projects Releases Packages Wiki Activity Actions

[2.7] catalog.elitigation_catchword #24

New issue
Closed
opened 2026-06-13 23:54:27 +02:00 by dernbu · 0 comments
dernbu commented 2026-06-13 23:54:27 +02:00
Owner
Copy link

Parent

#2 — depends on [2.5]

Schema

CREATE TABLE catalog.elitigation_catchword (
  id                       bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  elitigation_judgment_id  bigint NOT NULL REFERENCES catalog.elitigation_judgment ON DELETE CASCADE,
  ordinal                  integer NOT NULL,
  value                    text NOT NULL
);

Note: eLitigation catchwords are flat (no group/depth hierarchy, unlike LawNet).

Done when

  • FK cascades on source delete
## Parent #2 — depends on [2.5] ## Schema ```sql CREATE TABLE catalog.elitigation_catchword ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, elitigation_judgment_id bigint NOT NULL REFERENCES catalog.elitigation_judgment ON DELETE CASCADE, ordinal integer NOT NULL, value text NOT NULL ); ``` **Note:** eLitigation catchwords are flat (no group/depth hierarchy, unlike LawNet). ## Done when - FK cascades on source delete
Sign in to join this conversation.
No Branch/Tag specified
Branches Tags
main
temp
feat/53-rename-lawnet-routes
push-xrsnvuvuvsul
feat/37-bff-storage-frontend
l
feat/49-pg-bff-storage
push-zzvxlnkylqsp
feat/quick-and-dirty
No results found.
Labels
Clear labels
No items
No labels
Milestone
Clear milestone
No items
No milestone
Projects
Clear projects
No items
No project
Assignees
Clear assignees
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#24
No description provided.