DataloggerFileColumns - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

DataloggerFileColumnsInformation about columns in datalogger files

PKNameData TypeNULLsA/NDefaultCommentFK

DataloggerFileColumnIDInteger

Primary key identifier
ResultIDBigInt

Foreign key identifier for the Result associated with the datalogger file column

DataLoggerFileIDInteger Foreign key identifier for the datalogger file in which the column appears

InstrumentOutputVariableIDInteger Foreign key identifier for the instrument output variable recorded in the column

ColumnLabelVarChar(50) Text column label
ColumnDescriptionVarChar(5000)

Text description of the contents of the column
MeasurementEquationVarChar(255)

Text specificaiton of the equation used to calculate the column contents
ScanIntervalFloat

Scanning time interval used in the datalogger program
ScanIntervalUnitsIDInteger

Foreign key identifier for the Units of the scanning time interval

RecordingIntervalFloat

Recording time interval used in the datalogger program
RecordingIntervalUnitsIDInteger

Foreign key identifier for the Units of the recording time interval

AggregationStatisticCVVarChar(255)



NameParent TableChild TableParent ColumnsChild Columns
fk_DataloggerFileColumns_CV_AggregationStatisticODM2CV.CV_AggregationStatisticODM2Equipment.DataloggerFileColumnsNameAggregationStatisticCV
fk_DataloggerFileColumns_DataLoggerFilesODM2Equipment.DataLoggerFilesODM2Equipment.DataloggerFileColumnsDataLoggerFileIDDataLoggerFileID
fk_DataloggerFileColumns_InstrumentOutputVariablesODM2Equipment.InstrumentOutputVariablesODM2Equipment.DataloggerFileColumnsInstrumentOutputVariableIDInstrumentOutputVariableID
fk_DataloggerFileColumns_RecordingUnitsODM2Core.UnitsODM2Equipment.DataloggerFileColumnsUnitsIDRecordingIntervalUnitsID
fk_DataloggerFileColumns_ResultsODM2Core.ResultsODM2Equipment.DataloggerFileColumnsResultIDResultID
fk_DataloggerFileColumns_ScanUnitsODM2Core.UnitsODM2Equipment.DataloggerFileColumnsUnitsIDScanIntervalUnitsID


Diagram Name
ODM2Equipment