Revision 8590
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 582 | 582 |
-- ----------------------------------------------------- |
| 583 | 583 |
CREATE TABLE IF NOT EXISTS `aggregate_observation` ( |
| 584 | 584 |
`id` TEXT NOT NULL , |
| 585 |
`taxon` TEXT NOT NULL , |
|
| 585 | 586 |
PRIMARY KEY (`id`) , |
| 587 |
INDEX `fk_aggregate_observation_taxon_name1` (`taxon` ASC) , |
|
| 586 | 588 |
CONSTRAINT `fk_aggregate_observation_taxon_occurrence1` |
| 587 | 589 |
FOREIGN KEY () |
| 588 | 590 |
REFERENCES `taxon_observation` () |
| 589 | 591 |
ON DELETE CASCADE |
| 592 |
ON UPDATE CASCADE, |
|
| 593 |
CONSTRAINT `fk_aggregate_observation_taxon_name1` |
|
| 594 |
FOREIGN KEY (`taxon` ) |
|
| 595 |
REFERENCES `taxon_name` (`id` ) |
|
| 596 |
ON DELETE CASCADE |
|
| 590 | 597 |
ON UPDATE CASCADE) |
| 591 | 598 |
ENGINE = InnoDB |
| 592 | 599 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 598 | 605 |
-- ----------------------------------------------------- |
| 599 | 606 |
CREATE TABLE IF NOT EXISTS `taxon_presence` ( |
| 600 | 607 |
`id` TEXT NOT NULL , |
| 608 |
`taxon` TEXT NOT NULL , |
|
| 601 | 609 |
PRIMARY KEY (`id`) , |
| 610 |
INDEX `fk_taxon_presence_taxon_name1` (`taxon` ASC) , |
|
| 602 | 611 |
CONSTRAINT `fk_taxon_observation_taxon_occurrence1` |
| 603 | 612 |
FOREIGN KEY () |
| 604 | 613 |
REFERENCES `taxon_observation` () |
| 605 | 614 |
ON DELETE CASCADE |
| 615 |
ON UPDATE CASCADE, |
|
| 616 |
CONSTRAINT `fk_taxon_presence_taxon_name1` |
|
| 617 |
FOREIGN KEY (`taxon` ) |
|
| 618 |
REFERENCES `taxon_name` (`id` ) |
|
| 619 |
ON DELETE CASCADE |
|
| 606 | 620 |
ON UPDATE CASCADE) |
| 607 | 621 |
ENGINE = InnoDB |
| 608 | 622 |
DEFAULT CHARACTER SET = latin1 |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_presence, aggregate_observation: added required taxon field to identify (distinguish) the observation itself. this is expected to be the same as the first taxon_determination applied to the observation.