SpecimenTaxonomicClassifiers - Table
Home|Tables|Schemas|Diagrams|Foreign Keys|Indexes

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

PKNameData TypeNULLsA/NDefaultCommentFK

BridgeIDInteger

Primary key for a bridge table, enabling many-to-many joins.
SamplingFeatureIDInteger Foreign key to SamplingFeatures.Specimens.

TaxonomicClassifierIDInteger Foreign key to TaxonomicClassifiers.

CitationIDInteger

Foreign key to the attribution, or Citation, for the classification.



NameParent TableChild TableParent ColumnsChild Columns
fk_SpecimenTaxonomicClassifiers_CitationsODM2Provenance.CitationsODM2SamplingFeatures.SpecimenTaxonomicClassifiersCitationIDCitationID
fk_SpecimenTaxonomicClassifiers_SpecimensODM2SamplingFeatures.SpecimensODM2SamplingFeatures.SpecimenTaxonomicClassifiersSamplingFeatureIDSamplingFeatureID
fk_SpecimenTaxonomicClassifiers_TaxonomicClassifiersODM2Core.TaxonomicClassifiersODM2SamplingFeatures.SpecimenTaxonomicClassifiersTaxonomicClassifierIDTaxonomicClassifierID


Diagram Name
ODM2SamplingFeatures