==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==