ODMX [ODMX_DBWrench_Schema.xml]
Information about columns in datalogger files
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| DataloggerFileColumnID | Integer |
| nextval('"ODMXEquipment"."DataloggerFileColumns_DataloggerFileColumnID_seq"'::regclass) | Primary key identifier | ||
| ResultID | BigInt |
| Foreign key identifier for the Result associated with the datalogger file column |
|
|||
| DataloggerFileID | Integer | Foreign key identifier for the datalogger file in which the column appears |
|
||||
| InstrumentOutputQuantityKindID | Integer | Foreign key identifier for the instrument output variable recorded in the column |
|
||||
| ColumnLabel | VarChar() | Text column label | |||||
| ColumnDescription | VarChar() |
| Text description of the contents of the column | ||||
| MeasurementEquation | VarChar() |
| Text specificaiton of the equation used to calculate the column contents | ||||
| ScanInterval | Float |
| Scanning time interval used in the datalogger program | ||||
| ScanIntervalUnitsID | Integer |
| Foreign key identifier for the Units of the scanning time interval | ||||
| RecordingInterval | Float |
| Recording time interval used in the datalogger program | ||||
| RecordingIntervalUnitsID | Integer |
| Foreign key identifier for the Units of the recording time interval | ||||
| AggregationStatisticCV | VarChar() |
|
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DataloggerFileColumns_CV_AggregationStatistic | ODMXCV.CV_AggregationStatistic | ODMXEquipment.DataloggerFileColumns | Term | AggregationStatisticCV |
| fk_DataloggerFileColumns_DataloggerFiles | ODMXEquipment.DataloggerFiles | ODMXEquipment.DataloggerFileColumns | DataloggerFileID | DataloggerFileID |
| fk_DataloggerFileColumns_InstrumentOutputQuantityKind | ODMXEquipment.InstrumentOutputQuantityKind | ODMXEquipment.DataloggerFileColumns | InstrumentOutputQuantityKindID | InstrumentOutputQuantityKindID |
| fk_DataloggerFileColumns_Results | ODMXCore.Results | ODMXEquipment.DataloggerFileColumns | ResultID | ResultID |
(none)
| Diagram Name |
| ODMXEquipment |