Changes

 '''Patentdata Schema:''' Column | Type | Modifiers- --------+-------------------+-----------

  '''Patent_2015 Schema:'''

'''Combined Schema:'''

Column NamesThe final schema of the patents table is : patent int, kind varchar, claims int, apptype int, appnum int, gdate date, gyear int, appdate date, appyear int

patentnumber intAdditionally, three columns -- patent kind varchar, -- kind grantdate datenber, --gdate type varcharuspc, applicationnumber varcharuspc_sub have been added from the historicalpatentdata, 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 CREATE TABLE patents_merged( 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, claims int, apptype int, appnum int, gyear int, appdate date, appyear int );a table built from data downloaded from the USPTO Bulk Data Storage. The join was executed on the patent number.