Table description for GPS DATA in subject area AIRPORT
| Home | Free Reports and Queries Fee Based Services Database Description Database Access |
| COLUMN NAME | DATA TYPE | LENGTH | PRECISION | NULLABLE | COMMENT |
|---|---|---|---|---|---|
| SITE_NUMBER | numeric | 65535 | 65531 | YES | SITE NUMBER |
| LOCATION_IDENTIFIER | varchar | 4 | 0 | YES | LOCATION IDENTIFIER |
| PROCEDURE | varchar | 33 | 0 | YES | PROCEDURE |
| AIRPORT_NAME | varchar | 42 | 0 | YES | AIRPORT NAME |
| EFFECTIVE_DATE | date | 4 | 0 | YES | EFFECTIVE DATE |
| UPDATE_DATE | date | 4 | 0 | YES | UPDATE DATE |
| CITY | varchar | 26 | 0 | YES | CITY |
| STATE | varchar | 2 | 0 | YES | STATE |
| AMENDMENT_NUMBER | varchar | 4 | 0 | YES | AMENDMENT NUMBER |
| REGULATION | varchar | 3 | 0 | YES | REGULATION |
| FOREIGN_AIRPORT_NAME | varchar | 21 | 0 | YES | FOREIGN AIRPORT NAME |
| FOREIGN_CITY | varchar | 12 | 0 | YES | FOREIGN CITY |
| COUNTRY | varchar | 20 | 0 | YES | COUNTRY |
| COUNTRY_CODE | varchar | 3 | 0 | YES | COUNTRY CODE |
| TYPE | varchar | 1 | 0 | YES | TYPE |
| ADDED_TIMESTAMP | timestamp | 8 | 0 | NO | |
| MODIFIED_TIMESTAMP | timestamp | 8 | 0 | YES |
| Legal | Copyright 2001 - 2004 AviationDB.com Corp. All Rights Reserved | Contact Us |