ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

CitationExternalIdentifiers

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer
	CitationID	Integer				Forign key of the Citation linked to the external identifer
	ExternalIdentifierSystemID	Integer				Foreign Key to ExternalIdentifierSystems
	CitationExternalIdentifier	VarChar(255)				A resolvable, globally unique ID, such as a DOI; could be a Uniform Resource Name (URN).
	CitationExternalIdentifierURI	VarChar(255)				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
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_CitationExternalIdentifiers_Citations	ODM2Provenance.Citations	ODM2ExternalIdentifiers.CitationExternalIdentifiers	CitationID	CitationID
fk_CitationExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.CitationExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2ExternalIdentifers