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) |
Used in Diagrams |
Diagram Name |
ODM2SamplingFeatures |