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

ReferenceMaterialExternalIdentifiers(Table)

PKNameData TypeNULLsA/NDefaultCommentFK

BridgeIDInteger

Primary key for a bridge table, enabling many-to-many joins.
ReferenceMaterialIDInteger Foreign Key to ReferenceMaterials

ExternalIdentifierSystemIDInteger Foreign Key to ExternalIdentifierSystems

ReferenceMaterialExternalIdentifierVarChar(255) A resolvable, globally unique ID, such as NBS-19; could be a Uniform Resource Name (URN).
ReferenceMaterialExternalIdentifierURIVarChar(255)

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


NameParent TableChild TableParent ColumnsChild Columns
fk_RefMaterialExtIdentifiers_ExtIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_RefMaterialExtIdentifiers_RefMaterialsODM2DataQuality.ReferenceMaterialsODM2ExternalIdentifiers.ReferenceMaterialExternalIdentifiersReferenceMaterialIDReferenceMaterialID


Diagram Name
ODM2ExternalIdentifers