Difference between revisions of "Assignment Table"
Jump to navigation
Jump to search
Line 34: | Line 34: | ||
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 is the patent number assigned. The names of each assignee and assignor involved in the assignment are given in the table. The table has a composite key consisting of reel number, frame number, and recdate. | 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 is the patent number assigned. The names of each assignee and assignor involved in the assignment are given in the table. The table has a composite key consisting of reel number, frame number, and recdate. | ||
==Current Problems== | ==Current Problems== | ||
+ | |||
+ | [[Category: Internal]] | ||
+ | [[Internal Classification: Legacy| ]] |
Latest revision as of 17:17, 2 September 2016
Return to USPTOAssigneesData.
Table Purpose
The Assignment Table brings the information in the Assignee, Assignor, and Patent Id Tables together in a more usable format. The most relevant properties of an assignment are included in the table.
Table Structure
Table "public.assignment" Column | Type | Modifiers ---------+------------------------+----------- reel | integer | frame | integer | recdate | date | patent | integer | assignee | character varying(500) | assignor | character varying(500) |
Example of table entries:
reel | frame | recdate | patent | assignee | assignor ------+-------+------------+---------+--------------------------------------------+-------------------------------- 4974 | 662 | 1988-10-18 | 9999999 | PHYSICAL OPTICS CORPORATION, A CORP. OF CA | JANNSON, TOMASZ P. 4974 | 662 | 1988-10-18 | 9999999 | PHYSICAL OPTICS CORPORATION, A CORP. OF CA | JANNSON, JOANNA L. 18015 | 523 | 2006-06-30 | 9933719 | NUFLARE TECHNOLOGY, INC. | TOSHIBA KIKAI KABUSHIKI KAISHA 10425 | 882 | 1999-12-06 | 9925487 | UNITED STATES AIR FORCE | SARNOFF CORPORATION 11177 | 159 | 2000-09-14 | 9907141 | UNITED STATES OF AMERICA | CAL DIVE I-TITLE XI, INC. 11177 | 159 | 2000-09-14 | 9907141 | UNITED STATES OF AMERICA | CAL DIVE INTERNATIONAL, INC. 13036 | 521 | 2002-06-25 | 9903592 | DARBY & DARBY | Z.P.M. INC. 13011 | 193 | 2002-06-19 | 9827659 | REGIMENT CAPITAL II, L.P. | ORMET CORPORATION 13036 | 521 | 2002-06-25 | 9824727 | DARBY & DARBY | Z.P.M. INC. 12653 | 532 | 2002-02-25 | 9808340 | COLGATE-PALMOLIVE COMPANY | CAO, HOAI-CHAU
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 is the patent number assigned. The names of each assignee and assignor involved in the assignment are given in the table. The table has a composite key consisting of reel number, frame number, and recdate.