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

[2.16] ingest.reconciliation_issue #33

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

Parent

#2

Schema

CREATE TABLE ingest.reconciliation_issue (
  id           bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  source       text   NOT NULL CHECK (source IN (lawnet, elitigation)),
  source_key   text   NOT NULL,
  issue_type   text   NOT NULL,
  details      jsonb  NULL,
  status       text   NOT NULL DEFAULT open CHECK (status IN (open, resolved, ignored)),
  created_at   timestamptz NOT NULL DEFAULT now(),
  resolved_at  timestamptz NULL
);

Issue types: Missing citation, Unparseable citation, Citation component conflict, Source record disappeared, Ambiguous LawNet rendition, Unexpected source schema.

Done when

  • CHECK constraints on source and status
  • Index on (source, status) for operator queries
## Parent #2 ## Schema ```sql CREATE TABLE ingest.reconciliation_issue ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, source text NOT NULL CHECK (source IN (lawnet, elitigation)), source_key text NOT NULL, issue_type text NOT NULL, details jsonb NULL, status text NOT NULL DEFAULT open CHECK (status IN (open, resolved, ignored)), created_at timestamptz NOT NULL DEFAULT now(), resolved_at timestamptz NULL ); ``` **Issue types:** `Missing citation`, `Unparseable citation`, `Citation component conflict`, `Source record disappeared`, `Ambiguous LawNet rendition`, `Unexpected source schema`. ## Done when - CHECK constraints on `source` and `status` - Index on `(source, status)` for operator queries
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#33
No description provided.