[2.15] ingest.discovery_record #32

New issue

Closed

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

dernbu commented

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

Owner

Parent

#2 — depends on [2.13]

Schema

CREATE TABLE ingest.discovery_record (
  id               bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  run_id           bigint NOT NULL REFERENCES ingest.discovery_run ON DELETE CASCADE,
  source_key       text   NOT NULL,
  discovery_order  integer NOT NULL,
  parsed_fields    jsonb  NOT NULL,
  source_payload   jsonb  NOT NULL,
  pass             integer NOT NULL,
  page             integer NOT NULL
);

Rules: Records are staged here then published to catalog on stabilized run completion.

Done when

FK cascades on run delete
Index on (run_id, source_key) for publication queries

## Parent #2 — depends on [2.13] ## Schema ```sql CREATE TABLE ingest.discovery_record ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, run_id bigint NOT NULL REFERENCES ingest.discovery_run ON DELETE CASCADE, source_key text NOT NULL, discovery_order integer NOT NULL, parsed_fields jsonb NOT NULL, source_payload jsonb NOT NULL, pass integer NOT NULL, page integer NOT NULL ); ``` **Rules:** Records are staged here then published to catalog on stabilized run completion. ## Done when - FK cascades on run delete - Index on `(run_id, source_key)` for publication queries

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

No description provided.

Rows
Columns