[2.3] catalog.lawnet_coram #20

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

Parent

#2 — depends on [2.2]

Schema

CREATE TABLE catalog.lawnet_coram (
  id                  bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  lawnet_judgment_id  bigint NOT NULL REFERENCES catalog.lawnet_judgment ON DELETE CASCADE,
  ordinal             integer NOT NULL,
  name                text NOT NULL
);

Done when

FK cascades on source delete
ordinal + name store correctly

## Parent #2 — depends on [2.2] ## Schema ```sql CREATE TABLE catalog.lawnet_coram ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, lawnet_judgment_id bigint NOT NULL REFERENCES catalog.lawnet_judgment ON DELETE CASCADE, ordinal integer NOT NULL, name text NOT NULL ); ``` ## Done when - FK cascades on source delete - `ordinal` + `name` store correctly

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#20

No description provided.

Rows
Columns