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			nextval('"ODM2SamplingFeatures"."SpatialOffsets_SpatialOffsetID_seq"'::regclass)	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	Term	SpatialOffsetTypeCV

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