Litigation Schema and User-Defined Functions

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

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