ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

TimeSeriesResultValues

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ValueID	BigInt			nextval('"ODM2Results"."TimeSeriesResultValues_ValueID_seq"'::regclass)
	ResultID	BigInt
	DataValue	Float
	ValueDateTime	DateTime
	ValueDateTimeUTCOffset	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_TimeSeriesResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.TimeSeriesResultValues	Term	CensorCodeCV
fk_TimeSeriesResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.TimeSeriesResultValues	Term	QualityCodeCV
fk_TimeSeriesResultValues_TimeSeriesResults	ODM2Results.TimeSeriesResults	ODM2Results.TimeSeriesResultValues	ResultID	ResultID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_TimeSeriesResultValueAnnotations_TimeSeriesResultValues	ODM2Results.TimeSeriesResultValues	ODM2Annotations.TimeSeriesResultValueAnnotations	ValueID	ValueID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2OverviewSimplified

ODM2Results

ODM2Simulation