ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

PointCoverageResultValues

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	ValueID	BigInt
	ResultID	BigInt
	DataValue	Double
	ValueDateTime	DateTime
	ValueDateTimeUTCOffset	Integer
	XLocation	Float
	XLocationUnitsID	Integer
	YLocation	Float
	YLocationUnitsID	Integer
	CensorCodeCV	VarChar(255)
	QualityCodeCV	VarChar(255)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_PointCoverageResultValues_CV_CensorCode	ODM2CV.CV_CensorCode	ODM2Results.PointCoverageResultValues	Name	CensorCodeCV
fk_PointCoverageResultValues_CV_QualityCode	ODM2CV.CV_QualityCode	ODM2Results.PointCoverageResultValues	Name	QualityCodeCV
fk_PointCoverageResultValues_PointCoverageResults	ODM2Results.PointCoverageResults	ODM2Results.PointCoverageResultValues	ResultID	ResultID
fk_PointCoverageResultValues_XUnits	ODM2Core.Units	ODM2Results.PointCoverageResultValues	UnitsID	XLocationUnitsID
fk_PointCoverageResultValues_YUnits	ODM2Core.Units	ODM2Results.PointCoverageResultValues	UnitsID	YLocationUnitsID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_PointCoverageResultValueAnnotations_PointCoverageResultValues	ODM2Results.PointCoverageResultValues	ODM2Annotations.PointCoverageResultValueAnnotations	ValueID	ValueID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2Annotations

ODM2Results