/*CONSTRAINT "collection_unique" */UNIQUE ("institution","name"),

  /*KEY "fk_collection_organization1_idx" ("institution")*/CHECK (true),

  /*KEY "fk_collection_source1_idx" ("id")*/CHECK (true),

) /*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)'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*KEY "fk_event_place1_idx" ("place")*/CHECK (true),

  /*KEY "fk_event1_idx" ("parent")*/CHECK (true),

  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),

  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*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)'*/;

  "parent_geoplace" text NOT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_geovalidatable_place_geoplace1_idx" ("parent_geoplace")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  "tag_history" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_individual_place1_idx" ("place")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  "info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_method_method1_idx" ("parent")*/CHECK (true),

) /*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)'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  "info" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_party_organization1_idx" ("organization")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY ("id","entry"),

  /*KEY "fk_party_list_has_party_party1_idx" ("entry")*/CHECK (true),

  /*KEY "fk_party_list_has_party_party_list1_idx" ("id")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*KEY "fk_place_observation_community1_idx" ("community")*/CHECK (true),

  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_occurrence_taxon_determination1_idx" ("original_determination")*/CHECK (true),

  /*KEY "fk_taxon_occurrence_taxon_determination2_idx" ("current_determination")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination1" FOREIGN KEY ("original_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE "reobservable" ENABLE KEYS */;

--

-- Table structure for table "size_class"

--

  /*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),

  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),

  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),

  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*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'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  "traits" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*CONSTRAINT "stem_observation_unique" */UNIQUE ("individual_observation","stem"),

  /*KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation")*/CHECK (true),

  /*KEY "fk_stem_observation_stem1_idx" ("stem")*/CHECK (true),

  /*CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY ("id"),

  /*KEY "fk_stratum_event_stratum1_idx" ("stratum")*/CHECK (true),

  /*KEY "fk_stratum_event_sampling_event2_idx" ("parent_event")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  "coords" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_rel_place_place1_idx" ("parent")*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE "subplot" ENABLE KEYS */;

--

-- Table structure for table "taxon_absence"

--

  /*KEY "fk_taxon_assertion_taxon_string1_idx" ("string")*/CHECK (true),

  /*KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon")*/CHECK (true),

  /*CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*KEY "fk_taxon_taxon1_idx" ("parent")*/CHECK (true),

  /*KEY "fk_taxon_concept_source1_idx" ("according_to")*/CHECK (true),

  /*KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),

  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),

  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),

  /*KEY "fk_taxon_name_taxon_path1_idx" ("taxon_path")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*KEY "fk_taxon_observation_specimen1_idx" ("voucher")*/CHECK (true),

  /*KEY "fk_taxon_observation_party_list1_idx" ("collectors")*/CHECK (true),

  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_taxon_observation_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

  /*KEY "fk_taxon_scrub_taxon_assertion1_idx" ("parsed_taxon_assertion")*/CHECK (true),

  /*KEY "fk_taxon_scrub_taxon_string1_idx" ("input_string")*/CHECK (true),

  /*CONSTRAINT "fk_parsed_taxon_assertion_taxon_name1" FOREIGN KEY ("matched_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_taxon_scrub_taxon_assertion1" FOREIGN KEY ("parsed_taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;

/*!40101 SET character_set_client = @saved_cs_client */;

                  <value type="int" key="commentedOut">0</value>

                  <value type="string" key="createDate">2013-04-16 14:58</value>

                  <value _ptr_="0x9ec6fe0" type="dict" key="customData"/>

                  <value type="int" key="modelOnly">0</value>

                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>

                  <value type="string" key="temp_sql"></value>

                  <value type="string" key="comment"></value>

                <value type="real" key="left">5.4e+02</value>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <value type="real" key="width">8.1e+01</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

                <value type="int" key="expanded">1</value>

                <value type="real" key="height">7.7e+01</value>

                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>

                <value type="int" key="locked">0</value>

                <value type="int" key="manualSizing">0</value>

                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>

                <value type="int" key="visible">1</value>

              </value>

              <value type="object" struct-name="workbench.physical.TableFigure" id="83dc3f6a-f6e8-11e2-9cf1-080027bcf912" struct-checksum="0x3b14eccb">

                <value type="int" key="columnsExpanded">1</value>

        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>

        <value _ptr_="0xab34298" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>

        <value _ptr_="0xa5b1650" type="dict" key="syncProfiles">

              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>

              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>

              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>

              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>

              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>

              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>

              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>

              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>

              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>

              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>

              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>

              <value type="string" key="ea3bec44-acef-11e2-bdae-080027bcf912">source_id_scope</value>

              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>

              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>

              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>

    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">

      <value type="string" key="author">Aaron Marcuse-Kubitza</value>

      <value type="string" key="caption">New Model</value>

      <value type="string" key="dateCreated">2012-01-19 14:06</value>

      <value type="string" key="description"></value>

      <value type="string" key="project">Name of the project</value>

  UNIQUE KEY `collection_unique` (`institution`,`name`),

  KEY `fk_collection_organization1_idx` (`institution`),

  KEY `fk_collection_source1_idx` (`id`),

) 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)';

/*!40101 SET character_set_client = @saved_cs_client */;

  KEY `fk_event_place1_idx` (`place`),

  KEY `fk_event1_idx` (`parent`),

  KEY `fk_event_party_list1_idx` (`participants`),

  CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) 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)';

  `parent_geoplace` varbinary(767) NOT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_geovalidatable_place_geoplace1_idx` (`parent_geoplace`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores only scrubbed geoplaces (GADM places, and distinct point coordinates that GNRS says should be located within them)';

/*!40101 SET character_set_client = @saved_cs_client */;

  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_individual_place1_idx` (`place`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';

/*!40101 SET character_set_client = @saved_cs_client */;

  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_method_method1_idx` (`parent`),

) 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)';

/*!40101 SET character_set_client = @saved_cs_client */;

  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_party_organization1_idx` (`organization`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY (`id`,`entry`),

  KEY `fk_party_list_has_party_party1_idx` (`entry`),

  KEY `fk_party_list_has_party_party_list1_idx` (`id`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  KEY `fk_place_observation_community1_idx` (`community`),

  CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]';

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY (`id`),

  KEY `fk_taxon_occurrence_taxon_determination1_idx` (`original_determination`),

  KEY `fk_taxon_occurrence_taxon_determination2_idx` (`current_determination`),

  CONSTRAINT `fk_taxon_occurrence_taxon_determination1` FOREIGN KEY (`original_determination`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made';

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `reobservable` ENABLE KEYS */;

--

-- Table structure for table `size_class`

--

  KEY `fk_specimen_collection2_idx` (`current_collection`),

  KEY `fk_specimen_organization3_idx` (`owner_collection`),

  KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`),

  CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) 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';

/*!40101 SET character_set_client = @saved_cs_client */;

  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_specimen_observation_specimen1_idx` (`specimen`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  UNIQUE KEY `stem_observation_unique` (`individual_observation`,`stem`),

  KEY `fk_stem_observation_individual_observation1_idx` (`individual_observation`),

  KEY `fk_stem_observation_stem1_idx` (`stem`),

  CONSTRAINT `fk_stem_observation_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of a [[VegCore#Stem|Stem]]';

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY (`id`),

  KEY `fk_stratum_event_stratum1_idx` (`stratum`),

  KEY `fk_stratum_event_sampling_event2_idx` (`parent_event`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  `coords` set('hstore') COLLATE utf8_bin DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_rel_place_place1_idx` (`parent`),

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='stores plot elements such as subplots ("subplot, line, or any other subsample  or subdivision of plot" ("SALVIAS":http://salvias.net/Documents/salvias_data_dictionary.html#Plot_data/subplot))';

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40000 ALTER TABLE `subplot` ENABLE KEYS */;

--

-- Table structure for table `taxon_absence`

--

  KEY `fk_taxon_assertion_taxon_string1_idx` (`string`),

  KEY `fk_taxon_assertion_taxon_name1_idx` (`taxon`),

  CONSTRAINT `fk_qualified_taxon_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  KEY `fk_taxon_taxon1_idx` (`parent`),

  KEY `fk_taxon_concept_source1_idx` (`according_to`),

  KEY `fk_taxon_concept_taxon_concept1_idx` (`accepted_taxon_concept`),

  CONSTRAINT `fk_taxon_concept_source1` FOREIGN KEY (`according_to`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_concept_taxon_concept1` FOREIGN KEY (`accepted_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A [[VegCore#Taxon|Taxon]] described by a specific [[VegCore#Reference|Reference]]';

/*!40101 SET character_set_client = @saved_cs_client */;

  UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`),

  KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`),

  KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),

  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]';

/*!40101 SET character_set_client = @saved_cs_client */;

  PRIMARY KEY (`id`),

  KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`),

  KEY `fk_taxon_name_taxon_path1_idx` (`taxon_path`),

  CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  KEY `fk_taxon_observation_specimen1_idx` (`voucher`),

  KEY `fk_taxon_observation_party_list1_idx` (`collectors`),

  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_observation_specimen1` FOREIGN KEY (`voucher`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;

  KEY `fk_taxon_scrub_taxon_assertion1_idx` (`parsed_taxon_assertion`),

  KEY `fk_taxon_scrub_taxon_string1_idx` (`input_string`),

  CONSTRAINT `fk_parsed_taxon_assertion_taxon_name1` FOREIGN KEY (`matched_taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_taxon_scrub_taxon_assertion1` FOREIGN KEY (`parsed_taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

/*!40101 SET character_set_client = @saved_cs_client */;