CitationExternalIdentifiers - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: CitationExternalIdentifiers

Columns

PKNameData TypeNULLAutoDefaultCommentFK

BridgeIDInteger

nextval('"ODMXExternalIdentifiers"."CitationExternalIdentifiers_BridgeID_seq"'::regclass)
CitationIDInteger Forign key of the Citation linked to the external identifer

ExternalIdentifierSystemIDInteger Foreign Key to ExternalIdentifierSystems

CitationExternalIdentifierVarChar() A resolvable, globally unique ID, such as a DOI. Could be a Uniform Resource Name (URN).
CitationExternalIdentifierURIVarChar()

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

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_CitationExternalIdentifiers_CitationsODMXProvenance.CitationsODMXExternalIdentifiers.CitationExternalIdentifiersCitationIDCitationID
fk_CitationExternalIdentifiers_ExternalIdentifierSystemsODMXExternalIdentifiers.ExternalIdentifierSystemsODMXExternalIdentifiers.CitationExternalIdentifiersExternalIdentifierSystemIDExternalIdentifierSystemID

Triggers

(none)


Used in Diagrams

Diagram Name
ODMXExternalIdentifiers