Project

General

Profile

« Previous | Next » 

Revision 10488

schemas/VegCore/VegCore.ERD.mwb: taxon_determination: inherit from taxon_observation again because now that redeterminations can only occur on reobservable things, it makes sense to only allow one taxon_determination per observation event. this means that each redetermination on a specimen would get its own taxon_observation (where any additional attributes noted in the reobservation could also be included).

View differences:

schemas/VegCore/document.mwb.xml
4248 4248
                      <value type="string" key="oldName">id</value>
4249 4249
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4250 4250
                    </value>
4251
                    <value type="object" struct-name="db.mysql.Column" id="4a62f964-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
4252
                      <value type="int" key="autoIncrement">0</value>
4253
                      <value type="string" key="characterSetName"></value>
4254
                      <value _ptr_="0xaae1458" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4255
                      <value type="string" key="collationName"></value>
4256
                      <value type="string" key="datatypeExplicitParams"></value>
4257
                      <value type="string" key="defaultValue"></value>
4258
                      <value type="int" key="defaultValueIsNull">0</value>
4259
                      <value _ptr_="0xaae17b8" type="list" content-type="string" key="flags"/>
4260
                      <value type="int" key="isNotNull">1</value>
4261
                      <value type="int" key="length">767</value>
4262
                      <value type="int" key="precision">-1</value>
4263
                      <value type="int" key="scale">-1</value>
4264
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4265
                      <value type="string" key="comment"></value>
4266
                      <value type="string" key="name">taxon_observation</value>
4267
                      <value type="string" key="oldName">taxon_observation</value>
4268
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4269
                    </value>
4270 4251
                    <value type="object" struct-name="db.mysql.Column" id="3d9b197c-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4271 4252
                      <value type="int" key="autoIncrement">0</value>
4272 4253
                      <value type="string" key="characterSetName"></value>
......
4372 4353
                      <value type="string" key="name">fk_taxon_determination_party_list1</value>
4373 4354
                      <value type="string" key="oldName">fk_taxon_determination_party_list1</value>
4374 4355
                    </value>
4375
                    <value type="object" struct-name="db.mysql.ForeignKey" id="4a62f766-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
4356
                    <value type="object" struct-name="db.mysql.ForeignKey" id="5b345f5e-f957-11e2-8597-080027bcf912" struct-checksum="0x70a8fc40">
4376 4357
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
4377
                      <value _ptr_="0xaae2f70" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4378
                        <link type="object">4a62f964-f6dd-11e2-b6d1-080027bcf912</link>
4358
                      <value _ptr_="0xb2b50e0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4359
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
4379 4360
                      </value>
4380 4361
                      <value type="int" key="deferability">0</value>
4381 4362
                      <value type="string" key="deleteRule">CASCADE</value>
4382
                      <link type="object" struct-name="db.Index" key="index">4a630f80-f6dd-11e2-b6d1-080027bcf912</link>
4383
                      <value type="int" key="mandatory">1</value>
4384
                      <value type="int" key="many">1</value>
4363
                      <value type="int" key="mandatory">0</value>
4364
                      <value type="int" key="many">0</value>
4385 4365
                      <value type="int" key="modelOnly">0</value>
4386 4366
                      <link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4387
                      <value _ptr_="0xaae32f8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4367
                      <value _ptr_="0xaba4b98" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4388 4368
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
4389 4369
                      </value>
4390 4370
                      <value type="int" key="referencedMandatory">1</value>
......
4393 4373
                      <value type="string" key="name">fk_taxon_determination_taxon_observation1</value>
4394 4374
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1</value>
4395 4375
                    </value>
4396
                    <value type="object" struct-name="db.mysql.ForeignKey" id="55756896-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
4397
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
4398
                      <value _ptr_="0xaae3368" type="list" content-type="object" content-struct-name="db.Column" key="columns">
4399
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
4400
                      </value>
4401
                      <value type="int" key="deferability">0</value>
4402
                      <value type="string" key="deleteRule">CASCADE</value>
4403
                      <value type="int" key="mandatory">0</value>
4404
                      <value type="int" key="many">0</value>
4405
                      <value type="int" key="modelOnly">0</value>
4406
                      <link type="object" struct-name="db.Table" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4407
                      <value _ptr_="0xaae36f0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
4408
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
4409
                      </value>
4410
                      <value type="int" key="referencedMandatory">1</value>
4411
                      <value type="string" key="updateRule">CASCADE</value>
4412
                      <value type="string" key="comment"></value>
4413
                      <value type="string" key="name">fk_taxon_determination_sampling_event1</value>
4414
                      <value type="string" key="oldName">fk_taxon_determination_sampling_event1</value>
4415
                    </value>
4416 4376
                  </value>
4417 4377
                  <value _ptr_="0xaae0d58" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
4418 4378
                    <value type="object" struct-name="db.mysql.Index" id="3d9b1f30-a7a1-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
4515 4475
                      <value type="string" key="oldName">fk_taxon_determination_party_list1_idx</value>
4516 4476
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4517 4477
                    </value>
4518
                    <value type="object" struct-name="db.mysql.Index" id="4a630f80-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
4519
                      <value _ptr_="0xaae5340" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
4520
                        <value type="object" struct-name="db.mysql.IndexColumn" id="4a631124-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
4521
                          <value type="int" key="columnLength">0</value>
4522
                          <value type="string" key="comment"></value>
4523
                          <value type="int" key="descend">0</value>
4524
                          <link type="object" struct-name="db.Column" key="referencedColumn">4a62f964-f6dd-11e2-b6d1-080027bcf912</link>
4525
                          <value type="string" key="name"></value>
4526
                          <link type="object" struct-name="GrtObject" key="owner">4a630f80-f6dd-11e2-b6d1-080027bcf912</link>
4527
                        </value>
4528
                      </value>
4529
                      <value type="string" key="indexKind"></value>
4530
                      <value type="int" key="keyBlockSize">0</value>
4531
                      <value type="string" key="withParser"></value>
4532
                      <value type="string" key="comment"></value>
4533
                      <value type="int" key="deferability">0</value>
4534
                      <value type="string" key="indexType">INDEX</value>
4535
                      <value type="int" key="isPrimary">0</value>
4536
                      <value type="string" key="name">fk_taxon_determination_taxon_observation1_idx</value>
4537
                      <value type="int" key="unique">0</value>
4538
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1_idx</value>
4539
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4540
                    </value>
4541 4478
                  </value>
4542 4479
                  <value type="string" key="maxRows"></value>
4543 4480
                  <value type="string" key="mergeInsert"></value>
......
6878 6815
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
6879 6816
                  <value type="string" key="temp_sql"></value>
6880 6817
                  <value type="string" key="comment">Any entity on which [[VegCore#TaxonDetermination|TaxonDetermination]]s can be made</value>
6881
                  <value type="string" key="oldName">taxon_occurrence</value>
6818
                  <value type="string" key="oldName">reobservable</value>
6882 6819
                </value>
6883 6820
                <value type="object" struct-name="db.mysql.Table" id="0ab9880e-a7a1-11e2-b667-080027bcf912" struct-checksum="0x1a403946">
6884 6821
                  <value type="string" key="avgRowLength"></value>
......
13152 13089
                <value type="int" key="visible">1</value>
13153 13090
                <value type="string" key="name"></value>
13154 13091
              </value>
13155
              <value type="object" struct-name="workbench.physical.Connection" id="4a631b9c-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
13156
                <value type="string" key="caption">fk_taxon_determination_taxon_observation1</value>
13157
                <value type="real" key="captionXOffs">0.e+00</value>
13158
                <value type="real" key="captionYOffs">0.e+00</value>
13159
                <value type="string" key="comment"></value>
13160
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13161
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13162
                <value type="string" key="extraCaption"></value>
13163
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13164
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13165
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">4a62f766-f6dd-11e2-b6d1-080027bcf912</link>
13166
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13167
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13168
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13169
                <value type="int" key="drawSplit">0</value>
13170
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
13171
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
13172
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13173
                <value type="int" key="visible">1</value>
13174
                <value type="string" key="name"></value>
13175
              </value>
13176
              <value type="object" struct-name="workbench.physical.Connection" id="557583a8-f6dd-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
13177
                <value type="string" key="caption">fk_taxon_determination_sampling_event1</value>
13178
                <value type="real" key="captionXOffs">0.e+00</value>
13179
                <value type="real" key="captionYOffs">0.e+00</value>
13180
                <value type="string" key="comment"></value>
13181
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13182
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13183
                <value type="string" key="extraCaption"></value>
13184
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13185
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13186
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">55756896-f6dd-11e2-b6d1-080027bcf912</link>
13187
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13188
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13189
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13190
                <value type="int" key="drawSplit">0</value>
13191
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
13192
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
13193
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13194
                <value type="int" key="visible">1</value>
13195
                <value type="string" key="name"></value>
13196
              </value>
13197 13092
              <value type="object" struct-name="workbench.physical.Connection" id="329240cc-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
13198 13093
                <value type="string" key="caption">fk_geovalidation_geoplace1</value>
13199 13094
                <value type="real" key="captionXOffs">0.e+00</value>
......
13488 13383
                <value type="int" key="visible">1</value>
13489 13384
                <value type="string" key="name"></value>
13490 13385
              </value>
13386
              <value type="object" struct-name="workbench.physical.Connection" id="5b3479d0-f957-11e2-8597-080027bcf912" struct-checksum="0x9baebc92">
13387
                <value type="string" key="caption">fk_taxon_determination_taxon_observation1</value>
13388
                <value type="real" key="captionXOffs">0.e+00</value>
13389
                <value type="real" key="captionYOffs">0.e+00</value>
13390
                <value type="string" key="comment"></value>
13391
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13392
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13393
                <value type="string" key="extraCaption"></value>
13394
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13395
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13396
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">5b345f5e-f957-11e2-8597-080027bcf912</link>
13397
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13398
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13399
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13400
                <value type="int" key="drawSplit">0</value>
13401
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
13402
                <link type="object" struct-name="model.Figure" key="startFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
13403
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13404
                <value type="int" key="visible">1</value>
13405
                <value type="string" key="name"></value>
13406
              </value>
13491 13407
            </value>
13492 13408
            <value type="string" key="description"></value>
13493 13409
            <value _ptr_="0xab48bb8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13895 13811
                <value type="int" key="triggersExpanded">0</value>
13896 13812
                <value type="string" key="color">#00ee00</value>
13897 13813
                <value type="int" key="expanded">1</value>
13898
                <value type="real" key="height">1.46e+02</value>
13814
                <value type="real" key="height">1.23e+02</value>
13899 13815
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13900 13816
                <value type="real" key="left">8.69e+02</value>
13901 13817
                <value type="int" key="locked">0</value>
......
14967 14883
        <value _ptr_="0xaab1d60" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>
14968 14884
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14969 14885
        <value _ptr_="0xaab1d90" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14970
        <value _ptr_="0x9d366e8" type="dict" key="syncProfiles"/>
14886
        <value _ptr_="0x9d366e8" type="dict" key="syncProfiles">
14887
          <value type="object" struct-name="db.mgmt.SyncProfile" id="aaa49690-f956-11e2-8597-080027bcf912" struct-checksum="0xc64972c2" key="">
14888
            <value _ptr_="0xb5c9f40" type="dict" key="lastKnownDBNames">
14889
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14890
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14891
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
14892
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
14893
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
14894
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
14895
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
14896
              <value type="string" key="0621717a-a90f-11e2-8576-080027bcf912">fk_taxon_presence_taxon_name1</value>
14897
              <value type="string" key="06217332-a90f-11e2-8576-080027bcf912">taxon_concept</value>
14898
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14899
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
14900
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">footprint_geom_WKT</value>
14901
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
14902
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
14903
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>
14904
              <value type="string" key="0ab98e12-a7a1-11e2-b667-080027bcf912">traits</value>
14905
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
14906
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>
14907
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
14908
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
14909
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
14910
              <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>
14911
              <value type="string" key="15161a3e-f6e2-11e2-b6d1-080027bcf912">geoplace</value>
14912
              <value type="string" key="15162024-f6e2-11e2-b6d1-080027bcf912">id</value>
14913
              <value type="string" key="15162484-f6e2-11e2-b6d1-080027bcf912">geocoords</value>
14914
              <value type="string" key="15162704-f6e2-11e2-b6d1-080027bcf912">geopath</value>
14915
              <value type="string" key="1516297a-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_place_path10</value>
14916
              <value type="string" key="15162bc8-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_coordinates10</value>
14917
              <value type="string" key="15162dbc-f6e2-11e2-b6d1-080027bcf912">PRIMARY</value>
14918
              <value type="string" key="151635b4-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_place_path1_idx</value>
14919
              <value type="string" key="151638a2-f6e2-11e2-b6d1-080027bcf912">fk_geovalidation_coordinates1_idx</value>
14920
              <value type="string" key="15163b68-f6e2-11e2-b6d1-080027bcf912">validatable_place_unique</value>
14921
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
14922
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
14923
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
14924
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
14925
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
14926
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
14927
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
14928
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
14929
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>
14930
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>
14931
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>
14932
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>
14933
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>
14934
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>
14935
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>
14936
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>
14937
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>
14938
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>
14939
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>
14940
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>
14941
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
14942
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
14943
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
14944
              <value type="string" key="1a652744-f6da-11e2-b6d1-080027bcf912">geocoords_unique</value>
14945
              <value type="string" key="1b4ab2ae-f6ea-11e2-9cf1-080027bcf912">fk_georeferencing_geoplace1</value>
14946
              <value type="string" key="1b4ac44c-f6ea-11e2-9cf1-080027bcf912">fk_georeferencing_geoplace1_idx</value>
14947
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
14948
              <value type="string" key="1cc7051e-f6be-11e2-af44-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
14949
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
14950
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>
14951
              <value type="string" key="238b4ae4-a700-11e2-9461-080027bcf912">stratum</value>
14952
              <value type="string" key="238b4f6c-a700-11e2-9461-080027bcf912">id</value>
14953
              <value type="string" key="238b53d6-a700-11e2-9461-080027bcf912">fk_place_path_record10</value>
14954
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>
14955
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>
14956
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>
14957
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
14958
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
14959
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
14960
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
14961
              <value type="string" key="277ed080-f6e7-11e2-b6d1-080027bcf912">fk_geopath_scrub_geopath1</value>
14962
              <value type="string" key="277ee28c-f6e7-11e2-b6d1-080027bcf912">fk_geopath_scrub_geopath1_idx</value>
14963
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
14964
              <value type="string" key="2ba6f9f6-a761-11e2-aa10-080027bcf912">fk_geovalidation_place_path1</value>
14965
              <value type="string" key="2ba6fbb8-a761-11e2-aa10-080027bcf912">geopath</value>
14966
              <value type="string" key="2ba715bc-a761-11e2-aa10-080027bcf912">fk_geovalidation_place_path1_idx</value>
14967
              <value type="string" key="2e2885fa-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1</value>
14968
              <value type="string" key="2e2887c6-a761-11e2-aa10-080027bcf912">geocoords</value>
14969
              <value type="string" key="2e28a288-a761-11e2-aa10-080027bcf912">fk_geovalidation_coordinates1_idx</value>
14970
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
14971
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
14972
              <value type="string" key="2eedb6e2-a764-11e2-b6a9-080027bcf912">validatable_place_unique</value>
14973
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
14974
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
14975
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
14976
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
14977
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">scrubbed_geoplace</value>
14978
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
14979
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">coords</value>
14980
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
14981
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
14982
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
14983
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>
14984
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>
14985
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>
14986
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
14987
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
14988
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
14989
              <value type="string" key="3ddbec50-f6e7-11e2-b6d1-080027bcf912">fk_geopath_scrub_geopath2</value>
14990
              <value type="string" key="3ddd0bd0-f6e7-11e2-b6d1-080027bcf912">fk_geopath_scrub_geopath2_idx</value>
14991
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
14992
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
14993
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
14994
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>
14995
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>
14996
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>
14997
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>
14998
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>
14999
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>
15000
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>
15001
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>
15002
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
15003
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
15004
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
15005
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
15006
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>
15007
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
15008
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>
15009
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>
15010
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
15011
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
15012
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
15013
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
15014
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
15015
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
15016
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>
15017
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>
15018
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>
15019
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
15020
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
15021
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>
15022
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>
15023
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>
15024
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>
15025
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
15026
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
15027
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
15028
              <value type="string" key="4a62f766-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_taxon_observation1</value>
15029
              <value type="string" key="4a62f964-f6dd-11e2-b6d1-080027bcf912">taxon_observation</value>
15030
              <value type="string" key="4a630f80-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_taxon_observation1_idx</value>
15031
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
15032
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
15033
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
15034
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
15035
              <value type="string" key="4e241b94-ad15-11e2-9617-080027bcf912">specimen_unique_by_collection_event</value>
15036
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
15037
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
15038
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
15039
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
15040
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
15041
              <value type="string" key="55756896-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_sampling_event1</value>
15042
              <value type="string" key="565fd9e8-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1</value>
15043
              <value type="string" key="565fe000-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1_idx</value>
15044
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
15045
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
15046
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
15047
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
15048
              <value type="string" key="59b34338-f6ba-11e2-aebb-080027bcf912">taxon_concept</value>
15049
              <value type="string" key="59b34766-f6ba-11e2-aebb-080027bcf912">fk_taxon_observation_taxon_occurrence10</value>
15050
              <value type="string" key="59b34978-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name10</value>
15051
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
15052
              <value type="string" key="59b34dec-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name1_idx</value>
15053
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>
15054
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
15055
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
15056
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">bounding_box_rect</value>
15057
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
15058
              <value type="string" key="6856853a-a796-11e2-84c3-080027bcf912">traits</value>
15059
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
15060
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>
15061
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>
15062
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>
15063
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>
15064
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>
15065
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>
15066
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>
15067
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>
15068
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>
15069
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>
15070
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>
15071
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>
15072
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>
15073
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>
15074
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
15075
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
15076
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
15077
              <value type="string" key="687f3e3c-a780-11e2-afd5-080027bcf912">fk_taxon_path_taxon_name1</value>
15078
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>
15079
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>
15080
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>
15081
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>
15082
              <value type="string" key="705abb34-f6e2-11e2-b6d1-080027bcf912">fk_validatable_geoplace_geoplace1</value>
15083
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
15084
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
15085
              <value type="string" key="7eeac536-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1</value>
15086
              <value type="string" key="7eeac720-f6e2-11e2-b6d1-080027bcf912">geoplace</value>
15087
              <value type="string" key="7eeadc2e-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1_idx</value>
15088
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">sampling_event</value>
15089
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
15090
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
15091
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>
15092
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>
15093
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>
15094
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>
15095
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>
15096
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
15097
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
15098
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
15099
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>
15100
              <value type="string" key="83dbde1c-f6e8-11e2-9cf1-080027bcf912">georeferenced_place</value>
15101
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>
15102
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>
15103
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
15104
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
15105
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
15106
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
15107
              <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>
15108
              <value type="string" key="980eb49e-ad0b-11e2-b309-080027bcf912">fk_taxon_presence_taxon_name1_idx</value>
15109
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
15110
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
15111
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
15112
              <value type="string" key="9d6ca408-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1</value>
15113
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>
15114
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>
15115
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>
15116
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">entry</value>
15117
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>
15118
              <value type="string" key="9d6cbbd2-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party_list1_idx</value>
15119
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>
15120
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>
15121
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>
15122
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>
15123
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>
15124
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>
15125
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>
15126
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
15127
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
15128
              <value type="string" key="a09e45d4-a79d-11e2-a346-080027bcf912">source_record_id</value>
15129
              <value type="string" key="a2fe2068-a790-11e2-84c3-080027bcf912">name</value>
15130
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
15131
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
15132
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
15133
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
15134
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>
15135
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
15136
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
15137
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
15138
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
15139
              <value type="string" key="b37dc2a8-a6fb-11e2-9461-080027bcf912">fk_subplot_plot1</value>
15140
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
15141
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
15142
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
15143
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">collectors</value>
15144
              <value type="string" key="bb0eaf44-ad10-11e2-b309-080027bcf912">current_collection</value>
15145
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">code_in_individual</value>
15146
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
15147
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">source</value>
15148
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>
15149
              <value type="string" key="be8cc59c-a6e0-11e2-95e9-080027bcf912">parent</value>
15150
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15151
              <value type="string" key="be8ccb14-a6e0-11e2-95e9-080027bcf912">fk_source1_idx</value>
15152
              <value type="string" key="be8cce5c-a6e0-11e2-95e9-080027bcf912">fk_source1</value>
15153
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">record</value>
15154
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>
15155
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>
15156
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15157
              <value type="string" key="be8cddca-a6e0-11e2-95e9-080027bcf912">fk_record_source1_idx</value>
15158
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>
15159
              <value type="string" key="be8ce932-a6e0-11e2-95e9-080027bcf912">relationship</value>
15160
              <value type="string" key="be8cebb2-a6e0-11e2-95e9-080027bcf912">id</value>
15161
              <value type="string" key="be8ced88-a6e0-11e2-95e9-080027bcf912">record</value>
15162
              <value type="string" key="be8cef2c-a6e0-11e2-95e9-080027bcf912">related_record</value>
15163
              <value type="string" key="be8cf0d0-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15164
              <value type="string" key="be8cf42c-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1_idx</value>
15165
              <value type="string" key="be8cf71a-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record_idx</value>
15166
              <value type="string" key="be8cf9fe-a6e0-11e2-95e9-080027bcf912">fk_relationship_record1</value>
15167
              <value type="string" key="be8cfb66-a6e0-11e2-95e9-080027bcf912">fk_relationship_record2</value>
15168
              <value type="string" key="be8cfcb0-a6e0-11e2-95e9-080027bcf912">fk_relationship_related_record</value>
15169
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>
15170
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
15171
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15172
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
15173
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geocoords</value>
15174
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
15175
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15176
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
15177
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>
15178
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15179
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>
15180
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>
15181
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>
15182
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>
15183
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>
15184
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>
15185
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15186
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>
15187
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>
15188
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>
15189
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>
15190
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15191
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>
15192
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>
15193
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>
15194
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>
15195
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>
15196
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">stem</value>
15197
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15198
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>
15199
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>
15200
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>
15201
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>
15202
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">aggregate_observation</value>
15203
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>
15204
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15205
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
15206
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
15207
              <value type="string" key="be8eaf4c-a6e0-11e2-95e9-080027bcf912">fk_taxon_observation_taxon_occurrence1</value>
15208
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
15209
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
15210
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15211
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>
15212
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>
15213
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
15214
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15215
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
15216
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
15217
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
15218
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">place</value>
15219
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
15220
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>
15221
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>
15222
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>
15223
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>
15224
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>
15225
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>
15226
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>
15227
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>
15228
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
15229
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15230
              <value type="string" key="be8f60ea-a6e0-11e2-95e9-080027bcf912">fk_soil_observation_place_observation1</value>
15231
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplot</value>
15232
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
15233
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15234
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">validatable_geoplace</value>
15235
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
15236
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15237
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
15238
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>
15239
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15240
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>
15241
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>
15242
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>
15243
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>
15244
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15245
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>
15246
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>
15247
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15248
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>
15249
              <value type="string" key="c20b4bce-ad13-11e2-b309-080027bcf912">fk_specimen_organization3_idx</value>
15250
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>
15251
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>
15252
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>
15253
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>
15254
              <value type="string" key="c540c5c0-ad19-11e2-9d85-080027bcf912">traits</value>
15255
              <value type="string" key="c66112f6-ad10-11e2-b309-080027bcf912">fk_specimen_collection2</value>
15256
              <value type="string" key="c6612660-ad10-11e2-b309-080027bcf912">fk_specimen_collection2_idx</value>
15257
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
15258
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>
15259
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>
15260
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>
15261
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>
15262
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>
15263
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>
15264
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>
15265
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
15266
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
15267
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
15268
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
15269
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
15270
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
15271
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
15272
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
15273
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
15274
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
15275
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
15276
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
15277
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>
15278
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>
15279
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">place</value>
15280
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
15281
              <value type="string" key="c67283da-a7a0-11e2-b667-080027bcf912">fk_event_place1_idx</value>
15282
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>
15283
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>
15284
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>
15285
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>
15286
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>
15287
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>
15288
              <value type="string" key="c672b24c-a7a0-11e2-b667-080027bcf912">current_determination</value>
15289
              <value type="string" key="c672b418-a7a0-11e2-b667-080027bcf912">original_determination</value>
15290
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
15291
              <value type="string" key="c672c0d4-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination1_idx</value>
15292
              <value type="string" key="c672c52a-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination2_idx</value>
15293
              <value type="string" key="c672cf2a-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination1</value>
15294
              <value type="string" key="c672d2a4-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_taxon_determination2</value>
15295
              <value type="string" key="c672d4ac-a7a0-11e2-b667-080027bcf912">fk_taxon_occurrence_event1</value>
15296
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>
15297
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>
15298
              <value type="string" key="c673038c-a7a0-11e2-b667-080027bcf912">owner_collection</value>
15299
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>
15300
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>
15301
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>
15302
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
15303
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>
15304
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>
15305
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>
15306
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>
15307
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>
15308
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>
15309
              <value type="string" key="c7c2089c-a91b-11e2-bdec-080027bcf912">fk_source_party2_idx</value>
15310
              <value type="string" key="c8552934-a7bc-11e2-8af2-080027bcf912">fk_source_party1</value>
15311
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">owner</value>
15312
              <value type="string" key="c8554edc-a7bc-11e2-8af2-080027bcf912">fk_source_party1_idx</value>
15313
              <value type="string" key="c8868c00-a793-11e2-84c3-080027bcf912">info</value>
15314
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
15315
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
15316
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
15317
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
15318
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
15319
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>
15320
              <value type="string" key="d9b5781e-a90b-11e2-8576-080027bcf912">name</value>
15321
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>
15322
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
15323
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">traits</value>
15324
              <value type="string" key="e5155806-a793-11e2-84c3-080027bcf912">info</value>
15325
              <value type="string" key="e550209e-f676-11e2-9716-080027bcf912">fk_party_organization1</value>
15326
              <value type="string" key="e5502346-f676-11e2-9716-080027bcf912">organization</value>
15327
              <value type="string" key="e550389a-f676-11e2-9716-080027bcf912">fk_party_organization1_idx</value>
15328
              <value type="string" key="e5d27f54-a792-11e2-84c3-080027bcf912">info</value>
15329
              <value type="string" key="ea3bec44-acef-11e2-bdae-080027bcf912">source_id_scope</value>
15330
              <value type="string" key="eaefe558-f6c0-11e2-af44-080027bcf912">fk_place_observation_sampling_event1</value>
15331
              <value type="string" key="eb778868-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1</value>
15332
              <value type="string" key="eb778aac-ad01-11e2-b309-080027bcf912">collection_event</value>
15333
              <value type="string" key="eb77b1da-ad01-11e2-b309-080027bcf912">fk_specimen_taxon_observation1_idx</value>
15334
              <value type="string" key="eba38182-f6e6-11e2-b6d1-080027bcf912">geopath_scrub</value>
15335
              <value type="string" key="eba38394-f6e6-11e2-b6d1-080027bcf912">id</value>
15336
              <value type="string" key="eba3877c-f6e6-11e2-b6d1-080027bcf912">input_geopath</value>
15337
              <value type="string" key="eba389e8-f6e6-11e2-b6d1-080027bcf912">scrubbed_geopath</value>
15338
              <value type="string" key="eba39820-f6e6-11e2-b6d1-080027bcf912">fk_geovalidation_record10</value>
15339
              <value type="string" key="eba39a1e-f6e6-11e2-b6d1-080027bcf912">PRIMARY</value>
15340
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
15341
              <value type="string" key="ec6965f0-a925-11e2-acee-080027bcf912">fk_specimen_organization3</value>
15342
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
15343
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
15344
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
15345
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
15346
              <value type="string" key="f6c9182a-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_record1</value>
15347
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">record_unique</value>
15348
              <value type="string" key="ff7f1558-a791-11e2-84c3-080027bcf912">name</value>
15349
            </value>
15350
            <value type="string" key="lastSyncDate"></value>
15351
            <value type="string" key="name"></value>
15352
          </value>
15353
        </value>
14971 15354
        <value _ptr_="0xaab1dc0" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>
14972 15355
        <value _ptr_="0xaab1df0" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>
14973 15356
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
15050 15433
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
15051 15434
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
15052 15435
      <value type="string" key="caption">New Model</value>
15053
      <value type="string" key="dateChanged">2013-07-30 13:28</value>
15436
      <value type="string" key="dateChanged">2013-07-30 13:35</value>
15054 15437
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
15055 15438
      <value type="string" key="description"></value>
15056 15439
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1009 1009
/*!40101 SET character_set_client = utf8 */;
1010 1010
CREATE TABLE `taxon_determination` (
1011 1011
  `id` varbinary(767) NOT NULL,
1012
  `taxon_observation` varbinary(767) NOT NULL,
1013 1012
  `identified_by` varbinary(767) DEFAULT NULL,
1014 1013
  `taxon_assertion` varbinary(767) NOT NULL,
1015 1014
  `fit_info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
......
1017 1016
  UNIQUE KEY `taxon_determination_unique` (`taxon_assertion`,`identified_by`),
1018 1017
  KEY `fk_taxon_occurrence_has_qualified_taxon1_idx` (`taxon_assertion`),
1019 1018
  KEY `fk_taxon_determination_party_list1_idx` (`identified_by`),
1020
  KEY `fk_taxon_determination_taxon_observation1_idx` (`taxon_observation`),
1021
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1019
  CONSTRAINT `fk_taxon_determination_taxon_observation1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1022 1020
  CONSTRAINT `fk_taxon_determination_party_list1` FOREIGN KEY (`identified_by`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1023
  CONSTRAINT `fk_taxon_determination_taxon_observation1` FOREIGN KEY (`taxon_observation`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1024
  CONSTRAINT `fk_taxon_determination_sampling_event1` FOREIGN KEY (`id`) REFERENCES `sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1021
  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1` FOREIGN KEY (`taxon_assertion`) REFERENCES `taxon_assertion` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1025 1022
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]';
1026 1023
/*!40101 SET character_set_client = @saved_cs_client */;
1027 1024

  
schemas/VegCore/VegCore.pg.sql
1011 1011
/*!40101 SET character_set_client = utf8 */;
1012 1012
CREATE TABLE "taxon_determination" (
1013 1013
  "id" text NOT NULL,
1014
  "taxon_observation" text NOT NULL,
1015 1014
  "identified_by" text DEFAULT NULL,
1016 1015
  "taxon_assertion" text NOT NULL,
1017 1016
  "fit_info" hstore DEFAULT NULL,
......
1019 1018
  /*CONSTRAINT "taxon_determination_unique" */UNIQUE ("taxon_assertion","identified_by"),
1020 1019
  /*KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion")*/CHECK (true),
1021 1020
  /*KEY "fk_taxon_determination_party_list1_idx" ("identified_by")*/CHECK (true),
1022
  /*KEY "fk_taxon_determination_taxon_observation1_idx" ("taxon_observation")*/CHECK (true),
1023
  /*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1021
  /*CONSTRAINT "fk_taxon_determination_taxon_observation1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1024 1022
  /*CONSTRAINT "fk_taxon_determination_party_list1" FOREIGN KEY ("identified_by") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1025
  /*CONSTRAINT "fk_taxon_determination_taxon_observation1" FOREIGN KEY ("taxon_observation") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1026
  /*CONSTRAINT "fk_taxon_determination_sampling_event1" FOREIGN KEY ("id") REFERENCES "sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1023
  /*CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1027 1024
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An assertion that a [[VegCore#TaxonOccurrence|TaxonOccurrence]] is a particular [[VegCore#Taxon|Taxon]]'*/;
1028 1025
/*!40101 SET character_set_client = @saved_cs_client */;
1029 1026

  

Also available in: Unified diff