ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpectraResultValues

(Table)

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

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpectraResultValues_AIUnits	ODM2Core.Units	ODM2Results.SpectraResultValues	UnitsID	TimeAggregationIntervalUnitsID
fk_SpectraResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.SpectraResultValues	Name	CensorCodeCV
fk_SpectraResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.SpectraResultValues	Name	QualityCodeCV
fk_SpectraResultValues_SpectraResults	ODM2Results.SpectraResults	ODM2Results.SpectraResultValues	ResultID	ResultID
fk_SpectraResultValues_WUnits	ODM2Core.Units	ODM2Results.SpectraResultValues	UnitsID	WavelengthUnitsID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpectraResultValueAnnotations_SpectraResultValues	ODM2Results.SpectraResultValues	ODM2Annotations.SpectraResultValueAnnotations	ValueID	ValueID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2Results