377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 11:13, 28 September 2017
, 11:13, 28 September 2017→Assignment Database Structure
More extensive notes exist under :E/McNair/Projects/Redesigning Patent Database/New Patent Database Project/Notes on USPTO Assignment Data Paper
==Patent Database Structure==
Most of this design is based off what I investigated last semester and therefore is subject to change, since the design for the Assignment database is somewhat new.
The foreign key that connects every table is patent_number, which uniquely identifies every patent in the PATENT table and is included in every table.
===PATENT===
Purpose: represent patents – central table for the database
Each entry represents: an individual patent
Primary key: patent_number
All columns (variables): patent_number, grantdate, prioritydate, prioritycountry, prioritypatentnumber, cpcsubgroup, pctpatentnumber, claims, appnum, grantyear, appdate, appyear, nber, uspc, uspc_sub
==Connecting Patent database and Assignment database==
