Project

General

Profile

« Previous | Next » 

Revision 10635

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: added reobservable_presence, which allows a vouchered taxon_presence (e.g. a set of aggregate_observations) to have taxon redeterminations

View differences:

schemas/VegCore/VegCore.pg.sql
720 720 
/*!40000 ALTER TABLE "reobservable" ENABLE KEYS */;
721 721 

  		




  722
  722
  
    
--


  		




  
  723
  
    
-- Table structure for table "reobservable_presence"


  		




  
  724
  
    
--


  		




  
  725
  
    

  		




  
  726
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  
  728
  
    
CREATE TABLE "reobservable_presence" (


  		




  
  729
  
    
  "id" text NOT NULL,


  		




  
  730
  
    
  "voucher" text NOT NULL,


  		




  
  731
  
    
  PRIMARY KEY ("id"),


  		




  
  732
  
    
  /*KEY "fk_reobservable_presence_specimen1_idx" ("voucher")*/CHECK (true),


  		




  
  733
  
    
  /*CONSTRAINT "fk_reobservable_presence_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  734
  
    
  /*CONSTRAINT "fk_reobservable_presence_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  735
  
    
  /*CONSTRAINT "fk_reobservable_presence_reobservable1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  736
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  
  737
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  738
  
    

  		




  
  739
  
    
--


  		




  
  740
  
    
-- Dumping data for table "reobservable_presence"


  		




  
  741
  
    
--


  		




  
  742
  
    

  		




  
  743
  
    
/*!40000 ALTER TABLE "reobservable_presence" DISABLE KEYS */;


  		




  
  744
  
    
/*!40000 ALTER TABLE "reobservable_presence" ENABLE KEYS */;


  		




  
  745
  
    

  		




  
  746
  
    
--


  		




  723
  747
  
    
-- Table structure for table "size_class"


  		




  724
  748
  
    
--


  		




  725
  749
  
    

  		




  ......




  1182
  1206
  
    
  "id" text NOT NULL,


  		




  1183
  1207
  
    
  "collectors" text DEFAULT NULL,


  		




  1184
  1208
  
    
  "collector_number" text DEFAULT NULL,


  		




  1185
  
  
    
  "voucher" text DEFAULT NULL,


  		




  1186
  1209
  
    
  "growth_form" text DEFAULT NULL,


  		




  1187
  1210
  
    
  "cultivated" integer DEFAULT NULL,


  		




  1188
  1211
  
    
  "traits" hstore DEFAULT NULL,


  		




  1189
  1212
  
    
  PRIMARY KEY ("id"),


  		




  1190
  
  
    
  /*KEY "fk_taxon_observation_specimen1_idx" ("voucher")*/CHECK (true),


  		




  1191
  1213
  
    
  /*KEY "fk_taxon_observation_party_list1_idx" ("collectors")*/CHECK (true),


  		




  1192
  1214
  
    
  /*CONSTRAINT "fk_taxon_observation_party_list1" FOREIGN KEY ("collectors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1193
  
  
    
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1194
  
  
    
  /*CONSTRAINT "fk_taxon_observation_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1215
  
    
  /*CONSTRAINT "fk_taxon_observation_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1195
  1216
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  1196
  1217
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1197
  1218
  
    

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  3297
  3297
  
    
                      <value type="string" key="oldName">collector_number</value>


  		




  3298
  3298
  
    
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>


  		




  3299
  3299
  
    
                    </value>


  		




  3300
  
  
    
                    <value type="object" struct-name="db.mysql.Column" id="3730d234-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  3308
  
  
    
                      <value _ptr_="0xb0cd7e8" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  3315
  
  
    
                      <value type="string" key="name">voucher</value>


  		




  3316
  
  
    
                      <value type="string" key="oldName">voucher</value>


  		




  3317
  
  
    
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>


  		




  3318
  
  
    
                    </value>


  		




  3319
  3300
  
    
                    <value type="object" struct-name="db.mysql.Column" id="16538808-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x783b5183">


  		




  3320
  3301
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  3321
  3302
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




  3420
  3401
  
    
                      <value type="string" key="name">fk_taxon_observation_sampling_event1</value>


  		




  3421
  3402
  
    
                      <value type="string" key="oldName">fk_taxon_observation_sampling_event1</value>


  		




  3422
  3403
  
    
                    </value>


  		




  3423
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="565fd9e8-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




  3426
  
  
    
                        <link type="object">3730d234-a7ab-11e2-8ba6-080027bcf912</link>


  		




  3427
  
  
    
                      </value>


  		




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


  		




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


  		




  3430
  
  
    
                      <link type="object" struct-name="db.Index" key="index">565fe000-a7ab-11e2-8ba6-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  3434
  
  
    
                      <link type="object" struct-name="db.Table" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>


  		




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


  		




  3436
  
  
    
                        <link type="object">c672fb6c-a7a0-11e2-b667-080027bcf912</link>


  		




  3437
  
  
    
                      </value>


  		




  3438
  
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




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


  		




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


  		




  3441
  
  
    
                      <value type="string" key="name">fk_taxon_observation_specimen1</value>


  		




  3442
  
  
    
                      <value type="string" key="oldName">fk_taxon_observation_specimen1</value>


  		




  3443
  
  
    
                    </value>


  		




  3444
  3404
  
    
                  </value>


  		




  3445
  3405
  
    
                  <value _ptr_="0xb0cc3e8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">


  		




  3446
  3406
  
    
                    <value type="object" struct-name="db.mysql.Index" id="165395c8-a7a7-11e2-8ba6-080027bcf912" struct-checksum="0x309b847a">


  		




  ......




  3466
  3426
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




  3467
  3427
  
    
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>


  		




  3468
  3428
  
    
                    </value>


  		




  3469
  
  
    
                    <value type="object" struct-name="db.mysql.Index" id="565fe000-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  3471
  
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="56600bf2-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  3475
  
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">3730d234-a7ab-11e2-8ba6-080027bcf912</link>


  		




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


  		




  3477
  
  
    
                          <link type="object" struct-name="GrtObject" key="owner">565fe000-a7ab-11e2-8ba6-080027bcf912</link>


  		




  3478
  
  
    
                        </value>


  		




  3479
  
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  3487
  
  
    
                      <value type="string" key="name">fk_taxon_observation_specimen1_idx</value>


  		




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


  		




  3489
  
  
    
                      <value type="string" key="oldName">fk_taxon_observation_specimen1_idx</value>


  		




  3490
  
  
    
                      <link type="object" struct-name="GrtObject" key="owner">16537a20-a7a7-11e2-8ba6-080027bcf912</link>


  		




  3491
  
  
    
                    </value>


  		




  3492
  3429
  
    
                    <value type="object" struct-name="db.mysql.Index" id="21b41366-f680-11e2-aebb-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  3494
  3431
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="21b447e6-f680-11e2-aebb-080027bcf912" struct-checksum="0x62630b3c">


  		




  ......




  11496
  11433
  
    
                  <value type="string" key="comment"></value>


  		




  11497
  11434
  
    
                  <value type="string" key="oldName">size_class</value>


  		




  11498
  11435
  
    
                </value>


  		




  
  11436
  
    
                <value type="object" struct-name="db.mysql.Table" id="f903388e-0084-11e3-ac06-080027bcf912" struct-checksum="0x1a403946">


  		




  
  11437
  
    
                  <value type="string" key="avgRowLength"></value>


  		




  
  11438
  
    
                  <value type="int" key="checksum">0</value>


  		




  
  11439
  
    
                  <value _ptr_="0xc00ee10" type="list" content-type="object" content-struct-name="db.mysql.Column" key="columns">


  		




  
  11440
  
    
                    <value type="object" struct-name="db.mysql.Column" id="f9033c9e-0084-11e3-ac06-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11447
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  
  11448
  
    
                      <value _ptr_="0xbbc1228" type="list" content-type="string" key="flags"/>


  		




  
  11449
  
    
                      <value type="int" key="isNotNull">1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11455
  
    
                      <value type="string" key="name">id</value>


  		




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


  		




  
  11457
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11458
  
    
                    </value>


  		




  
  11459
  
    
                    <value type="object" struct-name="db.mysql.Column" id="f903400e-0084-11e3-ac06-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11466
  
    
                      <value type="int" key="defaultValueIsNull">0</value>


  		




  
  11467
  
    
                      <value _ptr_="0xbd1ab48" type="list" content-type="string" key="flags"/>


  		




  
  11468
  
    
                      <value type="int" key="isNotNull">1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11474
  
    
                      <value type="string" key="name">voucher</value>


  		




  
  11475
  
    
                      <value type="string" key="oldName">occurrence_status</value>


  		




  
  11476
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11477
  
    
                    </value>


  		




  
  11478
  
    
                  </value>


  		




  
  11479
  
    
                  <value type="string" key="connectionString"></value>


  		




  
  11480
  
    
                  <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  
  11481
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  
  11482
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




  
  11483
  
    
                  <value _ptr_="0xc187ea8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">


  		




  
  11484
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="293dc5b4-0085-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  11485
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8ea786-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




  
  11487
  
    
                        <link type="object">f9033c9e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11488
  
    
                      </value>


  		




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


  		




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


  		




  
  11491
  
    
                      <value type="int" key="mandatory">0</value>


  		




  
  11492
  
    
                      <value type="int" key="many">0</value>


  		




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


  		




  
  11494
  
    
                      <link type="object" struct-name="db.Table" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  11496
  
    
                        <link type="object">be8eaa06-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  11497
  
    
                      </value>


  		




  
  11498
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




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


  		




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


  		




  
  11501
  
    
                      <value type="string" key="name">fk_reobservable_presence_taxon_presence1</value>


  		




  
  11502
  
    
                      <value type="string" key="oldName">fk_reobservable_presence_taxon_presence1</value>


  		




  
  11503
  
    
                    </value>


  		




  
  11504
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7627a20a-0085-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




  
  11507
  
    
                        <link type="object">f903400e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11508
  
    
                      </value>


  		




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


  		




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


  		




  
  11511
  
    
                      <link type="object" struct-name="db.Index" key="index">7627b66e-0085-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  11515
  
    
                      <link type="object" struct-name="db.Table" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  11517
  
    
                        <link type="object">c672fb6c-a7a0-11e2-b667-080027bcf912</link>


  		




  
  11518
  
    
                      </value>


  		




  
  11519
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




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


  		




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


  		




  
  11522
  
    
                      <value type="string" key="name">fk_reobservable_presence_specimen1</value>


  		




  
  11523
  
    
                      <value type="string" key="oldName">fk_reobservable_presence_specimen1</value>


  		




  
  11524
  
    
                    </value>


  		




  
  11525
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="b3ac613c-0086-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




  
  11528
  
    
                        <link type="object">f9033c9e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11529
  
    
                      </value>


  		




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


  		




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


  		




  
  11532
  
    
                      <value type="int" key="mandatory">0</value>


  		




  
  11533
  
    
                      <value type="int" key="many">0</value>


  		




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


  		




  
  11535
  
    
                      <link type="object" struct-name="db.Table" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  11537
  
    
                        <link type="object">c672abda-a7a0-11e2-b667-080027bcf912</link>


  		




  
  11538
  
    
                      </value>


  		




  
  11539
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




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


  		




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


  		




  
  11542
  
    
                      <value type="string" key="name">fk_reobservable_presence_reobservable1</value>


  		




  
  11543
  
    
                      <value type="string" key="oldName">fk_reobservable_presence_reobservable1</value>


  		




  
  11544
  
    
                    </value>


  		




  
  11545
  
    
                  </value>


  		




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


  		




  
  11547
  
    
                    <value type="object" struct-name="db.mysql.Index" id="f903472a-0084-11e3-ac06-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  11549
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="f903486a-0084-11e3-ac06-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  11553
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">f9033c9e-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  11555
  
    
                          <link type="object" struct-name="GrtObject" key="owner">f903472a-0084-11e3-ac06-080027bcf912</link>


  		




  
  11556
  
    
                        </value>


  		




  
  11557
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11563
  
    
                      <value type="string" key="indexType">PRIMARY</value>


  		




  
  11564
  
    
                      <value type="int" key="isPrimary">1</value>


  		




  
  11565
  
    
                      <value type="string" key="name">PRIMARY</value>


  		




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


  		




  
  11567
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




  
  11568
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11569
  
    
                    </value>


  		




  
  11570
  
    
                    <value type="object" struct-name="db.mysql.Index" id="7627b66e-0085-11e3-ac06-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  11572
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="7627e7e2-0085-11e3-ac06-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  11576
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">f903400e-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  11578
  
    
                          <link type="object" struct-name="GrtObject" key="owner">7627b66e-0085-11e3-ac06-080027bcf912</link>


  		




  
  11579
  
    
                        </value>


  		




  
  11580
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  11588
  
    
                      <value type="string" key="name">fk_reobservable_presence_specimen1_idx</value>


  		




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


  		




  
  11590
  
    
                      <value type="string" key="oldName">fk_reobservable_presence_specimen1</value>


  		




  
  11591
  
    
                      <link type="object" struct-name="GrtObject" key="owner">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




  
  11592
  
    
                    </value>


  		




  
  11593
  
    
                  </value>


  		




  
  11594
  
    
                  <value type="string" key="maxRows"></value>


  		




  
  11595
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  
  11596
  
    
                  <value type="string" key="mergeUnion"></value>


  		




  
  11597
  
    
                  <value type="string" key="minRows"></value>


  		




  
  11598
  
    
                  <value type="string" key="nextAutoInc"></value>


  		




  
  11599
  
    
                  <value type="string" key="packKeys"></value>


  		




  
  11600
  
    
                  <value type="int" key="partitionCount">0</value>


  		




  
  11601
  
    
                  <value _ptr_="0xc19e398" type="list" content-type="object" content-struct-name="db.mysql.PartitionDefinition" key="partitionDefinitions"/>


  		




  
  11602
  
    
                  <value type="string" key="partitionExpression"></value>


  		




  
  11603
  
    
                  <value type="string" key="partitionType"></value>


  		




  
  11604
  
    
                  <value type="string" key="password"></value>


  		




  
  11605
  
    
                  <link type="object" struct-name="db.mysql.Index" key="primaryKey">f903472a-0084-11e3-ac06-080027bcf912</link>


  		




  
  11606
  
    
                  <value type="string" key="raidChunkSize"></value>


  		




  
  11607
  
    
                  <value type="string" key="raidChunks"></value>


  		




  
  11608
  
    
                  <value type="string" key="raidType"></value>


  		




  
  11609
  
    
                  <value type="string" key="rowFormat"></value>


  		




  
  11610
  
    
                  <value type="int" key="subpartitionCount">0</value>


  		




  
  11611
  
    
                  <value type="string" key="subpartitionExpression"></value>


  		




  
  11612
  
    
                  <value type="string" key="subpartitionType"></value>


  		




  
  11613
  
    
                  <value type="string" key="tableDataDir"></value>


  		




  
  11614
  
    
                  <value type="string" key="tableEngine">InnoDB</value>


  		




  
  11615
  
    
                  <value type="string" key="tableIndexDir"></value>


  		




  
  11616
  
    
                  <value _ptr_="0xbd04ef8" type="list" content-type="object" content-struct-name="db.mysql.Trigger" key="triggers"/>


  		




  
  11617
  
    
                  <value type="int" key="isStub">0</value>


  		




  
  11618
  
    
                  <value type="int" key="isSystem">0</value>


  		




  
  11619
  
    
                  <value type="int" key="isTemporary">0</value>


  		




  
  11620
  
    
                  <value type="string" key="temporaryScope"></value>


  		




  
  11621
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  
  11622
  
    
                  <value type="string" key="createDate">2013-04-16 14:58</value>


  		




  
  11623
  
    
                  <value _ptr_="0xbc65c48" type="dict" key="customData"/>


  		




  
  11624
  
    
                  <value type="string" key="lastChangeDate">2013-08-08 16:56</value>


  		




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


  		




  
  11626
  
    
                  <value type="string" key="name">reobservable_presence</value>


  		




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


  		




  
  11628
  
    
                  <value type="string" key="temp_sql"></value>


  		




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


  		




  
  11630
  
    
                  <value type="string" key="oldName"></value>


  		




  
  11631
  
    
                </value>


  		




  11499
  11632
  
    
              </value>


  		




  11500
  11633
  
    
              <value _ptr_="0xb0afb48" type="list" content-type="object" content-struct-name="db.mysql.View" key="views"/>


  		




  11501
  11634
  
    
              <value type="string" key="defaultCharacterSetName">utf8</value>


  		




  ......




  12706
  12839
  
    
                <value type="int" key="visible">1</value>


  		




  12707
  12840
  
    
                <value type="string" key="name"></value>


  		




  12708
  12841
  
    
              </value>


  		




  12709
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="5660493c-a7ab-11e2-8ba6-080027bcf912" struct-checksum="0x9baebc92">


  		




  12710
  
  
    
                <value type="string" key="caption">fk_taxon_observation_specimen1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  12719
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">565fd9e8-a7ab-11e2-8ba6-080027bcf912</link>


  		




  12720
  
  
    
                <value type="real" key="middleSegmentOffset">3.05e+01</value>


  		




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


  		




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


  		




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


  		




  12724
  
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>


  		




  12725
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  12729
  
  
    
              </value>


  		




  12730
  12842
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="44e3a7e0-a7b4-11e2-97d7-080027bcf912" struct-checksum="0x9baebc92">


  		




  12731
  12843
  
    
                <value type="string" key="caption">fk_specimen_observation_specimen1</value>


  		




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


  		




  ......




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


  		




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


  		




  13538
  13650
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d2081100-f959-11e2-8597-080027bcf912</link>


  		




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


  		




  
  13651
  
    
                <value type="real" key="middleSegmentOffset">-7.830631616688742724363692104816436767578125e+01</value>


  		




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


  		




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


  		




  13542
  13654
  
    
                <value type="int" key="drawSplit">0</value>


  		




  ......




  14029
  14141
  
    
                <value type="int" key="visible">1</value>


  		




  14030
  14142
  
    
                <value type="string" key="name"></value>


  		




  14031
  14143
  
    
              </value>


  		




  
  14144
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="293ddb6c-0085-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  14145
  
    
                <value type="string" key="caption">fk_reobservable_presence_taxon_presence1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14154
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">293dc5b4-0085-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  14158
  
    
                <value type="int" key="drawSplit">0</value>


  		




  
  14159
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">83F9DA1B-026F-4852-892A-55EF8BD52280</link>


  		




  
  14160
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">f9035ca6-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  14164
  
    
              </value>


  		




  
  14165
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="76283256-0085-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  14166
  
    
                <value type="string" key="caption">fk_reobservable_presence_specimen1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14175
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7627a20a-0085-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  14179
  
    
                <value type="int" key="drawSplit">0</value>


  		




  
  14180
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>


  		




  
  14181
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">f9035ca6-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  14185
  
    
              </value>


  		




  
  14186
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="b3ac7898-0086-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  14187
  
    
                <value type="string" key="caption">fk_reobservable_presence_reobservable1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14196
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">b3ac613c-0086-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




  
  14201
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">1CE42D82-5AE5-4C01-A503-85E84F7B01D3</link>


  		




  
  14202
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">f9035ca6-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  14206
  
    
              </value>


  		




  14032
  14207
  
    
            </value>


  		




  14033
  14208
  
    
            <value type="string" key="description"></value>


  		




  14034
  14209
  
    
            <value _ptr_="0xb148400" type="list" content-type="object" content-struct-name="model.Figure" key="figures">


  		




  ......




  14338
  14513
  
    
                <value type="int" key="expanded">1</value>


  		




  14339
  14514
  
    
                <value type="real" key="height">1.23e+02</value>


  		




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


  		




  14341
  
  
    
                <value type="real" key="left">1.306e+03</value>


  		




  
  14516
  
    
                <value type="real" key="left">1.328e+03</value>


  		




  14342
  14517
  
    
                <value type="int" key="locked">0</value>


  		




  14343
  14518
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14344
  
  
    
                <value type="real" key="top">1.106e+03</value>


  		




  
  14519
  
    
                <value type="real" key="top">1.107e+03</value>


  		




  14345
  14520
  
    
                <value type="real" key="width">1.44e+02</value>


  		




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


  		




  14347
  14522
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14358
  14533
  
    
                <value type="int" key="expanded">1</value>


  		




  14359
  14534
  
    
                <value type="real" key="height">1.46e+02</value>


  		




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


  		




  14361
  
  
    
                <value type="real" key="left">8.96e+02</value>


  		




  
  14536
  
    
                <value type="real" key="left">9.24e+02</value>


  		




  14362
  14537
  
    
                <value type="int" key="locked">0</value>


  		




  14363
  14538
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14364
  
  
    
                <value type="real" key="top">9.19e+02</value>


  		




  
  14539
  
    
                <value type="real" key="top">9.22e+02</value>


  		




  14365
  14540
  
    
                <value type="real" key="width">1.42e+02</value>


  		




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


  		




  14367
  14542
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14378
  14553
  
    
                <value type="int" key="expanded">1</value>


  		




  14379
  14554
  
    
                <value type="real" key="height">1.69e+02</value>


  		




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


  		




  14381
  
  
    
                <value type="real" key="left">1.075e+03</value>


  		




  
  14556
  
    
                <value type="real" key="left">1.087e+03</value>


  		




  14382
  14557
  
    
                <value type="int" key="locked">0</value>


  		




  14383
  14558
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14384
  
  
    
                <value type="real" key="top">1.103e+03</value>


  		




  
  14559
  
    
                <value type="real" key="top">1.104e+03</value>


  		




  14385
  14560
  
    
                <value type="real" key="width">1.41e+02</value>


  		




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


  		




  14387
  14562
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14418
  14593
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  14421
  
  
    
                <value type="real" key="left">9.81e+02</value>


  		




  
  14596
  
    
                <value type="real" key="left">1.255e+03</value>


  		




  14422
  14597
  
    
                <value type="int" key="locked">0</value>


  		




  14423
  14598
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14424
  
  
    
                <value type="real" key="top">6.5e+02</value>


  		




  
  14599
  
    
                <value type="real" key="top">6.09e+02</value>


  		




  14425
  14600
  
    
                <value type="real" key="width">1.41e+02</value>


  		




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


  		




  14427
  14602
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14441
  14616
  
    
                <value type="real" key="left">9.11e+02</value>


  		




  14442
  14617
  
    
                <value type="int" key="locked">0</value>


  		




  14443
  14618
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14444
  
  
    
                <value type="real" key="top">4.95e+02</value>


  		




  
  14619
  
    
                <value type="real" key="top">5.14e+02</value>


  		




  14445
  14620
  
    
                <value type="real" key="width">1.68e+02</value>


  		




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


  		




  14447
  14622
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14458
  14633
  
    
                <value type="int" key="expanded">1</value>


  		




  14459
  14634
  
    
                <value type="real" key="height">1.23e+02</value>


  		




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


  		




  14461
  
  
    
                <value type="real" key="left">1.163e+03</value>


  		




  
  14636
  
    
                <value type="real" key="left">1.026e+03</value>


  		




  14462
  14637
  
    
                <value type="int" key="locked">0</value>


  		




  14463
  14638
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14464
  
  
    
                <value type="real" key="top">6.73e+02</value>


  		




  
  14639
  
    
                <value type="real" key="top">6.69e+02</value>


  		




  14465
  14640
  
    
                <value type="real" key="width">1.82e+02</value>


  		




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


  		




  14467
  14642
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14578
  14753
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  14581
  
  
    
                <value type="real" key="left">1.479e+03</value>


  		




  
  14756
  
    
                <value type="real" key="left">1.499e+03</value>


  		




  14582
  14757
  
    
                <value type="int" key="locked">0</value>


  		




  14583
  14758
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14584
  
  
    
                <value type="real" key="top">5.88e+02</value>


  		




  
  14759
  
    
                <value type="real" key="top">5.81e+02</value>


  		




  14585
  14760
  
    
                <value type="real" key="width">1.06e+02</value>


  		




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


  		




  14587
  14762
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  14598
  14773
  
    
                <value type="int" key="expanded">1</value>


  		




  14599
  14774
  
    
                <value type="real" key="height">1.23e+02</value>


  		




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


  		




  14601
  
  
    
                <value type="real" key="left">1.33e+02</value>


  		




  
  14776
  
    
                <value type="real" key="left">1.27e+02</value>


  		




  14602
  14777
  
    
                <value type="int" key="locked">0</value>


  		




  14603
  14778
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14604
  14779
  
    
                <value type="real" key="top">7.21e+02</value>


  		




  ......




  14964
  15139
  
    
                <value type="int" key="expanded">1</value>


  		




  14965
  15140
  
    
                <value type="real" key="height">5.4e+01</value>


  		




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


  		




  14967
  
  
    
                <value type="real" key="left">1.085e+03</value>


  		




  
  15142
  
    
                <value type="real" key="left">1.097e+03</value>


  		




  14968
  15143
  
    
                <value type="int" key="locked">0</value>


  		




  14969
  15144
  
    
                <value type="int" key="manualSizing">0</value>


  		




  14970
  
  
    
                <value type="real" key="top">9.9e+02</value>


  		




  
  15145
  
    
                <value type="real" key="top">9.98e+02</value>


  		




  14971
  15146
  
    
                <value type="real" key="width">1.22e+02</value>


  		




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


  		




  14973
  15148
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15004
  15179
  
    
                <value type="int" key="expanded">1</value>


  		




  15005
  15180
  
    
                <value type="real" key="height">2.15e+02</value>


  		




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


  		




  15007
  
  
    
                <value type="real" key="left">1.358e+03</value>


  		




  
  15182
  
    
                <value type="real" key="left">1.34e+03</value>


  		




  15008
  15183
  
    
                <value type="int" key="locked">0</value>


  		




  15009
  15184
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15010
  
  
    
                <value type="real" key="top">8.55e+02</value>


  		




  
  15185
  
    
                <value type="real" key="top">8.63e+02</value>


  		




  15011
  15186
  
    
                <value type="real" key="width">1.2e+02</value>


  		




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


  		




  15013
  15188
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15024
  15199
  
    
                <value type="int" key="expanded">1</value>


  		




  15025
  15200
  
    
                <value type="real" key="height">1.46e+02</value>


  		




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


  		




  15027
  
  
    
                <value type="real" key="left">1.494e+03</value>


  		




  
  15202
  
    
                <value type="real" key="left">1.491e+03</value>


  		




  15028
  15203
  
    
                <value type="int" key="locked">0</value>


  		




  15029
  15204
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15030
  
  
    
                <value type="real" key="top">9.9e+02</value>


  		




  
  15205
  
    
                <value type="real" key="top">8.98e+02</value>


  		




  15031
  15206
  
    
                <value type="real" key="width">1.14e+02</value>


  		




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


  		




  15033
  15208
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15042
  15217
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  15043
  15218
  
    
                <value type="string" key="color">#FFFF00</value>


  		




  15044
  15219
  
    
                <value type="int" key="expanded">1</value>


  		




  15045
  
  
    
                <value type="real" key="height">1.92e+02</value>


  		




  
  15220
  
    
                <value type="real" key="height">1.69e+02</value>


  		




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


  		




  15047
  15222
  
    
                <value type="real" key="left">8.49e+02</value>


  		




  15048
  15223
  
    
                <value type="int" key="locked">0</value>


  		




  15049
  15224
  
    
                <value type="int" key="manualSizing">0</value>


  		




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


  		




  
  15225
  
    
                <value type="real" key="top">1.67e+02</value>


  		




  15051
  15226
  
    
                <value type="real" key="width">1.56e+02</value>


  		




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


  		




  15053
  15228
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15067
  15242
  
    
                <value type="real" key="left">1.259e+03</value>


  		




  15068
  15243
  
    
                <value type="int" key="locked">0</value>


  		




  15069
  15244
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15070
  
  
    
                <value type="real" key="top">4.8e+02</value>


  		




  
  15245
  
    
                <value type="real" key="top">4.67e+02</value>


  		




  15071
  15246
  
    
                <value type="real" key="width">1.8e+02</value>


  		




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


  		




  15073
  15248
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15099
  15274
  
    
                <value type="int" key="expanded">1</value>


  		




  15100
  15275
  
    
                <value type="real" key="height">2.7e+01</value>


  		




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


  		




  15102
  
  
    
                <value type="real" key="left">1.071e+03</value>


  		




  
  15277
  
    
                <value type="real" key="left">1.099e+03</value>


  		




  15103
  15278
  
    
                <value type="int" key="locked">0</value>


  		




  15104
  15279
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15105
  
  
    
                <value type="real" key="top">8.89e+02</value>


  		




  
  15280
  
    
                <value type="real" key="top">8.92e+02</value>


  		




  15106
  15281
  
    
                <value type="real" key="width">2.02e+02</value>


  		




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


  		




  15108
  15283
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15114
  15289
  
    
                <value type="int" key="expanded">1</value>


  		




  15115
  15290
  
    
                <value type="real" key="height">2.5e+01</value>


  		




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


  		




  15117
  
  
    
                <value type="real" key="left">1.041e+03</value>


  		




  
  15292
  
    
                <value type="real" key="left">1.069e+03</value>


  		




  15118
  15293
  
    
                <value type="int" key="locked">0</value>


  		




  15119
  15294
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15120
  
  
    
                <value type="real" key="top">9.39e+02</value>


  		




  
  15295
  
    
                <value type="real" key="top">9.42e+02</value>


  		




  15121
  15296
  
    
                <value type="real" key="width">9.1e+01</value>


  		




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


  		




  15123
  15298
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15129
  15304
  
    
                <value type="int" key="expanded">1</value>


  		




  15130
  15305
  
    
                <value type="real" key="height">2.5e+01</value>


  		




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


  		




  15132
  
  
    
                <value type="real" key="left">1.244e+03</value>


  		




  
  15307
  
    
                <value type="real" key="left">1.226e+03</value>


  		




  15133
  15308
  
    
                <value type="int" key="locked">0</value>


  		




  15134
  15309
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15135
  
  
    
                <value type="real" key="top">1.023e+03</value>


  		




  
  15310
  
    
                <value type="real" key="top">1.031e+03</value>


  		




  15136
  15311
  
    
                <value type="real" key="width">1.09e+02</value>


  		




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


  		




  15138
  15313
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15144
  15319
  
    
                <value type="int" key="expanded">1</value>


  		




  15145
  15320
  
    
                <value type="real" key="height">2.7e+01</value>


  		




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


  		




  15147
  
  
    
                <value type="real" key="left">1.063e+03</value>


  		




  
  15322
  
    
                <value type="real" key="left">1.075e+03</value>


  		




  15148
  15323
  
    
                <value type="int" key="locked">0</value>


  		




  15149
  15324
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15150
  
  
    
                <value type="real" key="top">1.049e+03</value>


  		




  
  15325
  
    
                <value type="real" key="top">1.057e+03</value>


  		




  15151
  15326
  
    
                <value type="real" key="width">7.7e+01</value>


  		




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


  		




  15153
  15328
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15159
  15334
  
    
                <value type="int" key="expanded">1</value>


  		




  15160
  15335
  
    
                <value type="real" key="height">2.5e+01</value>


  		




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


  		




  15162
  
  
    
                <value type="real" key="left">1.219e+03</value>


  		




  
  15337
  
    
                <value type="real" key="left">1.231e+03</value>


  		




  15163
  15338
  
    
                <value type="int" key="locked">0</value>


  		




  15164
  15339
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15165
  
  
    
                <value type="real" key="top">1.194e+03</value>


  		




  
  15340
  
    
                <value type="real" key="top">1.195e+03</value>


  		




  15166
  15341
  
    
                <value type="real" key="width">8.3e+01</value>


  		




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


  		




  15168
  15343
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15174
  15349
  
    
                <value type="int" key="expanded">1</value>


  		




  15175
  15350
  
    
                <value type="real" key="height">2.7e+01</value>


  		




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


  		




  15177
  
  
    
                <value type="real" key="left">1.483e+03</value>


  		




  
  15352
  
    
                <value type="real" key="left">1.505e+03</value>


  		




  15178
  15353
  
    
                <value type="int" key="locked">0</value>


  		




  15179
  15354
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15180
  
  
    
                <value type="real" key="top">1.179e+03</value>


  		




  
  15355
  
    
                <value type="real" key="top">1.18e+03</value>


  		




  15181
  15356
  
    
                <value type="real" key="width">8.6e+01</value>


  		




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


  		




  15183
  15358
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15189
  15364
  
    
                <value type="int" key="expanded">1</value>


  		




  15190
  15365
  
    
                <value type="real" key="height">2.5e+01</value>


  		




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


  		




  15192
  
  
    
                <value type="real" key="left">9.73e+02</value>


  		




  
  15367
  
    
                <value type="real" key="left">1.001e+03</value>


  		




  15193
  15368
  
    
                <value type="int" key="locked">0</value>


  		




  15194
  15369
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15195
  
  
    
                <value type="real" key="top">8.9e+02</value>


  		




  
  15370
  
    
                <value type="real" key="top">8.93e+02</value>


  		




  15196
  15371
  
    
                <value type="real" key="width">9.3e+01</value>


  		




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


  		




  15198
  15373
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15267
  15442
  
    
                <value type="real" key="left">1.1e+03</value>


  		




  15268
  15443
  
    
                <value type="int" key="locked">0</value>


  		




  15269
  15444
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15270
  
  
    
                <value type="real" key="top">5.71e+02</value>


  		




  
  15445
  
    
                <value type="real" key="top">5.8e+02</value>


  		




  15271
  15446
  
    
                <value type="real" key="width">1.36e+02</value>


  		




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


  		




  15273
  15448
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  15380
  15555
  
    
                <value type="int" key="expanded">1</value>


  		




  15381
  15556
  
    
                <value type="real" key="height">2.7e+01</value>


  		




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


  		




  15383
  
  
    
                <value type="real" key="left">2.38e+02</value>


  		




  
  15558
  
    
                <value type="real" key="left">2.37e+02</value>


  		




  15384
  15559
  
    
                <value type="int" key="locked">0</value>


  		




  15385
  15560
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15386
  15561
  
    
                <value type="real" key="top">1.e+01</value>


  		




  ......




  15523
  15698
  
    
                <value type="int" key="expanded">1</value>


  		




  15524
  15699
  
    
                <value type="real" key="height">1.23e+02</value>


  		




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


  		




  15526
  
  
    
                <value type="real" key="left">8.39e+02</value>


  		




  
  15701
  
    
                <value type="real" key="left">8.6e+02</value>


  		




  15527
  15702
  
    
                <value type="int" key="locked">0</value>


  		




  15528
  15703
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15529
  
  
    
                <value type="real" key="top">7.04e+02</value>


  		




  
  15704
  
    
                <value type="real" key="top">6.89e+02</value>


  		




  15530
  15705
  
    
                <value type="real" key="width">1.09e+02</value>


  		




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


  		




  15532
  15707
  
    
                <value type="int" key="visible">1</value>


  		




  15533
  15708
  
    
                <value type="string" key="name">size_class</value>


  		




  15534
  15709
  
    
              </value>


  		




  
  15710
  
    
              <value type="object" struct-name="workbench.physical.TableFigure" id="f9035ca6-0084-11e3-ac06-080027bcf912" struct-checksum="0x3b14eccb">


  		




  
  15711
  
    
                <value type="int" key="columnsExpanded">1</value>


  		




  
  15712
  
    
                <value type="int" key="foreignKeysExpanded">0</value>


  		




  
  15713
  
    
                <value type="int" key="indicesExpanded">0</value>


  		




  
  15714
  
    
                <value type="int" key="summarizeDisplay">-1</value>


  		




  
  15715
  
    
                <link type="object" struct-name="db.Table" key="table">f903388e-0084-11e3-ac06-080027bcf912</link>


  		




  
  15716
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




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


  		




  
  15718
  
    
                <value type="int" key="expanded">1</value>


  		




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


  		




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


  		




  
  15721
  
    
                <value type="real" key="left">1.393e+03</value>


  		




  
  15722
  
    
                <value type="int" key="locked">0</value>


  		




  
  15723
  
    
                <value type="int" key="manualSizing">0</value>


  		




  
  15724
  
    
                <value type="real" key="top">7.5e+02</value>


  		




  
  15725
  
    
                <value type="real" key="width">1.84e+02</value>


  		




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


  		




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


  		




  
  15728
  
    
                <value type="string" key="name">reobservable_presence</value>


  		




  
  15729
  
    
              </value>


  		




  15535
  15730
  
    
            </value>


  		




  15536
  15731
  
    
            <value type="real" key="height">1.2865e+03</value>


  		




  15537
  15732
  
    
            <value _ptr_="0xb148450" type="list" content-type="object" content-struct-name="model.Layer" key="layers">


  		




  ......




  15656
  15851
  
    
                <link type="object">853604e4-006c-11e3-895c-080027bcf912</link>


  		




  15657
  15852
  
    
                <link type="object">23ec6436-0075-11e3-906b-080027bcf912</link>


  		




  15658
  15853
  
    
                <link type="object">7afee050-0075-11e3-906b-080027bcf912</link>


  		




  
  15854
  
    
                <link type="object">f9035ca6-0084-11e3-ac06-080027bcf912</link>


  		




  15659
  15855
  
    
              </value>


  		




  15660
  15856
  
    
              <value _ptr_="0xb18d7b8" type="list" content-type="object" content-struct-name="model.Group" key="groups"/>


  		




  15661
  15857
  
    
              <value type="real" key="height">1.2865e+03</value>


  		




  ......




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


  		




  15684
  15880
  
    
        <value _ptr_="0xb0ae9c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>


  		




  15685
  15881
  
    
        <value _ptr_="0xa79b4b0" type="dict" key="syncProfiles">


  		




  15686
  
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="01d9ea80-0084-11e3-ac06-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  15687
  
  
    
            <value _ptr_="0xc46f2d8" type="dict" key="lastKnownDBNames">


  		




  
  15882
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="458985ec-0084-11e3-ac06-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  15883
  
    
            <value _ptr_="0xc2da8e8" type="dict" key="lastKnownDBNames">


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  15742
  15939
  
    
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>


  		




  ......




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


  		




  16254
  16451
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  16255
  16452
  
    
      <value type="string" key="caption">New Model</value>


  		




  16256
  
  
    
      <value type="string" key="dateChanged">2013-08-08 16:42</value>


  		




  
  16453
  
    
      <value type="string" key="dateChanged">2013-08-08 17:03</value>


  		




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


  		




  16258
  16455
  
    
      <value type="string" key="description"></value>


  		




  16259
  16456
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  718
  718
  
    
/*!40000 ALTER TABLE `reobservable` ENABLE KEYS */;


  		




  719
  719
  
    

  		




  720
  720
  
    
--


  		




  
  721
  
    
-- Table structure for table `reobservable_presence`


  		




  
  722
  
    
--


  		




  
  723
  
    

  		




  
  724
  
    
/*!40101 SET @saved_cs_client     = @@character_set_client */;


  		




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


  		




  
  726
  
    
CREATE TABLE `reobservable_presence` (


  		




  
  727
  
    
  `id` varbinary(767) NOT NULL,


  		




  
  728
  
    
  `voucher` varbinary(767) NOT NULL,


  		




  
  729
  
    
  PRIMARY KEY (`id`),


  		




  
  730
  
    
  KEY `fk_reobservable_presence_specimen1_idx` (`voucher`),


  		




  
  731
  
    
  CONSTRAINT `fk_reobservable_presence_taxon_presence1` FOREIGN KEY (`id`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  732
  
    
  CONSTRAINT `fk_reobservable_presence_specimen1` FOREIGN KEY (`voucher`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  733
  
    
  CONSTRAINT `fk_reobservable_presence_reobservable1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  734
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  
  735
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  
  736
  
    

  		




  
  737
  
    
--


  		




  
  738
  
    
-- Dumping data for table `reobservable_presence`


  		




  
  739
  
    
--


  		




  
  740
  
    

  		




  
  741
  
    
/*!40000 ALTER TABLE `reobservable_presence` DISABLE KEYS */;


  		




  
  742
  
    
/*!40000 ALTER TABLE `reobservable_presence` ENABLE KEYS */;


  		




  
  743
  
    

  		




  
  744
  
    
--


  		




  721
  745
  
    
-- Table structure for table `size_class`


  		




  722
  746
  
    
--


  		




  723
  747
  
    

  		




  ......




  1180
  1204
  
    
  `id` varbinary(767) NOT NULL,


  		




  1181
  1205
  
    
  `collectors` varbinary(767) DEFAULT NULL,


  		




  1182
  1206
  
    
  `collector_number` varbinary(767) DEFAULT NULL,


  		




  1183
  
  
    
  `voucher` varbinary(767) DEFAULT NULL,


  		




  1184
  1207
  
    
  `growth_form` varbinary(767) DEFAULT NULL,


  		




  1185
  1208
  
    
  `cultivated` tinyint(1) DEFAULT NULL,


  		




  1186
  1209
  
    
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  1187
  1210
  
    
  PRIMARY KEY (`id`),


  		




  1188
  
  
    
  KEY `fk_taxon_observation_specimen1_idx` (`voucher`),


  		




  1189
  1211
  
    
  KEY `fk_taxon_observation_party_list1_idx` (`collectors`),


  		




  1190
  1212
  
    
  CONSTRAINT `fk_taxon_observation_party_list1` FOREIGN KEY (`collectors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1191
  
  
    
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  1192
  
  
    
  CONSTRAINT `fk_taxon_observation_specimen1` FOREIGN KEY (`voucher`) REFERENCES `specimen` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1213
  
    
  CONSTRAINT `fk_taxon_observation_sampling_event1` FOREIGN KEY (`id`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  1193
  1214
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


  		




  1194
  1215
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1195
  1216
  
    

  		












Also available in:  Unified diff