Revision 8521
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 72 | 72 |
|
| 73 | 73 |
|
| 74 | 74 |
-- ----------------------------------------------------- |
| 75 |
-- Table `default_schema`.`taxon` |
|
| 76 |
-- ----------------------------------------------------- |
|
| 77 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon` ( |
|
| 78 |
`taxon` TEXT NOT NULL , |
|
| 79 |
`taxon_parent` TEXT NULL , |
|
| 80 |
PRIMARY KEY (`taxon`) , |
|
| 81 |
INDEX `fk_taxon_taxon1` (`taxon_parent` ASC) , |
|
| 82 |
CONSTRAINT `fk_taxon_record1` |
|
| 83 |
FOREIGN KEY (`taxon` ) |
|
| 84 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 85 |
ON DELETE CASCADE |
|
| 86 |
ON UPDATE CASCADE, |
|
| 87 |
CONSTRAINT `fk_taxon_taxon1` |
|
| 88 |
FOREIGN KEY (`taxon_parent` ) |
|
| 89 |
REFERENCES `default_schema`.`taxon` (`taxon` ) |
|
| 90 |
ON DELETE NO ACTION |
|
| 91 |
ON UPDATE NO ACTION) |
|
| 92 |
ENGINE = InnoDB |
|
| 93 |
DEFAULT CHARACTER SET = latin1 |
|
| 94 |
COLLATE = latin1_swedish_ci; |
|
| 95 |
|
|
| 96 |
|
|
| 97 |
-- ----------------------------------------------------- |
|
| 98 |
-- Table `default_schema`.`taxon_assertion` |
|
| 99 |
-- ----------------------------------------------------- |
|
| 100 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_assertion` ( |
|
| 101 |
`taxon_assertion` TEXT NOT NULL , |
|
| 102 |
`taxon` TEXT NOT NULL , |
|
| 103 |
PRIMARY KEY (`taxon_assertion`) , |
|
| 104 |
INDEX `fk_qualified_taxon_name_taxon1` (`taxon` ASC) , |
|
| 105 |
CONSTRAINT `fk_qualified_taxon_record1` |
|
| 106 |
FOREIGN KEY (`taxon_assertion` ) |
|
| 107 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 108 |
ON DELETE CASCADE |
|
| 109 |
ON UPDATE CASCADE, |
|
| 110 |
CONSTRAINT `fk_qualified_taxon_name_taxon1` |
|
| 111 |
FOREIGN KEY (`taxon` ) |
|
| 112 |
REFERENCES `default_schema`.`taxon` (`taxon` ) |
|
| 113 |
ON DELETE NO ACTION |
|
| 114 |
ON UPDATE NO ACTION) |
|
| 115 |
ENGINE = InnoDB |
|
| 116 |
DEFAULT CHARACTER SET = latin1 |
|
| 117 |
COLLATE = latin1_swedish_ci; |
|
| 118 |
|
|
| 119 |
|
|
| 120 |
-- ----------------------------------------------------- |
|
| 121 |
-- Table `default_schema`.`taxon_determination` |
|
| 122 |
-- ----------------------------------------------------- |
|
| 123 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_determination` ( |
|
| 124 |
`taxon_determination` VARCHAR(45) NOT NULL , |
|
| 125 |
`taxon_occurrence` TEXT NOT NULL , |
|
| 126 |
`qualified_taxon` TEXT NOT NULL , |
|
| 127 |
INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`qualified_taxon` ASC) , |
|
| 128 |
INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) , |
|
| 129 |
PRIMARY KEY (`taxon_determination`) , |
|
| 130 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1` |
|
| 131 |
FOREIGN KEY (`taxon_occurrence` ) |
|
| 132 |
REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` ) |
|
| 133 |
ON DELETE NO ACTION |
|
| 134 |
ON UPDATE NO ACTION, |
|
| 135 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` |
|
| 136 |
FOREIGN KEY (`qualified_taxon` ) |
|
| 137 |
REFERENCES `default_schema`.`taxon_assertion` (`taxon_assertion` ) |
|
| 138 |
ON DELETE NO ACTION |
|
| 139 |
ON UPDATE NO ACTION, |
|
| 140 |
CONSTRAINT `fk_taxon_determination_record1` |
|
| 141 |
FOREIGN KEY (`taxon_determination` ) |
|
| 142 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 143 |
ON DELETE NO ACTION |
|
| 144 |
ON UPDATE NO ACTION) |
|
| 145 |
ENGINE = InnoDB |
|
| 146 |
DEFAULT CHARACTER SET = latin1 |
|
| 147 |
COLLATE = latin1_swedish_ci; |
|
| 148 |
|
|
| 149 |
|
|
| 150 |
-- ----------------------------------------------------- |
|
| 75 | 151 |
-- Table `default_schema`.`coordinates` |
| 76 | 152 |
-- ----------------------------------------------------- |
| 77 | 153 |
CREATE TABLE IF NOT EXISTS `default_schema`.`coordinates` ( |
| ... | ... | |
| 109 | 185 |
CREATE TABLE IF NOT EXISTS `default_schema`.`location` ( |
| 110 | 186 |
`location` TEXT NOT NULL , |
| 111 | 187 |
`location_parent` TEXT NULL DEFAULT NULL , |
| 112 |
`placename` TEXT NULL DEFAULT NULL ,
|
|
| 188 |
`named_place` TEXT NULL DEFAULT NULL ,
|
|
| 113 | 189 |
`coordinates` TEXT NULL DEFAULT NULL , |
| 114 | 190 |
PRIMARY KEY (`location`) , |
| 115 | 191 |
INDEX `fk_location_coordinates1` (`coordinates` ASC) , |
| 116 |
INDEX `fk_location_placename1` (`placename` ASC) ,
|
|
| 192 |
INDEX `fk_location_placename1` (`named_place` ASC) ,
|
|
| 117 | 193 |
INDEX `fk_location1` (`location_parent` ASC) , |
| 118 | 194 |
CONSTRAINT `fk_location_record1` |
| 119 | 195 |
FOREIGN KEY (`location` ) |
| ... | ... | |
| 126 | 202 |
ON DELETE NO ACTION |
| 127 | 203 |
ON UPDATE NO ACTION, |
| 128 | 204 |
CONSTRAINT `fk_location_placename1` |
| 129 |
FOREIGN KEY (`placename` )
|
|
| 205 |
FOREIGN KEY (`named_place` )
|
|
| 130 | 206 |
REFERENCES `default_schema`.`named_place` (`named_place` ) |
| 131 | 207 |
ON DELETE NO ACTION |
| 132 | 208 |
ON UPDATE NO ACTION, |
| ... | ... | |
| 194 | 270 |
|
| 195 | 271 |
|
| 196 | 272 |
-- ----------------------------------------------------- |
| 197 |
-- Table `default_schema`.`occurrence` |
|
| 273 |
-- Table `default_schema`.`taxon_occurrence`
|
|
| 198 | 274 |
-- ----------------------------------------------------- |
| 199 |
CREATE TABLE IF NOT EXISTS `default_schema`.`occurrence` ( |
|
| 200 |
`occurrence` TEXT NOT NULL , |
|
| 201 |
PRIMARY KEY (`occurrence`) , |
|
| 202 |
INDEX `fk_occurrence_record1` (`occurrence` ASC) , |
|
| 203 |
CONSTRAINT `fk_occurrence_event1` |
|
| 204 |
FOREIGN KEY (`occurrence` ) |
|
| 275 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_occurrence` ( |
|
| 276 |
`taxon_occurrence` TEXT NOT NULL , |
|
| 277 |
`current_taxon_determination` VARCHAR(45) NULL DEFAULT NULL , |
|
| 278 |
`original_taxon_determination` VARCHAR(45) NULL DEFAULT NULL , |
|
| 279 |
INDEX `fk_taxon_occurrence_taxon_determination1` (`original_taxon_determination` ASC) , |
|
| 280 |
INDEX `fk_taxon_occurrence_taxon_determination2` (`current_taxon_determination` ASC) , |
|
| 281 |
INDEX `fk_taxon_occurrence_event1` (`taxon_occurrence` ASC) , |
|
| 282 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` |
|
| 283 |
FOREIGN KEY (`original_taxon_determination` ) |
|
| 284 |
REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` ) |
|
| 285 |
ON DELETE NO ACTION |
|
| 286 |
ON UPDATE NO ACTION, |
|
| 287 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` |
|
| 288 |
FOREIGN KEY (`current_taxon_determination` ) |
|
| 289 |
REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` ) |
|
| 290 |
ON DELETE NO ACTION |
|
| 291 |
ON UPDATE NO ACTION, |
|
| 292 |
CONSTRAINT `fk_taxon_occurrence_event1` |
|
| 293 |
FOREIGN KEY (`taxon_occurrence` ) |
|
| 205 | 294 |
REFERENCES `default_schema`.`event` (`event` ) |
| 206 | 295 |
ON DELETE NO ACTION |
| 207 | 296 |
ON UPDATE NO ACTION) |
| ... | ... | |
| 211 | 300 |
|
| 212 | 301 |
|
| 213 | 302 |
-- ----------------------------------------------------- |
| 214 |
-- Table `default_schema`.`measurement`
|
|
| 303 |
-- Table `default_schema`.`trait`
|
|
| 215 | 304 |
-- ----------------------------------------------------- |
| 216 |
CREATE TABLE IF NOT EXISTS `default_schema`.`measurement` (
|
|
| 217 |
`measurement` TEXT NOT NULL ,
|
|
| 218 |
`occurrence` TEXT NOT NULL , |
|
| 219 |
PRIMARY KEY (`measurement`) ,
|
|
| 220 |
INDEX `fk_measurement_occurrence1` (`occurrence` ASC) ,
|
|
| 305 |
CREATE TABLE IF NOT EXISTS `default_schema`.`trait` (
|
|
| 306 |
`trait` TEXT NOT NULL ,
|
|
| 307 |
`taxon_occurrence` TEXT NOT NULL ,
|
|
| 308 |
PRIMARY KEY (`trait`) ,
|
|
| 309 |
INDEX `fk_trait_taxon_occurrence1` (`taxon_occurrence` ASC) ,
|
|
| 221 | 310 |
CONSTRAINT `fk_measurement_record1` |
| 222 |
FOREIGN KEY (`measurement` )
|
|
| 311 |
FOREIGN KEY (`trait` )
|
|
| 223 | 312 |
REFERENCES `default_schema`.`record` (`record` ) |
| 224 | 313 |
ON DELETE CASCADE |
| 225 | 314 |
ON UPDATE CASCADE, |
| 226 |
CONSTRAINT `fk_measurement_occurrence1` |
|
| 227 |
FOREIGN KEY (`occurrence` ) |
|
| 228 |
REFERENCES `default_schema`.`occurrence` (`occurrence` ) |
|
| 229 |
ON DELETE NO ACTION |
|
| 230 |
ON UPDATE NO ACTION) |
|
| 231 |
ENGINE = InnoDB |
|
| 232 |
DEFAULT CHARACTER SET = latin1 |
|
| 233 |
COLLATE = latin1_swedish_ci; |
|
| 234 |
|
|
| 235 |
|
|
| 236 |
-- ----------------------------------------------------- |
|
| 237 |
-- Table `default_schema`.`taxon` |
|
| 238 |
-- ----------------------------------------------------- |
|
| 239 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon` ( |
|
| 240 |
`taxon` TEXT NOT NULL , |
|
| 241 |
PRIMARY KEY (`taxon`) , |
|
| 242 |
CONSTRAINT `fk_taxon_record1` |
|
| 243 |
FOREIGN KEY (`taxon` ) |
|
| 244 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 245 |
ON DELETE CASCADE |
|
| 246 |
ON UPDATE CASCADE) |
|
| 247 |
ENGINE = InnoDB |
|
| 248 |
DEFAULT CHARACTER SET = latin1 |
|
| 249 |
COLLATE = latin1_swedish_ci; |
|
| 250 |
|
|
| 251 |
|
|
| 252 |
-- ----------------------------------------------------- |
|
| 253 |
-- Table `default_schema`.`qualified_taxon` |
|
| 254 |
-- ----------------------------------------------------- |
|
| 255 |
CREATE TABLE IF NOT EXISTS `default_schema`.`qualified_taxon` ( |
|
| 256 |
`qualified_taxon` TEXT NOT NULL , |
|
| 257 |
`taxon` TEXT NOT NULL , |
|
| 258 |
PRIMARY KEY (`qualified_taxon`) , |
|
| 259 |
INDEX `fk_qualified_taxon_name_taxon1` (`taxon` ASC) , |
|
| 260 |
CONSTRAINT `fk_qualified_taxon_record1` |
|
| 261 |
FOREIGN KEY (`qualified_taxon` ) |
|
| 262 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 263 |
ON DELETE CASCADE |
|
| 264 |
ON UPDATE CASCADE, |
|
| 265 |
CONSTRAINT `fk_qualified_taxon_name_taxon1` |
|
| 266 |
FOREIGN KEY (`taxon` ) |
|
| 267 |
REFERENCES `default_schema`.`taxon` (`taxon` ) |
|
| 268 |
ON DELETE NO ACTION |
|
| 269 |
ON UPDATE NO ACTION) |
|
| 270 |
ENGINE = InnoDB |
|
| 271 |
DEFAULT CHARACTER SET = latin1 |
|
| 272 |
COLLATE = latin1_swedish_ci; |
|
| 273 |
|
|
| 274 |
|
|
| 275 |
-- ----------------------------------------------------- |
|
| 276 |
-- Table `default_schema`.`taxon_determination` |
|
| 277 |
-- ----------------------------------------------------- |
|
| 278 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_determination` ( |
|
| 279 |
`taxon_determination` VARCHAR(45) NOT NULL , |
|
| 280 |
`taxon_occurrence` TEXT NOT NULL , |
|
| 281 |
`qualified_taxon` TEXT NOT NULL , |
|
| 282 |
INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`qualified_taxon` ASC) , |
|
| 283 |
INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) , |
|
| 284 |
PRIMARY KEY (`taxon_determination`) , |
|
| 285 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1` |
|
| 315 |
CONSTRAINT `fk_trait_taxon_occurrence1` |
|
| 286 | 316 |
FOREIGN KEY (`taxon_occurrence` ) |
| 287 | 317 |
REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` ) |
| 288 | 318 |
ON DELETE NO ACTION |
| 289 |
ON UPDATE NO ACTION, |
|
| 290 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` |
|
| 291 |
FOREIGN KEY (`qualified_taxon` ) |
|
| 292 |
REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` ) |
|
| 293 |
ON DELETE NO ACTION |
|
| 294 |
ON UPDATE NO ACTION, |
|
| 295 |
CONSTRAINT `fk_taxon_determination_record1` |
|
| 296 |
FOREIGN KEY (`taxon_determination` ) |
|
| 297 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 298 |
ON DELETE NO ACTION |
|
| 299 | 319 |
ON UPDATE NO ACTION) |
| 300 | 320 |
ENGINE = InnoDB |
| 301 | 321 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 303 | 323 |
|
| 304 | 324 |
|
| 305 | 325 |
-- ----------------------------------------------------- |
| 306 |
-- Table `default_schema`.`taxon_occurrence` |
|
| 307 |
-- ----------------------------------------------------- |
|
| 308 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_occurrence` ( |
|
| 309 |
`taxon_occurrence` TEXT NOT NULL , |
|
| 310 |
`current_taxon_determination` VARCHAR(45) NULL DEFAULT NULL , |
|
| 311 |
`original_taxon_determination` VARCHAR(45) NULL DEFAULT NULL , |
|
| 312 |
PRIMARY KEY (`taxon_occurrence`) , |
|
| 313 |
INDEX `fk_taxon_occurrence_taxon_determination1` (`original_taxon_determination` ASC) , |
|
| 314 |
INDEX `fk_taxon_occurrence_taxon_determination2` (`current_taxon_determination` ASC) , |
|
| 315 |
CONSTRAINT `fk_taxon_occurrence1` |
|
| 316 |
FOREIGN KEY (`taxon_occurrence` ) |
|
| 317 |
REFERENCES `default_schema`.`occurrence` (`occurrence` ) |
|
| 318 |
ON DELETE NO ACTION |
|
| 319 |
ON UPDATE NO ACTION, |
|
| 320 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` |
|
| 321 |
FOREIGN KEY (`original_taxon_determination` ) |
|
| 322 |
REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` ) |
|
| 323 |
ON DELETE NO ACTION |
|
| 324 |
ON UPDATE NO ACTION, |
|
| 325 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` |
|
| 326 |
FOREIGN KEY (`current_taxon_determination` ) |
|
| 327 |
REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` ) |
|
| 328 |
ON DELETE NO ACTION |
|
| 329 |
ON UPDATE NO ACTION) |
|
| 330 |
ENGINE = InnoDB |
|
| 331 |
DEFAULT CHARACTER SET = latin1 |
|
| 332 |
COLLATE = latin1_swedish_ci; |
|
| 333 |
|
|
| 334 |
|
|
| 335 |
-- ----------------------------------------------------- |
|
| 336 | 326 |
-- Table `default_schema`.`collection` |
| 337 | 327 |
-- ----------------------------------------------------- |
| 338 | 328 |
CREATE TABLE IF NOT EXISTS `default_schema`.`collection` ( |
| ... | ... | |
| 526 | 516 |
|
| 527 | 517 |
|
| 528 | 518 |
-- ----------------------------------------------------- |
| 529 |
-- Table `default_schema`.`verbatim_taxon`
|
|
| 519 |
-- Table `default_schema`.`accepted_taxon`
|
|
| 530 | 520 |
-- ----------------------------------------------------- |
| 531 |
CREATE TABLE IF NOT EXISTS `default_schema`.`verbatim_taxon` (
|
|
| 532 |
`verbatim_taxon` TEXT NOT NULL ,
|
|
| 533 |
PRIMARY KEY (`verbatim_taxon`) ,
|
|
| 534 |
CONSTRAINT `fk_matched_taxon_qualified_taxon100`
|
|
| 535 |
FOREIGN KEY (`verbatim_taxon` )
|
|
| 536 |
REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )
|
|
| 521 |
CREATE TABLE IF NOT EXISTS `default_schema`.`accepted_taxon` (
|
|
| 522 |
`accepted_taxon` TEXT NOT NULL ,
|
|
| 523 |
PRIMARY KEY (`accepted_taxon`) ,
|
|
| 524 |
CONSTRAINT `fk_accepted_taxon_taxon1`
|
|
| 525 |
FOREIGN KEY (`accepted_taxon` )
|
|
| 526 |
REFERENCES `default_schema`.`taxon` (`taxon` )
|
|
| 537 | 527 |
ON DELETE NO ACTION |
| 538 | 528 |
ON UPDATE NO ACTION) |
| 539 | 529 |
ENGINE = InnoDB |
| ... | ... | |
| 542 | 532 |
|
| 543 | 533 |
|
| 544 | 534 |
-- ----------------------------------------------------- |
| 545 |
-- Table `default_schema`.`parsed_taxon`
|
|
| 535 |
-- Table `default_schema`.`synonym_taxon`
|
|
| 546 | 536 |
-- ----------------------------------------------------- |
| 547 |
CREATE TABLE IF NOT EXISTS `default_schema`.`parsed_taxon` (
|
|
| 548 |
`parsed_taxon` TEXT NOT NULL ,
|
|
| 549 |
`verbatim_taxon` TEXT NOT NULL ,
|
|
| 550 |
PRIMARY KEY (`parsed_taxon`) ,
|
|
| 551 |
INDEX `fk_parsed_taxon_verbatim_taxon1` (`verbatim_taxon` ASC) ,
|
|
| 552 |
CONSTRAINT `fk_matched_taxon_qualified_taxon10`
|
|
| 553 |
FOREIGN KEY (`parsed_taxon` )
|
|
| 554 |
REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )
|
|
| 537 |
CREATE TABLE IF NOT EXISTS `default_schema`.`synonym_taxon` (
|
|
| 538 |
`synonym_taxon` TEXT NOT NULL ,
|
|
| 539 |
`accepted_taxon` TEXT NULL ,
|
|
| 540 |
PRIMARY KEY (`synonym_taxon`) ,
|
|
| 541 |
INDEX `fk_matched_taxon_accepted_taxon1` (`accepted_taxon` ASC) ,
|
|
| 542 |
CONSTRAINT `fk_matched_taxon_taxon1`
|
|
| 543 |
FOREIGN KEY (`synonym_taxon` )
|
|
| 544 |
REFERENCES `default_schema`.`taxon` (`taxon` )
|
|
| 555 | 545 |
ON DELETE NO ACTION |
| 556 | 546 |
ON UPDATE NO ACTION, |
| 557 |
CONSTRAINT `fk_parsed_taxon_verbatim_taxon1` |
|
| 558 |
FOREIGN KEY (`verbatim_taxon` ) |
|
| 559 |
REFERENCES `default_schema`.`verbatim_taxon` (`verbatim_taxon` ) |
|
| 560 |
ON DELETE NO ACTION |
|
| 561 |
ON UPDATE NO ACTION) |
|
| 562 |
ENGINE = InnoDB |
|
| 563 |
DEFAULT CHARACTER SET = latin1 |
|
| 564 |
COLLATE = latin1_swedish_ci; |
|
| 565 |
|
|
| 566 |
|
|
| 567 |
-- ----------------------------------------------------- |
|
| 568 |
-- Table `default_schema`.`matched_taxon` |
|
| 569 |
-- ----------------------------------------------------- |
|
| 570 |
CREATE TABLE IF NOT EXISTS `default_schema`.`matched_taxon` ( |
|
| 571 |
`matched_taxon` TEXT NOT NULL , |
|
| 572 |
`parsed_taxon` TEXT NOT NULL , |
|
| 573 |
PRIMARY KEY (`matched_taxon`) , |
|
| 574 |
INDEX `fk_matched_taxon_parsed_taxon1` (`parsed_taxon` ASC) , |
|
| 575 |
CONSTRAINT `fk_matched_taxon_qualified_taxon1` |
|
| 576 |
FOREIGN KEY (`matched_taxon` ) |
|
| 577 |
REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` ) |
|
| 578 |
ON DELETE NO ACTION |
|
| 579 |
ON UPDATE NO ACTION, |
|
| 580 |
CONSTRAINT `fk_matched_taxon_parsed_taxon1` |
|
| 581 |
FOREIGN KEY (`parsed_taxon` ) |
|
| 582 |
REFERENCES `default_schema`.`parsed_taxon` (`parsed_taxon` ) |
|
| 583 |
ON DELETE NO ACTION |
|
| 584 |
ON UPDATE NO ACTION) |
|
| 585 |
ENGINE = InnoDB |
|
| 586 |
DEFAULT CHARACTER SET = latin1 |
|
| 587 |
COLLATE = latin1_swedish_ci; |
|
| 588 |
|
|
| 589 |
|
|
| 590 |
-- ----------------------------------------------------- |
|
| 591 |
-- Table `default_schema`.`accepted_taxon` |
|
| 592 |
-- ----------------------------------------------------- |
|
| 593 |
CREATE TABLE IF NOT EXISTS `default_schema`.`accepted_taxon` ( |
|
| 594 |
`accepted_taxon` TEXT NOT NULL , |
|
| 595 |
`matched_taxon` TEXT NOT NULL , |
|
| 596 |
PRIMARY KEY (`accepted_taxon`) , |
|
| 597 |
INDEX `fk_accepted_taxon_matched_taxon1` (`matched_taxon` ASC) , |
|
| 598 |
CONSTRAINT `fk_accepted_taxon_qualified_taxon1` |
|
| 547 |
CONSTRAINT `fk_matched_taxon_accepted_taxon1` |
|
| 599 | 548 |
FOREIGN KEY (`accepted_taxon` ) |
| 600 |
REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )
|
|
| 549 |
REFERENCES `default_schema`.`accepted_taxon` (`accepted_taxon` )
|
|
| 601 | 550 |
ON DELETE NO ACTION |
| 602 |
ON UPDATE NO ACTION, |
|
| 603 |
CONSTRAINT `fk_accepted_taxon_matched_taxon1` |
|
| 604 |
FOREIGN KEY (`matched_taxon` ) |
|
| 605 |
REFERENCES `default_schema`.`matched_taxon` (`matched_taxon` ) |
|
| 606 |
ON DELETE NO ACTION |
|
| 607 | 551 |
ON UPDATE NO ACTION) |
| 608 | 552 |
ENGINE = InnoDB |
| 609 | 553 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 615 | 559 |
-- ----------------------------------------------------- |
| 616 | 560 |
CREATE TABLE IF NOT EXISTS `default_schema`.`taxon_concept` ( |
| 617 | 561 |
`taxon_concept` TEXT NOT NULL , |
| 618 |
`source` TEXT NOT NULL ,
|
|
| 562 |
`according_to` TEXT NOT NULL ,
|
|
| 619 | 563 |
PRIMARY KEY (`taxon_concept`) , |
| 620 |
INDEX `fk_taxon_concept_source1` (`source` ASC) ,
|
|
| 564 |
INDEX `fk_taxon_concept_source1` (`according_to` ASC) ,
|
|
| 621 | 565 |
CONSTRAINT `fk_taxon_concept_taxon1` |
| 622 | 566 |
FOREIGN KEY (`taxon_concept` ) |
| 623 | 567 |
REFERENCES `default_schema`.`taxon` (`taxon` ) |
| 624 | 568 |
ON DELETE NO ACTION |
| 625 | 569 |
ON UPDATE NO ACTION, |
| 626 | 570 |
CONSTRAINT `fk_taxon_concept_source1` |
| 627 |
FOREIGN KEY (`source` )
|
|
| 571 |
FOREIGN KEY (`according_to` )
|
|
| 628 | 572 |
REFERENCES `default_schema`.`source` (`source` ) |
| 629 | 573 |
ON DELETE NO ACTION |
| 630 | 574 |
ON UPDATE NO ACTION) |
| ... | ... | |
| 673 | 617 |
`location` TEXT NOT NULL , |
| 674 | 618 |
`geological_context` TEXT NULL DEFAULT NULL , |
| 675 | 619 |
`community` TEXT NULL DEFAULT NULL , |
| 676 |
PRIMARY KEY (`location_observation`) , |
|
| 677 | 620 |
INDEX `fk_location_observation_location1` (`location` ASC) , |
| 678 | 621 |
INDEX `fk_location_observation_geological_context1` (`geological_context` ASC) , |
| 679 | 622 |
INDEX `fk_location_observation_community1` (`community` ASC) , |
| ... | ... | |
| 682 | 625 |
REFERENCES `default_schema`.`location` (`location` ) |
| 683 | 626 |
ON DELETE NO ACTION |
| 684 | 627 |
ON UPDATE NO ACTION, |
| 685 |
CONSTRAINT `fk_location_observation_occurrence1` |
|
| 686 |
FOREIGN KEY (`location_observation` ) |
|
| 687 |
REFERENCES `default_schema`.`occurrence` (`occurrence` ) |
|
| 688 |
ON DELETE NO ACTION |
|
| 689 |
ON UPDATE NO ACTION, |
|
| 690 | 628 |
CONSTRAINT `fk_location_observation_geological_context1` |
| 691 | 629 |
FOREIGN KEY (`geological_context` ) |
| 692 | 630 |
REFERENCES `default_schema`.`geological_context` (`geological_context` ) |
| ... | ... | |
| 696 | 634 |
FOREIGN KEY (`community` ) |
| 697 | 635 |
REFERENCES `default_schema`.`community` (`community` ) |
| 698 | 636 |
ON DELETE NO ACTION |
| 637 |
ON UPDATE NO ACTION, |
|
| 638 |
CONSTRAINT `fk_location_observation_event1` |
|
| 639 |
FOREIGN KEY (`location_observation` ) |
|
| 640 |
REFERENCES `default_schema`.`event` (`event` ) |
|
| 641 |
ON DELETE NO ACTION |
|
| 699 | 642 |
ON UPDATE NO ACTION) |
| 700 | 643 |
ENGINE = InnoDB |
| 701 | 644 |
DEFAULT CHARACTER SET = latin1 |
| ... | ... | |
| 740 | 683 |
CREATE TABLE IF NOT EXISTS `default_schema`.`geovalidation` ( |
| 741 | 684 |
`geovalidation` TEXT NOT NULL , |
| 742 | 685 |
`coordinates` TEXT NOT NULL , |
| 743 |
`placename` TEXT NOT NULL ,
|
|
| 686 |
`named_place` TEXT NOT NULL ,
|
|
| 744 | 687 |
PRIMARY KEY (`geovalidation`) , |
| 745 | 688 |
INDEX `fk_geovalidation_coordinates1` (`coordinates` ASC) , |
| 746 |
INDEX `fk_geovalidation_placename1` (`placename` ASC) ,
|
|
| 689 |
INDEX `fk_geovalidation_placename1` (`named_place` ASC) ,
|
|
| 747 | 690 |
CONSTRAINT `fk_geovalidation_record1` |
| 748 | 691 |
FOREIGN KEY (`geovalidation` ) |
| 749 | 692 |
REFERENCES `default_schema`.`record` (`record` ) |
| ... | ... | |
| 755 | 698 |
ON DELETE NO ACTION |
| 756 | 699 |
ON UPDATE NO ACTION, |
| 757 | 700 |
CONSTRAINT `fk_geovalidation_placename1` |
| 758 |
FOREIGN KEY (`placename` )
|
|
| 701 |
FOREIGN KEY (`named_place` )
|
|
| 759 | 702 |
REFERENCES `default_schema`.`named_place` (`named_place` ) |
| 760 | 703 |
ON DELETE NO ACTION |
| 761 | 704 |
ON UPDATE NO ACTION) |
| ... | ... | |
| 781 | 724 |
|
| 782 | 725 |
|
| 783 | 726 |
-- ----------------------------------------------------- |
| 727 |
-- Table `default_schema`.`parsed_taxon_assertion` |
|
| 728 |
-- ----------------------------------------------------- |
|
| 729 |
CREATE TABLE IF NOT EXISTS `default_schema`.`parsed_taxon_assertion` ( |
|
| 730 |
`parsed_taxon_assertion` TEXT NOT NULL , |
|
| 731 |
`matched_taxon` TEXT NULL , |
|
| 732 |
PRIMARY KEY (`parsed_taxon_assertion`) , |
|
| 733 |
INDEX `fk_parsed_taxon_matched_taxon1` (`matched_taxon` ASC) , |
|
| 734 |
CONSTRAINT `fk_matched_taxon_qualified_taxon10` |
|
| 735 |
FOREIGN KEY (`parsed_taxon_assertion` ) |
|
| 736 |
REFERENCES `default_schema`.`taxon_assertion` (`taxon_assertion` ) |
|
| 737 |
ON DELETE NO ACTION |
|
| 738 |
ON UPDATE NO ACTION, |
|
| 739 |
CONSTRAINT `fk_parsed_taxon_matched_taxon1` |
|
| 740 |
FOREIGN KEY (`matched_taxon` ) |
|
| 741 |
REFERENCES `default_schema`.`synonym_taxon` (`synonym_taxon` ) |
|
| 742 |
ON DELETE NO ACTION |
|
| 743 |
ON UPDATE NO ACTION) |
|
| 744 |
ENGINE = InnoDB |
|
| 745 |
DEFAULT CHARACTER SET = latin1 |
|
| 746 |
COLLATE = latin1_swedish_ci; |
|
| 747 |
|
|
| 748 |
|
|
| 749 |
-- ----------------------------------------------------- |
|
| 750 |
-- Table `default_schema`.`verbatim_taxon_assertion` |
|
| 751 |
-- ----------------------------------------------------- |
|
| 752 |
CREATE TABLE IF NOT EXISTS `default_schema`.`verbatim_taxon_assertion` ( |
|
| 753 |
`verbatim_taxon_assertion` TEXT NOT NULL , |
|
| 754 |
`parsed_taxon` TEXT NULL , |
|
| 755 |
PRIMARY KEY (`verbatim_taxon_assertion`) , |
|
| 756 |
INDEX `fk_verbatim_taxon_parsed_taxon1` (`parsed_taxon` ASC) , |
|
| 757 |
CONSTRAINT `fk_matched_taxon_qualified_taxon100` |
|
| 758 |
FOREIGN KEY (`verbatim_taxon_assertion` ) |
|
| 759 |
REFERENCES `default_schema`.`taxon_assertion` (`taxon_assertion` ) |
|
| 760 |
ON DELETE NO ACTION |
|
| 761 |
ON UPDATE NO ACTION, |
|
| 762 |
CONSTRAINT `fk_verbatim_taxon_parsed_taxon1` |
|
| 763 |
FOREIGN KEY (`parsed_taxon` ) |
|
| 764 |
REFERENCES `default_schema`.`parsed_taxon_assertion` (`parsed_taxon_assertion` ) |
|
| 765 |
ON DELETE NO ACTION |
|
| 766 |
ON UPDATE NO ACTION) |
|
| 767 |
ENGINE = InnoDB |
|
| 768 |
DEFAULT CHARACTER SET = latin1 |
|
| 769 |
COLLATE = latin1_swedish_ci; |
|
| 770 |
|
|
| 771 |
|
|
| 772 |
-- ----------------------------------------------------- |
|
| 784 | 773 |
-- Table `default_schema`.`party` |
| 785 | 774 |
-- ----------------------------------------------------- |
| 786 | 775 |
CREATE TABLE IF NOT EXISTS `default_schema`.`party` ( |
| ... | ... | |
| 812 | 801 |
COLLATE = latin1_swedish_ci; |
| 813 | 802 |
|
| 814 | 803 |
|
| 804 |
-- ----------------------------------------------------- |
|
| 805 |
-- Table `default_schema`.`referenced_class` |
|
| 806 |
-- ----------------------------------------------------- |
|
| 807 |
CREATE TABLE IF NOT EXISTS `default_schema`.`referenced_class` ( |
|
| 808 |
`referenced_class` INT NOT NULL , |
|
| 809 |
PRIMARY KEY (`referenced_class`) , |
|
| 810 |
CONSTRAINT `fk_example_record10` |
|
| 811 |
FOREIGN KEY (`referenced_class` ) |
|
| 812 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 813 |
ON DELETE NO ACTION |
|
| 814 |
ON UPDATE NO ACTION) |
|
| 815 |
ENGINE = InnoDB; |
|
| 815 | 816 |
|
| 817 |
|
|
| 818 |
-- ----------------------------------------------------- |
|
| 819 |
-- Table `default_schema`.`base_class` |
|
| 820 |
-- ----------------------------------------------------- |
|
| 821 |
CREATE TABLE IF NOT EXISTS `default_schema`.`base_class` ( |
|
| 822 |
`base_class` INT NOT NULL , |
|
| 823 |
`referenced_class` INT NOT NULL , |
|
| 824 |
PRIMARY KEY (`base_class`) , |
|
| 825 |
INDEX `fk_base_class_referenced_class1` (`referenced_class` ASC) , |
|
| 826 |
CONSTRAINT `fk_example_record1` |
|
| 827 |
FOREIGN KEY (`base_class` ) |
|
| 828 |
REFERENCES `default_schema`.`record` (`record` ) |
|
| 829 |
ON DELETE NO ACTION |
|
| 830 |
ON UPDATE NO ACTION, |
|
| 831 |
CONSTRAINT `fk_base_class_referenced_class1` |
|
| 832 |
FOREIGN KEY (`referenced_class` ) |
|
| 833 |
REFERENCES `default_schema`.`referenced_class` (`referenced_class` ) |
|
| 834 |
ON DELETE NO ACTION |
|
| 835 |
ON UPDATE NO ACTION) |
|
| 836 |
ENGINE = InnoDB; |
|
| 837 |
|
|
| 838 |
|
|
| 839 |
-- ----------------------------------------------------- |
|
| 840 |
-- Table `default_schema`.`derived_class` |
|
| 841 |
-- ----------------------------------------------------- |
|
| 842 |
CREATE TABLE IF NOT EXISTS `default_schema`.`derived_class` ( |
|
| 843 |
`derived_class` INT NOT NULL , |
|
| 844 |
PRIMARY KEY (`derived_class`) , |
|
| 845 |
CONSTRAINT `fk_derived_class_base_class1` |
|
| 846 |
FOREIGN KEY (`derived_class` ) |
|
| 847 |
REFERENCES `default_schema`.`base_class` (`base_class` ) |
|
| 848 |
ON DELETE NO ACTION |
|
| 849 |
ON UPDATE NO ACTION) |
|
| 850 |
ENGINE = InnoDB; |
|
| 851 |
|
|
| 852 |
|
|
| 853 |
|
|
| 816 | 854 |
SET SQL_MODE=@OLD_SQL_MODE; |
| 817 | 855 |
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; |
| 818 | 856 |
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS; |
Also available in: Unified diff
schemas/VegCore/VegCore.my.sql: regenerated from ERD