ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

InstrumentOutputQuantityKind

Information about the QuantityKind that an instrument is capable of me...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	InstrumentOutputQuantityKindID	Integer			nextval('"ODM2Equipment"."InstrumentOutputVariables_InstrumentOutputVariableID_seq"'::regclass)	Primary key identifier
	EquipmentModelID	Integer				Foreign key identifier of the Equipment Model
	QuantityKind	VarChar(255)				Foreign key identifier of the QuantityKind measured by the Equipment
	InstrumentResolution	VarChar(255)				Text description of the resolution of the output variable
	InstrumentAccuracy	VarChar(255)				Text description of the accuracy of the output variable
	InstrumentRawOutputUnitsID	Integer				Foreign key identifier of the raw output Units associated with the output variable
	InstrumentStandardOutputVariable	Integer				In many cases the instrument generated a standard variable (e.g. air temperature or soil moisture) in addition to its quantitykind output. This is an optional link, but provided here
	InstrumentMethodID	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_InstrumentOutputQuantityKind_Methods	ODM2Core.Methods	ODM2Equipment.InstrumentOutputQuantityKind	MethodID	InstrumentMethodID
fk_InstrumentOutputQuantityKind_Variables	ODM2Core.Variables	ODM2Equipment.InstrumentOutputQuantityKind	VariableID	InstrumentStandardOutputVariable
fk_InstrumentOutputVariables_CV_QuantityKind	ODM2CV.CV_QuantityKind	ODM2Equipment.InstrumentOutputQuantityKind	Term	QuantityKind
fk_InstrumentOutputVariables_CV_Units	ODM2CV.CV_Units	ODM2Equipment.InstrumentOutputQuantityKind	UnitsID	InstrumentRawOutputUnitsID
fk_InstrumentOutputVariables_EquipmentModels	ODM2Equipment.EquipmentModels	ODM2Equipment.InstrumentOutputQuantityKind	EquipmentModelID	EquipmentModelID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_CalibrationActions_InstrumentOutputVariables	ODM2Equipment.InstrumentOutputQuantityKind	ODM2Equipment.CalibrationActions	InstrumentOutputQuantityKindID	InstrumentOutputVariableID
fk_DataloggerFileColumns_InstrumentOutputQuantityKind	ODM2Equipment.InstrumentOutputQuantityKind	ODM2Equipment.DataloggerFileColumns	InstrumentOutputQuantityKindID	InstrumentOutputQuantityKindID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Equipment