377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 18:53, 10 November 2017
, 18:53, 10 November 2017no edit summary
* Note that I did include some unique attributes for Utility patents as seen below in the "Finding New Paths Unique to Plant, Reissue, and/or Design Patents" section, but for now (11/3/2017) I'm not going to create a separate table for those fields. Most of them seem to be repeated in Reissue, and the other fields, while interesting, are perhaps not very useful.
====DESIGNPLANT=========Fields=====
* patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar
* latin_name (varchar(255)) latin name for the plant
====PLANT====
=====Fields=====
* length_of_grant (int) length of grant, most likely in years
* hague_registration_date (date) filing date of international patent application
* hague_filing_date (date) not necessarily the same as the filing date of the international patent application, this is the date that the International Bureau receives all necessary elements for the international patent application
* hague_registration_pub_date (date) datethat the International Bureau publishes the international patent application
* hague_international_registration_number (varchar(255)) international registration number
* edition (varchar(255)) possibly the edition of the Classification Locarno which determined main_classification
* main_classification (varchar(255)) classification for what type of design the patent is for
==Connecting Patent database and Assignment database==
* Hague Agreement Data (XML45) - allows people to file design patents in 66 countries with one application
** International Registration Date
** International Filing DataDate
** International Registration Publication Date
** International Registration Number
