ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpatialReferenceExternalIdentifiers

(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.
	SpatialReferenceID	Integer
	ExternalIdentifierSystemID	Integer
	SpatialReferenceExternalIdentifier	VarChar(255)
	SpatialReferenceExternalIdentifierURI	VarChar(255)

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpatialReferenceExternalIdentifiers_ExternalIdentifierSystems	ODM2ExternalIdentifiers.ExternalIdentifierSystems	ODM2ExternalIdentifiers.SpatialReferenceExternalIdentifiers	ExternalIdentifierSystemID	ExternalIdentifierSystemID
fk_SpatialReferenceExternalIdentifiers_SpatialReferences	ODM2SamplingFeatures.SpatialReferences	ODM2ExternalIdentifiers.SpatialReferenceExternalIdentifiers	SpatialReferenceID	SpatialReferenceID

Parent Relations (none)

Used in Diagrams

Diagram Name

ODM2ExternalIdentifers