Difference between revisions of "Assignor Count Table"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
==Table Variables== | ==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. Patent gives the patent number of the patent involved in a specific transaction. Numassignors is the number of assignors involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate. | |
| + | |||
==Current Problems== | ==Current Problems== | ||
Revision as of 10:07, 28 July 2016
Return to USPTOAssigneesData.
Table Purpose
Table Structure
Table "public.assignorcount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignor | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignor ------+-------+------------+---------+------------- 4974 | 662 | 1988-10-18 | 9999999 | 2 18015 | 523 | 2006-06-30 | 9933719 | 1 10425 | 882 | 1999-12-06 | 9925487 | 1 11177 | 159 | 2000-09-14 | 9907141 | 2 13036 | 521 | 2002-06-25 | 9903592 | 1 13011 | 193 | 2002-06-19 | 9827659 | 1 13036 | 521 | 2002-06-25 | 9824727 | 1 12653 | 532 | 2002-02-25 | 9808340 | 6 11566 | 681 | 2001-02-13 | 9802673 | 1 22928 | 276 | 2009-07-06 | 9727320 | 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. Patent gives the patent number of the patent involved in a specific transaction. Numassignors is the number of assignors involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate.
