.. highlight:: rest

.. _database:

MySql Database
==============

Information about the individual footprint files is contained in a MySQL database.  The structure of the database is::

        mysql> describe info_v11;
        +--------------+-------------------+------+-----+------------+----------------+
        | Field        | Type              | Null | Key | Default    | Extra          |
        +--------------+-------------------+------+-----+------------+----------------+
        | id           | int(11)           | NO   | PRI | NULL       | auto_increment |
        | filename     | varchar(255)      | NO   | MUL | NULL       |                |
        | directory    | varchar(256)      | NO   |     | NULL       |                |
        | version      | varchar(30)       | NO   |     | NULL       |                |
        | type         | varchar(20)       | NO   |     | NULL       |                |
        | subtype      | varchar(25)       | NO   |     | NULL       |                |
        | model        | varchar(20)       | NO   |     | NULL       |                |
        | lat          | float             | NO   |     | NULL       |                |
        | lon          | float             | NO   |     | NULL       |                |
        | surface_elev | float             | NO   |     | 0          |                |
        | agl          | float             | NO   |     | -999       |                |
        | asl          | float             | NO   |     | -999       |                |
        | alt_type     | enum('agl','asl') | NO   |     | NULL       |                |
        | alt_index    | tinyint(4)        | NO   |     | 0          |                |
        | date         | date              | NO   |     | NULL       |                |
        | time         | time              | NO   |     | NULL       |                |
        | obsdate      | date              | NO   |     | 0000-00-00 |                |
        | obstime      | time              | NO   |     | 00:00:00   |                |
        | solardate    | date              | NO   |     | NULL       |                |
        | solartime    | time              | NO   |     | NULL       |                |
        | site_num     | int(11)           | NO   |     | NULL       |                |
        | event_num    | int(11)           | NO   |     | 0          |                |
        | group_num    | int(11)           | NO   |     | 0          |                |
        | operator     | varchar(20)       | NO   |     | NULL       |                |
        +--------------+-------------------+------+-----+------------+----------------+
        24 rows in set (0.00 sec)