Metatables

There are three metatables which contain the relationships between LoggerNet and the database: lndbstationmeta, lndbtablemeta, and lndbcolumnmeta.

lndbstationmeta

Information for every station for which data has been or will be stored.

stationID - primary key

lnStationName - LoggerNet station name

lndbtablemeta

Information for every database data table that has been or will be written to.

tableID - primary key

LNDBStationMeta_stationID - foreign key referencing lndbstationmeta.stationId

lnTableName - LoggerNet tablename

dbTableName - database tablename

lndbcolumnmeta

Information for every database "data" column that has been or will be written to.

LNDBStationMeta_stationID - foreign key referencing lndbstationmeta.stationID.

LNDBTableMeta_tableID - foreign key referencing lndbtablemeta

lnColumnName - datalogger column name (from LoggerNet)

dbColumnName - Database column name

process - process as defined in datalogger program

units - units as defined in datalogger program

dataType - datalogger column's data type

columnOrder - actual order in datalogger table definitions

active - true if data for the column should be stored