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

SamplingFeatureExternalIdentifiers(Table)

PKNameData TypeNULLsA/NDefaultCommentFK

BridgeIDInteger

Primary key for a bridge table, enabling many-to-many joins.
SamplingFeatureIDInteger Foreign Key to SamplingFeatures

ExternalIdentifierSystemIDInteger Foreign Key to ExternalIdentifierSystems

SamplingFeatureExternalIdentifierVarChar(255) A resolvable, globally unique ID, such as an IGSN; could be a Uniform Resource Name (URN).
SamplingFeatureExternalIdentifierURIVarChar(255)

Uniform Resource Identifier (URI), preferably in the form of a persistent URL that is self-documenting.


NameParent TableChild TableParent ColumnsChild Columns
fk_SamplingFeatureExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.SamplingFeatureExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_SamplingFeatureExternalIdentifiers_SamplingFeaturesODM2Core.SamplingFeaturesODM2ExternalIdentifiers.SamplingFeatureExternalIdentifiersSamplingFeatureIDSamplingFeatureID


Diagram Name
ODM2ExternalIdentifers