ODM2 [ODM2_DBWrench_Schema.xml]

Home

|

Tables

|

Schemas

|

Diagrams

|

Foreign Keys

|

Indexes

---

SpecimenTaxonomicClassifiers

This cross-reference table allows Taxonomic Classification of Specimen...

Columns
PK	Name	Data Type	NULLs	A/N	Default	Comment	FK
	BridgeID	Integer				Primary key for a bridge table, enabling many-to-many joins.
	SamplingFeatureID	Integer				Foreign key to SamplingFeatures.Specimens.
	TaxonomicClassifierID	Integer				Foreign key to TaxonomicClassifiers.
	CitationID	Integer				Foreign key to the attribution, or Citation, for the classification.

Indexes (none)

Foreign Keys
Name	Parent Table	Child Table	Parent Columns	Child Columns
fk_SpecimenTaxonomicClassifiers_Citations	ODM2Provenance.Citations	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	CitationID	CitationID
fk_SpecimenTaxonomicClassifiers_Specimens	ODM2SamplingFeatures.Specimens	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	SamplingFeatureID	SamplingFeatureID
fk_SpecimenTaxonomicClassifiers_TaxonomicClassifiers	ODM2Core.TaxonomicClassifiers	ODM2SamplingFeatures.SpecimenTaxonomicClassifiers	TaxonomicClassifierID	TaxonomicClassifierID

Parent Relations (none)

Triggers (none)

Used in Diagrams

Diagram Name

ODM2SamplingFeatures