Primary Key of legal-status-document
Posted: Mon Jun 19, 2017 11:10 am
Hi!
Currently we implement a batch job that imports INPADOC legal-status-documents into a database. As such we wonder what would be the natural primary key for legal-status-documents?
Taken from the sample, a legal-status-document looks like below.
There are several attributes or combinations of attributes, we could use as primary key. But what I would expect as the right thing is the combination of family-id="4211500" and sequence-number="1".
Is that right?
Currently we implement a batch job that imports INPADOC legal-status-documents into a database. As such we wonder what would be the natural primary key for legal-status-documents?
Taken from the sample, a legal-status-document looks like below.
There are several attributes or combinations of attributes, we could use as primary key. But what I would expect as the right thing is the combination of family-id="4211500" and sequence-number="1".
Is that right?
Code: Select all
<legal-status-document family-id="4211500" status="C" country="CH" number-of-events="1">
<application-reference doc-id="5860841">
<document-id>
<country>CH</country>
<doc-number>148296</doc-number>
<kind>A</kind>
<date>19960613</date>
</document-id>
</application-reference>
<publication-reference doc-id="296901770" lang="de">
<document-id>
<country>CH</country>
<doc-number>690950</doc-number>
<kind>A5</kind>
<date>20010228</date>
</document-id>
</publication-reference>
<ipr-type>patent for invention</ipr-type>
<legal-event providing-office="CH" status="C" date-added="20160707" sequence-number="1">
<event-date>20160630</event-date>
<event-code>PL</event-code>
<event-details>
<event-description event-description-type="original">LOESCHUNG/RADIATION/RADIAZION</event-description>
<event-description lang="en">PATENT CEASED</event-description>
</event-details>
</legal-event>
</legal-status-document>