ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpatialOffsets

An explicit spatial relationship between a sampling feature relative t...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	SpatialOffsetID	Integer				Primary Key of SpatialOffset
	SpatialOffsetTypeCV	VarChar(255)				Type of SpatialOffset, such as Depth, DepthInterval, HorizaontalRadial
	Offset1Value	Float				Numerical value for 1st SpatialOffset, which is defined by SpatialOffsetType
	Offset1UnitID	Integer				Units for 1st SpatialOffset, which is defined by SpatialOffsetType
	Offset2Value	Float				Numerical value for 2nd SpatialOffset, which is defined by SpatialOffsetType
	Offset2UnitID	Integer				Units for 2nd SpatialOffset, which is defined by SpatialOffsetType
	Offset3Value	Float				Numerical value for 3rd SpatialOffset, which is defined by SpatialOffsetType
	Offset3UnitID	Integer				Units for 3rd SpatialOffset, which is defined by SpatialOffsetType

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpatialOffsets_CV_SpatialOffsetType	ODM2CV.CV_SpatialOffsetType	ODM2SamplingFeatures.SpatialOffsets	Name	SpatialOffsetTypeCV
fk_SpatialOffsets_Offset1Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset1UnitID
fk_SpatialOffsets_Offset2Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset2UnitID
fk_SpatialOffsets_Offset3Units	ODM2Core.Units	ODM2SamplingFeatures.SpatialOffsets	UnitsID	Offset3UnitID

Parent Relations
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_FeatureParents_SpatialOffsets	ODM2SamplingFeatures.SpatialOffsets	ODM2SamplingFeatures.RelatedFeatures	SpatialOffsetID	SpatialOffsetID

Triggers (none)

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2SamplingFeatures