1,181
edits
Changes
Jump to navigation
Jump to search
Table "public.partycount"
recdate | date |
no edit summary
==Table Structure==
Column | Type | Modifiers
------------+---------+-----------
reel | integer |
frame | integer |
recdate | date |
patent | integer |
numassignor | bigint |
numassignee | bigint |
Example of table entries:
reel | frame | patent recdate | patent recdate | numassignor | numassignee ------+-------+---------+---+---------+-------------+------------- 39094 | 222 | 7494254 | 2016-07-07 | 7494254 | 1 | 2 39094 | 578 | 8884582 | 2016-07-07 | 8884582 | 1 | 1 39090 | 698 | 9350624 | 2016-07-07 | 9350624 | 1 | 1 39094 | 73 | 7326866 | 2016-07-07 | 7326866 | 2 | 1 39094 | 423 | 8809526 | 2016-07-07 | 8809526 | 1 | 1 39094 | 578 | 8795876 | 2016-07-07 | 8795876 | 1 | 1 39090 | 591 | 6830898 | 2016-07-07 | 6830898 | 1 | 1 39090 | 591 | 7858335 | 2016-07-07 | 7858335 | 1 | 1 39096 | 156 | 8406275 | 2016-07-07 | 8406275 | 1 | 1 39094 | 578 | 9108497 | 2016-07-07 | 9108497 | 1 | 1
==Table Variables==
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor. The recdate is the date the assignment was recorded by the USPTO. Patent identifies the patent involved in the transaction. Numassignor and numassignee identify how many assignors and assignees were involved in the assignment. The table key is composite consisting of reel, frame, and recdate.
==Current Problems==
