Revision 8555
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 124 | 124 |
FOREIGN KEY (`taxon_name` ) |
| 125 | 125 |
REFERENCES `taxon_name` (`name` ) |
| 126 | 126 |
ON DELETE CASCADE |
| 127 |
ON UPDATE CASCADE, |
|
| 128 |
CONSTRAINT `fk_taxon_concept_taxon_string1` |
|
| 129 |
FOREIGN KEY (`taxon_name` ) |
|
| 130 |
REFERENCES `taxon_string` (`string` ) |
|
| 131 |
ON DELETE CASCADE |
|
| 127 | 132 |
ON UPDATE CASCADE) |
| 128 | 133 |
ENGINE = InnoDB |
| 129 | 134 |
DEFAULT CHARACTER SET = latin1 |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: linked taxon_concept directly to taxon_string rather than to child table taxon_name, because it creates unnecessary confusion to have two tables storing taxonomic strings. a taxon_string is anything that can be used as input to TNRS, and may or may not include a cf_aff.