<value type="object" struct-name="db.mysql.ForeignKey" id="67fa5b28-f6c1-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>

                      <value _ptr_="0xa7d9da0" type="list" content-type="object" content-struct-name="db.Column" key="columns">

                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>

                      </value>

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

                      <value type="string" key="deleteRule">CASCADE</value>

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

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

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

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

                      <value _ptr_="0xaf7df20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">

                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>

                      </value>

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

                      <value type="string" key="updateRule">CASCADE</value>

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="eaefe558-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>

                      <value _ptr_="0xa9d03b8" type="list" content-type="object" content-struct-name="db.Column" key="columns">

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

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

                      <value _ptr_="0xa89a478" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">

                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>

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

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

                <value type="object" struct-name="db.mysql.Table" id="7f176964-f6c0-11e2-af44-080027bcf912" struct-checksum="0x1a403946">

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

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

                  <value _ptr_="0xa8a0948" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">

                    <value type="object" struct-name="db.mysql.Column" id="7f176d06-f6c0-11e2-af44-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value _ptr_="0xa722bc8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>

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

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

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

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

                      <value _ptr_="0xa079220" type="list" content-type="string" key="flags"/>

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Column" id="a841ba7e-f6c0-11e2-af44-080027bcf912" struct-checksum="0x783b5183">

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

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

                      <value _ptr_="0xab62508" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>

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

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

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

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

                      <value _ptr_="0xacf22b8" type="list" content-type="string" key="flags"/>

                      <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>

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                  </value>

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

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

                  <value type="string" key="defaultCollationName">utf8_bin</value>

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

                  <value _ptr_="0xa732c00" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">

                    <value type="object" struct-name="db.mysql.ForeignKey" id="7f177512-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672743a-a7a0-11e2-b667-080027bcf912</link>

                      <value _ptr_="0xaf9f068" type="list" content-type="object" content-struct-name="db.Column" key="columns">

                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>

                      </value>

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

                      <value type="string" key="deleteRule">CASCADE</value>

                      <link type="object" struct-name="db.Index" key="index">7f177760-f6c0-11e2-af44-080027bcf912</link>

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

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

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

                      <link type="object" struct-name="db.Table" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                      <value _ptr_="0xad25dc8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">

                        <link type="object">c67276b0-a7a0-11e2-b667-080027bcf912</link>

                      </value>

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

                      <value type="string" key="updateRule">CASCADE</value>

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

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

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

                    </value>

                    <value type="object" struct-name="db.mysql.ForeignKey" id="a841b894-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">

                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8d8c2a-a6e0-11e2-95e9-080027bcf912</link>

                      <value _ptr_="0xa8ab6a0" type="list" content-type="object" content-struct-name="db.Column" key="columns">

                        <link type="object">a841ba7e-f6c0-11e2-af44-080027bcf912</link>

                      </value>

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

                      <value type="string" key="deleteRule">CASCADE</value>

                      <link type="object" struct-name="db.Index" key="index">a842920a-f6c0-11e2-af44-080027bcf912</link>

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

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

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

                      <link type="object" struct-name="db.Table" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                      <value _ptr_="0xa8ab650" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">

                        <link type="object">be8d8ea0-a6e0-11e2-95e9-080027bcf912</link>

                      </value>

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

                      <value type="string" key="updateRule">CASCADE</value>

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

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

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

                    </value>

                  </value>

                  <value _ptr_="0xa817668" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">

                    <value type="object" struct-name="db.mysql.Index" id="7f177760-f6c0-11e2-af44-080027bcf912" struct-checksum="0x309b847a">

                      <value _ptr_="0xa8ca528" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">

                        <value type="object" struct-name="db.mysql.IndexColumn" id="7f1778a0-f6c0-11e2-af44-080027bcf912" struct-checksum="0x62630b3c">

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

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

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

                          <link type="object" struct-name="db.Column" key="referencedColumn">7f176d06-f6c0-11e2-af44-080027bcf912</link>

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

                          <link type="object" struct-name="GrtObject" key="owner">7f177760-f6c0-11e2-af44-080027bcf912</link>

                        </value>

                      </value>

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

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

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

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

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

                      <value type="string" key="indexType">PRIMARY</value>

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

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                    <value type="object" struct-name="db.mysql.Index" id="a842920a-f6c0-11e2-af44-080027bcf912" struct-checksum="0x309b847a">

                      <value _ptr_="0xadca6c8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">

                        <value type="object" struct-name="db.mysql.IndexColumn" id="a842b0fa-f6c0-11e2-af44-080027bcf912" struct-checksum="0x62630b3c">

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

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

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

                          <link type="object" struct-name="db.Column" key="referencedColumn">a841ba7e-f6c0-11e2-af44-080027bcf912</link>

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

                          <link type="object" struct-name="GrtObject" key="owner">a842920a-f6c0-11e2-af44-080027bcf912</link>

                        </value>

                      </value>

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

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

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

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

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

                      <value type="string" key="indexType">INDEX</value>

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

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

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

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

                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>

                    </value>

                  </value>

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

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

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

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

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

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

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

                  <value _ptr_="0xaa305a0" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>

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

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

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

                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">7f177760-f6c0-11e2-af44-080027bcf912</link>

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

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

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

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

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

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

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

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

                  <value type="string" key="tableEngine">InnoDB</value>

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

                  <value _ptr_="0xa9cbfa8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>

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

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

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

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

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

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

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

                  <value type="string" key="lastChangeDate">2013-07-27 06:30</value>

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

                  <value type="string" key="name">sampling_event</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="string" key="oldName"></value>

                </value>

              <value type="object" struct-name="workbench.physical.Connection" id="7f181abc-f6c0-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_project_event10</value>

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

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

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

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

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

                <value type="string" key="extraCaption"></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">7f177512-f6c0-11e2-af44-080027bcf912</link>

                <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>

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

                <link type="object" struct-name="model.Figure" key="endFigure">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>

                <link type="object" struct-name="model.Figure" key="startFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>

                <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"></value>

              </value>

              <value type="object" struct-name="workbench.physical.Connection" id="a842ecd2-f6c0-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_sampling_event_method1</value>

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

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

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

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

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

                <value type="string" key="extraCaption"></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">a841b894-f6c0-11e2-af44-080027bcf912</link>

                <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>

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

                <link type="object" struct-name="model.Figure" key="endFigure">D9C4F621-07DC-4B10-A898-30DA84E9030D</link>

                <link type="object" struct-name="model.Figure" key="startFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>

                <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"></value>

              </value>

              <value type="object" struct-name="workbench.physical.Connection" id="eaeffb88-f6c0-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_place_observation_sampling_event1</value>

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

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

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

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

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

                <value type="string" key="extraCaption"></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">eaefe558-f6c0-11e2-af44-080027bcf912</link>

                <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>

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

                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>

                <link type="object" struct-name="model.Figure" key="startFigure">FF3A48D7-490E-4E77-B97B-1F51BF51FA8A</link>

                <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"></value>

              </value>

              <value type="object" struct-name="workbench.physical.Connection" id="67fa734c-f6c1-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">

                <value type="string" key="caption">fk_taxon_observation_sampling_event1</value>

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

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

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

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

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

                <value type="string" key="extraCaption"></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">67fa5b28-f6c1-11e2-af44-080027bcf912</link>

                <value type="real" key="middleSegmentOffset">1.4677044673224594362181960605084896087646484375e+02</value>

                <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>

                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>

                <link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>

                <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"></value>

              </value>

                <value type="real" key="height">1.69e+02</value>

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

                <value type="real" key="top">3.69e+02</value>

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

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

                <value type="real" key="top">4.46e+02</value>

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

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

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

                <value type="real" key="top">6.95e+02</value>

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

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

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

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

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

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

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

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

                <value type="real" key="top">8.29e+02</value>

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

                <value type="real" key="top">7.44e+02</value>

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

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

              <value type="object" struct-name="workbench.physical.TableFigure" id="7f17a4b0-f6c0-11e2-af44-080027bcf912" struct-checksum="0x3b14eccb">

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

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

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

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

                <link type="object" struct-name="db.Table" key="table">7f176964-f6c0-11e2-af44-080027bcf912</link>

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

                <value type="string" key="color">#66ffff</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="real" key="left">5.54e+02</value>

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

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

                <value type="real" key="top">5.85e+02</value>

                <value type="real" key="width">1.4e+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">sampling_event</value>

              </value>

                <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>

            <value _ptr_="0xa0364c0" type="list" content-type="object" content-struct-name="model.Object" key="selection">

              <link type="object">71dceeac-a780-11e2-afd5-080027bcf912</link>

              <link type="object">71d9ecb6-a780-11e2-afd5-080027bcf912</link>

              <link type="object">21b637c2-f680-11e2-aebb-080027bcf912</link>

            </value>

      <value type="string" key="dateChanged">2013-07-27 06:41</value>

  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

  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

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

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

  CONSTRAINT `fk_place_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

-- Table structure for table `sampling_event`

--

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `sampling_event` (

  `id` varbinary(767) NOT NULL,

  `method` varbinary(767) DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `fk_sampling_event_method1_idx` (`method`),

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

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

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

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

--

-- Dumping data for table `sampling_event`

--

/*!40000 ALTER TABLE `sampling_event` DISABLE KEYS */;

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

--

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

  CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

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

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

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

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

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

  CONSTRAINT `fk_taxon_observation_taxon_occurrence2` FOREIGN KEY (`taxon_occurrence`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

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

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

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

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

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

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

-- Table structure for table "sampling_event"

--

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE "sampling_event" (

  "id" text NOT NULL,

  "method" text DEFAULT NULL,

  PRIMARY KEY ("id"),

  /*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),

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

  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("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 */;

--

-- Dumping data for table "sampling_event"

--

/*!40000 ALTER TABLE "sampling_event" DISABLE KEYS */;

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

--

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

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

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

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

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

  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("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),

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