Sites - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

SitesDescribes sampling features that are point sites

PKNameData TypeNULLsA/NDefaultCommentFK

SamplingFeatureIDInteger Foreign key identifier of the Sampling Feature that is the Site

SiteTypeCVVarChar(255) A CV term describing the site type

LatitudeFloat Latitude of the site
LongitudeFloat Longitude of the site
SpatialReferenceIDInteger Foreign key identifier for the Spatial Reference System that describes the latitude and longitude coordinates



NameParent TableChild TableParent ColumnsChild Columns
fk_Sites_CV_SiteTypeODM2CV.CV_SiteTypeODM2SamplingFeatures.SitesNameSiteTypeCV
fk_Sites_SamplingFeaturesODM2Core.SamplingFeaturesODM2SamplingFeatures.SitesSamplingFeatureIDSamplingFeatureID
fk_Sites_SpatialReferencesODM2SamplingFeatures.SpatialReferencesODM2SamplingFeatures.SitesSpatialReferenceIDSpatialReferenceID


Diagram Name
ODM2OverviewSimplified
ODM2SamplingFeatures