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

MethodExternalIdentifiers(Table)

PKNameData TypeNULLsA/NDefaultCommentFK

BridgeIDInteger

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

ExternalIdentifierSystemIDInteger Foreign Key to ExternalIdentifierSystems

MethodExternalIdentifierVarChar(255) A resolvable, globally unique ID, such as a NEMI method number; could be a Uniform Resource Name (URN).
MethodExternalIdentifierURIVarChar(255)

Uniform Resource Identifier (URI), preferably in the form of a persistent URL that is self-documenting and maintained by the external identifier system.


NameParent TableChild TableParent ColumnsChild Columns
fk_MethodExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.MethodExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_MethodExternalIdentifiers_MethodsODM2Core.MethodsODM2ExternalIdentifiers.MethodExternalIdentifiersMethodIDMethodID


Diagram Name
ODM2ExternalIdentifers