Database Selection / upc_ip.db

Configure Ingestion Mapping

Specify how this SQLite database relates and maps to our standard PostgreSQL tables.

1 Select Main & Join Tables

Main Table

The core registry index representing the main Case entries (e.g. `matters` or `extractions`).

2 Map Source Fields to Case Schema

Map standard PostgreSQL fields to columns from the SQLite database. Dropping down lists all unique columns found across all databases in the folder. Unmapped columns are automatically backed up in a `raw_data` JSON column so no details are lost.

Case Name / Title * The primary title of the case lawsuit

Case / Trial Number E.g., application ID, trial ID

IP Category Field Patent, Trademark, Copyright, Design

Court / Board Name Court, division, level name

Judges / Bench List of judges or bench detail

Petitioner / Plaintiff Claimant, applicant, or petitioner side

Respondent / Defendant Defendant, respondent, or patent owner

Filing Date Filing date column

Decision / Verdict Date Decision or judgment date

Dispute Summary Overview or short abstract summary

Outcome / Ruling The decision outcome, reasons, or verdict

Source PDF / Case URL Original URL link to the case or PDF

Case Full Text Full text block of the case judgment

3 Ingestion Details

Jurisdiction Code *

E.g., `us`, `in`, `upc`, `eu`. This determines the dynamic SEO slug prefix.

Default Category (Fallback)

Fallback category if no dynamic category column is mapped.

Select a main table and run "Test JOIN" in Step 1 to unlock the migration control panel.