Data Dictionary

[mike_phillips urscorp com]

Here are my first thoughts on the data dictionary. A lot more of the 
detail will come out once I dive fully into the DAFIF files to find all 
the information. 

Mike

#  Proposed data dictionary for fplan
#  Mike Phillips, 2001

There will be at least two different data dictionaries. All
supported databases will support at least the classic and 
enhanced data sets. This does include the current flat files.
This will require the writing of some relational lookups for
the flat file system, but that shouldn't be too much of a
problem.

The type of system being used will be either be selected from a menu
or passed in as a command line option. (I did consider making it part
of the flight plan file itself, but you may want to run the enhanced
databases on the flight plan on a PC and the same flight plan on the
classic files while in the air.)

The first, called "classic" is identical to the existing files.

1. Airports
        Identifier
        Location
        Name 
        Elevation
        MagVar degress
        MagVar minutes
        Lat degrees
        Lat minutes
        Long degrees
        Long minutes
        CTAF
        Additional Information

2. VORS
        Identifier
        Name
        Frequency
        Elevation
        MagVar degrees
        MagVar minutes
        Lat degrees
        Lat minutes
        Long degrees
        Long minutes
        Navaid or fix type
        Comments

The second, called "enhanced" will contain ALL the information
that we may require to use, either now or in the future. The
format of the files will be based heavily on the DAFIF files to make
conversion from DAFIF easier. 

In fact, its probably better for the moment for people to simply check
out the DAFIF data dictionaries.

This data set will also include the files for miscellaneous items 
such as aircraft information, pilot information, etc. 

Aircraft:
        Registration
        Make
        Type
        Equipment 
        Color
        Fuel Capacity
        Fuel Usage Rate (for multiple configurations)
        Speeds (Vso,Vs,Va,Vne,Vfe,Vx,Vy, etc, etc.)
        Checklists 
        Weight and Balance Information
                W&B will be based on the use of several moments (as many
                as required really. Probably at least four: base datum
                engine, fuel, pilot. 

Pilot:
        Name
        License Type and #
        Medical Cert Type and #
        Medical Cert Expire
        Ratings
        Log information
                The log information will be the same as the pilots 
logbook.