Revision 10468
Added by Aaron Marcuse-Kubitza over 11 years ago
schemas/VegCore/document.mwb.xml | ||
---|---|---|
5836 | 5836 |
<value type="int" key="commentedOut">0</value> |
5837 | 5837 |
<value type="string" key="createDate">2013-04-16 14:58</value> |
5838 | 5838 |
<value _ptr_="0xa3b99e0" type="dict" key="customData"/> |
5839 |
<value type="string" key="lastChangeDate">2013-07-27 07:38</value>
|
|
5839 |
<value type="string" key="lastChangeDate">2013-07-27 07:44</value>
|
|
5840 | 5840 |
<value type="int" key="modelOnly">0</value> |
5841 |
<value type="string" key="name">geovalidatable_place</value>
|
|
5841 |
<value type="string" key="name">geoplace</value> |
|
5842 | 5842 |
<link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link> |
5843 | 5843 |
<value type="string" key="temp_sql"></value> |
5844 | 5844 |
<value type="string" key="comment"></value> |
... | ... | |
12356 | 12356 |
<value type="int" key="expanded">1</value> |
12357 | 12357 |
<value type="real" key="height">1.e+02</value> |
12358 | 12358 |
<link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link> |
12359 |
<value type="real" key="left">3.97e+02</value>
|
|
12359 |
<value type="real" key="left">4.31e+02</value>
|
|
12360 | 12360 |
<value type="int" key="locked">0</value> |
12361 | 12361 |
<value type="int" key="manualSizing">0</value> |
12362 | 12362 |
<value type="real" key="top">1.1e+01</value> |
12363 |
<value type="real" key="width">1.7e+02</value>
|
|
12363 |
<value type="real" key="width">1.02e+02</value>
|
|
12364 | 12364 |
<link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link> |
12365 | 12365 |
<value type="int" key="visible">1</value> |
12366 |
<value type="string" key="name">geovalidatable_place</value>
|
|
12366 |
<value type="string" key="name">geoplace</value> |
|
12367 | 12367 |
</value> |
12368 | 12368 |
<value type="object" struct-name="workbench.physical.TableFigure" id="FF3A48D7-490E-4E77-B97B-1F51BF51FA8A" struct-checksum="0x3b14eccb"> |
12369 | 12369 |
<value type="int" key="columnsExpanded">1</value> |
... | ... | |
14072 | 14072 |
<value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info"> |
14073 | 14073 |
<value type="string" key="author">Aaron Marcuse-Kubitza</value> |
14074 | 14074 |
<value type="string" key="caption">New Model</value> |
14075 |
<value type="string" key="dateChanged">2013-07-27 07:40</value>
|
|
14075 |
<value type="string" key="dateChanged">2013-07-27 08:05</value>
|
|
14076 | 14076 |
<value type="string" key="dateCreated">2012-01-19 14:06</value> |
14077 | 14077 |
<value type="string" key="description"></value> |
14078 | 14078 |
<value type="string" key="project">Name of the project</value> |
schemas/VegCore/VegCore.my.sql | ||
---|---|---|
1 |
-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
|
|
1 |
-- MySQL dump 10.13 Distrib 5.5.32, for debian-linux-gnu (x86_64)
|
|
2 | 2 |
-- |
3 | 3 |
-- Host: localhost Database: VegCore |
4 | 4 |
-- ------------------------------------------------------ |
5 |
-- Server version 5.5.31-0ubuntu0.12.04.2
|
|
5 |
-- Server version 5.5.32-0ubuntu0.12.04.1
|
|
6 | 6 |
|
7 | 7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
8 | 8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
... | ... | |
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_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
|
|
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
|
|
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_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
146 | 147 |
CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
147 |
CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`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)'; |
... | ... | |
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_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
|
|
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
|
|
244 | 244 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
245 | 245 |
/*!40101 SET character_set_client = @saved_cs_client */; |
246 | 246 |
|
... | ... | |
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_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
|
|
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
|
|
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 |
|
... | ... | |
403 | 403 |
`info` set('hstore') COLLATE utf8_bin DEFAULT NULL, |
404 | 404 |
PRIMARY KEY (`id`), |
405 | 405 |
KEY `fk_party_organization1_idx` (`organization`), |
406 |
CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
407 |
CONSTRAINT `fk_collection_source10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
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
|
|
408 | 408 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
409 | 409 |
/*!40101 SET character_set_client = @saved_cs_client */; |
410 | 410 |
|
... | ... | |
449 | 449 |
PRIMARY KEY (`id`,`entry`), |
450 | 450 |
KEY `fk_party_list_has_party_party1_idx` (`entry`), |
451 | 451 |
KEY `fk_party_list_has_party_party_list1_idx` (`id`), |
452 |
CONSTRAINT `fk_party_list_has_party_party_list1` FOREIGN KEY (`id`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
453 |
CONSTRAINT `fk_party_list_has_party_party1` FOREIGN KEY (`entry`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
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
|
|
454 | 454 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
455 | 455 |
/*!40101 SET character_set_client = @saved_cs_client */; |
456 | 456 |
|
... | ... | |
477 | 477 |
KEY `fk_place_coordinates1_idx` (`geocoordinates`), |
478 | 478 |
KEY `fk_place1_idx` (`parent`), |
479 | 479 |
KEY `fk_place_place_path1_idx` (`geopath`), |
480 |
CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
480 | 481 |
CONSTRAINT `fk_place_coordinates1` FOREIGN KEY (`geocoordinates`) REFERENCES `geocoordinates` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
481 | 482 |
CONSTRAINT `fk_place_place_path1` FOREIGN KEY (`geopath`) REFERENCES `geopath` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
482 |
CONSTRAINT `fk_place1` FOREIGN KEY (`parent`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
483 | 483 |
CONSTRAINT `fk_place_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
484 | 484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'; |
485 | 485 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
510 | 510 |
KEY `fk_place_observation_place1_idx` (`place`), |
511 | 511 |
KEY `fk_place_observation_geological_context1_idx` (`geological_context`), |
512 | 512 |
KEY `fk_place_observation_community1_idx` (`community`), |
513 |
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, |
|
513 | 515 |
CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`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_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
516 | 516 |
CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
517 | 517 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'; |
518 | 518 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
656 | 656 |
`method` varbinary(767) DEFAULT NULL, |
657 | 657 |
PRIMARY KEY (`id`), |
658 | 658 |
KEY `fk_sampling_event_method1_idx` (`method`), |
659 |
CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
660 |
CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
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
|
|
661 | 661 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
662 | 662 |
/*!40101 SET character_set_client = @saved_cs_client */; |
663 | 663 |
|
... | ... | |
748 | 748 |
KEY `fk_specimen_collection2_idx` (`current_collection`), |
749 | 749 |
KEY `fk_specimen_organization3_idx` (`owner_collection`), |
750 | 750 |
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, |
|
752 |
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, |
|
751 | 754 |
CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
755 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
752 | 756 |
CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`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_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
755 |
CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
756 |
CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
757 | 757 |
CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
758 | 758 |
) 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 | 759 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
777 | 777 |
`traits` set('hstore') COLLATE utf8_bin DEFAULT NULL, |
778 | 778 |
PRIMARY KEY (`id`), |
779 | 779 |
KEY `fk_specimen_observation_specimen1_idx` (`specimen`), |
780 |
CONSTRAINT `fk_specimen_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
781 |
CONSTRAINT `fk_specimen_observation_specimen1` FOREIGN KEY (`specimen`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
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
|
|
782 | 782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
783 | 783 |
/*!40101 SET character_set_client = @saved_cs_client */; |
784 | 784 |
|
... | ... | |
827 | 827 |
UNIQUE KEY `stem_observation_unique` (`individual_observation`,`stem`), |
828 | 828 |
KEY `fk_stem_observation_individual_observation1_idx` (`individual_observation`), |
829 | 829 |
KEY `fk_stem_observation_stem1_idx` (`stem`), |
830 |
CONSTRAINT `fk_stem_observation_stem1` FOREIGN KEY (`stem`) REFERENCES `stem` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
831 | 830 |
CONSTRAINT `fk_stem_observation_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
832 |
CONSTRAINT `fk_stem_observation_individual_observation2` FOREIGN KEY (`id`) 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 |
|
833 | 833 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'; |
834 | 834 |
/*!40101 SET character_set_client = @saved_cs_client */; |
835 | 835 |
|
... | ... | |
924 | 924 |
KEY `fk_taxon_assertion_taxon_string1_idx` (`string`), |
925 | 925 |
KEY `fk_taxon_assertion_taxon_name1_idx` (`taxon`), |
926 | 926 |
CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
927 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` FOREIGN KEY (`string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
928 |
CONSTRAINT `fk_taxon_assertion_taxon_name1` FOREIGN KEY (`taxon`) REFERENCES `taxon_name` (`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
|
|
929 | 929 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
930 | 930 |
/*!40101 SET character_set_client = @saved_cs_client */; |
931 | 931 |
|
... | ... | |
952 | 952 |
KEY `fk_taxon_taxon1_idx` (`parent`), |
953 | 953 |
KEY `fk_taxon_concept_source1_idx` (`according_to`), |
954 | 954 |
KEY `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon_concept`), |
955 |
CONSTRAINT `fk_taxon_taxon1` FOREIGN KEY (`parent`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
956 | 955 |
CONSTRAINT `fk_taxon_concept_source1` FOREIGN KEY (`according_to`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
957 | 956 |
CONSTRAINT `fk_taxon_concept_taxon_concept1` FOREIGN KEY (`accepted_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
958 |
CONSTRAINT `fk_taxon_concept_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`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 |
|
959 | 959 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'; |
960 | 960 |
/*!40101 SET character_set_client = @saved_cs_client */; |
961 | 961 |
|
... | ... | |
981 | 981 |
UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`), |
982 | 982 |
KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`), |
983 | 983 |
KEY `fk_taxon_determination_party_list1_idx` (`identified_by`), |
984 |
CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
984 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
985 | 985 |
CONSTRAINT `fk_taxon_determination_record1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
986 |
CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`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
|
|
987 | 987 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'; |
988 | 988 |
/*!40101 SET character_set_client = @saved_cs_client */; |
989 | 989 |
|
... | ... | |
1010 | 1010 |
`rank` varbinary(767) DEFAULT NULL, |
1011 | 1011 |
PRIMARY KEY (`id`), |
1012 | 1012 |
KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`), |
1013 |
CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
|
|
1014 |
CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
|
|
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
|
|
1015 | 1015 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
1016 | 1016 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1017 | 1017 |
|
... | ... | |
1068 | 1068 |
PRIMARY KEY (`id`), |
1069 | 1069 |
KEY `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination`), |
1070 | 1070 |
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, |
|
1071 | 1072 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination1` FOREIGN KEY (`original_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
1072 |
CONSTRAINT `fk_taxon_occurrence_taxon_determination2` FOREIGN KEY (`current_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, |
|
1073 |
CONSTRAINT `fk_taxon_occurrence_event1` FOREIGN KEY (`id`) REFERENCES `record` (`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 |
|
1074 | 1074 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'; |
1075 | 1075 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1076 | 1076 |
|
schemas/VegCore/VegCore.pg.sql | ||
---|---|---|
1 | 1 |
SET standard_conforming_strings = off; |
2 | 2 |
SET escape_string_warning = off; |
3 |
-- MySQL dump 10.13 Distrib 5.5.31, for debian-linux-gnu (x86_64)
|
|
3 |
-- MySQL dump 10.13 Distrib 5.5.32, for debian-linux-gnu (x86_64)
|
|
4 | 4 |
-- |
5 | 5 |
-- Host: localhost Database: VegCore |
6 | 6 |
-- ------------------------------------------------------ |
7 |
-- Server version 5.5.31-0ubuntu0.12.04.2
|
|
7 |
-- Server version 5.5.32-0ubuntu0.12.04.1
|
|
8 | 8 |
|
9 | 9 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
10 | 10 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
... | ... | |
74 | 74 |
/*CONSTRAINT "collection_unique" */UNIQUE ("institution","name"), |
75 | 75 |
/*KEY "fk_collection_organization1_idx" ("institution")*/CHECK (true), |
76 | 76 |
/*KEY "fk_collection_source1_idx" ("id")*/CHECK (true), |
77 |
/*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
78 |
/*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
77 |
/*CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
78 |
/*CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
79 | 79 |
) /*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)'*/; |
80 | 80 |
/*!40101 SET character_set_client = @saved_cs_client */; |
81 | 81 |
|
... | ... | |
145 | 145 |
/*KEY "fk_event_place1_idx" ("place")*/CHECK (true), |
146 | 146 |
/*KEY "fk_event1_idx" ("parent")*/CHECK (true), |
147 | 147 |
/*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true), |
148 |
/*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
148 | 149 |
/*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
149 |
/*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
150 | 150 |
/*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
151 | 151 |
/*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
152 | 152 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/; |
... | ... | |
241 | 241 |
/*CONSTRAINT "validatable_place_unique" */UNIQUE ("geopath","geocoordinates"), |
242 | 242 |
/*KEY "fk_geovalidation_place_path1_idx" ("geopath")*/CHECK (true), |
243 | 243 |
/*KEY "fk_geovalidation_coordinates1_idx" ("geocoordinates")*/CHECK (true), |
244 |
/*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
245 |
/*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
244 |
/*CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
245 |
/*CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
246 | 246 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
247 | 247 |
/*!40101 SET character_set_client = @saved_cs_client */; |
248 | 248 |
|
... | ... | |
335 | 335 |
"info" hstore DEFAULT NULL, |
336 | 336 |
PRIMARY KEY ("id"), |
337 | 337 |
/*KEY "fk_method_method1_idx" ("parent")*/CHECK (true), |
338 |
/*CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
339 |
/*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
338 |
/*CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
339 |
/*CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
340 | 340 |
) /*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)'*/; |
341 | 341 |
/*!40101 SET character_set_client = @saved_cs_client */; |
342 | 342 |
|
... | ... | |
405 | 405 |
"info" hstore DEFAULT NULL, |
406 | 406 |
PRIMARY KEY ("id"), |
407 | 407 |
/*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true), |
408 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
409 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
408 |
/*CONSTRAINT "fk_collection_source10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
409 |
/*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
410 | 410 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
411 | 411 |
/*!40101 SET character_set_client = @saved_cs_client */; |
412 | 412 |
|
... | ... | |
451 | 451 |
PRIMARY KEY ("id","entry"), |
452 | 452 |
/*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true), |
453 | 453 |
/*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true), |
454 |
/*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
455 |
/*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
454 |
/*CONSTRAINT "fk_party_list_has_party_party1" FOREIGN KEY ("entry") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
455 |
/*CONSTRAINT "fk_party_list_has_party_party_list1" FOREIGN KEY ("id") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
456 | 456 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
457 | 457 |
/*!40101 SET character_set_client = @saved_cs_client */; |
458 | 458 |
|
... | ... | |
479 | 479 |
/*KEY "fk_place_coordinates1_idx" ("geocoordinates")*/CHECK (true), |
480 | 480 |
/*KEY "fk_place1_idx" ("parent")*/CHECK (true), |
481 | 481 |
/*KEY "fk_place_place_path1_idx" ("geopath")*/CHECK (true), |
482 |
/*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
482 | 483 |
/*CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("geocoordinates") REFERENCES "geocoordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
483 | 484 |
/*CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("geopath") REFERENCES "geopath" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
484 |
/*CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
485 | 485 |
/*CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
486 | 486 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"A spatial region" ("DwC":http://rs.tdwg.org/dwc/terms/#dcterms:Location) or point'*/; |
487 | 487 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
512 | 512 |
/*KEY "fk_place_observation_place1_idx" ("place")*/CHECK (true), |
513 | 513 |
/*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true), |
514 | 514 |
/*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true), |
515 |
/*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
516 |
/*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
515 | 517 |
/*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
516 |
/*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
517 |
/*CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
518 | 518 |
/*CONSTRAINT "fk_place_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
519 | 519 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/; |
520 | 520 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
658 | 658 |
"method" text DEFAULT NULL, |
659 | 659 |
PRIMARY KEY ("id"), |
660 | 660 |
/*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true), |
661 |
/*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
662 |
/*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
661 |
/*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
662 |
/*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
663 | 663 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
664 | 664 |
/*!40101 SET character_set_client = @saved_cs_client */; |
665 | 665 |
|
... | ... | |
750 | 750 |
/*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true), |
751 | 751 |
/*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true), |
752 | 752 |
/*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true), |
753 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
754 |
/*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
755 |
/*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
753 | 756 |
/*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
757 |
/*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
754 | 758 |
/*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
755 |
/*CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
756 |
/*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
757 |
/*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
758 |
/*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
759 | 759 |
/*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
760 | 760 |
) /*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'*/; |
761 | 761 |
/*!40101 SET character_set_client = @saved_cs_client */; |
... | ... | |
779 | 779 |
"traits" hstore DEFAULT NULL, |
780 | 780 |
PRIMARY KEY ("id"), |
781 | 781 |
/*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true), |
782 |
/*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
783 |
/*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
782 |
/*CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
783 |
/*CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
784 | 784 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
785 | 785 |
/*!40101 SET character_set_client = @saved_cs_client */; |
786 | 786 |
|
... | ... | |
829 | 829 |
/*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"), |
830 | 830 |
/*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true), |
831 | 831 |
/*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true), |
832 |
/*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
833 | 832 |
/*CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
834 |
/*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
833 |
/*CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
834 |
/*CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
835 | 835 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/; |
836 | 836 |
/*!40101 SET character_set_client = @saved_cs_client */; |
837 | 837 |
|
... | ... | |
926 | 926 |
/*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true), |
927 | 927 |
/*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true), |
928 | 928 |
/*CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
929 |
/*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
930 |
/*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
929 |
/*CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
930 |
/*CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
931 | 931 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
932 | 932 |
/*!40101 SET character_set_client = @saved_cs_client */; |
933 | 933 |
|
... | ... | |
954 | 954 |
/*KEY "fk_taxon_taxon1_idx" ("parent")*/CHECK (true), |
955 | 955 |
/*KEY "fk_taxon_concept_source1_idx" ("according_to")*/CHECK (true), |
956 | 956 |
/*KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept")*/CHECK (true), |
957 |
/*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
958 | 957 |
/*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
959 | 958 |
/*CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
960 |
/*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
959 |
/*CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
960 |
/*CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
961 | 961 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'*/; |
962 | 962 |
/*!40101 SET character_set_client = @saved_cs_client */; |
963 | 963 |
|
... | ... | |
983 | 983 |
/*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"), |
984 | 984 |
/*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true), |
985 | 985 |
/*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true), |
986 |
/*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
986 |
/*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
987 | 987 |
/*CONSTRAINT "fk_taxon_determination_record1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
988 |
/*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
988 |
/*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
989 | 989 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/; |
990 | 990 |
/*!40101 SET character_set_client = @saved_cs_client */; |
991 | 991 |
|
... | ... | |
1012 | 1012 |
"rank" text DEFAULT NULL, |
1013 | 1013 |
PRIMARY KEY ("id"), |
1014 | 1014 |
/*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true), |
1015 |
/*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
1016 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
1015 |
/*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
|
|
1016 |
/*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
|
|
1017 | 1017 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/; |
1018 | 1018 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1019 | 1019 |
|
... | ... | |
1070 | 1070 |
PRIMARY KEY ("id"), |
1071 | 1071 |
/*KEY "fk_taxon_occurrence_taxon_determination1_idx" ("original_determination")*/CHECK (true), |
1072 | 1072 |
/*KEY "fk_taxon_occurrence_taxon_determination2_idx" ("current_determination")*/CHECK (true), |
1073 |
/*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
1073 | 1074 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination1" FOREIGN KEY ("original_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
1074 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true), |
|
1075 |
/*CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
1075 |
/*CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true) |
|
1076 | 1076 |
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'*/; |
1077 | 1077 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1078 | 1078 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: geovalidatable_place: renamed to geoplace, since this uniquification is useful independently of geovalidation. note that the MySQL upgrade on vegbiendev has now reordered the fkeys again, this time in forwards order.