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