Revision 8575
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 172 | 172 |
|
| 173 | 173 |
|
| 174 | 174 |
-- ----------------------------------------------------- |
| 175 |
-- Table `party` |
|
| 176 |
-- ----------------------------------------------------- |
|
| 177 |
CREATE TABLE IF NOT EXISTS `party` ( |
|
| 178 |
`id` TEXT NOT NULL , |
|
| 179 |
PRIMARY KEY (`id`) , |
|
| 180 |
CONSTRAINT `fk_collection_source10` |
|
| 181 |
FOREIGN KEY (`id` ) |
|
| 182 |
REFERENCES `source` (`id` ) |
|
| 183 |
ON DELETE CASCADE |
|
| 184 |
ON UPDATE CASCADE) |
|
| 185 |
ENGINE = InnoDB |
|
| 186 |
DEFAULT CHARACTER SET = latin1 |
|
| 187 |
COLLATE = latin1_swedish_ci; |
|
| 188 |
|
|
| 189 |
|
|
| 190 |
-- ----------------------------------------------------- |
|
| 175 | 191 |
-- Table `taxon_determination` |
| 176 | 192 |
-- ----------------------------------------------------- |
| 177 | 193 |
CREATE TABLE IF NOT EXISTS `taxon_determination` ( |
| 178 | 194 |
`id` TEXT NOT NULL , |
| 179 | 195 |
`taxon_occurrence` TEXT NOT NULL , |
| 180 | 196 |
`taxon_assertion` TEXT NOT NULL , |
| 197 |
`identified_by` TEXT NULL , |
|
| 181 | 198 |
`fit_info` SET('hstore') NULL ,
|
| 182 | 199 |
INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`taxon_assertion` ASC) , |
| 183 | 200 |
INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) , |
| 184 | 201 |
PRIMARY KEY (`id`) , |
| 202 |
INDEX `fk_taxon_determination_party1` (`identified_by` ASC) , |
|
| 185 | 203 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1` |
| 186 | 204 |
FOREIGN KEY (`taxon_occurrence` ) |
| 187 | 205 |
REFERENCES `taxon_occurrence` (`id` ) |
| ... | ... | |
| 196 | 214 |
FOREIGN KEY (`id` ) |
| 197 | 215 |
REFERENCES `record` (`id` ) |
| 198 | 216 |
ON DELETE CASCADE |
| 217 |
ON UPDATE CASCADE, |
|
| 218 |
CONSTRAINT `fk_taxon_determination_party1` |
|
| 219 |
FOREIGN KEY (`identified_by` ) |
|
| 220 |
REFERENCES `party` (`id` ) |
|
| 221 |
ON DELETE CASCADE |
|
| 199 | 222 |
ON UPDATE CASCADE) |
| 200 | 223 |
ENGINE = InnoDB |
| 201 | 224 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 761 | 784 |
|
| 762 | 785 |
|
| 763 | 786 |
-- ----------------------------------------------------- |
| 764 |
-- Table `party` |
|
| 765 |
-- ----------------------------------------------------- |
|
| 766 |
CREATE TABLE IF NOT EXISTS `party` ( |
|
| 767 |
`id` TEXT NOT NULL , |
|
| 768 |
PRIMARY KEY (`id`) , |
|
| 769 |
CONSTRAINT `fk_collection_source10` |
|
| 770 |
FOREIGN KEY (`id` ) |
|
| 771 |
REFERENCES `source` (`id` ) |
|
| 772 |
ON DELETE CASCADE |
|
| 773 |
ON UPDATE CASCADE) |
|
| 774 |
ENGINE = InnoDB |
|
| 775 |
DEFAULT CHARACTER SET = latin1 |
|
| 776 |
COLLATE = latin1_swedish_ci; |
|
| 777 |
|
|
| 778 |
|
|
| 779 |
-- ----------------------------------------------------- |
|
| 780 | 787 |
-- Table `first_publisher` |
| 781 | 788 |
-- ----------------------------------------------------- |
| 782 | 789 |
CREATE TABLE IF NOT EXISTS `first_publisher` ( |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: taxon_determination: added identified_by. rearranged taxon tables to visually differentiate between inheritance relationships (1:1) and directional HAS-A arrows