ExternalIdentifierSystems - Table

ODMX [ODMX_DBWrench_Schema.xml]

Home Tables Schemas Diagrams Foreign Keys Indexes

Table: ExternalIdentifierSystems

A single table for connecting various primary keys with points to outside systems.

Columns

PK	Name	Data Type	NULL	Auto	Default	Comment	FK
	ExternalIdentifierSystemID	Integer			nextval('"ODMXExternalIdentifiers"."ExternalIdentifierSystems_ExternalIdentifierSystemID_seq"'::regclass)	Primary key identifier
	ExternalIdentifierSystemName	VarChar()				Defines the identifier system used (i.e. IGSN, SWRC Sample Number, etc.)
	IdentifierSystemOrganizationID	Integer				Foreign Key identifer for the organization overseeing or affiliated with the identifier system
	ExternalIdentifierSystemDescription	VarChar()				Description of identifier system.
	ExternalIdentifierSystemURL	VarChar()				Universal Resource Locator (URL) for resolution/translation of an identifier system's URNs (i.e. http://dx.doi.org/ is the resolver URL for doi:10.1002/2013GL057450)

Indexes

(none)

Foreign Keys

Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_ExternalIdentifierSystems_Organizations	ODMXCore.Organizations	ODMXExternalIdentifiers.ExternalIdentifierSystems	OrganizationID	IdentifierSystemOrganizationID

Triggers

(none)

Used in Diagrams

ODMXExternalIdentifiers