1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 17:45, 2 May 2017
, 17:45, 2 May 2017→Data Cleanup Progress
ALTER TABLE ptoproperty_pub RENAME COLUMN documentid TO pubno;
All three tables contain the following information and differ only on the type of patent id.
Table "public.ptoproperty_patent"
Column | Type | Modifiers
-----------------+------------------------+-----------
reelno | integer |
frameno | integer |
documentid | character varying(20) |
country | character varying(500) |
kind | character varying(3) |
filingdate | date |
invention_title | character varying(500) |
===Ptotracking Tables===
