The litigation schema is used for global litigation data provided by MaxVal. This data is available through the CLAIMS Direct platform as an optional data subscription. For information about the Litigation API, see Litigation.
Schema
litigation.t_cases
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| case_id | serial | primary key | Table primary key |
| case_number | varchar(32) | Identifying case number | |
| filed | date | Filing date of case | |
| closed | date | Date case closed | |
| created_load_id | integer | not null | Load id of case creation |
| modified_load_id | integer | not null | Load id of last modification |
| deleted_load_id | integer | Load id when case was deleted |
litigation.t_publication_cases
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| publication_case_id | serial | primary key | Table primary key |
| case_id | integer | not null | Case ID referencing litigation.t_cases (case_id ) |
| publication_id | integer | not null | Publication ID referencing xml.t_patent_document_values (publication_id ) |
litigation.t_parties
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| parties_id | serial | primary key | Table primary key |
| case_id | integer | not null | Case ID referencing litigation.t_cases (case_id ) |
| modified_load_id | integer | not null | Load id of last modification |
| status | char(1) | XML validity flag (v=valid;i=invalid) | |
| content | xml | Parties XML container |
litigation.t_related_publications
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| related_publications_id | serial | primary key | Table primary key |
| case_id | integer | not null | Case ID referencing litigation.t_cases (case_id ) |
| modified_load_id | integer | not null | Load id of last modification |
| status | char(1) | XML validity flag (v=valid;i=invalid) | |
| content | xml | Related publications XML container |
litigation.t_related_cases
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| related_cases_id | serial | primary key | Table primary key |
| case_id | integer | not null | Case ID referencing litigation.t_cases (case_id ) |
| modified_load_id | integer | not null | Load id of last modification |
| status | char(1) | XML validity flag (v=valid;i=invalid) | |
| content | xml | Related cases XML container |
litigation.t_litigation_case_extract
| Column | Type | Modifiers | Comment |
|---|---|---|---|
| parties_id | serial | primary key | Table primary key |
| case_id | integer | not null | Case ID referencing litigation.t_cases (case_id ) |
| modified_load_id | integer | not null | Load id of last modification |
| status | char(1) | XML validity flag (v=valid;i=invalid) | |
| content | xml | Main XML case container |
User-Defined Functions
litigation.f_build_case(integer, text)
This function returns an entire XML case given a case_id as first argument. The second argument is currently unused.
SELECT litigation.f_build_case(534987, null);