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

[2.4] catalog.lawnet_catchword #21

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

Parent

#2 — depends on [2.2]

Schema

CREATE TABLE catalog.lawnet_catchword (
  id                  bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  lawnet_judgment_id  bigint NOT NULL REFERENCES catalog.lawnet_judgment ON DELETE CASCADE,
  group_ordinal       integer NOT NULL,
  item_ordinal        integer NOT NULL,
  depth               integer NOT NULL,
  value               text NOT NULL
);

Rules: hierarchical catchwords (group → item → depth).

Done when

  • FK cascades on source delete
  • Hierarchical ordering fields store correctly
## Parent #2 — depends on [2.2] ## Schema ```sql CREATE TABLE catalog.lawnet_catchword ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, lawnet_judgment_id bigint NOT NULL REFERENCES catalog.lawnet_judgment ON DELETE CASCADE, group_ordinal integer NOT NULL, item_ordinal integer NOT NULL, depth integer NOT NULL, value text NOT NULL ); ``` **Rules:** hierarchical catchwords (group → item → depth). ## Done when - FK cascades on source delete - Hierarchical ordering fields store correctly
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#21
No description provided.