Changes

Jump to navigation Jump to search
no edit summary
--3818842
Note : The assignees table was updated on 6/23 to remove the 'null' string and the '-1' values.
 --  ==Patents ==
Patentdata:
appdate | date |
appyear | integer |
 
Column Names:
patent int,
kind varchar,
claims int,
apptype int,
appnum int,
gdate date,
gyear int,
appdate date,
appyear int
 
 
filename | varchar |
Column Names:
patentnumber int,
kind varchar,
grantdate date,
type varchar,
applicationnumber varchar,
filingdate date,
prioritydate date,
prioritycountry varchar,
prioritypatentnumber varchar,
ussubclass varchar,
maingroup varchar,
subgroup varchar,
cpcsubclass varchar,
cpcmaingroup varchar,
cpcsubgroup varchar,
classificationnationalcountry varchar,
classificationnationalclass varchar,
title varchar,
numberofclaims int,
primaryexaminerfirstname varchar,
primaryexaminerlastname varchar,
primaryexaminerdepartment varchar,
pctpatentnumber varchar,
filename varchar
 
Combined Schema:
appdate date,
appyear int
   patentnumber int, -- patent kind varchar, -- kind grantdate date, --gdate type varchar, applicationnumber varchar, filingdate date, prioritydate date, prioritycountry varchar, prioritypatentnumber varchar, ussubclass varchar, maingroup varchar, subgroup varchar, cpcsubclass varchar, cpcmaingroup varchar, cpcsubgroup varchar, classificationnationalcountry varchar, classificationnationalclass varchar, title varchar, numberofclaims int, primaryexaminerfirstname varchar, primaryexaminerlastname varchar, primaryexaminerdepartment varchar, pctpatentnumber varchar, filename varchar claims int, apptype int, appnum int, gyear int, appdate date, appyear int
Output Schema: patents
primaryexaminerdepartment,
pctpatentnumber,
filename,
-1,
-1,
********** ==== INDEX CREATION **************====
ALTER TABLE patents ADD PRIMARY KEY (patentnumber);
CREATE INDEX
    **== Citations==
To Extract Patents with Numbers Only and to Ignore Other RegExes
$$ LANGUAGE plperl;
 
************ Columns *********************
patentdata:
Column | Type | Modifiers

Navigation menu