377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 14:43, 27 October 2017
, 14:43, 27 October 2017→PATENT
* prioritycountry (varchar(255)) country where patent is first filed
* patent_country (varchar(255)) country in which this patent was published
* prioritypatentnumber (varchar(255)) placeholder patent number if the patent is published before it is fully approved- also referred to as priority claims number
* cpcsubclass (varchar(255)) cooperative patent classification subclass
* cpcsubgroup (varchar(255)) cooperative patent classification subgroup
* cpcmaingroup (varchar(255)) cooperative patent classification main group
* cpctotal (varchar(255)) concatenated version of cpcmaingroup, cpcsubgroup, cpcsubclass
* pctpatentnumber (varchar(255)) international patent number (according to Patent Cooperation Treaty)also known as PCT Document Number* appnum(varchar(255)) application number, probably also the filing number - the format is a two digit series code followed by a six digit serial number (source: https://www.uspto.gov/patents-application-process/filing-online/info-application-number)* appdate (date) date that the application was filed, including year- probably also the filing date
* ipcrsubclass (varchar(255)) International patent classification subclass
* ipcrmaingroup (varchar(255)) International patent classification main group
* ipcrsubgroup (varchar(255)) International patent classification subgroup
* ipcrtotal (varchar(255)) concatenated version ipcrsubgroup, ipcrsubclass, ipcrmaincroup
* national_classification (varchar(255)) - probably uspc, which is United States Patent Classification
* natioanl_classification_country (varchar(255)) - should be United States
* num_claims (int) number of claims
Discrepancies:
