| 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 |   |
| CONTRACTOR_SEQNUM | numeric | 11 | 0 | NO |   |
| CONTRACTOR_NAME | varchar | 50 | 0 | YES |   |
| CONTRACTOR_FAR | varchar | 7 | 0 | YES |   |
| CONTRACTOR_DSGN_CODE | varchar | 4 | 0 | YES |   |
| CONTRACTOR_TYPE | varchar | 1 | 0 | YES |   |
| ADDRESS1 | varchar | 35 | 0 | YES |   |
| ADDRESS2 | varchar | 35 | 0 | YES |   |
| ADDRESS3 | varchar | 35 | 0 | YES |   |
| CITY | varchar | 22 | 0 | YES |   |
| CONTRACTOR_STATE | varchar | 2 | 0 | YES |   |
| POSTAL_CODE | varchar | 10 | 0 | YES |   |
| CONTRACTOR_COUNTRY | varchar | 2 | 0 | YES |   |
| CONTRACTOR_PHONE | varchar | 10 | 0 | YES |   |
| FAX | varchar | 16 | 0 | YES |   |
| INTERNET_ADDRESS | varchar | 50 | 0 | YES |   |
| FOREIGN_PHONE | varchar | 16 | 0 | YES |   |
| CONTRACTOR_AIRPORT_ID | varchar | 4 | 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 |