154
edits
Changes
Jump to navigation
Jump to search
patent_2015 | patentdata --------------+-------------- orgname | assignee city | city country | country patentnumber | patent state | state
Column | Type | Modifiers ---------------+-------------------+----------- lastname | character varying | firstname | character varying | address | character varying | postcode | character varying | orgname | character varying | city | character varying | country | character varying | patentnumber | integer | state | character varying | patentcountry | character varying | nationality2 | character varying | residence | character varying | asgseq | integer | asgtype | integer |
Patent Data Processing - SQL Steps (view source)
Revision as of 12:33, 6 July 2016
, 12:33, 6 July 2016→Assignees Data
'''Overlapping Columns'''
These columns will have entries for most rows in the table, because they exist in both tables. The rest of the columns will be populated based on which table the row is coming from.
'''Final Schema'''
Table "public.assignees"
'''Non-overlapping Columns'''
