Project

General

Profile

« Previous | Next » 

Revision 10490

Added by Aaron Marcuse-Kubitza over 11 years ago

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