ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

Sites

Describes sampling features that are point sites

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	SamplingFeatureID	Integer				Foreign key identifier of the Sampling Feature that is the Site
	SiteTypeCV	VarChar(255)				A CV term describing the site type
	Latitude	Float				Latitude of the site
	Longitude	Float				Longitude of the site
	SpatialReferenceID	Integer				Foreign key identifier for the Spatial Reference System that describes the latitude and longitude coordinates

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_Sites_CV_SiteType	ODM2CV.CV_SiteType	ODM2SamplingFeatures.Sites	Name	SiteTypeCV
fk_Sites_SamplingFeatures	ODM2Core.SamplingFeatures	ODM2SamplingFeatures.Sites	SamplingFeatureID	SamplingFeatureID
fk_Sites_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2SamplingFeatures.Sites	SpatialReferenceID	SpatialReferenceID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2OverviewSimplified

ODM2SamplingFeatures