ODMX [ODMX_DBWrench_Schema.xml]
This cross-reference table allows Taxonomic Classification of Specimens as an annotation, rather than as a Result.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| BridgeID | Integer |
| nextval('"ODMXSamplingFeatures"."SpecimenTaxonomicClassifiers_BridgeID_seq"'::regclass) | 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. |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SpecimenTaxonomicClassifiers_Citations | ODMXProvenance.Citations | ODMXSamplingFeatures.SpecimenTaxonomicClassifiers | CitationID | CitationID |
| fk_SpecimenTaxonomicClassifiers_Specimens | ODMXSamplingFeatures.Specimens | ODMXSamplingFeatures.SpecimenTaxonomicClassifiers | SamplingFeatureID | SamplingFeatureID |
| fk_SpecimenTaxonomicClassifiers_TaxonomicClassifiers | ODMXCore.TaxonomicClassifiers | ODMXSamplingFeatures.SpecimenTaxonomicClassifiers | TaxonomicClassifierID | TaxonomicClassifierID |
(none)
| Diagram Name |
| ODMXSamplingFeatures |