Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 3

The litigation schema is used for global litigation data provided by MaxVal. This data is available through the CLAIMS Direct platform as a separate subscription. For information about the Litigation API, see Litigation. tst

Table of Contents

Schema

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.

Code Block
languagesql
SELECT litigation.f_build_case(534987, null);