7,649
edits
Changes
Jump to navigation
Jump to search
Patent Data Processing - SQL Steps (view source)
Revision as of 15:20, 21 June 2016
, 15:20, 21 June 2016no edit summary
** Assignees Data:
CREATE TABLE assignees_temp2 (
lastname varchar,
firstname varchar,
asgseq int,
asgtype integer
);
PatentData:
Column | Type | Modifiers
-------------+-------------------+-----------
patent | integer |
asgtype | integer |
Patent_2015:
Column | Type | Modifiers
---------------+---------+-----------
lastname | text |
firstname | text |
Patentdata: Column | Type | Modifiers ---------+-------------------+-----------
patent | integer |
kind | character varying |
