377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 10:16, 3 October 2017
, 10:16, 3 October 2017→Patent Database Structure
All columns (variables):
* patent_number (varchar(255))unique identifier for the patent from the UPSTO office, can contain letters hence varchar* cited_patent_number (varchar(255))unique identifier from the UPSTO office for the patent being cited
===FEE===
Primary key: patent_number
All columns: * patent_number(varchar(255)) unique identifier for the patent from the UPSTO office, can contain letters hence varchar * four, (boolean) payment of maintenance fee 4th year* eight, (boolean) payment of maintenance fee 8th year* twelve, (boolean) payment of maintenance fee 12th year* fee_date, (date) date that fee is paid on* fee_code(varchar(255)) code for type of fee to pay
===CLAIMS===
