ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

ProfileResultValues

Numeric values of Depth Profile Results.

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ValueID	BigInt
	ResultID	BigInt
	DataValue	Float
	ValueDateTime	DateTime
	ValueDateTimeUTCOffset	Integer
	ZLocation	Float
	ZAggregationInterval	Float
	ZLocationUnitsID	Integer
	CensorCodeCV	VarChar(255)
	QualityCodeCV	VarChar(255)
	TimeAggregationInterval	Float
	TimeAggregationIntervalUnitsID	Integer

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ProfileResultValues_AIUnits	ODM2Core.Units	ODM2Results.ProfileResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_ProfileResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.ProfileResultValues	Name	CensorCodeCV
fk_ProfileResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.ProfileResultValues	Name	QualityCodeCV
fk_ProfileResultValues_DUnits	ODM2Core.Units	ODM2Results.ProfileResultValues	UnitsID	ZLocationUnitsID
fk_ProfileResultValues_ProfileResults	ODM2Results.ProfileResults	ODM2Results.ProfileResultValues	ResultID	ResultID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ProfileResultValueAnnotations_ProfileResultValues	ODM2Results.ProfileResultValues	ODM2Annotations.ProfileResultValueAnnotations	ValueID	ValueID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2OverviewSimplified

ODM2Results