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

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

                    </value>

                  </value>

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

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

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

                      <value type="string" key="comment">where the data in the dataset came from (as opposed to where the metadata *about* the dataset came from, which is in source, inherited from traceable)</value>

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183">

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

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

                    </value>

                  </value>

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

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

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

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

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">049df920-a91b-11e2-bdec-080027bcf912</link>

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>

                    </value>

                  </value>

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

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

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

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

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">238b4ae4-a700-11e2-9461-080027bcf912</link>

                    </value>

                  </value>

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

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

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

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

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">23ec4078-0075-11e3-906b-080027bcf912</link>

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7afebdc8-0075-11e3-906b-080027bcf912</link>

                    </value>

                  </value>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>

                    </value>

                  </value>

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

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

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

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

                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>

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

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

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

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

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

                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6ec4a89c-ad05-11e2-b309-080027bcf912</link>

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

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

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

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

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

                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7afec93a-0075-11e3-906b-080027bcf912</link>

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

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

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

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

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

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

                <link type="object" struct-name="model.Figure" key="endFigure">7afee050-0075-11e3-906b-080027bcf912</link>

                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>

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

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

                <value type="string" key="color">#99ccff</value>

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

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

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

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

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

                <value type="real" key="width">9.2e+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="real" key="left">5.03e+02</value>

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

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

                <value type="real" key="width">9.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="int" key="expanded">1</value>

                <value type="real" key="height">1.23e+02</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>

                <value type="real" key="top">1.012e+03</value>

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

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

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

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

                <value type="real" key="left">1.272e+03</value>

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

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

                <value type="real" key="width">1.41e+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="real" key="left">1.301e+03</value>

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

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

                <value type="real" key="width">1.06e+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="int" key="triggersExpanded">0</value>

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

                <value type="int" key="expanded">1</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>

                <value type="real" key="top">4.4e+01</value>

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

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

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

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

                <value type="real" key="left">1.049e+03</value>

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

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

                <value type="real" key="width">1.52e+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="int" key="triggersExpanded">0</value>

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

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

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

                <value type="real" key="left">1.2e+01</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="triggersExpanded">0</value>

                <value type="string" key="color">#99cc00</value>

                <value type="int" key="expanded">1</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>

                <value type="real" key="width">9.4e+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">2.38e+02</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>

                <value type="real" key="width">1.63e+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="int" key="triggersExpanded">0</value>

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

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

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

                <value type="real" key="left">1.218e+03</value>

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

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

                <value type="real" key="width">1.8e+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="int" key="triggersExpanded">0</value>

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

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

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

                <value type="real" key="left">8.e+00</value>

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

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

                <value type="real" key="width">1.21e+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="real" key="left">1.124e+03</value>

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

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

                <value type="real" key="width">1.36e+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="real" key="left">6.46e+02</value>

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

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

                <value type="real" key="width">1.71e+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="int" key="expanded">1</value>

                <value type="real" key="height">1.e+02</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>

                <value type="real" key="width">1.32e+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="int" key="triggersExpanded">0</value>

                <value type="string" key="color">#99cc00</value>

                <value type="int" key="expanded">1</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>

                <value type="real" key="width">9.4e+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="triggersExpanded">0</value>

                <value type="string" key="color">#99cc00</value>

                <value type="int" key="expanded">1</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>

                <value type="real" key="width">1.09e+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="int" key="triggersExpanded">0</value>

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

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

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

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

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

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

                <value type="real" key="width">1.82e+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="int" key="expanded">1</value>

                <value type="real" key="height">1.e+02</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>

                <value type="real" key="top">2.8e+01</value>

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

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

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

                <value type="real" key="width">1.06e+02</value>

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

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

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

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

        <value _ptr_="0xb030e28" 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="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="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</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="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</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>

  `id` varbinary(767) NOT NULL,

  `sampling_event` varbinary(767) NOT NULL,

  `occurrence_status` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_aggregate_observation_taxa_sampling_event1_idx` (`sampling_event`),

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

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

  `first_publisher` varbinary(767) DEFAULT NULL,

  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',

  `contacts` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_source_party2_idx` (`first_publisher`),

  KEY `fk_source_party_list1_idx` (`data_owners`),

  KEY `fk_source_party1_idx` (`contacts`),

  KEY `fk_dataset_source2_idx` (`data_source`),

  KEY `fk_dataset_dataset1_idx` (`parent`),

  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

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

  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';

  `place_observed_at` varbinary(767) DEFAULT NULL,

  `individual` varbinary(767) DEFAULT NULL COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant',

  `code` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_individual_observation_individual1_idx` (`individual`),

  KEY `fk_individual_observation_place1_idx` (`place_observed_at`),

  `name` varbinary(767) NOT NULL,

  `height_min_m` varbinary(767) DEFAULT NULL,

  `height_max_m` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_layer_stratum1` FOREIGN KEY (`id`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegBank.vegpath.org?stratumType';

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `organization` (

  `id` varbinary(767) NOT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_organization_party1` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

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

  `id` varbinary(767) NOT NULL,

  `name` varbinary(767) NOT NULL,

  `organization` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_party_organization1_idx` (`organization`),

  KEY `party_unique` (`organization`,`name`),

  CONSTRAINT `fk_party_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

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

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

  `id` varbinary(767) NOT NULL,

  `diameter_min_m` double NOT NULL,

  `diameter_max_m` double NOT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_layer_stratum10` FOREIGN KEY (`id`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

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

  `id` varbinary(767) NOT NULL,

  `specimen` varbinary(767) NOT NULL,

  `description` varbinary(767) 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 */;

  `id` varbinary(767) NOT NULL,

  `individual_observation` varbinary(767) DEFAULT NULL,

  `stem` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `stratum` (

  `id` varbinary(767) NOT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_place_path_record10` FOREIGN KEY (`id`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a non-horizontal way of subdividing a plot; = VegX.vegpath.org?stratum, VegBank.vegpath.org?stratumType';

CREATE TABLE `taxon_presence` (

  `id` varbinary(767) NOT NULL,

  `cover_percent` double DEFAULT NULL,

  PRIMARY KEY (`id`),

  CONSTRAINT `fk_taxon_presence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `aggregate_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?aggregateOrganismObservation, VegBank.vegpath.org?taxonImportance; "An observation applying to all occurrences of an organism" ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/aggregateOrganismObservations/aggregateOrganismObservation).';

  "id" text NOT NULL,

  "sampling_event" text NOT NULL,

  "occurrence_status" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

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

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

  "first_publisher" text DEFAULT NULL,

  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,

  "contacts" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),

  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),

  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),

  /*KEY "fk_dataset_source2_idx" ("data_source")*/CHECK (true),

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

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

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

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

  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;

  "place_observed_at" text DEFAULT NULL,

  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,

  "code" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),

  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),

  "name" text NOT NULL,

  "height_min_m" text DEFAULT NULL,

  "height_max_m" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegBank.vegpath.org?stratumType'*/;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "organization" (

  "id" text NOT NULL,

  PRIMARY KEY ("id"),

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

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

  "id" text NOT NULL,

  "name" text NOT NULL,

  "organization" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

  /*KEY "party_unique" ("organization","name")*/CHECK (true),

  /*CONSTRAINT "fk_party_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("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 */;

  "id" text NOT NULL,

  "diameter_min_m" double precision NOT NULL,

  "diameter_max_m" double precision NOT NULL,

  PRIMARY KEY ("id"),

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

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

  "id" text NOT NULL,

  "specimen" text NOT NULL,

  "description" text 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 */;

  "id" text NOT NULL,

  "individual_observation" text DEFAULT NULL,

  "stem" text DEFAULT NULL,

  PRIMARY KEY ("id"),

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "stratum" (

  "id" text NOT NULL,

  PRIMARY KEY ("id"),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a non-horizontal way of subdividing a plot; = VegX.vegpath.org?stratum, VegBank.vegpath.org?stratumType'*/;

CREATE TABLE "taxon_presence" (

  "id" text NOT NULL,

  "cover_percent" double precision DEFAULT NULL,

  PRIMARY KEY ("id"),

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

) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?aggregateOrganismObservation, VegBank.vegpath.org?taxonImportance; "An observation applying to all occurrences of an organism" ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/aggregateOrganismObservations/aggregateOrganismObservation).'*/;