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);