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

ExternalIdentifierSystemsA single table for connecting various primary keys with points to outs...

PKNameData TypeNULLsA/NDefaultCommentFK

ExternalIdentifierSystemIDInteger

Primary key identifier
ExternalIdentifierSystemNameVarChar(255) Defines the identifier system used (i.e. IGSN, SWRC Sample Number, etc.)
IdentifierSystemOrganizationIDInteger Foreign Key identifer for the organization overseeing or affiliated with the identifier system

ExternalIdentifierSystemDescriptionVarChar(5000)

Description of identifier system.
ExternalIdentifierSystemURLVarChar(255)

Universal Resource Locator (URL) for resolution/translation of an identifier system's URNs (i.e. http://dx.doi.org/ is the resolver URL for doi:10.1002/2013GL057450)


NameParent TableChild TableParent ColumnsChild Columns
fk_ExternalIdentifierSystems_OrganizationsODM2Core.OrganizationsODM2ExternalIdentifiers.ExternalIdentifierSystemsOrganizationIDIdentifierSystemOrganizationID

NameParent TableChild TableParent ColumnsChild Columns
fk_CitationExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.CitationExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_MethodExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.MethodExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_PersonExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.PersonExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_RefMaterialExtIdentifiers_ExtIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_SamplingFeatureExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.SamplingFeatureExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_SpatialReferenceExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.SpatialReferenceExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_TaxonomicClassifierExtIDs_ExtIDSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.TaxonomicClassifierExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_VariableExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.VariableExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID

Diagram Name
ODM2ExternalIdentifers