Data Base Explorer abbreviations

[leomicen]

my friends:
 I would like to inform the meaning of the abbreviations in the Data Base Explorer as an example: P4, P3, PT, PS, PN, PM, LK, CN, PM ETC as a couple that I may have some information. There are over 50 abbreviations that you can not know what it is and the manual is silent.
 thank you very much.
leonard

[bindeaw]

I don't understand too.

[RodBearden]

Here's all that I know:

Aircraft Table:

MS - Mode-S Code
AR - Aircraft Registration
AT - Aircraft Type (ICAO Code)
AN - Aircraft Name (make and model)
AC - Aircraft Company (Owner)
CN - Constructor's Number / Line Number)
PT - Photographer (first)
LK - Link to first photo
PT2 - Photographer (second)
LK2 - Link to second photo
CO - ???

Actype Table (Table not currently used):

AT - Aircraft Type (ICAO Code)
AN - Aircraft Name (make and model)
AG - Aircraft Group (landplane, amphibian, helicopter etc)

Airlines Table:

CN - Company (airline/operator) name
C3 - ICAO Code
CM - Company Type (not used)
C2 - IATA Code

Airports Table:

P4 - ICAO Code
P3 - IATA Code
PN - Airport Name
PC - Airport name again (?) - don't know how these are used
PS - ?
PT - Country
PM - ?
PA - Centrepoint Latitude
PO - Centrepoint Longitude (used for route lines)

Routes Table:
FN - Flight Number
NO - Origin Airport ICAO Code
ND - Destination Airport (ICAO Code)
NV - Via Airport (ICAO Code)
CH - Date and time record was changed (data will be refreshed 6 months after this date when flight is received again)

I hope someone can fill in my unknowns and correct my mistakes!

Rod

[Runway 31]

In the aircraft table CO = company/owner/operator

Alan

[RodBearden]

Alan - what's the difference between CO and AC, then?

Rod

[Runway 31]

Sorry Rod, we use CO in the updater, I presumed they were the same but having looked in d/b explorer after you asked and  having not noted AC in your list, obviously not. Havent a clue what it is for.

BTW good compilation

Alan

[RodBearden]

Ah well, thanks anyway, Alan.

Rod

[Bell 407]

It's interesting to note that the Airports Table is the only table with the headers in lowercase. All the other tables have their headers in UPPERCASE?