Assignee Table

From edegan.com
Jump to navigation Jump to search

Table Purpose

Table Structure

         Table "public.assignee"
 Column   |          Type          | Modifiers 

+------------------------+-----------

reel      | integer                | 
frame     | integer                | 
recdate   | date                   | 
assignee  | 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(500) | 

Example of table entries:

reel  | frame |  recdate   |                                         assignee                                          |   country    | postcode 

+-------+------------+-------------------------------------------------------------------------------------------+--------------+----------

15283 |   287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED                                                              | INDIA        | 110019
 5744 |   401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED                                                                | ENGLAND      | SW1Y
 3634 |   874 | 1979-03-02 | PARADYNE CORPORATION                                                                      |              | 33540
 3634 |   875 | 1979-03-02 | PARADYNE CORPORATION                                                                      |              | 33540
 3625 |   888 | 1979-03-05 | NORTHERN TELECOM LIMITED                                                                  | NOT PROVIDED | 
 8613 |   265 | 1979-05-27 | STAHL INTERNATIONAL B.V.                                                                  | NETHERLANDS  | 
 3835 |   710 | 1979-09-07 | KIORITZ CORPORATION, 5-1, SHIMORENJAKU-7-CHOME, MITAKA-SHI, TOKYO, JAPAN A CORP. OF JAPAN |              | 
 3692 |   537 | 1979-09-26 | EHD, INC.                                                                                 |              | 38501
 3696 |   452 | 1979-10-11 | HOWMEDICA, INC.                                                                           | NOT PROVIDED | 
 3818 |   140 | 1980-01-02 | E. EDELMANN & CO.                                                                         |              | 60076

reel | frame | recdate | assignee | addrline1 | addrline2 | city | state


+-------+------------+-------------------------------------------------------------------------------------------+-------------------------+---------------------------------+------------------+-----------

15283 |   287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED                                                              | 19, NEHRU PLACE         |                                 | NEW DELHI        | 
 5744 |   401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED                                                                |                         | NORFOLK HOUSE, ST. JAMES SQUARE | LONDON           | 
 3634 |   874 | 1979-03-02 | PARADYNE CORPORATION                                                                      |                         | 8550 ULMERTON ROAD              | LARGO            | FLORIDA
 3634 |   875 | 1979-03-02 | PARADYNE CORPORATION                                                                      |                         | 8550 ULMERTON ROAD              | LARGO            | FLORIDA
 3625 |   888 | 1979-03-05 | NORTHERN TELECOM LIMITED                                                                  |                         |                                 |                  | 
 8613 |   265 | 1979-05-27 | STAHL INTERNATIONAL B.V.                                                                  |                         | POSTBUS 110, SLUISWEG 10        | 5140 AC WAALWIJK | 
 3835 |   710 | 1979-09-07 | KIORITZ CORPORATION, 5-1, SHIMORENJAKU-7-CHOME, MITAKA-SHI, TOKYO, JAPAN A CORP. OF JAPAN |                         |                                 |                  | 
 3692 |   537 | 1979-09-26 | EHD, INC.                                                                                 | A TENNESSEE CORPORATION | 500 GOULD DRIVE                 | COOKEVILLE       | TENNESSEE
 3696 |   452 | 1979-10-11 | HOWMEDICA, INC.                                                                           |                         |                                 |                  | 
 3818 |   140 | 1980-01-02 | E. EDELMANN & CO.                                                                         | 4711 GOLF RD.           |                                 | SKOKIE           | ILLINOIS

Table Variables

Current Problems