Table description for OPR OPERATOR NAME ADDRESS in subject area OPERATOR
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| DSGN_CODE | varchar | 4 | 0 | NO | |
| NAME_ADDRESS_CODE | varchar | 3 | 0 | YES | |
| NAME_ADDRESS_SEQNUM | numeric | 11 | 0 | NO | |
| NAME | varchar | 50 | 0 | YES | |
| TITLE | varchar | 50 | 0 | YES | |
| ADDR1 | varchar | 35 | 0 | YES | |
| ADDR2 | varchar | 35 | 0 | YES | |
| ADDR3 | varchar | 35 | 0 | YES | |
| CITY | varchar | 22 | 0 | YES | |
| STATE | varchar | 2 | 0 | YES | |
| POSTAL_CODE | varchar | 10 | 0 | YES | |
| COUNTRY | varchar | 2 | 0 | YES | |
| FTS_PHONE | varchar | 7 | 0 | YES | |
| PHONE | varchar | 10 | 0 | YES | |
| EXTENSION | varchar | 4 | 0 | YES | |
| FOREIGN_PHONE | varchar | 16 | 0 | YES | |
| AIRPORT_ID | varchar | 4 | 0 | YES | |
| OPSPECS_A6_121 | varchar | 1 | 0 | YES | |
| OPSPECS_A6_135 | varchar | 1 | 0 | YES | |
| CODE_COUNTY | varchar | 22 | 0 | YES | |
| CODE_REGION | varchar | 2 | 0 | YES | |
| CODE_DISTRICT | varchar | 2 | 0 | YES | |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |