Difference between revisions of "Assignment Table"
Jump to navigation
Jump to search
(Created page with "Return to USPTOAssigneesData. ==Table Purpose== ==Table Structure== ==Table Variables== ==Current Problems==") |
|||
| Line 4: | Line 4: | ||
==Table Structure== | ==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== | ==Table Variables== | ||
==Current Problems== | ==Current Problems== | ||
Revision as of 12:46, 27 July 2016
Return to USPTOAssigneesData.
Table Purpose
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
