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.