Revision 8526
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 272 | 272 |
-- ----------------------------------------------------- |
| 273 | 273 |
CREATE TABLE IF NOT EXISTS `taxon_occurrence` ( |
| 274 | 274 |
`id` TEXT NOT NULL , |
| 275 |
`current_taxon_determination` TEXT NULL DEFAULT NULL ,
|
|
| 276 |
`original_taxon_determination` TEXT NULL DEFAULT NULL ,
|
|
| 275 |
`current_determination` TEXT NULL DEFAULT NULL , |
|
| 276 |
`original_determination` TEXT NULL DEFAULT NULL , |
|
| 277 | 277 |
PRIMARY KEY (`id`) , |
| 278 |
INDEX `fk_taxon_occurrence_taxon_determination1` (`original_taxon_determination` ASC) ,
|
|
| 279 |
INDEX `fk_taxon_occurrence_taxon_determination2` (`current_taxon_determination` ASC) ,
|
|
| 278 |
INDEX `fk_taxon_occurrence_taxon_determination1` (`original_determination` ASC) , |
|
| 279 |
INDEX `fk_taxon_occurrence_taxon_determination2` (`current_determination` ASC) , |
|
| 280 | 280 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` |
| 281 |
FOREIGN KEY (`original_taxon_determination` )
|
|
| 281 |
FOREIGN KEY (`original_determination` ) |
|
| 282 | 282 |
REFERENCES `taxon_determination` (`id` ) |
| 283 | 283 |
ON DELETE CASCADE |
| 284 | 284 |
ON UPDATE CASCADE, |
| 285 | 285 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` |
| 286 |
FOREIGN KEY (`current_taxon_determination` )
|
|
| 286 |
FOREIGN KEY (`current_determination` ) |
|
| 287 | 287 |
REFERENCES `taxon_determination` (`id` ) |
| 288 | 288 |
ON DELETE CASCADE |
| 289 | 289 |
ON UPDATE CASCADE, |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: renamed taxon_occurrence.*_taxon_determination to taxon_occurrence.*_determination because the column name does not need to be globally unique, and can therefore be shorter while still being unambiguous within the table