...
The following graphic is a tree view of the structure of a complete XML document. Each node represents a container whereby each leaf of the tree represents a table in the data warehouse (xml
and work
schemas). The naming pattern of tables follows the following rules:
...
The table xml.t_patent_document_values
is the master content table containing meta information of the document in standard relation database columns. This table is the basis for the over-all overall container element patent-document
.
Column | Type | Modifiers | Comment |
---|---|---|---|
patent_document_value_id | serial | primary key | Table primary key |
publication_id | integer | not null | Integer representation of the publication |
created_load_id | integer | Load id of document creation | |
modified_load_id | integer |
| Load id of last modification |
deleted_load_id | integer | Load id when document was deleted | |
status | varchar(16) |
| Status of complete document (new|update) |
country | char(2) | not null | Country of publication |
doc_number | varchar(32) | not null | Publication document number |
kind | varchar(4) |
| Document kind code |
lang | char(2) |
| Document publication language |
ucid | varchar(32) |
| Concatenation of country-doc_number-kind |
published | date |
| Date of publication |
produced | date |
| Date of Alexandria XML production |
withdraw | boolean |
| Withdrawn status |
family_id | integer |
| DOCDB-provided simple family identifier |
...
Similar to the function above, this function returns a SETOF SET OF XML documents, one document per row. Arguments are identical to function above.
...