ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

MeasurementResultValues

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ValueID	BigInt			nextval('"ODM2Results"."MeasurementResultValues_ValueID_seq"'::regclass)
	ResultID	BigInt
	DataValue	Float
	ValueDateTime	DateTime
	ValueDateTimeUTCOffset	Integer
	AggregationStatisticCV	VarChar(255)				Controlled vocabulary term
	CensorCodeCV	VarChar(255)				Controlled vocabulary term
	QualityCodeCV	VarChar(255)				Controlled vocabulary term

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MeasurementResultValues_CV_AggregationStatistic	ODM2CV.CV_AggregationStatistic	ODM2Results.MeasurementResultValues	Term	AggregationStatisticCV
fk_MeasurementResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.MeasurementResultValues	Term	CensorCodeCV
fk_MeasurementResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.MeasurementResultValues	Term	QualityCodeCV
fk_MeasurementResultValues_MeasurementResults	ODM2Results.MeasurementResults	ODM2Results.MeasurementResultValues	ResultID	ResultID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_MeasurementResultValueAnnotations_MeasurementResultValues	ODM2Results.MeasurementResultValues	ODM2Annotations.MeasurementResultValueAnnotations	ValueID	ValueID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2OverviewSimplified

ODM2Results