1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 14:37, 3 May 2017
, 14:37, 3 May 2017→Semester Plan
correspondent_address_4 | character varying(500) |
conveyance_text | character varying(500) |
Table "public.ptoassignee"
Column | Type | Modifiers
-----------+------------------------+-----------
reelno | integer |
frameno | integer |
name | character varying(500) |
addrline1 | character varying(500) |
addrline2 | character varying(500) |
city | character varying(500) |
state | character varying(500) |
country | character varying(500) |
postcode | character varying(80) |
Table "public.ptoassignor"
Column | Type | Modifiers
----------------+------------------------+-----------
reel_no | integer |
frame_no | integer |
assignor_name | character varying(500) |
execution_date | date |
Table "public.ptoproperty"
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) |
Table "public.ptopatentfile"
Column | Type | Modifiers
------------------------+-----------------------+-----------
reel_no | integer |
frame_no | integer |
action_key_code | character varying(10) |
uspto_transaction_date | date |
uspto_date_produced | date |
version | numeric |
==Data Cleanup Progress==
