377
edits
Changes
Jump to navigation
Jump to search
Redesign Assignment and Patent Database (view source)
Revision as of 10:28, 3 October 2017
, 10:28, 3 October 2017→Patent Database Structure
All columns (variables):
* patent_number (varchar(255)) unique identifier for the patentfrom the UPSTO office, can contain letters hence varchar
* grantdate (date) date that patent was officially granted
* prioritydate (date) date used to established novelty of an invention in regards to other inventions (source: http://www.bios.net/daisy/patentlens/2343.html)
* prioritycountry (varchar(255)) country used to establish novelty of where patent is first filed* prioritypatentnumber, (varchar(255)) placeholder patent number if the patent is published before it is fully approved* cpcsubgroup, (varchar(255)) cooperative patent classification subgroup* pctpatentnumber, claims, (varchar(255)) international patent number (according to Patent Cooperation Treaty)* appnum, (varchar(255)) application number* grantyear, (int) year the patent was granted* appdate, (date) date that the application was filed* appyear, (int) year that the application was filed* nber, (varchar(255)) classification according to the National Bureau of Economic Research (NBER) Patent Citations Data File* uspc, (varchar(255)) United States patent classification* uspc_sub(varchar(255)) United States patent classification subgroup
===ASSIGNEE===
All columns: patent_number, four, eight, twelve, fee_date, fee_code
===CLAIMS===
Purpose: Represent information about the claims for an individual patent
Each entry represents: information about a claim that a patent makes
Primary key: patent_number and claim_id
All columns:
* patent_number (varchar(255))
* claim_id (varchar(255)) id number for the claim
* language (varchar(255)) language of claim
* claim_type (varchar(255)) type of claim
* status (varchar(255))
* claim_text (text) the text of the claim
===HISTPATENT===
