Project

General

Profile

« Previous | Next » 

Revision 10956

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon_occurrence: added within_place to allow easily locating all the taxon_occurrences in a plot. (some taxon_occurrences require within_place, but there was no common superclass field to allow joining to just a single table.)

View differences:

schemas/VegCore/VegCore.pg.sql
1286 1286 
/*!40101 SET character_set_client = utf8 */;
1287 1287 
CREATE TABLE "taxon_occurrence" (
1288 1288 
  "id" text NOT NULL,
1289 
  "within_place" text DEFAULT NULL,
1289 1290 
  "current_observation" text DEFAULT NULL,
1290 1291 
  PRIMARY KEY ("id"),
1291 1292 
  /*KEY "fk_taxon_occurrence_taxon_determination3_idx" ("current_observation")*/CHECK (true),
1293 
  /*KEY "fk_taxon_occurrence_place1_idx" ("within_place")*/CHECK (true),
1292 1294 
  /*CONSTRAINT "fk_taxon_occurrence_taxon_determination3" FOREIGN KEY ("current_observation") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1293 
  /*CONSTRAINT "fk_taxon_occurrence_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1295 
  /*CONSTRAINT "fk_taxon_occurrence_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1296 
  /*CONSTRAINT "fk_taxon_occurrence_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1294 1297 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1295 1298 
/*!40101 SET character_set_client = @saved_cs_client */;
1296 1299 

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





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


  		




  12332
  12332
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  12333
  12333
  
    
                    </value>


  		




  
  12334
  
    
                    <value type="object" struct-name="db.mysql.Column" id="09a29d14-1dd2-11e3-b98c-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12341
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




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


  		




  
  12343
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  
  12344
  
    
                      <value type="int" key="length">767</value>


  		




  
  12345
  
    
                      <value type="int" key="precision">-1</value>


  		




  
  12346
  
    
                      <value type="int" key="scale">-1</value>


  		




  
  12347
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>


  		




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


  		




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


  		




  
  12350
  
    
                      <value type="string" key="oldName">within_place</value>


  		




  
  12351
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  
  12352
  
    
                    </value>


  		




  12334
  12353
  
    
                    <value type="object" struct-name="db.mysql.Column" id="ab3ef6ae-1dc8-11e3-b98c-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




  ......




  12397
  12416
  
    
                      <value type="string" key="name">fk_taxon_occurrence_record1</value>


  		




  12398
  12417
  
    
                      <value type="string" key="oldName">fk_taxon_occurrence_record1</value>


  		




  12399
  12418
  
    
                    </value>


  		




  
  12419
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="09a29b5c-1dd2-11e3-b98c-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




  
  12422
  
    
                        <link type="object">09a29d14-1dd2-11e3-b98c-080027bcf912</link>


  		




  
  12423
  
    
                      </value>


  		




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


  		




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


  		




  
  12426
  
    
                      <link type="object" struct-name="db.Index" key="index">09a2b70e-1dd2-11e3-b98c-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  12430
  
    
                      <link type="object" struct-name="db.Table" key="owner">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




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


  		




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


  		




  
  12433
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




  
  12438
  
    
                      <value type="string" key="oldName">fk_taxon_occurrence_place1</value>


  		




  
  12439
  
    
                    </value>


  		




  12400
  12440
  
    
                  </value>


  		




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


  		




  12402
  12442
  
    
                    <value type="object" struct-name="db.mysql.Index" id="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca" struct-checksum="0x309b847a">


  		




  ......




  12445
  12485
  
    
                      <value type="string" key="oldName">fk_taxon_occurrence_taxon_determination3_idx</value>


  		




  12446
  12486
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  12447
  12487
  
    
                    </value>


  		




  
  12488
  
    
                    <value type="object" struct-name="db.mysql.Index" id="09a2b70e-1dd2-11e3-b98c-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  12490
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="09a2b8b2-1dd2-11e3-b98c-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  12494
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">09a29d14-1dd2-11e3-b98c-080027bcf912</link>


  		




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


  		




  
  12496
  
    
                          <link type="object" struct-name="GrtObject" key="owner">09a2b70e-1dd2-11e3-b98c-080027bcf912</link>


  		




  
  12497
  
    
                        </value>


  		




  
  12498
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  12508
  
    
                      <value type="string" key="oldName">fk_taxon_occurrence_place1_idx</value>


  		




  
  12509
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f9d23e32-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  
  12510
  
    
                    </value>


  		




  12448
  12511
  
    
                  </value>


  		




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


  		




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


  		




  ......




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


  		




  12477
  12540
  
    
                  <value type="string" key="createDate">2013-04-17 13:52</value>


  		




  12478
  12541
  
    
                  <value _ptr_="0xa6d61c0" type="dict" key="customData"/>


  		




  12479
  
  
    
                  <value type="string" key="lastChangeDate">2013-09-14 23:02</value>


  		




  
  12542
  
    
                  <value type="string" key="lastChangeDate">2013-09-14 23:44</value>


  		




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


  		




  12481
  12544
  
    
                  <value type="string" key="name">taxon_occurrence</value>


  		




  12482
  12545
  
    
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>


  		




  ......




  15290
  15353
  
    
                <value type="int" key="visible">1</value>


  		




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


  		




  15292
  15355
  
    
              </value>


  		




  
  15356
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="09a2bf1a-1dd2-11e3-b98c-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  15357
  
    
                <value type="string" key="caption">fk_taxon_occurrence_place1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  15363
  
    
                <value type="string" key="extraCaption"></value>


  		




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


  		




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


  		




  
  15366
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">09a29b5c-1dd2-11e3-b98c-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  15370
  
    
                <value type="int" key="drawSplit">1</value>


  		




  
  15371
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>


  		




  
  15372
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">f9d27532-1dc5-11e3-838b-410b6ef2c3ca</link>


  		




  
  15373
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  
  15374
  
    
                <value type="int" key="visible">1</value>


  		




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


  		




  
  15376
  
    
              </value>


  		




  15293
  15377
  
    
            </value>


  		




  15294
  15378
  
    
            <value type="string" key="description"></value>


  		




  15295
  15379
  
    
            <value _ptr_="0xa6dbf30" type="list" content-type="object" content-struct-name="model.Figure" key="figures">


  		




  ......




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


  		




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


  		




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


  		




  15525
  
  
    
                <value type="real" key="top">1.5e+01</value>


  		




  
  15609
  
    
                <value type="real" key="top">2.3e+01</value>


  		




  15526
  15610
  
    
                <value type="real" key="width">1.02e+02</value>


  		




  15527
  15611
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15528
  15612
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15662
  15746
  
    
                <value type="real" key="left">1.488e+03</value>


  		




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


  		




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


  		




  15665
  
  
    
                <value type="real" key="top">3.5e+01</value>


  		




  
  15749
  
    
                <value type="real" key="top">3.2e+01</value>


  		




  15666
  15750
  
    
                <value type="real" key="width">1.24e+02</value>


  		




  15667
  15751
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15668
  15752
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15702
  15786
  
    
                <value type="real" key="left">8.54e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  15706
  15790
  
    
                <value type="real" key="width">1.68e+02</value>


  		




  15707
  15791
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15708
  15792
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15742
  15826
  
    
                <value type="real" key="left">1.301e+03</value>


  		




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


  		




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


  		




  15745
  
  
    
                <value type="real" key="top">5.9e+01</value>


  		




  
  15829
  
    
                <value type="real" key="top">5.6e+01</value>


  		




  15746
  15830
  
    
                <value type="real" key="width">1.06e+02</value>


  		




  15747
  15831
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15748
  15832
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15762
  15846
  
    
                <value type="real" key="left">1.064e+03</value>


  		




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


  		




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


  		




  15765
  
  
    
                <value type="real" key="top">5.9e+01</value>


  		




  
  15849
  
    
                <value type="real" key="top">5.6e+01</value>


  		




  15766
  15850
  
    
                <value type="real" key="width">1.8e+02</value>


  		




  15767
  15851
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15768
  15852
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16308
  16392
  
    
                <value type="real" key="left">8.56e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  16312
  16396
  
    
                <value type="real" key="width">1.63e+02</value>


  		




  16313
  16397
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  16314
  16398
  
    
                <value type="int" key="visible">1</value>


  		




  ......




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


  		




  16859
  16943
  
    
                <value type="string" key="color">#FFFF00</value>


  		




  16860
  16944
  
    
                <value type="int" key="expanded">1</value>


  		




  16861
  
  
    
                <value type="real" key="height">7.7e+01</value>


  		




  
  16945
  
    
                <value type="real" key="height">1.e+02</value>


  		




  16862
  16946
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  16863
  16947
  
    
                <value type="real" key="left">8.5e+02</value>


  		




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


  		




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


  		




  16866
  
  
    
                <value type="real" key="top">3.4e+01</value>


  		




  
  16950
  
    
                <value type="real" key="top">2.6e+01</value>


  		




  16867
  16951
  
    
                <value type="real" key="width">1.53e+02</value>


  		




  16868
  16952
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  16869
  16953
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  17024
  17108
  
    
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>


  		




  17025
  17109
  
    
        <value _ptr_="0xa633848" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>


  		




  17026
  17110
  
    
        <value _ptr_="0x97750f0" type="dict" key="syncProfiles">


  		




  17027
  
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="914c15e8-1dcc-11e3-b98c-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  17028
  
  
    
            <value _ptr_="0xb37be80" type="dict" key="lastKnownDBNames">


  		




  
  17111
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="863491ac-1dd2-11e3-b98c-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  17112
  
    
            <value _ptr_="0xb30dcf0" type="dict" key="lastKnownDBNames">


  		




  17029
  17113
  
    
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>


  		




  17030
  17114
  
    
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>


  		




  17031
  17115
  
    
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>


  		




  ......




  17036
  17120
  
    
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>


  		




  17037
  17121
  
    
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>


  		




  17038
  17122
  
    
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>


  		




  
  17123
  
    
              <value type="string" key="09a29b5c-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1</value>


  		




  
  17124
  
    
              <value type="string" key="09a29d14-1dd2-11e3-b98c-080027bcf912">within_place</value>


  		




  
  17125
  
    
              <value type="string" key="09a2b70e-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1_idx</value>


  		




  17039
  17126
  
    
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>


  		




  17040
  17127
  
    
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>


  		




  17041
  17128
  
    
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>


  		




  ......




  17081
  17168
  
    
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>


  		




  17082
  17169
  
    
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>


  		




  17083
  17170
  
    
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>


  		




  17084
  
  
    
              <value type="string" key="18c810aa-0084-11e3-ac06-080027bcf912">fk_aggregate_observation_record1</value>


  		




  17085
  17171
  
    
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>


  		




  17086
  17172
  
    
              <value type="string" key="1b07bbcc-1dcb-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1_idx</value>


  		




  17087
  17173
  
    
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>


  		




  ......




  17154
  17240
  
    
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>


  		




  17155
  17241
  
    
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>


  		




  17156
  17242
  
    
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>


  		




  
  17243
  
    
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>


  		




  17157
  17244
  
    
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>


  		




  17158
  17245
  
    
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>


  		




  17159
  17246
  
    
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>


  		




  ......




  17638
  17725
  
    
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">


  		




  17639
  17726
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  17640
  17727
  
    
      <value type="string" key="caption">New Model</value>


  		




  17641
  
  
    
      <value type="string" key="dateChanged">2013-09-14 23:09</value>


  		




  
  17728
  
    
      <value type="string" key="dateChanged">2013-09-14 23:46</value>


  		




  17642
  17729
  
    
      <value type="string" key="dateCreated">2012-01-19 14:06</value>


  		




  17643
  17730
  
    
      <value type="string" key="description"></value>


  		




  17644
  17731
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  1284
  1284
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  1285
  1285
  
    
CREATE TABLE `taxon_occurrence` (


  		




  1286
  1286
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  1287
  
    
  `within_place` varbinary(767) DEFAULT NULL,


  		




  1287
  1288
  
    
  `current_observation` varbinary(767) DEFAULT NULL,


  		




  1288
  1289
  
    
  PRIMARY KEY (`id`),


  		




  1289
  1290
  
    
  KEY `fk_taxon_occurrence_taxon_determination3_idx` (`current_observation`),


  		




  
  1291
  
    
  KEY `fk_taxon_occurrence_place1_idx` (`within_place`),


  		




  1290
  1292
  
    
  CONSTRAINT `fk_taxon_occurrence_taxon_determination3` FOREIGN KEY (`current_observation`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




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


  		




  
  1293
  
    
  CONSTRAINT `fk_taxon_occurrence_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  1294
  
    
  CONSTRAINT `fk_taxon_occurrence_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




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


  		




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


  		




  1294
  1297
  
    

  		












Also available in:  Unified diff