Revision 8556
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 198 | 198 |
CREATE TABLE IF NOT EXISTS `taxon_assertion` ( |
| 199 | 199 |
`id` TEXT NOT NULL , |
| 200 | 200 |
`string` TEXT NOT NULL , |
| 201 |
`taxon_concept` TEXT NULL , |
|
| 201 | 202 |
PRIMARY KEY (`id`) , |
| 202 | 203 |
INDEX `fk_taxon_assertion_taxon_string1` (`string` ASC) , |
| 204 |
INDEX `fk_taxon_assertion_taxon_concept1` (`taxon_concept` ASC) , |
|
| 203 | 205 |
CONSTRAINT `fk_qualified_taxon_record1` |
| 204 | 206 |
FOREIGN KEY (`id` ) |
| 205 | 207 |
REFERENCES `record` (`id` ) |
| ... | ... | |
| 209 | 211 |
FOREIGN KEY (`string` ) |
| 210 | 212 |
REFERENCES `taxon_string` (`string` ) |
| 211 | 213 |
ON DELETE CASCADE |
| 214 |
ON UPDATE CASCADE, |
|
| 215 |
CONSTRAINT `fk_taxon_assertion_taxon_concept1` |
|
| 216 |
FOREIGN KEY (`taxon_concept` ) |
|
| 217 |
REFERENCES `taxon_concept` (`id` ) |
|
| 218 |
ON DELETE CASCADE |
|
| 212 | 219 |
ON UPDATE CASCADE) |
| 213 | 220 |
ENGINE = InnoDB |
| 214 | 221 |
DEFAULT CHARACTER SET = latin1 |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_assertion: added fkey to taxon_concept/taxon_path to store any parsed taxonomic fields provided by the data provider