Litigation Schema and User-Defined Functions

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.

litigation.t_cases

ColumnTypeModifiersComment
case_idserialprimary keyTable primary key
case_numbervarchar(32)
Identifying case number
fileddate
Filing date of case
closeddate
Date case closed
created_load_idintegernot nullLoad id of case creation
modified_load_idintegernot nullLoad id of last modification
deleted_load_idinteger
Load id when case was deleted


litigation.t_publication_cases

ColumnTypeModifiersComment
publication_case_idserialprimary keyTable primary key
case_idintegernot nullCase ID referencing litigation.t_cases (case_id )
publication_idintegernot nullPublication ID referencing xml.t_patent_document_values (publication_id )


litigation.t_parties

ColumnTypeModifiersComment
parties_idserialprimary keyTable primary key
case_idintegernot nullCase ID referencing litigation.t_cases (case_id )
modified_load_idintegernot nullLoad id of last modification
statuschar(1)
XML validity flag (v=valid;i=invalid)
contentxml
Parties XML container


litigation.t_related_publications

ColumnTypeModifiersComment
related_publications_idserialprimary keyTable primary key
case_idintegernot nullCase ID referencing litigation.t_cases (case_id )
modified_load_idintegernot nullLoad id of last modification
statuschar(1)
XML validity flag (v=valid;i=invalid)
contentxml
Related publications XML container


litigation.t_related_cases

ColumnTypeModifiersComment
related_cases_idserialprimary keyTable primary key
case_idintegernot nullCase ID referencing litigation.t_cases (case_id )
modified_load_idintegernot nullLoad id of last modification
statuschar(1)
XML validity flag (v=valid;i=invalid)
contentxml
Related cases XML container


litigation.t_litigation_case_extract

ColumnTypeModifiersComment
parties_idserialprimary keyTable primary key
case_idintegernot nullCase ID referencing litigation.t_cases (case_id )
modified_load_idintegernot nullLoad id of last modification
statuschar(1)
XML validity flag (v=valid;i=invalid)
contentxml
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);