<value type="string" key="oldName">unique_name</value>

                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="687f18b2-a780-11e2-afd5-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value type="string" key="oldName">rank</value>

                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>

                    </value>

                  </value>

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

                  <value type="string" key="defaultCharacterSetName">utf8</value>

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

                  <value type="string" key="createDate">2013-04-17 10:01</value>

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

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

                  <value type="string" key="name">taxon_name</value>

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

                      <value type="string" key="oldName">matched_taxon_concept</value>

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="length">-1</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="length">-1</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

                  </value>

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

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

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

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

                  <value type="string" key="name">taxon_scrub</value>

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

                      <value type="string" key="oldName">all_collectors</value>

                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="16538808-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value type="string" key="oldName">cultivated</value>

                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>

                    </value>

                  </value>

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

                  <value type="string" key="defaultCharacterSetName">utf8</value>

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

                  <value type="string" key="createDate">2013-04-17 13:52</value>

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

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

                  <value type="string" key="name">taxon_observation</value>

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

                      <value type="string" key="oldName">id</value>

                      <link type="object" struct-name="GrtObject" key="owner">c6722390-a7a0-11e2-b667-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="c6722782-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value type="string" key="oldName">locality</value>

                      <link type="object" struct-name="GrtObject" key="owner">c6722390-a7a0-11e2-b667-080027bcf912</link>

                    </value>

                  </value>

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

                  <value type="string" key="defaultCharacterSetName">utf8</value>

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

                  <value type="string" key="createDate">2013-04-17 13:52</value>

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

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

                  <value type="string" key="name">geopath</value>

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

                      <value type="string" key="oldName">project</value>

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="length">-1</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

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

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

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

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

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

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

                      <value type="int" key="length">-1</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

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

                    </value>

                  </value>

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

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

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

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

                  <value type="string" key="name">place_visit</value>

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

                      <value type="string" key="oldName">lat_long_domain_valid</value>

                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>

                    </value>

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>

                    </value>

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

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

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

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

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

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

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

                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>

                    </value>

                  </value>

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

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

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

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

                  <value type="string" key="name">geovalidation</value>

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

                      <value type="string" key="oldName">subject</value>

                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>

                    </value>

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

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

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

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

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

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

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

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

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

                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>

                    </value>

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

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

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

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

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

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

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

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

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

                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>

                    </value>

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

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

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

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

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

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

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

                      <value type="int" key="length">767</value>

                      <value type="int" key="precision">-1</value>

                      <value type="int" key="scale">-1</value>

                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>

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

                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>

                    </value>

                  </value>

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

                  <value type="string" key="createDate">2013-04-17 13:52</value>

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

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

                  <value type="string" key="name">specimen_observation</value>

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

                <value type="string" key="text">1) inherited

2) required

3) identifying

5) extenders

6) others</value>

                <value type="string" key="color">#ffffff</value>

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

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

                <value type="real" key="top">2.e+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="string" key="name">field order</value>

                <value type="real" key="left">1.e+01</value>

                <value _ptr_="0xc756948" type="list" content-type="object" content-struct-name="model.Layer" key="subLayers"/>

                <value type="real" key="top">4.2e+02</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="string" key="name">field order</value>

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

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

            </value>

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

            <value type="real" key="width">1.6215e+03</value>

            <value type="real" key="x">0.e+00</value>

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

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

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

              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>

              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>

              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</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>

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `geopath` (

  `id` varbinary(767) NOT NULL,

  `continent` varbinary(767) DEFAULT NULL,

  `country` varbinary(767) DEFAULT NULL,

  `state_province` varbinary(767) DEFAULT NULL,

  `county` varbinary(767) DEFAULT NULL,

  `municipality` varbinary(767) DEFAULT NULL,

  `locality` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region';

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

  `input_geoplace` varbinary(767) NOT NULL,

  `geovalid` tinyint(1) NOT NULL,

  `lat_long_domain_valid` tinyint(1) NOT NULL,

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

  PRIMARY KEY (`id`),

  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),

  KEY `fk_geovalidation_geoplace2_idx` (`corrected_geoplace`),

  `parent` varbinary(767) DEFAULT NULL COMMENT 'the concurrent observation of the parent place',

  `subject` varbinary(767) NOT NULL,

  `project` varbinary(767) DEFAULT NULL,

  `elevation_m` double DEFAULT NULL,

  `slope_incline_deg` double DEFAULT NULL,

  `slope_direction_deg_N` double DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_place_observation_place1_idx` (`subject`),

  KEY `fk_place_observation_geological_context1_idx` (`geological_context`),

  KEY `fk_place_observation_community1_idx` (`community`),

  KEY `place_observation_id_fkey1_idx` (`project`),

  KEY `place_visit_id_fkey1_idx` (`parent`),

  CONSTRAINT `fk_place_observation_community1` FOREIGN KEY (`community`) REFERENCES `community` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_place_observation_event1` FOREIGN KEY (`id`) REFERENCES `event` (`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]]. = VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)';

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

CREATE TABLE `specimen_observation` (

  `id` varbinary(767) NOT NULL,

  `subject` varbinary(767) NOT NULL,

  `current_collection` varbinary(767) DEFAULT NULL,

  `owner_collection` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_specimen_observation_specimen1_idx` (`subject`),

  KEY `specimen_observation_id_fkey1_idx` (`current_collection`),

CREATE TABLE `taxon_name` (

  `id` varbinary(767) NOT NULL,

  `unique_name` varbinary(767) NOT NULL,

  `formal_name` varbinary(767) DEFAULT NULL,

  `taxon_name` varbinary(767) DEFAULT NULL,

  `author` varbinary(767) DEFAULT NULL,

  `common_name` varbinary(767) DEFAULT NULL,

  `rank` varbinary(767) DEFAULT NULL,

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

  `primary_collector` varbinary(767) DEFAULT NULL,

  `collector_number` varbinary(767) DEFAULT NULL,

  `all_collectors` varbinary(767) DEFAULT NULL,

  `growth_form` varbinary(767) DEFAULT NULL,

  `cultivated` tinyint(1) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_taxon_observation_taxon_occurrence1_idx` (`taxon_occurrence`),

  KEY `fk_taxon_observation_taxa_sampling_event1_idx` (`sampling_event`),

  KEY `taxon_observation__unique` (`sampling_event`,`primary_collector`,`collector_number`),

  KEY `taxon_observation_id_fkey2_idx` (`parent`),

  KEY `taxon_observation_id_fkey3_idx` (`subject`),

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

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

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)';

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

  `input_string` varbinary(767) NOT NULL,

  `parsed_taxon_assertion` varbinary(767) NOT NULL,

  `matched_taxon_concept` varbinary(767) DEFAULT NULL,

  `match_score` float DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_parsed_taxon_assertion_taxon_name1_idx` (`matched_taxon_concept`),

  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,

  CONSTRAINT `fk_taxon_scrub_taxon_string1` FOREIGN KEY (`input_string`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "geopath" (

  "id" text NOT NULL,

  "continent" text DEFAULT NULL,

  "country" text DEFAULT NULL,

  "state_province" text DEFAULT NULL,

  "county" text DEFAULT NULL,

  "municipality" text DEFAULT NULL,

  "locality" text DEFAULT NULL,

  PRIMARY KEY ("id")

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A named region'*/;

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

  "input_geoplace" text NOT NULL,

  "geovalid" integer NOT NULL,

  "lat_long_domain_valid" integer NOT NULL,

  "lat_long_in_place_ranks" hstore DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),

  /*KEY "fk_geovalidation_geoplace2_idx" ("corrected_geoplace")*/CHECK (true),

  "parent" text DEFAULT NULL /*COMMENT 'the concurrent observation of the parent place'*/,

  "subject" text NOT NULL,

  "project" text DEFAULT NULL,

  "elevation_m" double precision DEFAULT NULL,

  "slope_incline_deg" double precision DEFAULT NULL,

  "slope_direction_deg_N" double precision DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_place_observation_place1_idx" ("subject")*/CHECK (true),

  /*KEY "fk_place_observation_geological_context1_idx" ("geological_context")*/CHECK (true),

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

  /*KEY "place_observation_id_fkey1_idx" ("project")*/CHECK (true),

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

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

  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("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]]. = VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)'*/;

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

CREATE TABLE "specimen_observation" (

  "id" text NOT NULL,

  "subject" text NOT NULL,

  "current_collection" text DEFAULT NULL,

  "owner_collection" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

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

CREATE TABLE "taxon_name" (

  "id" text NOT NULL,

  "unique_name" text NOT NULL,

  "formal_name" text DEFAULT NULL,

  "taxon_name" text DEFAULT NULL,

  "author" text DEFAULT NULL,

  "common_name" text DEFAULT NULL,

  "rank" text DEFAULT NULL,

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

  "primary_collector" text DEFAULT NULL,

  "collector_number" text DEFAULT NULL,

  "all_collectors" text DEFAULT NULL,

  "growth_form" text DEFAULT NULL,

  "cultivated" integer DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_taxon_observation_taxon_occurrence1_idx" ("taxon_occurrence")*/CHECK (true),

  /*KEY "fk_taxon_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),

  /*KEY "taxon_observation__unique" ("sampling_event","primary_collector","collector_number")*/CHECK (true),

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

  /*KEY "taxon_observation_id_fkey3_idx" ("subject")*/CHECK (true),

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

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= DwC.vegpath.org?Occurrence (which actually represents an *observation* of an occurrence)'*/;

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

  "input_string" text NOT NULL,

  "parsed_taxon_assertion" text NOT NULL,

  "matched_taxon_concept" text DEFAULT NULL,

  "match_score" float DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_parsed_taxon_assertion_taxon_name1_idx" ("matched_taxon_concept")*/CHECK (true),

  /*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),

  /*CONSTRAINT "fk_taxon_scrub_taxon_string1" FOREIGN KEY ("input_string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

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