377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 15:10, 19 October 2017
, 15:10, 19 October 2017→Patent Database Structure
Each entry represents: sequence of historical data about an individual patent in PATENT
Primary key: patent_number * patent_number (varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar* pubno(varchar(255)) patent publication number* pubdate(date) date patent was issued* display dispdate (date, ) disposal date for the application* distype(varchar(3)) application status of the patent - ABN for patent term adjustment, ISS for issued, or PEN for pending* exp_dt(date) expiration date of patent* pta(int) length of patent term adjustment (which extends the amount of time the patent is allowed to be in force) in number of days
==Connecting Patent database and Assignment database==
