ODMXEquipment - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: ODMXEquipment

Tables

Table NameComment
CalibrationActionsInformation about calibration Actions
CalibrationReferenceEquipmentInformation about equipment used as referenece for a calibration
CalibrationStandardsBridge table linking field calibrations to the reference materials used
DataloggerFileColumnsInformation about columns in datalogger files
DataloggerFilesDestibes datalogger files created by a deployment action
DataloggerProgramFilesInformation about datalogger program files
EquipmentDescriptions of specific pieces of equipment.
EquipmentModelsDescribes models of sensors, loggers, and related equipment used in making observations.
EquipmentPersonsBridgeBridge between Equipment and Person
EquipmentPositionA table which gives the position of equipment relative to its parent equipment or sampling feature
EquipmentUsed
HeartbeatThis table provides update on the system connectivity status
InstrumentOutputQuantityKindInformation about the QuantityKind that an instrument is capable of measuring
MaintenanceActionsInformation about maintenance Actions performed on Equipment
RelatedEquipmentInformation about relationships among Equipment

Procedures

(none)

Views

(none)

Sequences

NameComment
CalibrationReferenceEquipment_BridgeID_seqDbWrench Autogenerated Sequence.
CalibrationStandards_BridgeID_seqDbWrench Autogenerated Sequence.
DataloggerFileColumns_DataloggerFileColumnID_seqDbWrench Autogenerated Sequence.
DataloggerFiles_DataloggerFileID_seqDbWrench Autogenerated Sequence.
DataloggerProgramFiles_ProgramID_seqDbWrench Autogenerated Sequence.
Equipment_EquipmentID_seqDbWrench Autogenerated Sequence.
EquipmentModels_EquipmentModelID_seqDbWrench Autogenerated Sequence.
EquipmentUsed_BridgeID_seqDbWrench Autogenerated Sequence.
InstrumentOutputVariables_InstrumentOutputVariableID_seqDbWrench Autogenerated Sequence.
RelatedEquipment_RelationID_seqDbWrench Autogenerated Sequence.