377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 10:50, 26 September 2017
, 10:50, 26 September 2017no edit summary
More extensive notes exist under :E/McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on USPTO Assignment Data Paper
==Connecting Patent database and Assignment database==
The answer to connecting the Patent database to the Assignment database lies somewhere in using the information in the table DOCUMENT_INFO to get a patent_id from the Patent database PATENT table for each assignment in the Assignment database ASSIGNMENT table. The patent_id will be stored in the DOCUMENT_INFO table once it has been found, but it is unclear currently how exactly to use the information in DOCUMENT_INFO to accomplish this.
