Revision 10469
Added by Aaron Marcuse-Kubitza almost 11 years ago
| VegCore.my.sql | ||
|---|---|---|
| 72 | 72 |
UNIQUE KEY `collection_unique` (`institution`,`name`), |
| 73 | 73 |
KEY `fk_collection_organization1_idx` (`institution`), |
| 74 | 74 |
KEY `fk_collection_source1_idx` (`id`), |
| 75 |
CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 76 |
CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 75 |
CONSTRAINT `fk_collection_source1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 76 |
CONSTRAINT `fk_collection_organization1` FOREIGN KEY (`institution`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 77 | 77 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"the collection within the institution where a specimen is held" ("Brad Boyle":https://projects.nceas.ucsb.edu/nceas/attachments/download/621/vegbien_identifier_examples.xlsx#terms/collectionCode)';
|
| 78 | 78 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 79 | 79 |
|
| ... | ... | |
| 143 | 143 |
KEY `fk_event_place1_idx` (`place`), |
| 144 | 144 |
KEY `fk_event1_idx` (`parent`), |
| 145 | 145 |
KEY `fk_event_party_list1_idx` (`participants`), |
| 146 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 146 | 147 |
CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 147 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 148 | 148 |
CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 149 | 149 |
CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 150 | 150 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of time" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)';
|
| ... | ... | |
| 226 | 226 |
/*!40000 ALTER TABLE `geopath` ENABLE KEYS */; |
| 227 | 227 |
|
| 228 | 228 |
-- |
| 229 |
-- Table structure for table `geovalidatable_place`
|
|
| 229 |
-- Table structure for table `geoplace` |
|
| 230 | 230 |
-- |
| 231 | 231 |
|
| 232 | 232 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
| 233 | 233 |
/*!40101 SET character_set_client = utf8 */; |
| 234 |
CREATE TABLE `geovalidatable_place` (
|
|
| 234 |
CREATE TABLE `geoplace` ( |
|
| 235 | 235 |
`id` varbinary(767) NOT NULL, |
| 236 | 236 |
`geocoordinates` varbinary(767) NOT NULL, |
| 237 | 237 |
`geopath` varbinary(767) NOT NULL, |
| ... | ... | |
| 239 | 239 |
UNIQUE KEY `validatable_place_unique` (`geopath`,`geocoordinates`), |
| 240 | 240 |
KEY `fk_geovalidation_place_path1_idx` (`geopath`), |
| 241 | 241 |
KEY `fk_geovalidation_coordinates1_idx` (`geocoordinates`), |
| 242 |
CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 243 |
CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 242 |
CONSTRAINT `fk_geovalidation_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 243 |
CONSTRAINT `fk_geovalidation_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 244 | 244 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 245 | 245 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 246 | 246 |
|
| 247 | 247 |
-- |
| 248 |
-- Dumping data for table `geovalidatable_place`
|
|
| 248 |
-- Dumping data for table `geoplace` |
|
| 249 | 249 |
-- |
| 250 | 250 |
|
| 251 |
/*!40000 ALTER TABLE `geovalidatable_place` DISABLE KEYS */;
|
|
| 252 |
/*!40000 ALTER TABLE `geovalidatable_place` ENABLE KEYS */;
|
|
| 251 |
/*!40000 ALTER TABLE `geoplace` DISABLE KEYS */; |
|
| 252 |
/*!40000 ALTER TABLE `geoplace` ENABLE KEYS */; |
|
| 253 | 253 |
|
| 254 | 254 |
-- |
| 255 | 255 |
-- Table structure for table `geovalidation` |
| ... | ... | |
| 263 | 263 |
`lat_long_domain_valid` tinyint(1) NOT NULL, |
| 264 | 264 |
`lat_long_in_place_ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 265 | 265 |
PRIMARY KEY (`id`), |
| 266 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geovalidatable_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 266 |
CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 267 | 267 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'; |
| 268 | 268 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 269 | 269 |
|
| ... | ... | |
| 333 | 333 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 334 | 334 |
PRIMARY KEY (`id`), |
| 335 | 335 |
KEY `fk_method_method1_idx` (`parent`), |
| 336 |
CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 337 |
CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 336 |
CONSTRAINT `fk_method_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 337 |
CONSTRAINT `fk_method_method1` FOREIGN KEY (`parent`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 338 | 338 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A specific method definition followed in the creation of the dataset. Each method links to a protocol and literature citation reference. A protocol may have many method or steps." ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/methods/method)';
|
| 339 | 339 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 340 | 340 |
|
| ... | ... | |
| 367 | 367 |
/*!40000 ALTER TABLE `organization` ENABLE KEYS */; |
| 368 | 368 |
|
| 369 | 369 |
-- |
| 370 |
-- Table structure for table `parsed_taxon_assertion` |
|
| 371 |
-- |
|
| 372 |
|
|
| 373 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 374 |
/*!40101 SET character_set_client = utf8 */; |
|
| 375 |
CREATE TABLE `parsed_taxon_assertion` ( |
|
| 376 |
`id` varbinary(767) NOT NULL, |
|
| 377 |
`matched_taxon_concept` varbinary(767) DEFAULT NULL, |
|
| 378 |
`match_score` float DEFAULT NULL, |
|
| 379 |
`match_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 380 |
PRIMARY KEY (`id`), |
|
| 381 |
KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`), |
|
| 382 |
CONSTRAINT `fk_matched_taxon_qualified_taxon10` FOREIGN KEY (`id`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 383 |
CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 384 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 385 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 386 |
|
|
| 387 |
-- |
|
| 388 |
-- Dumping data for table `parsed_taxon_assertion` |
|
| 389 |
-- |
|
| 390 |
|
|
| 391 |
/*!40000 ALTER TABLE `parsed_taxon_assertion` DISABLE KEYS */; |
|
| 392 |
/*!40000 ALTER TABLE `parsed_taxon_assertion` ENABLE KEYS */; |
|
| 393 |
|
|
| 394 |
-- |
|
| 395 | 370 |
-- Table structure for table `party` |
| 396 | 371 |
-- |
| 397 | 372 |
|
| ... | ... | |
| 403 | 378 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 404 | 379 |
PRIMARY KEY (`id`), |
| 405 | 380 |
KEY `fk_party_organization1_idx` (`organization`), |
| 406 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 407 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 381 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 382 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 408 | 383 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 409 | 384 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 410 | 385 |
|
| ... | ... | |
| 449 | 424 |
PRIMARY KEY (`id`,`entry`), |
| 450 | 425 |
KEY `fk_party_list_has_party_party1_idx` (`entry`), |
| 451 | 426 |
KEY `fk_party_list_has_party_party_list1_idx` (`id`), |
| 452 |
CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 453 |
CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 427 |
CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 428 |
CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 454 | 429 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 455 | 430 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 456 | 431 |
|
| ... | ... | |
| 477 | 452 |
KEY `fk_place_coordinates1_idx` (`geocoordinates`), |
| 478 | 453 |
KEY `fk_place1_idx` (`parent`), |
| 479 | 454 |
KEY `fk_place_place_path1_idx` (`geopath`), |
| 455 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 456 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 480 | 457 |
CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 481 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 482 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 483 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 458 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 484 | 459 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point';
|
| 485 | 460 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 486 | 461 |
|
| ... | ... | |
| 510 | 485 |
KEY `fk_place_observation_place1_idx` (`place`), |
| 511 | 486 |
KEY `fk_place_observation_geological_context1_idx` (`geological_context`), |
| 512 | 487 |
KEY `fk_place_observation_community1_idx` (`community`), |
| 488 |
CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 489 |
CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 513 | 490 |
CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 514 |
CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 515 |
CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 516 | 491 |
CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 517 | 492 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'; |
| 518 | 493 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 656 | 631 |
`method` varbinary(767) DEFAULT NULL, |
| 657 | 632 |
PRIMARY KEY (`id`), |
| 658 | 633 |
KEY `fk_sampling_event_method1_idx` (`method`), |
| 659 |
CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 660 |
CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 634 |
CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 635 |
CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 661 | 636 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 662 | 637 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 663 | 638 |
|
| ... | ... | |
| 748 | 723 |
KEY `fk_specimen_collection2_idx` (`current_collection`), |
| 749 | 724 |
KEY `fk_specimen_organization3_idx` (`owner_collection`), |
| 750 | 725 |
KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`), |
| 751 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 726 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 727 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 728 |
CONSTRAINT `fk_specimen_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 752 | 729 |
CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 753 |
CONSTRAINT `fk_specimen_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 754 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 755 | 730 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 756 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 731 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 757 | 732 |
CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 758 | 733 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen) which was collected from it';
|
| 759 | 734 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| ... | ... | |
| 777 | 752 |
`traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
| 778 | 753 |
PRIMARY KEY (`id`), |
| 779 | 754 |
KEY `fk_specimen_observation_specimen1_idx` (`specimen`), |
| 780 |
CONSTRAINT `fk_specimen_observation_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 781 |
CONSTRAINT `fk_specimen_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 755 |
CONSTRAINT `fk_specimen_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 756 |
CONSTRAINT `fk_specimen_observation_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 782 | 757 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 783 | 758 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 784 | 759 |
|
| ... | ... | |
| 827 | 802 |
UNIQUE KEY `stem_observation_unique` (`individual_observation`,`stem`), |
| 828 | 803 |
KEY `fk_stem_observation_individual_observation1_idx` (`individual_observation`), |
| 829 | 804 |
KEY `fk_stem_observation_stem1_idx` (`stem`), |
| 805 |
CONSTRAINT `fk_stem_observation_stem1` FOREIGN KEY (`stem`) REFERENCES `stem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 830 | 806 |
CONSTRAINT `fk_stem_observation_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 831 |
CONSTRAINT `fk_stem_observation_individual_observation2` FOREIGN KEY (`id`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 832 |
CONSTRAINT `fk_stem_observation_stem1` FOREIGN KEY (`stem`) REFERENCES `stem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 807 |
CONSTRAINT `fk_stem_observation_individual_observation2` FOREIGN KEY (`id`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 833 | 808 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'; |
| 834 | 809 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 835 | 810 |
|
| ... | ... | |
| 924 | 899 |
KEY `fk_taxon_assertion_taxon_string1_idx` (`string`), |
| 925 | 900 |
KEY `fk_taxon_assertion_taxon_name1_idx` (`taxon`), |
| 926 | 901 |
CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 927 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 928 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 902 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 903 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 929 | 904 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 930 | 905 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 931 | 906 |
|
| ... | ... | |
| 952 | 927 |
KEY `fk_taxon_taxon1_idx` (`parent`), |
| 953 | 928 |
KEY `fk_taxon_concept_source1_idx` (`according_to`), |
| 954 | 929 |
KEY `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon_concept`), |
| 930 |
CONSTRAINT `fk_taxon_taxon1` FOREIGN KEY (`parent`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 955 | 931 |
CONSTRAINT `fk_taxon_concept_source1` FOREIGN KEY (`according_to`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 956 | 932 |
CONSTRAINT `fk_taxon_concept_taxon_concept1` FOREIGN KEY (`accepted_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 957 |
CONSTRAINT `fk_taxon_concept_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 958 |
CONSTRAINT `fk_taxon_taxon1` FOREIGN KEY (`parent`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 933 |
CONSTRAINT `fk_taxon_concept_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 959 | 934 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'; |
| 960 | 935 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 961 | 936 |
|
| ... | ... | |
| 981 | 956 |
UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`), |
| 982 | 957 |
KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`), |
| 983 | 958 |
KEY `fk_taxon_determination_party_list1_idx` (`identified_by`), |
| 984 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 959 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 985 | 960 |
CONSTRAINT `fk_taxon_determination_record1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 986 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 961 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 987 | 962 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'; |
| 988 | 963 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 989 | 964 |
|
| ... | ... | |
| 1010 | 985 |
`rank` varbinary(767) DEFAULT NULL, |
| 1011 | 986 |
PRIMARY KEY (`id`), |
| 1012 | 987 |
KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`), |
| 1013 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 1014 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 988 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
| 989 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
| 1015 | 990 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
| 1016 | 991 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1017 | 992 |
|
| ... | ... | |
| 1068 | 1043 |
PRIMARY KEY (`id`), |
| 1069 | 1044 |
KEY `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination`), |
| 1070 | 1045 |
KEY `fk_taxon_occurrence_taxon_determination2_idx` (`current_determination`), |
| 1071 |
CONSTRAINT `fk_taxon_occurrence_event1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1072 | 1046 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` FOREIGN KEY (`original_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 1073 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` FOREIGN KEY (`current_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1047 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` FOREIGN KEY (`current_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1048 |
CONSTRAINT `fk_taxon_occurrence_event1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1074 | 1049 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'; |
| 1075 | 1050 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 1076 | 1051 |
|
| ... | ... | |
| 1130 | 1105 |
/*!40000 ALTER TABLE `taxon_presence` ENABLE KEYS */; |
| 1131 | 1106 |
|
| 1132 | 1107 |
-- |
| 1108 |
-- Table structure for table `taxon_scrub` |
|
| 1109 |
-- |
|
| 1110 |
|
|
| 1111 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 1112 |
/*!40101 SET character_set_client = utf8 */; |
|
| 1113 |
CREATE TABLE `taxon_scrub` ( |
|
| 1114 |
`id` varbinary(767) NOT NULL, |
|
| 1115 |
`input_string` varbinary(767) NOT NULL, |
|
| 1116 |
`parsed_taxon_assertion` varbinary(767) NOT NULL, |
|
| 1117 |
`matched_taxon_concept` varbinary(767) DEFAULT NULL, |
|
| 1118 |
`match_score` float DEFAULT NULL, |
|
| 1119 |
`match_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
|
|
| 1120 |
PRIMARY KEY (`id`), |
|
| 1121 |
KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`), |
|
| 1122 |
KEY `fk_taxon_scrub_taxon_assertion1_idx` (`parsed_taxon_assertion`), |
|
| 1123 |
KEY `fk_taxon_scrub_taxon_string1_idx` (`input_string`), |
|
| 1124 |
CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1125 |
CONSTRAINT `fk_taxon_scrub_taxon_assertion1` FOREIGN KEY (`parsed_taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1126 |
CONSTRAINT `fk_taxon_scrub_taxon_string1` FOREIGN KEY (`input_string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
| 1127 |
CONSTRAINT `fk_taxon_scrub_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
| 1128 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
| 1129 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 1130 |
|
|
| 1131 |
-- |
|
| 1132 |
-- Dumping data for table `taxon_scrub` |
|
| 1133 |
-- |
|
| 1134 |
|
|
| 1135 |
/*!40000 ALTER TABLE `taxon_scrub` DISABLE KEYS */; |
|
| 1136 |
/*!40000 ALTER TABLE `taxon_scrub` ENABLE KEYS */; |
|
| 1137 |
|
|
| 1138 |
-- |
|
| 1133 | 1139 |
-- Table structure for table `taxon_string` |
| 1134 | 1140 |
-- |
| 1135 | 1141 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: replaced parsed_taxon_assertion with taxon_scrub, which HAS-A parsed taxon_assertion rather than BEING-A parsed_taxon_assertion. (multiple TNRS results may parse to the same thing.)