Revision 8623
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 4 | 4 |
|
| 5 | 5 |
|
| 6 | 6 |
-- ----------------------------------------------------- |
| 7 |
-- Table `party` |
|
| 8 |
-- ----------------------------------------------------- |
|
| 9 |
CREATE TABLE IF NOT EXISTS `party` ( |
|
| 10 |
`id` VARBINARY(767) NOT NULL , |
|
| 11 |
`info` SET('hstore') NULL ,
|
|
| 12 |
PRIMARY KEY (`id`) , |
|
| 13 |
CONSTRAINT `fk_collection_source10` |
|
| 14 |
FOREIGN KEY (`id` ) |
|
| 15 |
REFERENCES `record` (`id` ) |
|
| 16 |
ON DELETE CASCADE |
|
| 17 |
ON UPDATE CASCADE) |
|
| 18 |
ENGINE = InnoDB |
|
| 19 |
DEFAULT CHARACTER SET = utf8 |
|
| 20 |
COLLATE = utf8_bin; |
|
| 21 |
|
|
| 22 |
|
|
| 23 |
-- ----------------------------------------------------- |
|
| 24 | 7 |
-- Table `source` |
| 25 | 8 |
-- ----------------------------------------------------- |
| 26 | 9 |
CREATE TABLE IF NOT EXISTS `source` ( |
| ... | ... | |
| 76 | 59 |
|
| 77 | 60 |
|
| 78 | 61 |
-- ----------------------------------------------------- |
| 62 |
-- Table `party` |
|
| 63 |
-- ----------------------------------------------------- |
|
| 64 |
CREATE TABLE IF NOT EXISTS `party` ( |
|
| 65 |
`id` VARBINARY(767) NOT NULL , |
|
| 66 |
`info` SET('hstore') NULL ,
|
|
| 67 |
PRIMARY KEY (`id`) , |
|
| 68 |
CONSTRAINT `fk_collection_source10` |
|
| 69 |
FOREIGN KEY (`id` ) |
|
| 70 |
REFERENCES `record` (`id` ) |
|
| 71 |
ON DELETE CASCADE |
|
| 72 |
ON UPDATE CASCADE) |
|
| 73 |
ENGINE = InnoDB |
|
| 74 |
DEFAULT CHARACTER SET = utf8 |
|
| 75 |
COLLATE = utf8_bin; |
|
| 76 |
|
|
| 77 |
|
|
| 78 |
-- ----------------------------------------------------- |
|
| 79 | 79 |
-- Table `relationship` |
| 80 | 80 |
-- ----------------------------------------------------- |
| 81 | 81 |
CREATE TABLE IF NOT EXISTS `relationship` ( |
| ... | ... | |
| 107 | 107 |
|
| 108 | 108 |
|
| 109 | 109 |
-- ----------------------------------------------------- |
| 110 |
-- Table `taxon_name`
|
|
| 110 |
-- Table `collection`
|
|
| 111 | 111 |
-- ----------------------------------------------------- |
| 112 |
CREATE TABLE IF NOT EXISTS `taxon_name` (
|
|
| 112 |
CREATE TABLE IF NOT EXISTS `collection` (
|
|
| 113 | 113 |
`id` VARBINARY(767) NOT NULL , |
| 114 |
`unique_name` VARBINARY(767) NOT NULL , |
|
| 115 |
`formal_name` VARBINARY(767) NULL , |
|
| 116 |
`taxon_name` VARBINARY(767) NULL , |
|
| 117 |
`author` VARBINARY(767) NULL , |
|
| 118 |
`common_name` VARBINARY(767) NULL , |
|
| 119 |
`rank` VARBINARY(767) NULL , |
|
| 120 | 114 |
PRIMARY KEY (`id`) , |
| 121 |
INDEX `fk_taxon_concept_taxon_string10_idx` (`unique_name` ASC) , |
|
| 122 |
CONSTRAINT `fk_taxon_record10` |
|
| 115 |
CONSTRAINT `fk_collection_source1` |
|
| 123 | 116 |
FOREIGN KEY (`id` ) |
| 117 |
REFERENCES `source` (`id` ) |
|
| 118 |
ON DELETE CASCADE |
|
| 119 |
ON UPDATE CASCADE) |
|
| 120 |
ENGINE = InnoDB |
|
| 121 |
DEFAULT CHARACTER SET = utf8 |
|
| 122 |
COLLATE = utf8_bin; |
|
| 123 |
|
|
| 124 |
|
|
| 125 |
-- ----------------------------------------------------- |
|
| 126 |
-- Table `taxon_assertion` |
|
| 127 |
-- ----------------------------------------------------- |
|
| 128 |
CREATE TABLE IF NOT EXISTS `taxon_assertion` ( |
|
| 129 |
`id` VARBINARY(767) NOT NULL , |
|
| 130 |
`string` VARBINARY(767) NOT NULL , |
|
| 131 |
`taxon` VARBINARY(767) NULL , |
|
| 132 |
`cf_aff` VARBINARY(767) NULL , |
|
| 133 |
`annotations` SET('hstore') NULL ,
|
|
| 134 |
PRIMARY KEY (`id`) , |
|
| 135 |
INDEX `fk_taxon_assertion_taxon_string1_idx` (`string` ASC) , |
|
| 136 |
INDEX `fk_taxon_assertion_taxon_name1_idx` (`taxon` ASC) , |
|
| 137 |
CONSTRAINT `fk_qualified_taxon_record1` |
|
| 138 |
FOREIGN KEY (`id` ) |
|
| 124 | 139 |
REFERENCES `record` (`id` ) |
| 125 | 140 |
ON DELETE CASCADE |
| 126 | 141 |
ON UPDATE CASCADE, |
| 127 |
CONSTRAINT `fk_taxon_concept_taxon_string10`
|
|
| 128 |
FOREIGN KEY (`unique_name` )
|
|
| 142 |
CONSTRAINT `fk_taxon_assertion_taxon_string1`
|
|
| 143 |
FOREIGN KEY (`string` )
|
|
| 129 | 144 |
REFERENCES `taxon_string` (`string` ) |
| 130 | 145 |
ON DELETE CASCADE |
| 146 |
ON UPDATE CASCADE, |
|
| 147 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` |
|
| 148 |
FOREIGN KEY (`taxon` ) |
|
| 149 |
REFERENCES `taxon_name` (`id` ) |
|
| 150 |
ON DELETE CASCADE |
|
| 131 | 151 |
ON UPDATE CASCADE) |
| 132 | 152 |
ENGINE = InnoDB |
| 133 | 153 |
DEFAULT CHARACTER SET = utf8 |
| ... | ... | |
| 178 | 198 |
|
| 179 | 199 |
|
| 180 | 200 |
-- ----------------------------------------------------- |
| 181 |
-- Table `taxon_assertion`
|
|
| 201 |
-- Table `taxon_name`
|
|
| 182 | 202 |
-- ----------------------------------------------------- |
| 183 |
CREATE TABLE IF NOT EXISTS `taxon_assertion` (
|
|
| 203 |
CREATE TABLE IF NOT EXISTS `taxon_name` (
|
|
| 184 | 204 |
`id` VARBINARY(767) NOT NULL , |
| 185 |
`string` VARBINARY(767) NOT NULL , |
|
| 186 |
`taxon` VARBINARY(767) NULL , |
|
| 187 |
`cf_aff` VARBINARY(767) NULL , |
|
| 188 |
`annotations` SET('hstore') NULL ,
|
|
| 205 |
`unique_name` VARBINARY(767) NOT NULL , |
|
| 206 |
`formal_name` VARBINARY(767) NULL , |
|
| 207 |
`taxon_name` VARBINARY(767) NULL , |
|
| 208 |
`author` VARBINARY(767) NULL , |
|
| 209 |
`common_name` VARBINARY(767) NULL , |
|
| 210 |
`rank` VARBINARY(767) NULL , |
|
| 189 | 211 |
PRIMARY KEY (`id`) , |
| 190 |
INDEX `fk_taxon_assertion_taxon_string1_idx` (`string` ASC) , |
|
| 191 |
INDEX `fk_taxon_assertion_taxon_name1_idx` (`taxon` ASC) , |
|
| 192 |
CONSTRAINT `fk_qualified_taxon_record1` |
|
| 212 |
INDEX `fk_taxon_concept_taxon_string10_idx` (`unique_name` ASC) , |
|
| 213 |
CONSTRAINT `fk_taxon_record10` |
|
| 193 | 214 |
FOREIGN KEY (`id` ) |
| 194 | 215 |
REFERENCES `record` (`id` ) |
| 195 | 216 |
ON DELETE CASCADE |
| 196 | 217 |
ON UPDATE CASCADE, |
| 197 |
CONSTRAINT `fk_taxon_assertion_taxon_string1`
|
|
| 198 |
FOREIGN KEY (`string` )
|
|
| 218 |
CONSTRAINT `fk_taxon_concept_taxon_string10`
|
|
| 219 |
FOREIGN KEY (`unique_name` )
|
|
| 199 | 220 |
REFERENCES `taxon_string` (`string` ) |
| 200 | 221 |
ON DELETE CASCADE |
| 201 |
ON UPDATE CASCADE, |
|
| 202 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` |
|
| 203 |
FOREIGN KEY (`taxon` ) |
|
| 204 |
REFERENCES `taxon_name` (`id` ) |
|
| 205 |
ON DELETE CASCADE |
|
| 206 | 222 |
ON UPDATE CASCADE) |
| 207 | 223 |
ENGINE = InnoDB |
| 208 | 224 |
DEFAULT CHARACTER SET = utf8 |
| ... | ... | |
| 334 | 350 |
|
| 335 | 351 |
|
| 336 | 352 |
-- ----------------------------------------------------- |
| 353 |
-- Table `organization` |
|
| 354 |
-- ----------------------------------------------------- |
|
| 355 |
CREATE TABLE IF NOT EXISTS `organization` ( |
|
| 356 |
`id` VARBINARY(767) NOT NULL , |
|
| 357 |
`info` SET('hstore') NULL ,
|
|
| 358 |
PRIMARY KEY (`id`) , |
|
| 359 |
CONSTRAINT `fk_organization_party1` |
|
| 360 |
FOREIGN KEY (`id` ) |
|
| 361 |
REFERENCES `party` (`id` ) |
|
| 362 |
ON DELETE CASCADE |
|
| 363 |
ON UPDATE CASCADE) |
|
| 364 |
ENGINE = InnoDB |
|
| 365 |
DEFAULT CHARACTER SET = utf8 |
|
| 366 |
COLLATE = utf8_bin; |
|
| 367 |
|
|
| 368 |
|
|
| 369 |
-- ----------------------------------------------------- |
|
| 370 |
-- Table `specimen` |
|
| 371 |
-- ----------------------------------------------------- |
|
| 372 |
CREATE TABLE IF NOT EXISTS `specimen` ( |
|
| 373 |
`id` VARBINARY(767) NOT NULL , |
|
| 374 |
`collection` VARBINARY(767) NULL , |
|
| 375 |
`stamping_institution` VARBINARY(767) NULL , |
|
| 376 |
`donor_institution` VARBINARY(767) NULL , |
|
| 377 |
`owner` VARBINARY(767) NULL , |
|
| 378 |
`barcode` VARBINARY(767) NULL , |
|
| 379 |
`accession_number` VARBINARY(767) NULL , |
|
| 380 |
PRIMARY KEY (`id`) , |
|
| 381 |
INDEX `fk_specimen_collection1_idx` (`collection` ASC) , |
|
| 382 |
INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) , |
|
| 383 |
INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) , |
|
| 384 |
INDEX `fk_specimen_organization3_idx` (`owner` ASC) , |
|
| 385 |
CONSTRAINT `fk_specimen_taxon_occurrence1` |
|
| 386 |
FOREIGN KEY (`id` ) |
|
| 387 |
REFERENCES `taxon_occurrence` (`id` ) |
|
| 388 |
ON DELETE CASCADE |
|
| 389 |
ON UPDATE CASCADE, |
|
| 390 |
CONSTRAINT `fk_specimen_collection1` |
|
| 391 |
FOREIGN KEY (`collection` ) |
|
| 392 |
REFERENCES `collection` (`id` ) |
|
| 393 |
ON DELETE CASCADE |
|
| 394 |
ON UPDATE CASCADE, |
|
| 395 |
CONSTRAINT `fk_specimen_organization1` |
|
| 396 |
FOREIGN KEY (`stamping_institution` ) |
|
| 397 |
REFERENCES `organization` (`id` ) |
|
| 398 |
ON DELETE CASCADE |
|
| 399 |
ON UPDATE CASCADE, |
|
| 400 |
CONSTRAINT `fk_specimen_organization2` |
|
| 401 |
FOREIGN KEY (`donor_institution` ) |
|
| 402 |
REFERENCES `organization` (`id` ) |
|
| 403 |
ON DELETE CASCADE |
|
| 404 |
ON UPDATE CASCADE, |
|
| 405 |
CONSTRAINT `fk_specimen_organization3` |
|
| 406 |
FOREIGN KEY (`owner` ) |
|
| 407 |
REFERENCES `organization` (`id` ) |
|
| 408 |
ON DELETE CASCADE |
|
| 409 |
ON UPDATE CASCADE) |
|
| 410 |
ENGINE = InnoDB |
|
| 411 |
DEFAULT CHARACTER SET = utf8 |
|
| 412 |
COLLATE = utf8_bin; |
|
| 413 |
|
|
| 414 |
|
|
| 415 |
-- ----------------------------------------------------- |
|
| 337 | 416 |
-- Table `taxon_observation` |
| 338 | 417 |
-- ----------------------------------------------------- |
| 339 | 418 |
CREATE TABLE IF NOT EXISTS `taxon_observation` ( |
| ... | ... | |
| 444 | 523 |
|
| 445 | 524 |
|
| 446 | 525 |
-- ----------------------------------------------------- |
| 447 |
-- Table `collection` |
|
| 448 |
-- ----------------------------------------------------- |
|
| 449 |
CREATE TABLE IF NOT EXISTS `collection` ( |
|
| 450 |
`id` VARBINARY(767) NOT NULL , |
|
| 451 |
PRIMARY KEY (`id`) , |
|
| 452 |
CONSTRAINT `fk_collection_source1` |
|
| 453 |
FOREIGN KEY (`id` ) |
|
| 454 |
REFERENCES `source` (`id` ) |
|
| 455 |
ON DELETE CASCADE |
|
| 456 |
ON UPDATE CASCADE) |
|
| 457 |
ENGINE = InnoDB |
|
| 458 |
DEFAULT CHARACTER SET = utf8 |
|
| 459 |
COLLATE = utf8_bin; |
|
| 460 |
|
|
| 461 |
|
|
| 462 |
-- ----------------------------------------------------- |
|
| 463 |
-- Table `organization` |
|
| 464 |
-- ----------------------------------------------------- |
|
| 465 |
CREATE TABLE IF NOT EXISTS `organization` ( |
|
| 466 |
`id` VARBINARY(767) NOT NULL , |
|
| 467 |
`info` SET('hstore') NULL ,
|
|
| 468 |
PRIMARY KEY (`id`) , |
|
| 469 |
CONSTRAINT `fk_organization_party1` |
|
| 470 |
FOREIGN KEY (`id` ) |
|
| 471 |
REFERENCES `party` (`id` ) |
|
| 472 |
ON DELETE CASCADE |
|
| 473 |
ON UPDATE CASCADE) |
|
| 474 |
ENGINE = InnoDB |
|
| 475 |
DEFAULT CHARACTER SET = utf8 |
|
| 476 |
COLLATE = utf8_bin; |
|
| 477 |
|
|
| 478 |
|
|
| 479 |
-- ----------------------------------------------------- |
|
| 480 |
-- Table `specimen` |
|
| 481 |
-- ----------------------------------------------------- |
|
| 482 |
CREATE TABLE IF NOT EXISTS `specimen` ( |
|
| 483 |
`id` VARBINARY(767) NOT NULL , |
|
| 484 |
`collection` VARBINARY(767) NULL , |
|
| 485 |
`stamping_institution` VARBINARY(767) NULL , |
|
| 486 |
`donor_institution` VARBINARY(767) NULL , |
|
| 487 |
`owner` VARBINARY(767) NULL , |
|
| 488 |
`barcode` VARBINARY(767) NULL , |
|
| 489 |
`accession_number` VARBINARY(767) NULL , |
|
| 490 |
PRIMARY KEY (`id`) , |
|
| 491 |
INDEX `fk_specimen_collection1_idx` (`collection` ASC) , |
|
| 492 |
INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) , |
|
| 493 |
INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) , |
|
| 494 |
INDEX `fk_specimen_organization3_idx` (`owner` ASC) , |
|
| 495 |
CONSTRAINT `fk_specimen_taxon_occurrence1` |
|
| 496 |
FOREIGN KEY (`id` ) |
|
| 497 |
REFERENCES `taxon_occurrence` (`id` ) |
|
| 498 |
ON DELETE CASCADE |
|
| 499 |
ON UPDATE CASCADE, |
|
| 500 |
CONSTRAINT `fk_specimen_collection1` |
|
| 501 |
FOREIGN KEY (`collection` ) |
|
| 502 |
REFERENCES `collection` (`id` ) |
|
| 503 |
ON DELETE CASCADE |
|
| 504 |
ON UPDATE CASCADE, |
|
| 505 |
CONSTRAINT `fk_specimen_organization1` |
|
| 506 |
FOREIGN KEY (`stamping_institution` ) |
|
| 507 |
REFERENCES `organization` (`id` ) |
|
| 508 |
ON DELETE CASCADE |
|
| 509 |
ON UPDATE CASCADE, |
|
| 510 |
CONSTRAINT `fk_specimen_organization2` |
|
| 511 |
FOREIGN KEY (`donor_institution` ) |
|
| 512 |
REFERENCES `organization` (`id` ) |
|
| 513 |
ON DELETE CASCADE |
|
| 514 |
ON UPDATE CASCADE, |
|
| 515 |
CONSTRAINT `fk_specimen_organization3` |
|
| 516 |
FOREIGN KEY (`owner` ) |
|
| 517 |
REFERENCES `organization` (`id` ) |
|
| 518 |
ON DELETE CASCADE |
|
| 519 |
ON UPDATE CASCADE) |
|
| 520 |
ENGINE = InnoDB |
|
| 521 |
DEFAULT CHARACTER SET = utf8 |
|
| 522 |
COLLATE = utf8_bin; |
|
| 523 |
|
|
| 524 |
|
|
| 525 |
-- ----------------------------------------------------- |
|
| 526 | 526 |
-- Table `individual` |
| 527 | 527 |
-- ----------------------------------------------------- |
| 528 | 528 |
CREATE TABLE IF NOT EXISTS `individual` ( |
| ... | ... | |
| 541 | 541 |
|
| 542 | 542 |
|
| 543 | 543 |
-- ----------------------------------------------------- |
| 544 |
-- Table `individual_observation` |
|
| 545 |
-- ----------------------------------------------------- |
|
| 546 |
CREATE TABLE IF NOT EXISTS `individual_observation` ( |
|
| 547 |
`id` VARBINARY(767) NOT NULL , |
|
| 548 |
`individual` VARBINARY(767) NOT NULL , |
|
| 549 |
`traits` SET('hstore') NULL ,
|
|
| 550 |
PRIMARY KEY (`id`) , |
|
| 551 |
INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) , |
|
| 552 |
CONSTRAINT `fk_individual_observation_taxon_occurrence1` |
|
| 553 |
FOREIGN KEY (`id` ) |
|
| 554 |
REFERENCES `taxon_observation` (`id` ) |
|
| 555 |
ON DELETE CASCADE |
|
| 556 |
ON UPDATE CASCADE, |
|
| 557 |
CONSTRAINT `fk_individual_observation_individual1` |
|
| 558 |
FOREIGN KEY (`individual` ) |
|
| 559 |
REFERENCES `individual` (`id` ) |
|
| 560 |
ON DELETE CASCADE |
|
| 561 |
ON UPDATE CASCADE) |
|
| 562 |
ENGINE = InnoDB |
|
| 563 |
DEFAULT CHARACTER SET = utf8 |
|
| 564 |
COLLATE = utf8_bin; |
|
| 565 |
|
|
| 566 |
|
|
| 567 |
-- ----------------------------------------------------- |
|
| 568 |
-- Table `stem` |
|
| 569 |
-- ----------------------------------------------------- |
|
| 570 |
CREATE TABLE IF NOT EXISTS `stem` ( |
|
| 571 |
`id` VARBINARY(767) NOT NULL , |
|
| 572 |
`individual` VARBINARY(767) NOT NULL , |
|
| 573 |
PRIMARY KEY (`id`) , |
|
| 574 |
INDEX `fk_stem_individual1_idx` (`individual` ASC) , |
|
| 575 |
CONSTRAINT `fk_stem_individual1` |
|
| 576 |
FOREIGN KEY (`individual` ) |
|
| 577 |
REFERENCES `individual` (`id` ) |
|
| 578 |
ON DELETE CASCADE |
|
| 579 |
ON UPDATE CASCADE, |
|
| 580 |
CONSTRAINT `fk_stem_individual2` |
|
| 581 |
FOREIGN KEY (`id` ) |
|
| 582 |
REFERENCES `individual` (`id` ) |
|
| 583 |
ON DELETE CASCADE |
|
| 584 |
ON UPDATE CASCADE) |
|
| 585 |
ENGINE = InnoDB |
|
| 586 |
DEFAULT CHARACTER SET = utf8 |
|
| 587 |
COLLATE = utf8_bin; |
|
| 588 |
|
|
| 589 |
|
|
| 590 |
-- ----------------------------------------------------- |
|
| 591 |
-- Table `stem_observation` |
|
| 592 |
-- ----------------------------------------------------- |
|
| 593 |
CREATE TABLE IF NOT EXISTS `stem_observation` ( |
|
| 594 |
`id` VARBINARY(767) NOT NULL , |
|
| 595 |
`individual_observation` VARBINARY(767) NOT NULL , |
|
| 596 |
`stem` VARBINARY(767) NOT NULL , |
|
| 597 |
`traits` SET('hstore') NULL ,
|
|
| 598 |
PRIMARY KEY (`id`) , |
|
| 599 |
INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) , |
|
| 600 |
INDEX `fk_stem_observation_stem1_idx` (`stem` ASC) , |
|
| 601 |
UNIQUE INDEX `stem_observation_unique` (`individual_observation` ASC, `stem` ASC) , |
|
| 602 |
CONSTRAINT `fk_stem_observation_individual_observation1` |
|
| 603 |
FOREIGN KEY (`individual_observation` ) |
|
| 604 |
REFERENCES `individual_observation` (`id` ) |
|
| 605 |
ON DELETE CASCADE |
|
| 606 |
ON UPDATE CASCADE, |
|
| 607 |
CONSTRAINT `fk_stem_observation_stem1` |
|
| 608 |
FOREIGN KEY (`stem` ) |
|
| 609 |
REFERENCES `stem` (`id` ) |
|
| 610 |
ON DELETE CASCADE |
|
| 611 |
ON UPDATE CASCADE, |
|
| 612 |
CONSTRAINT `fk_stem_observation_individual_observation2` |
|
| 613 |
FOREIGN KEY (`id` ) |
|
| 614 |
REFERENCES `individual_observation` (`id` ) |
|
| 615 |
ON DELETE CASCADE |
|
| 616 |
ON UPDATE CASCADE) |
|
| 617 |
ENGINE = InnoDB |
|
| 618 |
DEFAULT CHARACTER SET = utf8 |
|
| 619 |
COLLATE = utf8_bin; |
|
| 620 |
|
|
| 621 |
|
|
| 622 |
-- ----------------------------------------------------- |
|
| 623 | 544 |
-- Table `aggregate_observation` |
| 624 | 545 |
-- ----------------------------------------------------- |
| 625 | 546 |
CREATE TABLE IF NOT EXISTS `aggregate_observation` ( |
| ... | ... | |
| 862 | 783 |
|
| 863 | 784 |
|
| 864 | 785 |
-- ----------------------------------------------------- |
| 786 |
-- Table `individual_observation` |
|
| 787 |
-- ----------------------------------------------------- |
|
| 788 |
CREATE TABLE IF NOT EXISTS `individual_observation` ( |
|
| 789 |
`id` VARBINARY(767) NOT NULL , |
|
| 790 |
`individual` VARBINARY(767) NOT NULL , |
|
| 791 |
`traits` SET('hstore') NULL ,
|
|
| 792 |
PRIMARY KEY (`id`) , |
|
| 793 |
INDEX `fk_individual_observation_individual1_idx` (`individual` ASC) , |
|
| 794 |
CONSTRAINT `fk_individual_observation_taxon_occurrence1` |
|
| 795 |
FOREIGN KEY (`id` ) |
|
| 796 |
REFERENCES `taxon_observation` (`id` ) |
|
| 797 |
ON DELETE CASCADE |
|
| 798 |
ON UPDATE CASCADE, |
|
| 799 |
CONSTRAINT `fk_individual_observation_individual1` |
|
| 800 |
FOREIGN KEY (`individual` ) |
|
| 801 |
REFERENCES `individual` (`id` ) |
|
| 802 |
ON DELETE CASCADE |
|
| 803 |
ON UPDATE CASCADE) |
|
| 804 |
ENGINE = InnoDB |
|
| 805 |
DEFAULT CHARACTER SET = utf8 |
|
| 806 |
COLLATE = utf8_bin; |
|
| 807 |
|
|
| 808 |
|
|
| 809 |
-- ----------------------------------------------------- |
|
| 810 |
-- Table `stem` |
|
| 811 |
-- ----------------------------------------------------- |
|
| 812 |
CREATE TABLE IF NOT EXISTS `stem` ( |
|
| 813 |
`id` VARBINARY(767) NOT NULL , |
|
| 814 |
`individual` VARBINARY(767) NOT NULL , |
|
| 815 |
PRIMARY KEY (`id`) , |
|
| 816 |
INDEX `fk_stem_individual1_idx` (`individual` ASC) , |
|
| 817 |
CONSTRAINT `fk_stem_individual1` |
|
| 818 |
FOREIGN KEY (`individual` ) |
|
| 819 |
REFERENCES `individual` (`id` ) |
|
| 820 |
ON DELETE CASCADE |
|
| 821 |
ON UPDATE CASCADE, |
|
| 822 |
CONSTRAINT `fk_stem_individual2` |
|
| 823 |
FOREIGN KEY (`id` ) |
|
| 824 |
REFERENCES `individual` (`id` ) |
|
| 825 |
ON DELETE CASCADE |
|
| 826 |
ON UPDATE CASCADE) |
|
| 827 |
ENGINE = InnoDB |
|
| 828 |
DEFAULT CHARACTER SET = utf8 |
|
| 829 |
COLLATE = utf8_bin; |
|
| 830 |
|
|
| 831 |
|
|
| 832 |
-- ----------------------------------------------------- |
|
| 833 |
-- Table `stem_observation` |
|
| 834 |
-- ----------------------------------------------------- |
|
| 835 |
CREATE TABLE IF NOT EXISTS `stem_observation` ( |
|
| 836 |
`id` VARBINARY(767) NOT NULL , |
|
| 837 |
`individual_observation` VARBINARY(767) NOT NULL , |
|
| 838 |
`stem` VARBINARY(767) NOT NULL , |
|
| 839 |
`traits` SET('hstore') NULL ,
|
|
| 840 |
PRIMARY KEY (`id`) , |
|
| 841 |
INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) , |
|
| 842 |
INDEX `fk_stem_observation_stem1_idx` (`stem` ASC) , |
|
| 843 |
UNIQUE INDEX `stem_observation_unique` (`individual_observation` ASC, `stem` ASC) , |
|
| 844 |
CONSTRAINT `fk_stem_observation_individual_observation1` |
|
| 845 |
FOREIGN KEY (`individual_observation` ) |
|
| 846 |
REFERENCES `individual_observation` (`id` ) |
|
| 847 |
ON DELETE CASCADE |
|
| 848 |
ON UPDATE CASCADE, |
|
| 849 |
CONSTRAINT `fk_stem_observation_stem1` |
|
| 850 |
FOREIGN KEY (`stem` ) |
|
| 851 |
REFERENCES `stem` (`id` ) |
|
| 852 |
ON DELETE CASCADE |
|
| 853 |
ON UPDATE CASCADE, |
|
| 854 |
CONSTRAINT `fk_stem_observation_individual_observation2` |
|
| 855 |
FOREIGN KEY (`id` ) |
|
| 856 |
REFERENCES `individual_observation` (`id` ) |
|
| 857 |
ON DELETE CASCADE |
|
| 858 |
ON UPDATE CASCADE) |
|
| 859 |
ENGINE = InnoDB |
|
| 860 |
DEFAULT CHARACTER SET = utf8 |
|
| 861 |
COLLATE = utf8_bin; |
|
| 862 |
|
|
| 863 |
|
|
| 864 |
-- ----------------------------------------------------- |
|
| 865 | 865 |
-- Table `project` |
| 866 | 866 |
-- ----------------------------------------------------- |
| 867 | 867 |
CREATE TABLE IF NOT EXISTS `project` ( |
| ... | ... | |
| 953 | 953 |
|
| 954 | 954 |
|
| 955 | 955 |
-- ----------------------------------------------------- |
| 956 |
-- Table `plot_stratum`
|
|
| 956 |
-- Table `1. verbatim`
|
|
| 957 | 957 |
-- ----------------------------------------------------- |
| 958 |
CREATE TABLE IF NOT EXISTS `plot_stratum` (
|
|
| 958 |
CREATE TABLE IF NOT EXISTS `1. verbatim` (
|
|
| 959 | 959 |
`id` VARBINARY(767) NOT NULL , |
| 960 |
`stratum` VARBINARY(767) NOT NULL , |
|
| 961 |
PRIMARY KEY (`id`) , |
|
| 962 |
INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) , |
|
| 963 |
CONSTRAINT `fk_subplot_place10` |
|
| 964 |
FOREIGN KEY (`id` ) |
|
| 965 |
REFERENCES `place` (`id` ) |
|
| 966 |
ON DELETE CASCADE |
|
| 967 |
ON UPDATE CASCADE, |
|
| 968 |
CONSTRAINT `fk_plot_stratum_stratum1` |
|
| 969 |
FOREIGN KEY (`stratum` ) |
|
| 970 |
REFERENCES `stratum` (`id` ) |
|
| 971 |
ON DELETE CASCADE |
|
| 972 |
ON UPDATE CASCADE) |
|
| 960 |
PRIMARY KEY (`id`) ) |
|
| 973 | 961 |
ENGINE = InnoDB |
| 974 | 962 |
DEFAULT CHARACTER SET = utf8 |
| 975 | 963 |
COLLATE = utf8_bin; |
| 976 | 964 |
|
| 977 | 965 |
|
| 978 | 966 |
-- ----------------------------------------------------- |
| 979 |
-- Table `1. verbatim`
|
|
| 967 |
-- Table `2. concatenated`
|
|
| 980 | 968 |
-- ----------------------------------------------------- |
| 981 |
CREATE TABLE IF NOT EXISTS `1. verbatim` (
|
|
| 969 |
CREATE TABLE IF NOT EXISTS `2. concatenated` (
|
|
| 982 | 970 |
`id` VARBINARY(767) NOT NULL , |
| 983 | 971 |
PRIMARY KEY (`id`) ) |
| 984 | 972 |
ENGINE = InnoDB |
| ... | ... | |
| 987 | 975 |
|
| 988 | 976 |
|
| 989 | 977 |
-- ----------------------------------------------------- |
| 990 |
-- Table `2. concatenated`
|
|
| 978 |
-- Table `3. parsed`
|
|
| 991 | 979 |
-- ----------------------------------------------------- |
| 992 |
CREATE TABLE IF NOT EXISTS `2. concatenated` (
|
|
| 980 |
CREATE TABLE IF NOT EXISTS `3. parsed` (
|
|
| 993 | 981 |
`id` VARBINARY(767) NOT NULL , |
| 994 | 982 |
PRIMARY KEY (`id`) ) |
| 995 | 983 |
ENGINE = InnoDB |
| ... | ... | |
| 998 | 986 |
|
| 999 | 987 |
|
| 1000 | 988 |
-- ----------------------------------------------------- |
| 1001 |
-- Table `3. parsed`
|
|
| 989 |
-- Table `plot_stratum`
|
|
| 1002 | 990 |
-- ----------------------------------------------------- |
| 1003 |
CREATE TABLE IF NOT EXISTS `3. parsed` (
|
|
| 991 |
CREATE TABLE IF NOT EXISTS `plot_stratum` (
|
|
| 1004 | 992 |
`id` VARBINARY(767) NOT NULL , |
| 1005 |
PRIMARY KEY (`id`) ) |
|
| 993 |
`stratum` VARBINARY(767) NOT NULL , |
|
| 994 |
PRIMARY KEY (`id`) , |
|
| 995 |
INDEX `fk_plot_stratum_stratum1_idx` (`stratum` ASC) , |
|
| 996 |
CONSTRAINT `fk_subplot_place10` |
|
| 997 |
FOREIGN KEY (`id` ) |
|
| 998 |
REFERENCES `place` (`id` ) |
|
| 999 |
ON DELETE CASCADE |
|
| 1000 |
ON UPDATE CASCADE, |
|
| 1001 |
CONSTRAINT `fk_plot_stratum_stratum1` |
|
| 1002 |
FOREIGN KEY (`stratum` ) |
|
| 1003 |
REFERENCES `stratum` (`id` ) |
|
| 1004 |
ON DELETE CASCADE |
|
| 1005 |
ON UPDATE CASCADE) |
|
| 1006 | 1006 |
ENGINE = InnoDB |
| 1007 | 1007 |
DEFAULT CHARACTER SET = utf8 |
| 1008 | 1008 |
COLLATE = utf8_bin; |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: re-synced with VegCore.my.sql: step 1: table order changed