Changes

|Has title=Redesign Assignment and Patent Database

|Has owner=Shelby Bice,

|Is dependent on=Reproducible Patent Data,

}}

This is an extension of the work I did last semester under "Redesigning Patent Database". Instead of simply reconfiguring the existing database, this project encompasses and full redesign and creation of a new Patent database and a new Assignment database that will be joined together.

==ER Diagram for Assignment and Patent Databases==

Attributes for each table are listed below with descriptions - because of how many attributes there are, I decided the ER diagram would be better suited as an overview of the tables rather than trying to show all the attributes on the diagram.

==Assignment Database Structure==

====PLANT====

=====Fields=====

* latin_name (varchar(255)) latin name for the plant

* us_botanical_variety(varchar(255)) denotes what variety of plant it is - for example, a rose has several different varieties

=====Fields=====

* parent_doc_status (varchar(255)) status of the parent application. Probably related to whether the patent application is pending or not

* parent_doc_number (int) probably application number for the parent document

====DESIGN====

=====Fields=====

* length_of_grant (int) length of grant, most likely in years

* hague_registration_date (date) filing date of international patent application

Also in the paper, they mentioned the Assignments on the Web for Patents (AOTW-P), a searchable database of individual USPTO assignment records keyed on reel-frame identification, patent number, and assignor or assignee name (https://assignment.uspto.gov/patent/index.html#/patent/search). Obviously it would not be possible to individually use this tool to query all the patent numbers, but if it would be possible to write a script to somehow query each patent number using the rf_id and parse the response, this could potentially be useful to check the patent numbers, but might not be any more accurate than what will already be in DOCUMENT_INFO.

Based on Oliver's script which searched all xpaths and compared which were unique to particular types, we see that the following attributes are unique to each type of patents other than utility patents. These attributes vary by the XML version, which changed over time. Therefore, the lists below are a superset of the attributes that are unique to each of the patents types listed below across all XML versions.

** Address

* US Provisional Application Status (XML41)