ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

MeasurementResults

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ResultID	BigInt
	XLocation	Float
	XLocationUnitsID	Integer
	YLocation	Float
	YLocationUnitsID	Integer
	ZLocation	Float
	ZLocationUnitsID	Integer
	SpatialReferenceID	Integer
	CensorCodeCV	VarChar(255)
	QualityCodeCV	VarChar(255)
	AggregationStatisticCV	VarChar(255)
	TimeAggregationInterval	Float
	TimeAggregationIntervalUnitsID	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MeasurementResults_AIUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	TimeAggregationIntervalUnitsID
fk_MeasurementResults_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.MeasurementResults	Name	AggregationStatisticCV
fk_MeasurementResults_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.MeasurementResults	Name	CensorCodeCV
fk_MeasurementResults_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResults	Name	QualityCodeCV
fk_MeasurementResults_Results	ODM2Core.Results	ODM2Results.MeasurementResults	ResultID	ResultID
fk_MeasurementResults_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2Results.MeasurementResults	SpatialReferenceID	SpatialReferenceID
fk_MeasurementResults_XUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	XLocationUnitsID
fk_MeasurementResults_YUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	YLocationUnitsID
fk_MeasurementResults_ZUnits	ODM2Core.Units	ODM2Results.MeasurementResults	UnitsID	ZLocationUnitsID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MeasurementResultValues_MeasurementResults	ODM2Results.MeasurementResults	ODM2Results.MeasurementResultValues	ResultID	ResultID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2Results