...
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 |
| DOCDBDocDB-provided simple family identifier |
...