ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

TaxonomicClassifierExternalIdentifiers

(Table)

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	TaxonomicClassifierID	Integer				Foreign Key to TaxonomicClassifiers
	ExternalIdentifierSystemID	Integer				Foreign Key to ExternalIdentifierSystems
	TaxonomicClassifierExternalIdentifier	VarChar(255)				A resolvable, globally unique ID, such as a GBIF ID; could be a Uniform Resource Name (URN).
	TaxonomicClassifierExternalIdentifierURI	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_TaxonomicClassifierExtIDs_ExtIDSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.TaxonomicClassifierExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_TaxonomicClassifierExtIDs_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2ExternalIdentifiers.TaxonomicClassifierExternalIdentifiers	TaxonomicClassifierID	TaxonomicClassifierID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2ExternalIdentifers