Project

General

Profile

« Previous | Next » 

Revision 10489

schemas/VegCore/VegCore.ERD.mwb: taxon_presence, taxon_absence: inherit from taxon_determination rather than taxon_observation, so that the taxon_determination's taxon can be used as the identifying taxon (i.e. the authorPlantName, VegCore.vegpath.org?authorPlantName)

View differences:

schemas/VegCore/document.mwb.xml
2341 2341
                      <value type="string" key="oldName">id</value>
2342 2342
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2343 2343
                    </value>
2344
                    <value type="object" struct-name="db.mysql.Column" id="06217332-a90f-11e2-8576-080027bcf912" struct-checksum="0x783b5183">
2345
                      <value type="int" key="autoIncrement">0</value>
2346
                      <value type="string" key="characterSetName"></value>
2347
                      <value _ptr_="0xaac4bb8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
2348
                      <value type="string" key="collationName"></value>
2349
                      <value type="string" key="datatypeExplicitParams"></value>
2350
                      <value type="string" key="defaultValue"></value>
2351
                      <value type="int" key="defaultValueIsNull">0</value>
2352
                      <value _ptr_="0xaac4f18" type="list" content-type="string" key="flags"/>
2353
                      <value type="int" key="isNotNull">1</value>
2354
                      <value type="int" key="length">767</value>
2355
                      <value type="int" key="precision">-1</value>
2356
                      <value type="int" key="scale">-1</value>
2357
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2358
                      <value type="string" key="comment"></value>
2359
                      <value type="string" key="name">taxon_concept</value>
2360
                      <value type="string" key="oldName">taxon_concept</value>
2361
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2362
                    </value>
2363 2344
                    <value type="object" struct-name="db.mysql.Column" id="d72de448-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
2364 2345
                      <value type="int" key="autoIncrement">0</value>
2365 2346
                      <value type="string" key="characterSetName"></value>
......
2385 2366
                  <value type="string" key="defaultCollationName">utf8_bin</value>
2386 2367
                  <value type="int" key="delayKeyWrite">0</value>
2387 2368
                  <value _ptr_="0xaac4468" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
2388
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8eaf4c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
2389
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
2390
                      <value _ptr_="0xaac5560" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2369
                    <value type="object" struct-name="db.mysql.ForeignKey" id="d2081100-f959-11e2-8597-080027bcf912" struct-checksum="0x70a8fc40">
2370
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
2371
                      <value _ptr_="0xb2b9170" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2391 2372
                        <link type="object">be8eaa06-a6e0-11e2-95e9-080027bcf912</link>
2392 2373
                      </value>
2393 2374
                      <value type="int" key="deferability">0</value>
2394 2375
                      <value type="string" key="deleteRule">CASCADE</value>
2395
                      <value type="int" key="mandatory">0</value>
2396
                      <value type="int" key="many">0</value>
2397
                      <value type="int" key="modelOnly">0</value>
2398
                      <link type="object" struct-name="db.Table" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2399
                      <value _ptr_="0xaac58c8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2400
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
2401
                      </value>
2402
                      <value type="int" key="referencedMandatory">1</value>
2403
                      <value type="string" key="updateRule">CASCADE</value>
2404
                      <value type="string" key="comment"></value>
2405
                      <value type="string" key="name">fk_taxon_observation_taxon_occurrence1</value>
2406
                      <value type="string" key="oldName">fk_taxon_observation_taxon_occurrence1</value>
2407
                    </value>
2408
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0621717a-a90f-11e2-8576-080027bcf912" struct-checksum="0x70a8fc40">
2409
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
2410
                      <value _ptr_="0xaac5938" type="list" content-type="object" content-struct-name="db.Column" key="columns">
2411
                        <link type="object">06217332-a90f-11e2-8576-080027bcf912</link>
2412
                      </value>
2413
                      <value type="int" key="deferability">0</value>
2414
                      <value type="string" key="deleteRule">CASCADE</value>
2415
                      <link type="object" struct-name="db.Index" key="index">980eb49e-ad0b-11e2-b309-080027bcf912</link>
2416 2376
                      <value type="int" key="mandatory">1</value>
2417 2377
                      <value type="int" key="many">1</value>
2418 2378
                      <value type="int" key="modelOnly">0</value>
2419 2379
                      <link type="object" struct-name="db.Table" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2420
                      <value _ptr_="0xaac5cc0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2421
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
2380
                      <value _ptr_="0xb2cceb0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
2381
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
2422 2382
                      </value>
2423 2383
                      <value type="int" key="referencedMandatory">1</value>
2424 2384
                      <value type="string" key="updateRule">CASCADE</value>
2425 2385
                      <value type="string" key="comment"></value>
2426
                      <value type="string" key="name">fk_taxon_presence_taxon_name1</value>
2427
                      <value type="string" key="oldName">fk_taxon_presence_taxon_name1</value>
2386
                      <value type="string" key="name">fk_taxon_presence_taxon_determination1</value>
2387
                      <value type="string" key="oldName">fk_taxon_presence_taxon_determination1</value>
2428 2388
                    </value>
2429 2389
                  </value>
2430 2390
                  <value _ptr_="0xaac44b8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
2451 2411
                      <value type="string" key="oldName">PRIMARY</value>
2452 2412
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2453 2413
                    </value>
2454
                    <value type="object" struct-name="db.mysql.Index" id="980eb49e-ad0b-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
2455
                      <value _ptr_="0xaac6130" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
2456
                        <value type="object" struct-name="db.mysql.IndexColumn" id="980fd0e0-ad0b-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
2457
                          <value type="int" key="columnLength">0</value>
2458
                          <value type="string" key="comment"></value>
2459
                          <value type="int" key="descend">0</value>
2460
                          <link type="object" struct-name="db.Column" key="referencedColumn">06217332-a90f-11e2-8576-080027bcf912</link>
2461
                          <value type="string" key="name"></value>
2462
                          <link type="object" struct-name="GrtObject" key="owner">980eb49e-ad0b-11e2-b309-080027bcf912</link>
2463
                        </value>
2464
                      </value>
2465
                      <value type="string" key="indexKind"></value>
2466
                      <value type="int" key="keyBlockSize">0</value>
2467
                      <value type="string" key="withParser"></value>
2468
                      <value type="string" key="comment"></value>
2469
                      <value type="int" key="deferability">0</value>
2470
                      <value type="string" key="indexType">INDEX</value>
2471
                      <value type="int" key="isPrimary">0</value>
2472
                      <value type="string" key="name">fk_taxon_presence_taxon_name1_idx</value>
2473
                      <value type="int" key="unique">0</value>
2474
                      <value type="string" key="oldName">fk_taxon_presence_taxon_name1_idx</value>
2475
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2476
                    </value>
2477 2414
                  </value>
2478 2415
                  <value type="string" key="maxRows"></value>
2479 2416
                  <value type="string" key="mergeInsert"></value>
......
2505 2442
                  <value type="int" key="commentedOut">0</value>
2506 2443
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2507 2444
                  <value _ptr_="0xaac4210" type="dict" key="customData"/>
2508
                  <value type="string" key="lastChangeDate">2013-04-24 14:33</value>
2445
                  <value type="string" key="lastChangeDate">2013-07-30 13:45</value>
2509 2446
                  <value type="int" key="modelOnly">0</value>
2510 2447
                  <value type="string" key="name">taxon_presence</value>
2511 2448
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
9855 9792
                      <value type="string" key="oldName">id</value>
9856 9793
                      <link type="object" struct-name="GrtObject" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9857 9794
                    </value>
9858
                    <value type="object" struct-name="db.mysql.Column" id="59b34338-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x783b5183">
9859
                      <value type="int" key="autoIncrement">0</value>
9860
                      <value type="string" key="characterSetName"></value>
9861
                      <value _ptr_="0xab34538" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9862
                      <value type="string" key="collationName"></value>
9863
                      <value type="string" key="datatypeExplicitParams"></value>
9864
                      <value type="string" key="defaultValue"></value>
9865
                      <value type="int" key="defaultValueIsNull">0</value>
9866
                      <value _ptr_="0xab34898" type="list" content-type="string" key="flags"/>
9867
                      <value type="int" key="isNotNull">1</value>
9868
                      <value type="int" key="length">767</value>
9869
                      <value type="int" key="precision">-1</value>
9870
                      <value type="int" key="scale">-1</value>
9871
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9872
                      <value type="string" key="comment"></value>
9873
                      <value type="string" key="name">taxon_concept</value>
9874
                      <value type="string" key="oldName">taxon_concept</value>
9875
                      <link type="object" struct-name="GrtObject" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9876
                    </value>
9877 9795
                  </value>
9878 9796
                  <value type="string" key="connectionString"></value>
9879 9797
                  <value type="string" key="defaultCharacterSetName">utf8</value>
9880 9798
                  <value type="string" key="defaultCollationName">utf8_bin</value>
9881 9799
                  <value type="int" key="delayKeyWrite">0</value>
9882 9800
                  <value _ptr_="0xab33de8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
9883
                    <value type="object" struct-name="db.mysql.ForeignKey" id="59b34766-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
9884
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
9885
                      <value _ptr_="0xab34a10" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9801
                    <value type="object" struct-name="db.mysql.ForeignKey" id="d5a68396-f959-11e2-8597-080027bcf912" struct-checksum="0x70a8fc40">
9802
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
9803
                      <value _ptr_="0xb218a80" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9886 9804
                        <link type="object">59b33fe6-f6ba-11e2-aebb-080027bcf912</link>
9887 9805
                      </value>
9888 9806
                      <value type="int" key="deferability">0</value>
9889 9807
                      <value type="string" key="deleteRule">CASCADE</value>
9890
                      <value type="int" key="mandatory">0</value>
9891
                      <value type="int" key="many">0</value>
9892
                      <value type="int" key="modelOnly">0</value>
9893
                      <link type="object" struct-name="db.Table" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9894
                      <value _ptr_="0xab34d78" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9895
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
9896
                      </value>
9897
                      <value type="int" key="referencedMandatory">1</value>
9898
                      <value type="string" key="updateRule">CASCADE</value>
9899
                      <value type="string" key="comment"></value>
9900
                      <value type="string" key="name">fk_taxon_observation_taxon_occurrence10</value>
9901
                      <value type="string" key="oldName">fk_taxon_observation_taxon_occurrence10</value>
9902
                    </value>
9903
                    <value type="object" struct-name="db.mysql.ForeignKey" id="59b34978-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x70a8fc40">
9904
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">1832712c-a77d-11e2-afd5-080027bcf912</link>
9905
                      <value _ptr_="0xab34de8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9906
                        <link type="object">59b34338-f6ba-11e2-aebb-080027bcf912</link>
9907
                      </value>
9908
                      <value type="int" key="deferability">0</value>
9909
                      <value type="string" key="deleteRule">CASCADE</value>
9910
                      <link type="object" struct-name="db.Index" key="index">59b34dec-f6ba-11e2-aebb-080027bcf912</link>
9911 9808
                      <value type="int" key="mandatory">1</value>
9912 9809
                      <value type="int" key="many">1</value>
9913 9810
                      <value type="int" key="modelOnly">0</value>
9914 9811
                      <link type="object" struct-name="db.Table" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9915
                      <value _ptr_="0xab35170" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9916
                        <link type="object">18327370-a77d-11e2-afd5-080027bcf912</link>
9812
                      <value _ptr_="0xb5e9b40" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9813
                        <link type="object">3d9b13d2-a7a1-11e2-b667-080027bcf912</link>
9917 9814
                      </value>
9918 9815
                      <value type="int" key="referencedMandatory">1</value>
9919 9816
                      <value type="string" key="updateRule">CASCADE</value>
9920 9817
                      <value type="string" key="comment"></value>
9921
                      <value type="string" key="name">fk_taxon_presence_taxon_name10</value>
9922
                      <value type="string" key="oldName">fk_taxon_presence_taxon_name10</value>
9818
                      <value type="string" key="name">fk_taxon_absence_taxon_determination1</value>
9819
                      <value type="string" key="oldName">fk_taxon_absence_taxon_determination1</value>
9923 9820
                    </value>
9924 9821
                  </value>
9925 9822
                  <value _ptr_="0xab33e38" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
9946 9843
                      <value type="string" key="oldName">PRIMARY</value>
9947 9844
                      <link type="object" struct-name="GrtObject" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9948 9845
                    </value>
9949
                    <value type="object" struct-name="db.mysql.Index" id="59b34dec-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x309b847a">
9950
                      <value _ptr_="0xab355e0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9951
                        <value type="object" struct-name="db.mysql.IndexColumn" id="59b34ee6-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x62630b3c">
9952
                          <value type="int" key="columnLength">0</value>
9953
                          <value type="string" key="comment"></value>
9954
                          <value type="int" key="descend">0</value>
9955
                          <link type="object" struct-name="db.Column" key="referencedColumn">59b34338-f6ba-11e2-aebb-080027bcf912</link>
9956
                          <value type="string" key="name"></value>
9957
                          <link type="object" struct-name="GrtObject" key="owner">59b34dec-f6ba-11e2-aebb-080027bcf912</link>
9958
                        </value>
9959
                      </value>
9960
                      <value type="string" key="indexKind"></value>
9961
                      <value type="int" key="keyBlockSize">0</value>
9962
                      <value type="string" key="withParser"></value>
9963
                      <value type="string" key="comment"></value>
9964
                      <value type="int" key="deferability">0</value>
9965
                      <value type="string" key="indexType">INDEX</value>
9966
                      <value type="int" key="isPrimary">0</value>
9967
                      <value type="string" key="name">fk_taxon_presence_taxon_name1_idx</value>
9968
                      <value type="int" key="unique">0</value>
9969
                      <value type="string" key="oldName">fk_taxon_presence_taxon_name1_idx</value>
9970
                      <link type="object" struct-name="GrtObject" key="owner">59b33ca8-f6ba-11e2-aebb-080027bcf912</link>
9971
                    </value>
9972 9846
                  </value>
9973 9847
                  <value type="string" key="maxRows"></value>
9974 9848
                  <value type="string" key="mergeInsert"></value>
......
10000 9874
                  <value type="int" key="commentedOut">0</value>
10001 9875
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10002 9876
                  <value _ptr_="0xab33bc0" type="dict" key="customData"/>
10003
                  <value type="string" key="lastChangeDate">2013-07-27 05:46</value>
9877
                  <value type="string" key="lastChangeDate">2013-07-30 13:45</value>
10004 9878
                  <value type="int" key="modelOnly">0</value>
10005 9879
                  <value type="string" key="name">taxon_absence</value>
10006 9880
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12438 12312
                <value type="int" key="visible">1</value>
12439 12313
                <value type="string" key="name"></value>
12440 12314
              </value>
12441
              <value type="object" struct-name="workbench.physical.Connection" id="6e0ca6e0-ac45-11e2-820d-080027bcf912" struct-checksum="0x9baebc92">
12442
                <value type="string" key="caption">fk_taxon_observation_taxon_occurrence1</value>
12443
                <value type="real" key="captionXOffs">0.e+00</value>
12444
                <value type="real" key="captionYOffs">0.e+00</value>
12445
                <value type="string" key="comment"></value>
12446
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12447
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12448
                <value type="string" key="extraCaption"></value>
12449
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12450
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12451
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8eaf4c-a6e0-11e2-95e9-080027bcf912</link>
12452
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12453
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12454
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12455
                <value type="int" key="drawSplit">0</value>
12456
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
12457
                <link type="object" struct-name="model.Figure" key="startFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
12458
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12459
                <value type="int" key="visible">1</value>
12460
                <value type="string" key="name"></value>
12461
              </value>
12462 12315
              <value type="object" struct-name="workbench.physical.Connection" id="750f0118-ac45-11e2-820d-080027bcf912" struct-checksum="0x9baebc92">
12463 12316
                <value type="string" key="caption">fk_specimen_taxon_occurrence10</value>
12464 12317
                <value type="real" key="captionXOffs">0.e+00</value>
......
12470 12323
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12471 12324
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12472 12325
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>
12473
                <value type="real" key="middleSegmentOffset">1.8607724413788355377619154751300811767578125e+02</value>
12326
                <value type="real" key="middleSegmentOffset">8.55002879362949670394300483167171478271484375e+01</value>
12474 12327
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12475 12328
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12476 12329
                <value type="int" key="drawSplit">0</value>
......
12585 12438
                <value type="int" key="visible">1</value>
12586 12439
                <value type="string" key="name"></value>
12587 12440
              </value>
12588
              <value type="object" struct-name="workbench.physical.Connection" id="980eab5c-ad0b-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
12589
                <value type="string" key="caption">fk_taxon_presence_taxon_name1</value>
12590
                <value type="real" key="captionXOffs">0.e+00</value>
12591
                <value type="real" key="captionYOffs">0.e+00</value>
12592
                <value type="string" key="comment"></value>
12593
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12594
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12595
                <value type="string" key="extraCaption"></value>
12596
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12597
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12598
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">0621717a-a90f-11e2-8576-080027bcf912</link>
12599
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12600
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12601
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12602
                <value type="int" key="drawSplit">1</value>
12603
                <link type="object" struct-name="model.Figure" key="endFigure">8932D751-419A-4213-960A-F4E3E44763CD</link>
12604
                <link type="object" struct-name="model.Figure" key="startFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
12605
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12606
                <value type="int" key="visible">1</value>
12607
                <value type="string" key="name"></value>
12608
              </value>
12609 12441
              <value type="object" struct-name="workbench.physical.Connection" id="9b6b743c-ad0c-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
12610 12442
                <value type="string" key="caption">fk_parsed_taxon_assertion_taxon_name1</value>
12611 12443
                <value type="real" key="captionXOffs">0.e+00</value>
......
12879 12711
                <value type="int" key="visible">1</value>
12880 12712
                <value type="string" key="name"></value>
12881 12713
              </value>
12882
              <value type="object" struct-name="workbench.physical.Connection" id="59b3e810-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92">
12883
                <value type="string" key="caption">fk_taxon_observation_taxon_occurrence10</value>
12884
                <value type="real" key="captionXOffs">0.e+00</value>
12885
                <value type="real" key="captionYOffs">0.e+00</value>
12886
                <value type="string" key="comment"></value>
12887
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12888
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12889
                <value type="string" key="extraCaption"></value>
12890
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12891
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12892
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">59b34766-f6ba-11e2-aebb-080027bcf912</link>
12893
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12894
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12895
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12896
                <value type="int" key="drawSplit">0</value>
12897
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
12898
                <link type="object" struct-name="model.Figure" key="startFigure">59b361b0-f6ba-11e2-aebb-080027bcf912</link>
12899
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12900
                <value type="int" key="visible">1</value>
12901
                <value type="string" key="name"></value>
12902
              </value>
12903
              <value type="object" struct-name="workbench.physical.Connection" id="59b3f22e-f6ba-11e2-aebb-080027bcf912" struct-checksum="0x9baebc92">
12904
                <value type="string" key="caption">fk_taxon_presence_taxon_name10</value>
12905
                <value type="real" key="captionXOffs">0.e+00</value>
12906
                <value type="real" key="captionYOffs">0.e+00</value>
12907
                <value type="string" key="comment"></value>
12908
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12909
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12910
                <value type="string" key="extraCaption"></value>
12911
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12912
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12913
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">59b34978-f6ba-11e2-aebb-080027bcf912</link>
12914
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12915
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12916
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12917
                <value type="int" key="drawSplit">1</value>
12918
                <link type="object" struct-name="model.Figure" key="endFigure">8932D751-419A-4213-960A-F4E3E44763CD</link>
12919
                <link type="object" struct-name="model.Figure" key="startFigure">59b361b0-f6ba-11e2-aebb-080027bcf912</link>
12920
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12921
                <value type="int" key="visible">1</value>
12922
                <value type="string" key="name"></value>
12923
              </value>
12924 12714
              <value type="object" struct-name="workbench.physical.Connection" id="1cc826ba-f6be-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">
12925 12715
                <value type="string" key="caption">fk_aggregate_observation_taxon_presence1</value>
12926 12716
                <value type="real" key="captionXOffs">0.e+00</value>
......
13404 13194
                <value type="int" key="visible">1</value>
13405 13195
                <value type="string" key="name"></value>
13406 13196
              </value>
13197
              <value type="object" struct-name="workbench.physical.Connection" id="d20829c4-f959-11e2-8597-080027bcf912" struct-checksum="0x9baebc92">
13198
                <value type="string" key="caption">fk_taxon_presence_taxon_determination1</value>
13199
                <value type="real" key="captionXOffs">0.e+00</value>
13200
                <value type="real" key="captionYOffs">0.e+00</value>
13201
                <value type="string" key="comment"></value>
13202
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13203
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13204
                <value type="string" key="extraCaption"></value>
13205
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13206
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13207
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d2081100-f959-11e2-8597-080027bcf912</link>
13208
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13209
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13210
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13211
                <value type="int" key="drawSplit">0</value>
13212
                <link type="object" struct-name="model.Figure" key="endFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
13213
                <link type="object" struct-name="model.Figure" key="startFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>
13214
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13215
                <value type="int" key="visible">1</value>
13216
                <value type="string" key="name"></value>
13217
              </value>
13218
              <value type="object" struct-name="workbench.physical.Connection" id="d5a69f0c-f959-11e2-8597-080027bcf912" struct-checksum="0x9baebc92">
13219
                <value type="string" key="caption">fk_taxon_absence_taxon_determination1</value>
13220
                <value type="real" key="captionXOffs">0.e+00</value>
13221
                <value type="real" key="captionYOffs">0.e+00</value>
13222
                <value type="string" key="comment"></value>
13223
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13224
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13225
                <value type="string" key="extraCaption"></value>
13226
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13227
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13228
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d5a68396-f959-11e2-8597-080027bcf912</link>
13229
                <value type="real" key="middleSegmentOffset">5.46928875150280191519414074718952178955078125e+01</value>
13230
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13231
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13232
                <value type="int" key="drawSplit">0</value>
13233
                <link type="object" struct-name="model.Figure" key="endFigure">A09DFA1F-7755-4CBB-A5F8-AE7CAECAA7EC</link>
13234
                <link type="object" struct-name="model.Figure" key="startFigure">59b361b0-f6ba-11e2-aebb-080027bcf912</link>
13235
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13236
                <value type="int" key="visible">1</value>
13237
                <value type="string" key="name"></value>
13238
              </value>
13407 13239
            </value>
13408 13240
            <value type="string" key="description"></value>
13409 13241
            <value _ptr_="0xab48bb8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13713 13545
                <value type="int" key="expanded">1</value>
13714 13546
                <value type="real" key="height">1.23e+02</value>
13715 13547
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13716
                <value type="real" key="left">1.279e+03</value>
13548
                <value type="real" key="left">1.29e+03</value>
13717 13549
                <value type="int" key="locked">0</value>
13718 13550
                <value type="int" key="manualSizing">0</value>
13719 13551
                <value type="real" key="top">1.106e+03</value>
......
13733 13565
                <value type="int" key="expanded">1</value>
13734 13566
                <value type="real" key="height">1.46e+02</value>
13735 13567
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13736
                <value type="real" key="left">8.82e+02</value>
13568
                <value type="real" key="left">8.56e+02</value>
13737 13569
                <value type="int" key="locked">0</value>
13738 13570
                <value type="int" key="manualSizing">0</value>
13739 13571
                <value type="real" key="top">9.19e+02</value>
......
13773 13605
                <value type="int" key="expanded">1</value>
13774 13606
                <value type="real" key="height">1.e+02</value>
13775 13607
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13776
                <value type="real" key="left">1.455e+03</value>
13608
                <value type="real" key="left">1.471e+03</value>
13777 13609
                <value type="int" key="locked">0</value>
13778 13610
                <value type="int" key="manualSizing">0</value>
13779
                <value type="real" key="top">4.6e+01</value>
13611
                <value type="real" key="top">3.7e+01</value>
13780 13612
                <value type="real" key="width">1.3e+02</value>
13781 13613
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13782 13614
                <value type="int" key="visible">1</value>
......
13791 13623
                <value type="int" key="triggersExpanded">0</value>
13792 13624
                <value type="string" key="color">#FFFF00</value>
13793 13625
                <value type="int" key="expanded">1</value>
13794
                <value type="real" key="height">1.e+02</value>
13626
                <value type="real" key="height">7.7e+01</value>
13795 13627
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13796
                <value type="real" key="left">1.004e+03</value>
13628
                <value type="real" key="left">9.79e+02</value>
13797 13629
                <value type="int" key="locked">0</value>
13798 13630
                <value type="int" key="manualSizing">0</value>
13799
                <value type="real" key="top">2.82e+02</value>
13631
                <value type="real" key="top">6.71e+02</value>
13800 13632
                <value type="real" key="width">1.41e+02</value>
13801 13633
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13802 13634
                <value type="int" key="visible">1</value>
......
13809 13641
                <value type="int" key="summarizeDisplay">-1</value>
13810 13642
                <link type="object" struct-name="db.Table" key="table">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
13811 13643
                <value type="int" key="triggersExpanded">0</value>
13812
                <value type="string" key="color">#00ee00</value>
13644
                <value type="string" key="color">#ffff00</value>
13813 13645
                <value type="int" key="expanded">1</value>
13814 13646
                <value type="real" key="height">1.23e+02</value>
13815 13647
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13816
                <value type="real" key="left">8.69e+02</value>
13648
                <value type="real" key="left">8.84e+02</value>
13817 13649
                <value type="int" key="locked">0</value>
13818 13650
                <value type="int" key="manualSizing">0</value>
13819
                <value type="real" key="top">7.32e+02</value>
13651
                <value type="real" key="top">5.21e+02</value>
13820 13652
                <value type="real" key="width">1.68e+02</value>
13821 13653
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13822 13654
                <value type="int" key="visible">1</value>
......
13833 13665
                <value type="int" key="expanded">1</value>
13834 13666
                <value type="real" key="height">7.7e+01</value>
13835 13667
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13836
                <value type="real" key="left">9.6e+02</value>
13668
                <value type="real" key="left">1.207e+03</value>
13837 13669
                <value type="int" key="locked">0</value>
13838 13670
                <value type="int" key="manualSizing">0</value>
13839
                <value type="real" key="top">4.3e+02</value>
13671
                <value type="real" key="top">7.06e+02</value>
13840 13672
                <value type="real" key="width">1.82e+02</value>
13841 13673
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13842 13674
                <value type="int" key="visible">1</value>
......
13853 13685
                <value type="int" key="expanded">1</value>
13854 13686
                <value type="real" key="height">1.e+02</value>
13855 13687
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13856
                <value type="real" key="left">1.419e+03</value>
13688
                <value type="real" key="left">1.311e+03</value>
13857 13689
                <value type="int" key="locked">0</value>
13858 13690
                <value type="int" key="manualSizing">0</value>
13859
                <value type="real" key="top">2.2e+02</value>
13691
                <value type="real" key="top">5.6e+01</value>
13860 13692
                <value type="real" key="width">1.06e+02</value>
13861 13693
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13862 13694
                <value type="int" key="visible">1</value>
......
13873 13705
                <value type="int" key="expanded">1</value>
13874 13706
                <value type="real" key="height">1.23e+02</value>
13875 13707
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13876
                <value type="real" key="left">1.194e+03</value>
13708
                <value type="real" key="left">1.086e+03</value>
13877 13709
                <value type="int" key="locked">0</value>
13878 13710
                <value type="int" key="manualSizing">0</value>
13879
                <value type="real" key="top">2.08e+02</value>
13711
                <value type="real" key="top">4.4e+01</value>
13880 13712
                <value type="real" key="width">1.8e+02</value>
13881 13713
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13882 13714
                <value type="int" key="visible">1</value>
......
13893 13725
                <value type="int" key="expanded">1</value>
13894 13726
                <value type="real" key="height">7.7e+01</value>
13895 13727
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13896
                <value type="real" key="left">1.42e+03</value>
13728
                <value type="real" key="left">1.312e+03</value>
13897 13729
                <value type="int" key="locked">0</value>
13898 13730
                <value type="int" key="manualSizing">0</value>
13899
                <value type="real" key="top">4.83e+02</value>
13731
                <value type="real" key="top">3.19e+02</value>
13900 13732
                <value type="real" key="width">7.8e+01</value>
13901 13733
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13902 13734
                <value type="int" key="visible">1</value>
......
13913 13745
                <value type="int" key="expanded">1</value>
13914 13746
                <value type="real" key="height">1.23e+02</value>
13915 13747
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13916
                <value type="real" key="left">1.203e+03</value>
13748
                <value type="real" key="left">1.095e+03</value>
13917 13749
                <value type="int" key="locked">0</value>
13918 13750
                <value type="int" key="manualSizing">0</value>
13919
                <value type="real" key="top">4.6e+02</value>
13751
                <value type="real" key="top">2.96e+02</value>
13920 13752
                <value type="real" key="width">1.52e+02</value>
13921 13753
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13922 13754
                <value type="int" key="visible">1</value>
......
13933 13765
                <value type="int" key="expanded">1</value>
13934 13766
                <value type="real" key="height">2.61e+02</value>
13935 13767
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13936
                <value type="real" key="left">1.454e+03</value>
13768
                <value type="real" key="left">1.453e+03</value>
13937 13769
                <value type="int" key="locked">0</value>
13938 13770
                <value type="int" key="manualSizing">0</value>
13939
                <value type="real" key="top">5.97e+02</value>
13771
                <value type="real" key="top">3.48e+02</value>
13940 13772
                <value type="real" key="width">1.57e+02</value>
13941 13773
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13942 13774
                <value type="int" key="visible">1</value>
......
13953 13785
                <value type="int" key="expanded">1</value>
13954 13786
                <value type="real" key="height">1.e+02</value>
13955 13787
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13956
                <value type="real" key="left">1.281e+03</value>
13788
                <value type="real" key="left">1.299e+03</value>
13957 13789
                <value type="int" key="locked">0</value>
13958 13790
                <value type="int" key="manualSizing">0</value>
13959
                <value type="real" key="top">6.7e+02</value>
13791
                <value type="real" key="top">4.21e+02</value>
13960 13792
                <value type="real" key="width">1.06e+02</value>
13961 13793
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13962 13794
                <value type="int" key="visible">1</value>
......
14379 14211
                <value type="int" key="expanded">1</value>
14380 14212
                <value type="real" key="height">1.92e+02</value>
14381 14213
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14382
                <value type="real" key="left">1.327e+03</value>
14214
                <value type="real" key="left">1.338e+03</value>
14383 14215
                <value type="int" key="locked">0</value>
14384 14216
                <value type="int" key="manualSizing">0</value>
14385 14217
                <value type="real" key="top">8.73e+02</value>
......
14439 14271
                <value type="int" key="expanded">1</value>
14440 14272
                <value type="real" key="height">1.e+02</value>
14441 14273
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14442
                <value type="real" key="left">1.068e+03</value>
14274
                <value type="real" key="left">1.086e+03</value>
14443 14275
                <value type="int" key="locked">0</value>
14444 14276
                <value type="int" key="manualSizing">0</value>
14445
                <value type="real" key="top">7.44e+02</value>
14277
                <value type="real" key="top">4.95e+02</value>
14446 14278
                <value type="real" key="width">1.8e+02</value>
14447 14279
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14448 14280
                <value type="int" key="visible">1</value>
......
14474 14306
                <value type="int" key="expanded">1</value>
14475 14307
                <value type="real" key="height">2.7e+01</value>
14476 14308
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14477
                <value type="real" key="left">1.062e+03</value>
14309
                <value type="real" key="left">1.036e+03</value>
14478 14310
                <value type="int" key="locked">0</value>
14479 14311
                <value type="int" key="manualSizing">0</value>
14480 14312
                <value type="real" key="top">8.83e+02</value>
......
14489 14321
                <value type="int" key="expanded">1</value>
14490 14322
                <value type="real" key="height">2.5e+01</value>
14491 14323
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14492
                <value type="real" key="left">1.027e+03</value>
14324
                <value type="real" key="left">1.001e+03</value>
14493 14325
                <value type="int" key="locked">0</value>
14494 14326
                <value type="int" key="manualSizing">0</value>
14495 14327
                <value type="real" key="top">9.39e+02</value>
......
14504 14336
                <value type="int" key="expanded">1</value>
14505 14337
                <value type="real" key="height">2.5e+01</value>
14506 14338
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14507
                <value type="real" key="left">1.213e+03</value>
14339
                <value type="real" key="left">1.224e+03</value>
14508 14340
                <value type="int" key="locked">0</value>
14509 14341
                <value type="int" key="manualSizing">0</value>
14510 14342
                <value type="real" key="top">1.023e+03</value>
......
14549 14381
                <value type="int" key="expanded">1</value>
14550 14382
                <value type="real" key="height">2.7e+01</value>
14551 14383
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14552
                <value type="real" key="left">1.456e+03</value>
14384
                <value type="real" key="left">1.467e+03</value>
14553 14385
                <value type="int" key="locked">0</value>
14554 14386
                <value type="int" key="manualSizing">0</value>
14555 14387
                <value type="real" key="top">1.179e+03</value>
......
14564 14396
                <value type="int" key="expanded">1</value>
14565 14397
                <value type="real" key="height">2.5e+01</value>
14566 14398
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14567
                <value type="real" key="left">9.59e+02</value>
14399
                <value type="real" key="left">9.33e+02</value>
14568 14400
                <value type="int" key="locked">0</value>
14569 14401
                <value type="int" key="manualSizing">0</value>
14570 14402
                <value type="real" key="top">8.84e+02</value>
......
14637 14469
                <value type="int" key="triggersExpanded">0</value>
14638 14470
                <value type="string" key="color">#FFFF00</value>
14639 14471
                <value type="int" key="expanded">1</value>
14640
                <value type="real" key="height">7.7e+01</value>
14472
                <value type="real" key="height">5.4e+01</value>
14641 14473
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14642
                <value type="real" key="left">1.104e+03</value>
14474
                <value type="real" key="left">9.59e+02</value>
14643 14475
                <value type="int" key="locked">0</value>
14644 14476
                <value type="int" key="manualSizing">0</value>
14645
                <value type="real" key="top">3.e+01</value>
14477
                <value type="real" key="top">8.1e+02</value>
14646 14478
                <value type="real" key="width">1.36e+02</value>
14647 14479
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14648 14480
                <value type="int" key="visible">1</value>
......
14884 14716
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14885 14717
        <value _ptr_="0xaab1d90" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14886 14718
        <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">
14719
          <value type="object" struct-name="db.mgmt.SyncProfile" id="134858ba-f959-11e2-8597-080027bcf912" struct-checksum="0xc64972c2" key="">
14720
            <value _ptr_="0xb7fd7b8" type="dict" key="lastKnownDBNames">
14889 14721
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14890 14722
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14891 14723
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14894 14726
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
14895 14727
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
14896 14728
              <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>
14729
              <value type="string" key="06217332-a90f-11e2-8576-080027bcf912">taxon</value>
14898 14730
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14899 14731
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
14900 14732
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">footprint_geom_WKT</value>
......
15025 14857
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
15026 14858
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
15027 14859
              <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 14860
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
15032 14861
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
15033 14862
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
......
15038 14867
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
15039 14868
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
15040 14869
              <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 14870
              <value type="string" key="565fd9e8-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1</value>
15043 14871
              <value type="string" key="565fe000-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1_idx</value>
15044 14872
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
15045 14873
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
15046 14874
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
15047 14875
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
15048
              <value type="string" key="59b34338-f6ba-11e2-aebb-080027bcf912">taxon_concept</value>
14876
              <value type="string" key="59b34338-f6ba-11e2-aebb-080027bcf912">taxon</value>
15049 14877
              <value type="string" key="59b34766-f6ba-11e2-aebb-080027bcf912">fk_taxon_observation_taxon_occurrence10</value>
15050 14878
              <value type="string" key="59b34978-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name10</value>
15051 14879
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
15052 14880
              <value type="string" key="59b34dec-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name1_idx</value>
14881
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
15053 14882
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>
15054 14883
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
15055 14884
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
......
15433 15262
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
15434 15263
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
15435 15264
      <value type="string" key="caption">New Model</value>
15436
      <value type="string" key="dateChanged">2013-07-30 13:35</value>
15265
      <value type="string" key="dateChanged">2013-07-30 14:18</value>
15437 15266
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
15438 15267
      <value type="string" key="description"></value>
15439 15268
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
928 928
/*!40101 SET character_set_client = utf8 */;
929 929
CREATE TABLE `taxon_absence` (
930 930
  `id` varbinary(767) NOT NULL,
931
  `taxon_concept` varbinary(767) NOT NULL,
932 931
  PRIMARY KEY (`id`),
933
  KEY `fk_taxon_presence_taxon_name1_idx` (`taxon_concept`),
934
  CONSTRAINT `fk_taxon_observation_taxon_occurrence10` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
935
  CONSTRAINT `fk_taxon_presence_taxon_name10` FOREIGN KEY (`taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
932
  CONSTRAINT `fk_taxon_absence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
936 933
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation that a [[VegCore#Taxon|Taxon]]''s does _not_ exist in a place';
937 934
/*!40101 SET character_set_client = @saved_cs_client */;
938 935

  
......
1119 1116
/*!40101 SET character_set_client = utf8 */;
1120 1117
CREATE TABLE `taxon_presence` (
1121 1118
  `id` varbinary(767) NOT NULL,
1122
  `taxon_concept` varbinary(767) NOT NULL,
1123 1119
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
1124 1120
  PRIMARY KEY (`id`),
1125
  KEY `fk_taxon_presence_taxon_name1_idx` (`taxon_concept`),
1126
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1127
  CONSTRAINT `fk_taxon_presence_taxon_name1` FOREIGN KEY (`taxon_concept`) REFERENCES `taxon_concept` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1121
  CONSTRAINT `fk_taxon_presence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1128 1122
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of just a [[VegCore#Taxon|Taxon]]''s _presence_';
1129 1123
/*!40101 SET character_set_client = @saved_cs_client */;
1130 1124

  
schemas/VegCore/VegCore.pg.sql
930 930
/*!40101 SET character_set_client = utf8 */;
931 931
CREATE TABLE "taxon_absence" (
932 932
  "id" text NOT NULL,
933
  "taxon_concept" text NOT NULL,
934 933
  PRIMARY KEY ("id"),
935
  /*KEY "fk_taxon_presence_taxon_name1_idx" ("taxon_concept")*/CHECK (true),
936
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
937
  /*CONSTRAINT "fk_taxon_presence_taxon_name10" FOREIGN KEY ("taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
934
  /*CONSTRAINT "fk_taxon_absence_taxon_determination1" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
938 935
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation that a [[VegCore#Taxon|Taxon]]''s does _not_ exist in a place'*/;
939 936
/*!40101 SET character_set_client = @saved_cs_client */;
940 937

  
......
1121 1118
/*!40101 SET character_set_client = utf8 */;
1122 1119
CREATE TABLE "taxon_presence" (
1123 1120
  "id" text NOT NULL,
1124
  "taxon_concept" text NOT NULL,
1125 1121
  "traits" hstore DEFAULT NULL,
1126 1122
  PRIMARY KEY ("id"),
1127
  /*KEY "fk_taxon_presence_taxon_name1_idx" ("taxon_concept")*/CHECK (true),
1128
  /*CONSTRAINT "fk_taxon_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1129
  /*CONSTRAINT "fk_taxon_presence_taxon_name1" FOREIGN KEY ("taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1123
  /*CONSTRAINT "fk_taxon_presence_taxon_determination1" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1130 1124
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of just a [[VegCore#Taxon|Taxon]]''s _presence_'*/;
1131 1125
/*!40101 SET character_set_client = @saved_cs_client */;
1132 1126

  

Also available in: Unified diff