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

PersonExternalIdentifiersCross reference "linking" table to allow many to many

PKNameData TypeNULLsA/NDefaultCommentFK

BridgeIDInteger

Primary key for a bridge table, enabling many-to-many joins.
PersonIDInteger Foreign Key to People table

ExternalIdentifierSystemIDInteger Foreign Key to ExternalIdentifierSystems

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

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


NameParent TableChild TableParent ColumnsChild Columns
fk_PersonExternalIdentifiers_ExternalIdentifierSystemsODM2ExternalIdentifiers.ExternalIdentifierSystemsODM2ExternalIdentifiers.PersonExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID
fk_PersonExternalIdentifiers_PeopleODM2Core.PeopleODM2ExternalIdentifiers.PersonExternalIdentifiersPersonIDPersonID


Diagram Name
ODM2ExternalIdentifers