Project

General

Profile

« Previous | Next » 

Revision 10490

schemas/VegCore/VegCore.ERD.mwb: specimen_observation: added description (vegcore.vegpath.org?specimenDescription). taxon_presence: added occurrence_status (vegcore.vegpath.org?occurrenceStatus). stem_observation, aggregate_observation: made room for them to expand with additional first-class fields.

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="46a92892-f95e-11e2-8597-080027bcf912" struct-checksum="0x783b5183">
2345
                      <value type="int" key="autoIncrement">0</value>
2346
                      <value type="string" key="characterSetName"></value>
2347
                      <value _ptr_="0xba3d7d0" 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">1</value>
2352
                      <value _ptr_="0xb7a8388" type="list" content-type="string" key="flags"/>
2353
                      <value type="int" key="isNotNull">0</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">occurrence_status</value>
2360
                      <value type="string" key="oldName">occurrence_status</value>
2361
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2362
                    </value>
2344 2363
                    <value type="object" struct-name="db.mysql.Column" id="d72de448-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
2345 2364
                      <value type="int" key="autoIncrement">0</value>
2346 2365
                      <value type="string" key="characterSetName"></value>
......
2442 2461
                  <value type="int" key="commentedOut">0</value>
2443 2462
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2444 2463
                  <value _ptr_="0xaac4210" type="dict" key="customData"/>
2445
                  <value type="string" key="lastChangeDate">2013-07-30 13:45</value>
2464
                  <value type="string" key="lastChangeDate">2013-07-30 14:23</value>
2446 2465
                  <value type="int" key="modelOnly">0</value>
2447 2466
                  <value type="string" key="name">taxon_presence</value>
2448 2467
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
9255 9274
                      <value type="string" key="oldName">specimen</value>
9256 9275
                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>
9257 9276
                    </value>
9277
                    <value type="object" struct-name="db.mysql.Column" id="7d6806c8-f95e-11e2-8597-080027bcf912" struct-checksum="0x783b5183">
9278
                      <value type="int" key="autoIncrement">0</value>
9279
                      <value type="string" key="characterSetName"></value>
9280
                      <value _ptr_="0xb7f6398" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9281
                      <value type="string" key="collationName"></value>
9282
                      <value type="string" key="datatypeExplicitParams"></value>
9283
                      <value type="string" key="defaultValue"></value>
9284
                      <value type="int" key="defaultValueIsNull">1</value>
9285
                      <value _ptr_="0xbe91dd0" type="list" content-type="string" key="flags"/>
9286
                      <value type="int" key="isNotNull">0</value>
9287
                      <value type="int" key="length">767</value>
9288
                      <value type="int" key="precision">-1</value>
9289
                      <value type="int" key="scale">-1</value>
9290
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9291
                      <value type="string" key="comment"></value>
9292
                      <value type="string" key="name">description</value>
9293
                      <value type="string" key="oldName">description</value>
9294
                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>
9295
                    </value>
9258 9296
                    <value type="object" struct-name="db.mysql.Column" id="c540c5c0-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
9259 9297
                      <value type="int" key="autoIncrement">0</value>
9260 9298
                      <value type="string" key="characterSetName"></value>
......
9401 9439
                  <value type="int" key="commentedOut">0</value>
9402 9440
                  <value type="string" key="createDate">2013-04-17 13:52</value>
9403 9441
                  <value _ptr_="0xab2bc48" type="dict" key="customData"/>
9404
                  <value type="string" key="lastChangeDate">2013-04-24 13:01</value>
9442
                  <value type="string" key="lastChangeDate">2013-07-30 14:25</value>
9405 9443
                  <value type="int" key="modelOnly">0</value>
9406 9444
                  <value type="string" key="name">specimen_observation</value>
9407 9445
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11924 11962
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11925 11963
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11926 11964
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c6731c28-a7a0-11e2-b667-080027bcf912</link>
11927
                <value type="real" key="middleSegmentOffset">1.8e+01</value>
11965
                <value type="real" key="middleSegmentOffset">1.5418713475037293392233550548553466796875e-01</value>
11928 11966
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11929 11967
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11930 11968
                <value type="int" key="drawSplit">0</value>
......
12176 12214
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12177 12215
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12178 12216
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">44e36b2c-a7b4-11e2-97d7-080027bcf912</link>
12179
                <value type="real" key="middleSegmentOffset">1.06e+02</value>
12217
                <value type="real" key="middleSegmentOffset">3.57715086119578700163401663303375244140625e+01</value>
12180 12218
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12181 12219
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12182 12220
                <value type="int" key="drawSplit">0</value>
......
12323 12361
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12324 12362
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12325 12363
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>
12326
                <value type="real" key="middleSegmentOffset">8.55002879362949670394300483167171478271484375e+01</value>
12364
                <value type="real" key="middleSegmentOffset">-5.22661111819189727611956186592578887939453125e+01</value>
12327 12365
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12328 12366
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12329 12367
                <value type="int" key="drawSplit">0</value>
......
12428 12466
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12429 12467
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12430 12468
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6ec4a89c-ad05-11e2-b309-080027bcf912</link>
12431
                <value type="real" key="middleSegmentOffset">-2.3e+01</value>
12469
                <value type="real" key="middleSegmentOffset">1.38477697316619696721318177878856658935546875e+00</value>
12432 12470
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12433 12471
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12434 12472
                <value type="int" key="drawSplit">0</value>
......
13226 13264
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13227 13265
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13228 13266
                <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>
13267
                <value type="real" key="middleSegmentOffset">6.21546658059154424336156807839870452880859375e+01</value>
13230 13268
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13231 13269
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13232 13270
                <value type="int" key="drawSplit">0</value>
......
13623 13661
                <value type="int" key="triggersExpanded">0</value>
13624 13662
                <value type="string" key="color">#FFFF00</value>
13625 13663
                <value type="int" key="expanded">1</value>
13626
                <value type="real" key="height">7.7e+01</value>
13664
                <value type="real" key="height">1.e+02</value>
13627 13665
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13628
                <value type="real" key="left">9.79e+02</value>
13666
                <value type="real" key="left">9.86e+02</value>
13629 13667
                <value type="int" key="locked">0</value>
13630 13668
                <value type="int" key="manualSizing">0</value>
13631
                <value type="real" key="top">6.71e+02</value>
13669
                <value type="real" key="top">6.43e+02</value>
13632 13670
                <value type="real" key="width">1.41e+02</value>
13633 13671
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13634 13672
                <value type="int" key="visible">1</value>
......
13648 13686
                <value type="real" key="left">8.84e+02</value>
13649 13687
                <value type="int" key="locked">0</value>
13650 13688
                <value type="int" key="manualSizing">0</value>
13651
                <value type="real" key="top">5.21e+02</value>
13689
                <value type="real" key="top">4.95e+02</value>
13652 13690
                <value type="real" key="width">1.68e+02</value>
13653 13691
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13654 13692
                <value type="int" key="visible">1</value>
......
13665 13703
                <value type="int" key="expanded">1</value>
13666 13704
                <value type="real" key="height">7.7e+01</value>
13667 13705
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13668
                <value type="real" key="left">1.207e+03</value>
13706
                <value type="real" key="left">1.153e+03</value>
13669 13707
                <value type="int" key="locked">0</value>
13670 13708
                <value type="int" key="manualSizing">0</value>
13671
                <value type="real" key="top">7.06e+02</value>
13709
                <value type="real" key="top">6.73e+02</value>
13672 13710
                <value type="real" key="width">1.82e+02</value>
13673 13711
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13674 13712
                <value type="int" key="visible">1</value>
......
13705 13743
                <value type="int" key="expanded">1</value>
13706 13744
                <value type="real" key="height">1.23e+02</value>
13707 13745
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13708
                <value type="real" key="left">1.086e+03</value>
13746
                <value type="real" key="left">1.071e+03</value>
13709 13747
                <value type="int" key="locked">0</value>
13710 13748
                <value type="int" key="manualSizing">0</value>
13711 13749
                <value type="real" key="top">4.4e+01</value>
......
13745 13783
                <value type="int" key="expanded">1</value>
13746 13784
                <value type="real" key="height">1.23e+02</value>
13747 13785
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13748
                <value type="real" key="left">1.095e+03</value>
13786
                <value type="real" key="left">1.08e+03</value>
13749 13787
                <value type="int" key="locked">0</value>
13750 13788
                <value type="int" key="manualSizing">0</value>
13751 13789
                <value type="real" key="top">2.96e+02</value>
......
13768 13806
                <value type="real" key="left">1.453e+03</value>
13769 13807
                <value type="int" key="locked">0</value>
13770 13808
                <value type="int" key="manualSizing">0</value>
13771
                <value type="real" key="top">3.48e+02</value>
13809
                <value type="real" key="top">2.62e+02</value>
13772 13810
                <value type="real" key="width">1.57e+02</value>
13773 13811
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13774 13812
                <value type="int" key="visible">1</value>
......
13785 13823
                <value type="int" key="expanded">1</value>
13786 13824
                <value type="real" key="height">1.e+02</value>
13787 13825
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13788
                <value type="real" key="left">1.299e+03</value>
13826
                <value type="real" key="left">1.479e+03</value>
13789 13827
                <value type="int" key="locked">0</value>
13790 13828
                <value type="int" key="manualSizing">0</value>
13791
                <value type="real" key="top">4.21e+02</value>
13829
                <value type="real" key="top">5.88e+02</value>
13792 13830
                <value type="real" key="width">1.06e+02</value>
13793 13831
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13794 13832
                <value type="int" key="visible">1</value>
......
14211 14249
                <value type="int" key="expanded">1</value>
14212 14250
                <value type="real" key="height">1.92e+02</value>
14213 14251
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14214
                <value type="real" key="left">1.338e+03</value>
14252
                <value type="real" key="left">1.358e+03</value>
14215 14253
                <value type="int" key="locked">0</value>
14216 14254
                <value type="int" key="manualSizing">0</value>
14217 14255
                <value type="real" key="top">8.73e+02</value>
......
14231 14269
                <value type="int" key="expanded">1</value>
14232 14270
                <value type="real" key="height">1.46e+02</value>
14233 14271
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14234
                <value type="real" key="left">1.488e+03</value>
14272
                <value type="real" key="left">1.494e+03</value>
14235 14273
                <value type="int" key="locked">0</value>
14236 14274
                <value type="int" key="manualSizing">0</value>
14237
                <value type="real" key="top">9.43e+02</value>
14275
                <value type="real" key="top">9.9e+02</value>
14238 14276
                <value type="real" key="width">1.14e+02</value>
14239 14277
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14240 14278
                <value type="int" key="visible">1</value>
......
14251 14289
                <value type="int" key="expanded">1</value>
14252 14290
                <value type="real" key="height">1.92e+02</value>
14253 14291
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14254
                <value type="real" key="left">8.33e+02</value>
14292
                <value type="real" key="left">8.22e+02</value>
14255 14293
                <value type="int" key="locked">0</value>
14256 14294
                <value type="int" key="manualSizing">0</value>
14257
                <value type="real" key="top">3.7e+01</value>
14295
                <value type="real" key="top">1.41e+02</value>
14258 14296
                <value type="real" key="width">1.56e+02</value>
14259 14297
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14260 14298
                <value type="int" key="visible">1</value>
......
14269 14307
                <value type="int" key="triggersExpanded">0</value>
14270 14308
                <value type="string" key="color">#CCCC33</value>
14271 14309
                <value type="int" key="expanded">1</value>
14272
                <value type="real" key="height">1.e+02</value>
14310
                <value type="real" key="height">1.23e+02</value>
14273 14311
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14274
                <value type="real" key="left">1.086e+03</value>
14312
                <value type="real" key="left">1.251e+03</value>
14275 14313
                <value type="int" key="locked">0</value>
14276 14314
                <value type="int" key="manualSizing">0</value>
14277
                <value type="real" key="top">4.95e+02</value>
14315
                <value type="real" key="top">4.8e+02</value>
14278 14316
                <value type="real" key="width">1.8e+02</value>
14279 14317
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14280 14318
                <value type="int" key="visible">1</value>
......
14301 14339
                <value type="string" key="name">organization</value>
14302 14340
              </value>
14303 14341
              <value type="object" struct-name="workbench.model.NoteFigure" id="e3f8486c-aca1-11e2-a207-080027bcf912" struct-checksum="0x56ccd040">
14304
                <value type="string" key="text">&lt; TNRS taxonomic scrubbing steps</value>
14342
                <value type="string" key="text">v  TNRS taxonomic scrubbing steps</value>
14305 14343
                <value type="string" key="color">#ffffff</value>
14306 14344
                <value type="int" key="expanded">1</value>
14307 14345
                <value type="real" key="height">2.7e+01</value>
14308 14346
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14309
                <value type="real" key="left">1.036e+03</value>
14347
                <value type="real" key="left">9.33e+02</value>
14310 14348
                <value type="int" key="locked">0</value>
14311 14349
                <value type="int" key="manualSizing">0</value>
14312
                <value type="real" key="top">8.83e+02</value>
14313
                <value type="real" key="width">2.02e+02</value>
14350
                <value type="real" key="top">8.58e+02</value>
14351
                <value type="real" key="width">2.05e+02</value>
14314 14352
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14315 14353
                <value type="int" key="visible">1</value>
14316 14354
                <value type="string" key="name">TNRS taxonomic scrubbing steps</value>
......
14336 14374
                <value type="int" key="expanded">1</value>
14337 14375
                <value type="real" key="height">2.5e+01</value>
14338 14376
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
14339
                <value type="real" key="left">1.224e+03</value>
14377
                <value type="real" key="left">1.244e+03</value>
14340 14378
                <value type="int" key="locked">0</value>
14341 14379
                <value type="int" key="manualSizing">0</value>
14342 14380
                <value type="real" key="top">1.023e+03</value>
......
14399 14437
                <value type="real" key="left">9.33e+02</value>
14400 14438
                <value type="int" key="locked">0</value>
14401 14439
                <value type="int" key="manualSizing">0</value>
14402
                <value type="real" key="top">8.84e+02</value>
14440
                <value type="real" key="top">8.9e+02</value>
14403 14441
                <value type="real" key="width">9.3e+01</value>
14404 14442
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14405 14443
                <value type="int" key="visible">1</value>
......
14474 14512
                <value type="real" key="left">9.59e+02</value>
14475 14513
                <value type="int" key="locked">0</value>
14476 14514
                <value type="int" key="manualSizing">0</value>
14477
                <value type="real" key="top">8.1e+02</value>
14515
                <value type="real" key="top">7.84e+02</value>
14478 14516
                <value type="real" key="width">1.36e+02</value>
14479 14517
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14480 14518
                <value type="int" key="visible">1</value>
......
14703 14741
              <value type="int" key="visible">1</value>
14704 14742
              <value type="string" key="name"></value>
14705 14743
            </value>
14706
            <value _ptr_="0xab48c90" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
14744
            <value _ptr_="0xab48c90" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14745
              <link type="object">c3763ff6-a7b3-11e2-8ba6-080027bcf912</link>
14746
            </value>
14707 14747
            <value type="int" key="updateBlocked">0</value>
14708 14748
            <value type="real" key="width">1.6215e+03</value>
14709 14749
            <value type="real" key="x">0.e+00</value>
......
14716 14756
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14717 14757
        <value _ptr_="0xaab1d90" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14718 14758
        <value _ptr_="0x9d366e8" type="dict" key="syncProfiles">
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">
14759
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6ce91dd0-f960-11e2-8597-080027bcf912" struct-checksum="0xc64972c2" key="">
14760
            <value _ptr_="0xbcd7438" type="dict" key="lastKnownDBNames">
14721 14761
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14722 14762
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14723 14763
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14725 14765
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
14726 14766
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
14727 14767
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
14728
              <value type="string" key="0621717a-a90f-11e2-8576-080027bcf912">fk_taxon_presence_taxon_name1</value>
14729
              <value type="string" key="06217332-a90f-11e2-8576-080027bcf912">taxon</value>
14730 14768
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14731 14769
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
14732 14770
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">footprint_geom_WKT</value>
......
14841 14879
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>
14842 14880
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
14843 14881
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
14882
              <value type="string" key="46a92892-f95e-11e2-8597-080027bcf912">occurrence_status</value>
14844 14883
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
14845 14884
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
14846 14885
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
......
14873 14912
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
14874 14913
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
14875 14914
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
14876
              <value type="string" key="59b34338-f6ba-11e2-aebb-080027bcf912">taxon</value>
14877
              <value type="string" key="59b34766-f6ba-11e2-aebb-080027bcf912">fk_taxon_observation_taxon_occurrence10</value>
14878
              <value type="string" key="59b34978-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name10</value>
14879 14915
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
14880
              <value type="string" key="59b34dec-f6ba-11e2-aebb-080027bcf912">fk_taxon_presence_taxon_name1_idx</value>
14881 14916
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
14882 14917
              <value type="string" key="5c62b4f2-ad03-11e2-b309-080027bcf912">code</value>
14883 14918
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
......
14911 14946
              <value type="string" key="705abb34-f6e2-11e2-b6d1-080027bcf912">fk_validatable_geoplace_geoplace1</value>
14912 14947
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
14913 14948
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
14949
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
14914 14950
              <value type="string" key="7eeac536-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1</value>
14915 14951
              <value type="string" key="7eeac720-f6e2-11e2-b6d1-080027bcf912">geoplace</value>
14916 14952
              <value type="string" key="7eeadc2e-f6e2-11e2-b6d1-080027bcf912">fk_place_geoplace1_idx</value>
......
14934 14970
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
14935 14971
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
14936 14972
              <value type="string" key="95e0feca-a793-11e2-84c3-080027bcf912">info</value>
14937
              <value type="string" key="980eb49e-ad0b-11e2-b309-080027bcf912">fk_taxon_presence_taxon_name1_idx</value>
14938 14973
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
14939 14974
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
14940 14975
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
......
15033 15068
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
15034 15069
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
15035 15070
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
15036
              <value type="string" key="be8eaf4c-a6e0-11e2-95e9-080027bcf912">fk_taxon_observation_taxon_occurrence1</value>
15037 15071
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
15038 15072
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
15039 15073
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
......
15143 15177
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
15144 15178
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
15145 15179
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
15180
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>
15146 15181
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
15182
              <value type="string" key="d5a68396-f959-11e2-8597-080027bcf912">fk_taxon_absence_taxon_determination1</value>
15147 15183
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
15148 15184
              <value type="string" key="d72de448-ad19-11e2-9d85-080027bcf912">traits</value>
15149 15185
              <value type="string" key="d9b5781e-a90b-11e2-8576-080027bcf912">name</value>
......
15262 15298
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
15263 15299
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
15264 15300
      <value type="string" key="caption">New Model</value>
15265
      <value type="string" key="dateChanged">2013-07-30 14:18</value>
15301
      <value type="string" key="dateChanged">2013-07-30 14:42</value>
15266 15302
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
15267 15303
      <value type="string" key="description"></value>
15268 15304
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
809 809
CREATE TABLE `specimen_observation` (
810 810
  `id` varbinary(767) NOT NULL,
811 811
  `specimen` varbinary(767) NOT NULL,
812
  `description` varbinary(767) DEFAULT NULL,
812 813
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
813 814
  PRIMARY KEY (`id`),
814 815
  KEY `fk_specimen_observation_specimen1_idx` (`specimen`),
......
1116 1117
/*!40101 SET character_set_client = utf8 */;
1117 1118
CREATE TABLE `taxon_presence` (
1118 1119
  `id` varbinary(767) NOT NULL,
1120
  `occurrence_status` varbinary(767) DEFAULT NULL,
1119 1121
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
1120 1122
  PRIMARY KEY (`id`),
1121 1123
  CONSTRAINT `fk_taxon_presence_taxon_determination1` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
schemas/VegCore/VegCore.pg.sql
811 811
CREATE TABLE "specimen_observation" (
812 812
  "id" text NOT NULL,
813 813
  "specimen" text NOT NULL,
814
  "description" text DEFAULT NULL,
814 815
  "traits" hstore DEFAULT NULL,
815 816
  PRIMARY KEY ("id"),
816 817
  /*KEY "fk_specimen_observation_specimen1_idx" ("specimen")*/CHECK (true),
......
1118 1119
/*!40101 SET character_set_client = utf8 */;
1119 1120
CREATE TABLE "taxon_presence" (
1120 1121
  "id" text NOT NULL,
1122
  "occurrence_status" text DEFAULT NULL,
1121 1123
  "traits" hstore DEFAULT NULL,
1122 1124
  PRIMARY KEY ("id"),
1123 1125
  /*CONSTRAINT "fk_taxon_presence_taxon_determination1" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)

Also available in: Unified diff