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