Project

General

Profile

« Previous | Next » 

Revision 10634

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: aggregate_observation: changed relationship to taxon_presence to many:1 instead of 1:1 inheritance, because there can be multiple aggregate_observations (e.g. size classes) for each aggregated taxon. added optional size_class field to indicate the aggregating group.

View differences:

schemas/VegCore/VegCore.pg.sql
25 25 
/*!40101 SET character_set_client = utf8 */;
26 26 
CREATE TABLE "aggregate_observation" (
27 27 
  "id" text NOT NULL,
28 
  "taxon" text NOT NULL,
29 
  "size_class" text DEFAULT NULL,
28 30 
  "traits" hstore DEFAULT NULL,
29 31 
  PRIMARY KEY ("id"),
30 
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
32 
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon")*/CHECK (true),
33 
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),
34 
  /*CONSTRAINT "fk_aggregate_observation_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
35 
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
36 
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
31 37 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"An observation applying to all occurrences of an organism based on an aggregation factor" ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/aggregateOrganismObservations/aggregateOrganismObservation)'*/;
32 38 
/*!40101 SET character_set_client = @saved_cs_client */;
33 39 

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





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


  		




  2336
  2336
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  2337
  2337
  
    
                    </value>


  		




  
  2338
  
    
                    <value type="object" struct-name="db.mysql.Column" id="68bcc6ce-0083-11e3-ac06-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2346
  
    
                      <value _ptr_="0xbd4cdd0" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2353
  
    
                      <value type="string" key="name">taxon</value>


  		




  
  2354
  
    
                      <value type="string" key="oldName">taxon</value>


  		




  
  2355
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2356
  
    
                    </value>


  		




  
  2357
  
    
                    <value type="object" struct-name="db.mysql.Column" id="6c2bbbb2-0083-11e3-ac06-080027bcf912" struct-checksum="0x783b5183">


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2365
  
    
                      <value _ptr_="0xbb68d98" type="list" content-type="string" key="flags"/>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2372
  
    
                      <value type="string" key="name">size_class</value>


  		




  
  2373
  
    
                      <value type="string" key="oldName">size_class</value>


  		




  
  2374
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2375
  
    
                    </value>


  		




  2338
  2376
  
    
                    <value type="object" struct-name="db.mysql.Column" id="dc8d1c42-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">


  		




  2339
  2377
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  2340
  2378
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




  2360
  2398
  
    
                  <value type="string" key="defaultCollationName">utf8_bin</value>


  		




  2361
  2399
  
    
                  <value type="int" key="delayKeyWrite">0</value>


  		




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


  		




  2363
  
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="1cc7051e-f6be-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  2401
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="6c2bb9d2-0083-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  2402
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7afebdc8-0075-11e3-906b-080027bcf912</link>


  		




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


  		




  
  2404
  
    
                        <link type="object">6c2bbbb2-0083-11e3-ac06-080027bcf912</link>


  		




  
  2405
  
    
                      </value>


  		




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


  		




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


  		




  
  2408
  
    
                      <link type="object" struct-name="db.Index" key="index">6c2bd08e-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  
  2412
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




  
  2414
  
    
                        <link type="object">7afec156-0075-11e3-906b-080027bcf912</link>


  		




  
  2415
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  
  2419
  
    
                      <value type="string" key="name">fk_aggregate_observation_size_class1</value>


  		




  
  2420
  
    
                      <value type="string" key="oldName">fk_aggregate_observation_size_class1</value>


  		




  
  2421
  
    
                    </value>


  		




  
  2422
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="68bcc4bc-0083-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




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


  		




  
  2425
  
    
                        <link type="object">68bcc6ce-0083-11e3-ac06-080027bcf912</link>


  		




  2367
  2426
  
    
                      </value>


  		




  2368
  2427
  
    
                      <value type="int" key="deferability">0</value>


  		




  2369
  2428
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




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


  		




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


  		




  
  2429
  
    
                      <link type="object" struct-name="db.Index" key="index">68bcdca4-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




  2372
  2432
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  2373
  2433
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




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


  		




  2376
  2436
  
    
                      </value>


  		




  2377
  2437
  
    
                      <value type="int" key="referencedMandatory">1</value>


  		




  ......




  2380
  2440
  
    
                      <value type="string" key="name">fk_aggregate_observation_taxon_presence1</value>


  		




  2381
  2441
  
    
                      <value type="string" key="oldName">fk_aggregate_observation_taxon_presence1</value>


  		




  2382
  2442
  
    
                    </value>


  		




  
  2443
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="18c810aa-0084-11e3-ac06-080027bcf912" struct-checksum="0x70a8fc40">


  		




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


  		




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


  		




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


  		




  
  2447
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2453
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




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


  		




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


  		




  
  2456
  
    
                      </value>


  		




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


  		




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


  		




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


  		




  
  2460
  
    
                      <value type="string" key="name">fk_aggregate_observation_record1</value>


  		




  
  2461
  
    
                      <value type="string" key="oldName">fk_aggregate_observation_record1</value>


  		




  
  2462
  
    
                    </value>


  		




  2383
  2463
  
    
                  </value>


  		




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


  		




  2385
  2465
  
    
                    <value type="object" struct-name="db.mysql.Index" id="be8e9d90-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">


  		




  ......




  2405
  2485
  
    
                      <value type="string" key="oldName">PRIMARY</value>


  		




  2406
  2486
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  2407
  2487
  
    
                    </value>


  		




  
  2488
  
    
                    <value type="object" struct-name="db.mysql.Index" id="68bcdca4-0083-11e3-ac06-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  2490
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="68bcde3e-0083-11e3-ac06-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  2494
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">68bcc6ce-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  2496
  
    
                          <link type="object" struct-name="GrtObject" key="owner">68bcdca4-0083-11e3-ac06-080027bcf912</link>


  		




  
  2497
  
    
                        </value>


  		




  
  2498
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2506
  
    
                      <value type="string" key="name">fk_aggregate_observation_taxon_presence1_idx</value>


  		




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


  		




  
  2508
  
    
                      <value type="string" key="oldName">fk_aggregate_observation_taxon_presence1_idx</value>


  		




  
  2509
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2510
  
    
                    </value>


  		




  
  2511
  
    
                    <value type="object" struct-name="db.mysql.Index" id="6c2bd08e-0083-11e3-ac06-080027bcf912" struct-checksum="0x309b847a">


  		




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


  		




  
  2513
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6c2bd21e-0083-11e3-ac06-080027bcf912" struct-checksum="0x62630b3c">


  		




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


  		




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


  		




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


  		




  
  2517
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">6c2bbbb2-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




  
  2519
  
    
                          <link type="object" struct-name="GrtObject" key="owner">6c2bd08e-0083-11e3-ac06-080027bcf912</link>


  		




  
  2520
  
    
                        </value>


  		




  
  2521
  
    
                      </value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  2529
  
    
                      <value type="string" key="name">fk_aggregate_observation_size_class1_idx</value>


  		




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


  		




  
  2531
  
    
                      <value type="string" key="oldName">fk_aggregate_observation_size_class1_idx</value>


  		




  
  2532
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  2533
  
    
                    </value>


  		




  2408
  2534
  
    
                  </value>


  		




  2409
  2535
  
    
                  <value type="string" key="maxRows"></value>


  		




  2410
  2536
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  ......




  2436
  2562
  
    
                  <value type="int" key="commentedOut">0</value>


  		




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


  		




  2438
  2564
  
    
                  <value _ptr_="0xb0c0a68" type="dict" key="customData"/>


  		




  2439
  
  
    
                  <value type="string" key="lastChangeDate">2013-04-24 14:33</value>


  		




  
  2565
  
    
                  <value type="string" key="lastChangeDate">2013-08-08 16:40</value>


  		




  2440
  2566
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  2441
  2567
  
    
                  <value type="string" key="name">aggregate_observation</value>


  		




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


  		




  ......




  13147
  13273
  
    
                <value type="int" key="visible">1</value>


  		




  13148
  13274
  
    
                <value type="string" key="name"></value>


  		




  13149
  13275
  
    
              </value>


  		




  13150
  
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="1cc826ba-f6be-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">


  		




  13151
  
  
    
                <value type="string" key="caption">fk_aggregate_observation_taxon_presence1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13160
  
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1cc7051e-f6be-11e2-af44-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  13166
  
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>


  		




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


  		




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


  		




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


  		




  13170
  
  
    
              </value>


  		




  13171
  13276
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="7f181abc-f6c0-11e2-af44-080027bcf912" struct-checksum="0x9baebc92">


  		




  13172
  13277
  
    
                <value type="string" key="caption">fk_project_event10</value>


  		




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


  		




  ......




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


  		




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


  		




  13832
  13937
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7afec93a-0075-11e3-906b-080027bcf912</link>


  		




  13833
  
  
    
                <value type="real" key="middleSegmentOffset">-7.20001140741236440590000711381435394287109375e+01</value>


  		




  
  13938
  
    
                <value type="real" key="middleSegmentOffset">-6.93079377800839893097872845828533172607421875e+01</value>


  		




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


  		




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


  		




  13836
  13941
  
    
                <value type="int" key="drawSplit">0</value>


  		




  ......




  13861
  13966
  
    
                <value type="int" key="visible">1</value>


  		




  13862
  13967
  
    
                <value type="string" key="name"></value>


  		




  13863
  13968
  
    
              </value>


  		




  
  13969
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="68bce4e2-0083-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  13970
  
    
                <value type="string" key="caption">fk_aggregate_observation_taxon_presence1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  13979
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">68bcc4bc-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  13985
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>


  		




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


  		




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


  		




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


  		




  
  13989
  
    
              </value>


  		




  
  13990
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="6c2bd886-0083-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  13991
  
    
                <value type="string" key="caption">fk_aggregate_observation_size_class1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14000
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6c2bb9d2-0083-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




  
  14005
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">7afee050-0075-11e3-906b-080027bcf912</link>


  		




  
  14006
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>


  		




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


  		




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


  		




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


  		




  
  14010
  
    
              </value>


  		




  
  14011
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="18c831ca-0084-11e3-ac06-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  14012
  
    
                <value type="string" key="caption">fk_aggregate_observation_record1</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  
  14021
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">18c810aa-0084-11e3-ac06-080027bcf912</link>


  		




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


  		




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


  		




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


  		




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


  		




  
  14026
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>


  		




  
  14027
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>


  		




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


  		




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


  		




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


  		




  
  14031
  
    
              </value>


  		




  13864
  14032
  
    
            </value>


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14173
  
  
    
                <value type="real" key="left">1.29e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14193
  
  
    
                <value type="real" key="left">8.82e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14213
  
  
    
                <value type="real" key="left">1.059e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14253
  
  
    
                <value type="real" key="left">1.013e+03</value>


  		




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


  		




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


  		




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


  		




  14256
  
  
    
                <value type="real" key="top">6.43e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




  14288
  14456
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  14293
  
  
    
                <value type="real" key="left">1.18e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14934
  
  
    
                <value type="real" key="left">1.057e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14949
  
  
    
                <value type="real" key="left">1.027e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14979
  
  
    
                <value type="real" key="left">1.047e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  14994
  
  
    
                <value type="real" key="left">1.203e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  15009
  
  
    
                <value type="real" key="left">1.467e+03</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  15024
  
  
    
                <value type="real" key="left">9.59e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




  15096
  15264
  
    
                <value type="int" key="expanded">1</value>


  		




  15097
  15265
  
    
                <value type="real" key="height">5.4e+01</value>


  		




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


  		




  15099
  
  
    
                <value type="real" key="left">9.86e+02</value>


  		




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


  		




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


  		




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


  		




  15102
  
  
    
                <value type="real" key="top">7.84e+02</value>


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  15518
  
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="b59bec78-0082-11e3-ac06-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  15519
  
  
    
            <value _ptr_="0xbe1a988" type="dict" key="lastKnownDBNames">


  		




  
  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">


  		




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


  		




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


  		




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


  		




  ......




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


  		




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


  		




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


  		




  15575
  
  
    
              <value type="string" key="1cc7051e-f6be-11e2-af44-080027bcf912">fk_aggregate_observation_taxon_presence1</value>


  		




  15576
  15743
  
    
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>


  		




  15577
  15744
  
    
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>


  		




  15578
  15745
  
    
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>


  		




  ......




  15710
  15877
  
    
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>


  		




  15711
  15878
  
    
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>


  		




  15712
  15879
  
    
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>


  		




  
  15880
  
    
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>


  		




  
  15881
  
    
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">taxon</value>


  		




  
  15882
  
    
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>


  		




  15713
  15883
  
    
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>


  		




  15714
  15884
  
    
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>


  		




  15715
  15885
  
    
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>


  		




  15716
  15886
  
    
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>


  		




  15717
  15887
  
    
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>


  		




  
  15888
  
    
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>


  		




  
  15889
  
    
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>


  		




  
  15890
  
    
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>


  		




  15718
  15891
  
    
              <value type="string" key="6ec4a89c-ad05-11e2-b309-080027bcf912">fk_specimen_individual1</value>


  		




  15719
  15892
  
    
              <value type="string" key="6ec4aa86-ad05-11e2-b309-080027bcf912">individual</value>


  		




  15720
  15893
  
    
              <value type="string" key="6ec4c2fa-ad05-11e2-b309-080027bcf912">fk_specimen_individual1_idx</value>


  		




  ......




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


  		




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


  		




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


  		




  16083
  
  
    
      <value type="string" key="dateChanged">2013-08-08 16:32</value>


  		




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


  		




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


  		




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


  		




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


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





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


  		




  24
  24
  
    
CREATE TABLE `aggregate_observation` (


  		




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


  		




  
  26
  
    
  `taxon` varbinary(767) NOT NULL,


  		




  
  27
  
    
  `size_class` varbinary(767) DEFAULT NULL,


  		




  26
  28
  
    
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  27
  29
  
    
  PRIMARY KEY (`id`),


  		




  28
  
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`id`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  30
  
    
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`taxon`),


  		




  
  31
  
    
  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),


  		




  
  32
  
    
  CONSTRAINT `fk_aggregate_observation_record1` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  33
  
    
  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  34
  
    
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  29
  35
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"An observation applying to all occurrences of an organism based on an aggregation factor" ("VegX":http://wiki.tdwg.org/twiki/pub/Vegetation/WebHome/VegX_Schema_1.5.3_proposed.zip#/veg.xsd#/aggregateOrganismObservations/aggregateOrganismObservation)';


  		




  30
  36
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  31
  37
  
    

  		












Also available in:  Unified diff