1,181
edits
Changes
Jump to navigation
Jump to search
Patent Assignment Data Restructure (view source)
Revision as of 15:41, 3 May 2017
, 15:41, 3 May 2017→Semester Plan
Column | Type | Modifiers
-------------------------+------------------------+-----------
reelno | integer | frameno | integer | last_update_date | date | purge_indicator | character varying(2) | recorded_date | date | correspondent_name | character varying(500) | correspondent_address_1 | character varying(500) | correspondent_address_2 | character varying(500) | correspondent_address_3 | character varying(500) | 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==
