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

[2.10] catalog.lawnet_search_document #27

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

Parent

#2 — depends on [2.8]

Schema

CREATE TABLE catalog.lawnet_search_document (
  id                 bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
  source_artifact_id bigint NOT NULL UNIQUE REFERENCES catalog.lawnet_artifact,
  plain_text         text   NOT NULL,
  search_vector      tsvector GENERATED ALWAYS AS (to_tsvector(english, plain_text)) STORED
);

Rules: source_artifact_id must reference a judgment_html artifact.

Done when

  • GIN index on search_vector
  • Generated tsvector column works correctly
## Parent #2 — depends on [2.8] ## Schema ```sql CREATE TABLE catalog.lawnet_search_document ( id bigint GENERATED ALWAYS AS IDENTITY PRIMARY KEY, source_artifact_id bigint NOT NULL UNIQUE REFERENCES catalog.lawnet_artifact, plain_text text NOT NULL, search_vector tsvector GENERATED ALWAYS AS (to_tsvector(english, plain_text)) STORED ); ``` **Rules:** `source_artifact_id` must reference a `judgment_html` artifact. ## Done when - GIN index on `search_vector` - Generated `tsvector` column works 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#27
No description provided.