Project

General

Profile

« Previous | Next » 

Revision 11204

schemas/VegCore/ERD/VegCore.ERD.mwb: record.authors: moved to traceable because actually, different sections of a denormalized source record may have separate authors (e.g. participants for taxa_sampling_event, identifiers for taxon_determination)

View differences:

schemas/VegCore/ERD/document.mwb.xml
1357 1357
                      <value type="string" key="oldName">id_within_source</value>
1358 1358
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1359 1359
                    </value>
1360
                    <value type="object" struct-name="db.mysql.Column" id="84258ee2-3129-11e3-ac9d-080027bcf912" struct-checksum="0x783b5183">
1361
                      <value type="int" key="autoIncrement">0</value>
1362
                      <value type="string" key="characterSetName"></value>
1363
                      <value _ptr_="0xbd5a4e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1364
                      <value type="string" key="collationName"></value>
1365
                      <value type="string" key="datatypeExplicitParams"></value>
1366
                      <value type="string" key="defaultValue"></value>
1367
                      <value type="int" key="defaultValueIsNull">1</value>
1368
                      <value _ptr_="0xbc51bd0" type="list" content-type="string" key="flags"/>
1369
                      <value type="int" key="isNotNull">0</value>
1370
                      <value type="int" key="length">767</value>
1371
                      <value type="int" key="precision">-1</value>
1372
                      <value type="int" key="scale">-1</value>
1373
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1374
                      <value type="string" key="comment">the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author</value>
1375
                      <value type="string" key="name">authors</value>
1376
                      <value type="string" key="oldName">authors</value>
1377
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1378
                    </value>
1360 1379
                  </value>
1361 1380
                  <value type="string" key="connectionString"></value>
1362 1381
                  <value type="string" key="defaultCharacterSetName">utf8</value>
1363 1382
                  <value type="string" key="defaultCollationName">utf8_bin</value>
1364 1383
                  <value type="int" key="delayKeyWrite">0</value>
1365 1384
                  <value _ptr_="0xaeb5498" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
1385
                    <value type="object" struct-name="db.mysql.ForeignKey" id="84258cd0-3129-11e3-ac9d-080027bcf912" struct-checksum="0x70a8fc40">
1386
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
1387
                      <value _ptr_="0xc1dcbb0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1388
                        <link type="object">84258ee2-3129-11e3-ac9d-080027bcf912</link>
1389
                      </value>
1390
                      <value type="int" key="deferability">0</value>
1391
                      <value type="string" key="deleteRule">CASCADE</value>
1392
                      <link type="object" struct-name="db.Index" key="index">8425b926-3129-11e3-ac9d-080027bcf912</link>
1393
                      <value type="int" key="mandatory">1</value>
1394
                      <value type="int" key="many">1</value>
1395
                      <value type="int" key="modelOnly">0</value>
1396
                      <link type="object" struct-name="db.Table" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1397
                      <value _ptr_="0xc0dc7c8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1398
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
1399
                      </value>
1400
                      <value type="int" key="referencedMandatory">0</value>
1401
                      <value type="string" key="updateRule">CASCADE</value>
1402
                      <value type="string" key="comment"></value>
1403
                      <value type="string" key="name">traceable_id_fkey1</value>
1404
                      <value type="string" key="oldName">traceable_id_fkey1</value>
1405
                    </value>
1366 1406
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8ce0b8-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
1367 1407
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
1368 1408
                      <value _ptr_="0xa309e48" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
1462 1502
                      <value type="string" key="oldName">traceable__id_by_source</value>
1463 1503
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1464 1504
                    </value>
1505
                    <value type="object" struct-name="db.mysql.Index" id="8425b926-3129-11e3-ac9d-080027bcf912" struct-checksum="0x309b847a">
1506
                      <value _ptr_="0xbc205e0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1507
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8425bb9c-3129-11e3-ac9d-080027bcf912" struct-checksum="0x62630b3c">
1508
                          <value type="int" key="columnLength">0</value>
1509
                          <value type="string" key="comment"></value>
1510
                          <value type="int" key="descend">0</value>
1511
                          <link type="object" struct-name="db.Column" key="referencedColumn">84258ee2-3129-11e3-ac9d-080027bcf912</link>
1512
                          <value type="string" key="name"></value>
1513
                          <link type="object" struct-name="GrtObject" key="owner">8425b926-3129-11e3-ac9d-080027bcf912</link>
1514
                        </value>
1515
                      </value>
1516
                      <value type="string" key="indexKind"></value>
1517
                      <value type="int" key="keyBlockSize">0</value>
1518
                      <value type="string" key="withParser"></value>
1519
                      <value type="string" key="comment"></value>
1520
                      <value type="int" key="deferability">0</value>
1521
                      <value type="string" key="indexType">INDEX</value>
1522
                      <value type="int" key="isPrimary">0</value>
1523
                      <value type="string" key="name">traceable_id_fkey1_idx</value>
1524
                      <value type="int" key="unique">0</value>
1525
                      <value type="string" key="oldName">traceable_id_fkey1_idx</value>
1526
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1527
                    </value>
1465 1528
                  </value>
1466 1529
                  <value type="string" key="maxRows"></value>
1467 1530
                  <value type="string" key="mergeInsert"></value>
......
1493 1556
                  <value type="int" key="commentedOut">0</value>
1494 1557
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1495 1558
                  <value _ptr_="0xaeb7578" type="dict" key="customData"/>
1496
                  <value type="string" key="lastChangeDate">2013-09-30 01:57</value>
1559
                  <value type="string" key="lastChangeDate">2013-10-09 14:27</value>
1497 1560
                  <value type="int" key="modelOnly">0</value>
1498 1561
                  <value type="string" key="name">traceable</value>
1499 1562
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12304 12367
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12305 12368
                      <value type="string" key="comment">the dataset that scopes the id_within_dataset</value>
12306 12369
                      <value type="string" key="name">scoping_dataset</value>
12307
                      <value type="string" key="oldName">dataset</value>
12370
                      <value type="string" key="oldName">scoping_dataset</value>
12308 12371
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12309 12372
                    </value>
12310 12373
                    <value type="object" struct-name="db.mysql.Column" id="0de3ab06-1dec-11e3-b571-080027bcf912" struct-checksum="0x783b5183">
......
12342 12405
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12343 12406
                      <value type="string" key="comment">the dataset that provides attribution information. defaults to the scoping_dataset.</value>
12344 12407
                      <value type="string" key="name">attribution_dataset</value>
12345
                      <value type="string" key="oldName">dataset1</value>
12408
                      <value type="string" key="oldName">attribution_dataset</value>
12346 12409
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12347 12410
                    </value>
12348
                    <value type="object" struct-name="db.mysql.Column" id="0b8634b0-3114-11e3-995a-080027bcf912" struct-checksum="0x783b5183">
12349
                      <value type="int" key="autoIncrement">0</value>
12350
                      <value type="string" key="characterSetName"></value>
12351
                      <value _ptr_="0xaf59f78" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12352
                      <value type="string" key="collationName"></value>
12353
                      <value type="string" key="datatypeExplicitParams"></value>
12354
                      <value type="string" key="defaultValue"></value>
12355
                      <value type="int" key="defaultValueIsNull">1</value>
12356
                      <value _ptr_="0xaf5a2f8" type="list" content-type="string" key="flags"/>
12357
                      <value type="int" key="isNotNull">0</value>
12358
                      <value type="int" key="length">767</value>
12359
                      <value type="int" key="precision">-1</value>
12360
                      <value type="int" key="scale">-1</value>
12361
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12362
                      <value type="string" key="comment">the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author</value>
12363
                      <value type="string" key="name">authors</value>
12364
                      <value type="string" key="oldName">authors</value>
12365
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12366
                    </value>
12367 12411
                  </value>
12368 12412
                  <value type="string" key="connectionString"></value>
12369 12413
                  <value type="string" key="defaultCharacterSetName">utf8</value>
12370 12414
                  <value type="string" key="defaultCollationName">utf8_bin</value>
12371 12415
                  <value type="int" key="delayKeyWrite">0</value>
12372 12416
                  <value _ptr_="0xaf58ea8" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
12373
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0b8632a8-3114-11e3-995a-080027bcf912" struct-checksum="0x70a8fc40">
12374
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
12375
                      <value _ptr_="0xaf5a470" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12376
                        <link type="object">0b8634b0-3114-11e3-995a-080027bcf912</link>
12377
                      </value>
12378
                      <value type="int" key="deferability">0</value>
12379
                      <value type="string" key="deleteRule">CASCADE</value>
12380
                      <link type="object" struct-name="db.Index" key="index">0b871dbc-3114-11e3-995a-080027bcf912</link>
12381
                      <value type="int" key="mandatory">1</value>
12382
                      <value type="int" key="many">1</value>
12383
                      <value type="int" key="modelOnly">0</value>
12384
                      <link type="object" struct-name="db.Table" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12385
                      <value _ptr_="0xaf5a7d8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12386
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
12387
                      </value>
12388
                      <value type="int" key="referencedMandatory">0</value>
12389
                      <value type="string" key="updateRule">CASCADE</value>
12390
                      <value type="string" key="comment"></value>
12391
                      <value type="string" key="name">record_id_fkey1</value>
12392
                      <value type="string" key="oldName">record_id_fkey1</value>
12393
                    </value>
12394 12417
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0de3afc0-1dec-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">
12395 12418
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
12396 12419
                      <value _ptr_="0xaf5a848" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
12532 12555
                      <value type="string" key="oldName">fk_record_source1_idx</value>
12533 12556
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12534 12557
                    </value>
12535
                    <value type="object" struct-name="db.mysql.Index" id="0b871dbc-3114-11e3-995a-080027bcf912" struct-checksum="0x309b847a">
12536
                      <value _ptr_="0xaf5c530" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12537
                        <value type="object" struct-name="db.mysql.IndexColumn" id="0b87550c-3114-11e3-995a-080027bcf912" struct-checksum="0x62630b3c">
12538
                          <value type="int" key="columnLength">0</value>
12539
                          <value type="string" key="comment"></value>
12540
                          <value type="int" key="descend">0</value>
12541
                          <link type="object" struct-name="db.Column" key="referencedColumn">0b8634b0-3114-11e3-995a-080027bcf912</link>
12542
                          <value type="string" key="name"></value>
12543
                          <link type="object" struct-name="GrtObject" key="owner">0b871dbc-3114-11e3-995a-080027bcf912</link>
12544
                        </value>
12545
                      </value>
12546
                      <value type="string" key="indexKind"></value>
12547
                      <value type="int" key="keyBlockSize">0</value>
12548
                      <value type="string" key="withParser"></value>
12549
                      <value type="string" key="comment"></value>
12550
                      <value type="int" key="deferability">0</value>
12551
                      <value type="string" key="indexType">INDEX</value>
12552
                      <value type="int" key="isPrimary">0</value>
12553
                      <value type="string" key="name">record_id_fkey1_idx</value>
12554
                      <value type="int" key="unique">0</value>
12555
                      <value type="string" key="oldName">record_id_fkey1_idx</value>
12556
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12557
                    </value>
12558 12558
                    <value type="object" struct-name="db.mysql.Index" id="801b49d2-3128-11e3-ac9d-080027bcf912" struct-checksum="0x309b847a">
12559 12559
                      <value _ptr_="0xb722878" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12560 12560
                        <value type="object" struct-name="db.mysql.IndexColumn" id="801b7a88-3128-11e3-ac9d-080027bcf912" struct-checksum="0x62630b3c">
......
12575 12575
                      <value type="int" key="isPrimary">0</value>
12576 12576
                      <value type="string" key="name">record_id_fkey2_idx</value>
12577 12577
                      <value type="int" key="unique">0</value>
12578
                      <value type="string" key="oldName">record_id_fkey2</value>
12578
                      <value type="string" key="oldName">record_id_fkey2_idx</value>
12579 12579
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
12580 12580
                    </value>
12581 12581
                  </value>
......
12609 12609
                  <value type="int" key="commentedOut">0</value>
12610 12610
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12611 12611
                  <value _ptr_="0xaf58c80" type="dict" key="customData"/>
12612
                  <value type="string" key="lastChangeDate">2013-10-09 14:22</value>
12612
                  <value type="string" key="lastChangeDate">2013-10-09 14:27</value>
12613 12613
                  <value type="int" key="modelOnly">0</value>
12614 12614
                  <value type="string" key="name">record</value>
12615 12615
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15691 15691
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15692 15692
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15693 15693
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6a2c268a-1dfc-11e3-bbb6-080027bcf912</link>
15694
                <value type="real" key="middleSegmentOffset">-5.84551245782887463064980693161487579345703125e+00</value>
15694
                <value type="real" key="middleSegmentOffset">-3.691640769210835060221143066883087158203125e+00</value>
15695 15695
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15696 15696
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15697 15697
                <value type="int" key="drawSplit">0</value>
......
16037 16037
                <value type="int" key="visible">1</value>
16038 16038
                <value type="string" key="name"></value>
16039 16039
              </value>
16040
              <value type="object" struct-name="workbench.physical.Connection" id="0b878e64-3114-11e3-995a-080027bcf912" struct-checksum="0x9baebc92">
16041
                <value type="string" key="caption">record_id_fkey1</value>
16042
                <value type="real" key="captionXOffs">0.e+00</value>
16043
                <value type="real" key="captionYOffs">0.e+00</value>
16044
                <value type="string" key="comment"></value>
16045
                <value type="real" key="endCaptionXOffs">0.e+00</value>
16046
                <value type="real" key="endCaptionYOffs">0.e+00</value>
16047
                <value type="string" key="extraCaption"></value>
16048
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
16049
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
16050
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">0b8632a8-3114-11e3-995a-080027bcf912</link>
16051
                <value type="real" key="middleSegmentOffset">-2.23074902867347191204316914081573486328125e+00</value>
16052
                <value type="real" key="startCaptionXOffs">0.e+00</value>
16053
                <value type="real" key="startCaptionYOffs">0.e+00</value>
16054
                <value type="int" key="drawSplit">0</value>
16055
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
16056
                <link type="object" struct-name="model.Figure" key="startFigure">0de3d5b8-1dec-11e3-b571-080027bcf912</link>
16057
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16058
                <value type="int" key="visible">1</value>
16059
                <value type="string" key="name"></value>
16060
              </value>
16061 16040
              <value type="object" struct-name="workbench.physical.Connection" id="12c15f48-3119-11e3-995a-080027bcf912" struct-checksum="0x9baebc92">
16062 16041
                <value type="string" key="caption">dataset_dataset_source_fkey1</value>
16063 16042
                <value type="real" key="captionXOffs">0.e+00</value>
......
16121 16100
                <value type="int" key="visible">1</value>
16122 16101
                <value type="string" key="name"></value>
16123 16102
              </value>
16103
              <value type="object" struct-name="workbench.physical.Connection" id="8425c434-3129-11e3-ac9d-080027bcf912" struct-checksum="0x9baebc92">
16104
                <value type="string" key="caption">traceable_id_fkey1</value>
16105
                <value type="real" key="captionXOffs">0.e+00</value>
16106
                <value type="real" key="captionYOffs">0.e+00</value>
16107
                <value type="string" key="comment"></value>
16108
                <value type="real" key="endCaptionXOffs">0.e+00</value>
16109
                <value type="real" key="endCaptionYOffs">0.e+00</value>
16110
                <value type="string" key="extraCaption"></value>
16111
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
16112
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
16113
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">84258cd0-3129-11e3-ac9d-080027bcf912</link>
16114
                <value type="real" key="middleSegmentOffset">0.e+00</value>
16115
                <value type="real" key="startCaptionXOffs">0.e+00</value>
16116
                <value type="real" key="startCaptionYOffs">0.e+00</value>
16117
                <value type="int" key="drawSplit">1</value>
16118
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
16119
                <link type="object" struct-name="model.Figure" key="startFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
16120
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16121
                <value type="int" key="visible">1</value>
16122
                <value type="string" key="name"></value>
16123
              </value>
16124 16124
            </value>
16125 16125
            <value type="string" key="description"></value>
16126 16126
            <value _ptr_="0xaf69480" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
16153 16153
                <value type="real" key="left">4.2e+01</value>
16154 16154
                <value type="int" key="locked">0</value>
16155 16155
                <value type="int" key="manualSizing">0</value>
16156
                <value type="real" key="top">7.03e+02</value>
16156
                <value type="real" key="top">7.11e+02</value>
16157 16157
                <value type="real" key="width">9.7e+01</value>
16158 16158
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16159 16159
                <value type="int" key="visible">1</value>
......
16168 16168
                <value type="int" key="triggersExpanded">0</value>
16169 16169
                <value type="string" key="color">#99ccff</value>
16170 16170
                <value type="int" key="expanded">1</value>
16171
                <value type="real" key="height">1.23e+02</value>
16171
                <value type="real" key="height">1.46e+02</value>
16172 16172
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16173 16173
                <value type="real" key="left">1.49e+02</value>
16174 16174
                <value type="int" key="locked">0</value>
16175 16175
                <value type="int" key="manualSizing">0</value>
16176
                <value type="real" key="top">5.17e+02</value>
16176
                <value type="real" key="top">5.14e+02</value>
16177 16177
                <value type="real" key="width">1.03e+02</value>
16178 16178
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16179 16179
                <value type="int" key="visible">1</value>
......
17669 17669
                <value type="int" key="triggersExpanded">0</value>
17670 17670
                <value type="string" key="color">#99ccff</value>
17671 17671
                <value type="int" key="expanded">1</value>
17672
                <value type="real" key="height">1.46e+02</value>
17672
                <value type="real" key="height">1.23e+02</value>
17673 17673
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17674 17674
                <value type="real" key="left">1.82e+02</value>
17675 17675
                <value type="int" key="locked">0</value>
17676 17676
                <value type="int" key="manualSizing">0</value>
17677
                <value type="real" key="top">6.73e+02</value>
17677
                <value type="real" key="top">6.98e+02</value>
17678 17678
                <value type="real" key="width">1.12e+02</value>
17679 17679
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17680 17680
                <value type="int" key="visible">1</value>
......
17694 17694
                <value type="real" key="left">2.3e+01</value>
17695 17695
                <value type="int" key="locked">0</value>
17696 17696
                <value type="int" key="manualSizing">0</value>
17697
                <value type="real" key="top">5.38e+02</value>
17697
                <value type="real" key="top">5.46e+02</value>
17698 17698
                <value type="real" key="width">8.9e+01</value>
17699 17699
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17700 17700
                <value type="int" key="visible">1</value>
......
17884 17884
              <value type="int" key="visible">1</value>
17885 17885
              <value type="string" key="name"></value>
17886 17886
            </value>
17887
            <value _ptr_="0xaf69558" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17888
              <link type="object">40021096-f678-11e2-9716-080027bcf912</link>
17889
            </value>
17887
            <value _ptr_="0xaf69558" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17890 17888
            <value type="int" key="updateBlocked">0</value>
17891 17889
            <value type="real" key="width">1.6215e+03</value>
17892 17890
            <value type="real" key="x">0.e+00</value>
......
17898 17896
        <value _ptr_="0xaeb8480" type="list" content-type="object" content-struct-name="GrtStoredNote" key="notes"/>
17899 17897
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17900 17898
        <value _ptr_="0xaeb84b0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17901
        <value _ptr_="0xa305f10" type="dict" key="syncProfiles"/>
17899
        <value _ptr_="0xa305f10" type="dict" key="syncProfiles">
17900
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ebc4676c-3129-11e3-ac9d-080027bcf912" struct-checksum="0xc64972c2" key="">
17901
            <value _ptr_="0xc426c10" type="dict" key="lastKnownDBNames">
17902
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17903
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17904
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17905
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
17906
              <value type="string" key="04149c40-fa90-11e2-83d9-080027bcf912">official_name</value>
17907
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
17908
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
17909
              <value type="string" key="049e0370-a91b-11e2-bdec-080027bcf912">PRIMARY</value>
17910
              <value type="string" key="07e2f24c-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1</value>
17911
              <value type="string" key="07e2f45e-1dde-11e3-bd5f-080027bcf912">sampling_event</value>
17912
              <value type="string" key="07e3e7c4-1dde-11e3-bd5f-080027bcf912">fk_taxon_observation_taxa_sampling_event1_idx</value>
17913
              <value type="string" key="08481eda-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
17914
              <value type="string" key="08483334-f6e0-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
17915
              <value type="string" key="09a29b5c-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1</value>
17916
              <value type="string" key="09a29d14-1dd2-11e3-b98c-080027bcf912">within_place</value>
17917
              <value type="string" key="09a2b70e-1dd2-11e3-b98c-080027bcf912">fk_taxon_occurrence_place1_idx</value>
17918
              <value type="string" key="0a33807e-f6c5-11e2-af44-080027bcf912">boundary_WKT</value>
17919
              <value type="string" key="0ab9880e-a7a1-11e2-b667-080027bcf912">individual_observation</value>
17920
              <value type="string" key="0ab98a66-a7a1-11e2-b667-080027bcf912">id</value>
17921
              <value type="string" key="0ab98c50-a7a1-11e2-b667-080027bcf912">individual</value>
17922
              <value type="string" key="0ab99006-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
17923
              <value type="string" key="0ab99376-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1_idx</value>
17924
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
17925
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
17926
              <value type="string" key="0cec3fce-29ae-11e3-a980-080027bcf912">traceable__id_by_source</value>
17927
              <value type="string" key="0de39e86-1dec-11e3-b571-080027bcf912">record</value>
17928
              <value type="string" key="0de3a2aa-1dec-11e3-b571-080027bcf912">id</value>
17929
              <value type="string" key="0de3a61a-1dec-11e3-b571-080027bcf912">scoping_dataset</value>
17930
              <value type="string" key="0de3ab06-1dec-11e3-b571-080027bcf912">id_within_dataset</value>
17931
              <value type="string" key="0de3afc0-1dec-11e3-b571-080027bcf912">fk_record_source10</value>
17932
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>
17933
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>
17934
              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>
17935
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>
17936
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
17937
              <value type="string" key="1156cf50-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1</value>
17938
              <value type="string" key="1156d180-2393-11e3-a6f3-080027bcf912">parent</value>
17939
              <value type="string" key="1156fa5c-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1_idx</value>
17940
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>
17941
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
17942
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
17943
              <value type="string" key="12c0ef2c-3119-11e3-995a-080027bcf912">dataset_dataset_source_fkey1</value>
17944
              <value type="string" key="12c15368-3119-11e3-995a-080027bcf912">dataset_dataset_source_fkey1_idx</value>
17945
              <value type="string" key="1388436e-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1</value>
17946
              <value type="string" key="13884530-f9c5-11e2-9af4-080027bcf912">parent</value>
17947
              <value type="string" key="13885958-f9c5-11e2-9af4-080027bcf912">fk_rel_place_place1_idx</value>
17948
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
17949
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
17950
              <value type="string" key="16538808-a7a7-11e2-8ba6-080027bcf912">growth_form</value>
17951
              <value type="string" key="165389fc-a7a7-11e2-8ba6-080027bcf912">cultivated</value>
17952
              <value type="string" key="16538c2c-a7a7-11e2-8ba6-080027bcf912">traits</value>
17953
              <value type="string" key="165395c8-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
17954
              <value type="string" key="170b9dc8-310c-11e3-ab47-080027bcf912">fk_source_party2_idx</value>
17955
              <value type="string" key="174e1b4c-23e9-11e3-ab7c-080027bcf912">person</value>
17956
              <value type="string" key="174e1e76-23e9-11e3-ab7c-080027bcf912">id</value>
17957
              <value type="string" key="174e216e-23e9-11e3-ab7c-080027bcf912">fk_organization_party10</value>
17958
              <value type="string" key="174e238a-23e9-11e3-ab7c-080027bcf912">PRIMARY</value>
17959
              <value type="string" key="17d59e68-a794-11e2-84c3-080027bcf912">info</value>
17960
              <value type="string" key="181c8a8a-0077-11e3-906b-080027bcf912">height_min_m</value>
17961
              <value type="string" key="1832712c-a77d-11e2-afd5-080027bcf912">taxon_concept</value>
17962
              <value type="string" key="18327370-a77d-11e2-afd5-080027bcf912">id</value>
17963
              <value type="string" key="18327514-a77d-11e2-afd5-080027bcf912">according_to</value>
17964
              <value type="string" key="18327686-a77d-11e2-afd5-080027bcf912">parent</value>
17965
              <value type="string" key="183277ee-a77d-11e2-afd5-080027bcf912">accepted_taxon_concept</value>
17966
              <value type="string" key="1832797e-a77d-11e2-afd5-080027bcf912">PRIMARY</value>
17967
              <value type="string" key="18327c76-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1_idx</value>
17968
              <value type="string" key="18327f64-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1_idx</value>
17969
              <value type="string" key="1832823e-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1_idx</value>
17970
              <value type="string" key="18328522-a77d-11e2-afd5-080027bcf912">taxon_concept_unique_name</value>
17971
              <value type="string" key="183287f2-a77d-11e2-afd5-080027bcf912">fk_taxon_taxon1</value>
17972
              <value type="string" key="18328950-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_source1</value>
17973
              <value type="string" key="18328a9a-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_concept1</value>
17974
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
17975
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
17976
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
17977
              <value type="string" key="1b07bbcc-1dcb-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1_idx</value>
17978
              <value type="string" key="1b1bf6e4-0077-11e3-906b-080027bcf912">height_max_m</value>
17979
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
17980
              <value type="string" key="1e711948-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_occurrence_record1</value>
17981
              <value type="string" key="20c2d304-311b-11e3-84d1-080027bcf912">use_conditions</value>
17982
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
17983
              <value type="string" key="21b41366-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1_idx</value>
17984
              <value type="string" key="21c8f928-fa8d-11e2-9ba8-080027bcf912">fk_geovalidation_georeferencing1</value>
17985
              <value type="string" key="2213caf6-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1</value>
17986
              <value type="string" key="2213dee2-f971-11e2-9f36-080027bcf912">fk_georeferencing_geoplace1_idx</value>
17987
              <value type="string" key="238b4ae4-a700-11e2-9461-080027bcf912">stratum</value>
17988
              <value type="string" key="238b4f6c-a700-11e2-9461-080027bcf912">id</value>
17989
              <value type="string" key="238b53d6-a700-11e2-9461-080027bcf912">fk_place_path_record10</value>
17990
              <value type="string" key="23ec4078-0075-11e3-906b-080027bcf912">layer</value>
17991
              <value type="string" key="23ec4406-0075-11e3-906b-080027bcf912">id</value>
17992
              <value type="string" key="23ec4726-0075-11e3-906b-080027bcf912">name</value>
17993
              <value type="string" key="23ec4e92-0075-11e3-906b-080027bcf912">PRIMARY</value>
17994
              <value type="string" key="245083fa-a763-11e2-aa10-080027bcf912">geovalidation</value>
17995
              <value type="string" key="24508724-a763-11e2-aa10-080027bcf912">id</value>
17996
              <value type="string" key="2450919c-a763-11e2-aa10-080027bcf912">PRIMARY</value>
17997
              <value type="string" key="251c29a8-f67b-11e2-aebb-080027bcf912">fk_event_party_list1</value>
17998
              <value type="string" key="251c2b92-f67b-11e2-aebb-080027bcf912">participants</value>
17999
              <value type="string" key="251c57de-f67b-11e2-aebb-080027bcf912">fk_event_party_list1_idx</value>
18000
              <value type="string" key="26132be0-23e9-11e3-ab7c-080027bcf912">fk_person_organization1</value>
18001
              <value type="string" key="26132e1a-23e9-11e3-ab7c-080027bcf912">organization</value>
18002
              <value type="string" key="26134602-23e9-11e3-ab7c-080027bcf912">fk_person_organization1_idx</value>
18003
              <value type="string" key="2673b9ee-f9bc-11e2-a599-080027bcf912">subplot</value>
18004
              <value type="string" key="2673bdc2-f9bc-11e2-a599-080027bcf912">id</value>
18005
              <value type="string" key="2673d532-f9bc-11e2-a599-080027bcf912">PRIMARY</value>
18006
              <value type="string" key="26b22c2a-011d-11e3-9f3a-080027bcf912">fk_taxon_absence_taxa_sampling_event1</value>
18007
              <value type="string" key="273737e8-a796-11e2-84c3-080027bcf912">tag</value>
18008
              <value type="string" key="29c29602-a7a4-11e2-8ba6-080027bcf912">common_name</value>
18009
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
18010
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
18011
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>
18012
              <value type="string" key="2ebd5a70-238c-11e3-a6f3-080027bcf912">dataset_source</value>
18013
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
18014
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
18015
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>
18016
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>
18017
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>
18018
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
18019
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
18020
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
18021
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
18022
              <value type="string" key="3587a3e0-1dc6-11e3-838b-410b6ef2c3ca">fk_reobservable_taxon_occurrence1</value>
18023
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">corrected_geoplace</value>
18024
              <value type="string" key="39e40ed2-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1</value>
18025
              <value type="string" key="39e41094-23e9-11e3-ab7c-080027bcf912">parent</value>
18026
              <value type="string" key="39e42688-23e9-11e3-ab7c-080027bcf912">fk_organization_organization1_idx</value>
18027
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">verbatim</value>
18028
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
18029
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
18030
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
18031
              <value type="string" key="3d9b197c-a7a1-11e2-b667-080027bcf912">identified_by</value>
18032
              <value type="string" key="3d9b1d28-a7a1-11e2-b667-080027bcf912">fit_info</value>
18033
              <value type="string" key="3d9b1f30-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1_idx</value>
18034
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
18035
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
18036
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
18037
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
18038
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
18039
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
18040
              <value type="string" key="4001f692-f678-11e2-9716-080027bcf912">fk_collection_source100</value>
18041
              <value type="string" key="4001fa52-f678-11e2-9716-080027bcf912">PRIMARY</value>
18042
              <value type="string" key="400c0dc2-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1</value>
18043
              <value type="string" key="400c0fac-f6d1-11e2-a35e-080027bcf912">parsed_taxon_assertion</value>
18044
              <value type="string" key="400c2370-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_assertion1_idx</value>
18045
              <value type="string" key="40e95b66-acfb-11e2-b309-080027bcf912">fk_method_method1</value>
18046
              <value type="string" key="40e95d64-acfb-11e2-b309-080027bcf912">parent</value>
18047
              <value type="string" key="40e971d2-acfb-11e2-b309-080027bcf912">fk_method_method1_idx</value>
18048
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
18049
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
18050
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
18051
              <value type="string" key="426f5d76-1dcd-11e3-b98c-080027bcf912">fk_individual_count_taxon_presence1</value>
18052
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
18053
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
18054
              <value type="string" key="44e36b2c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1</value>
18055
              <value type="string" key="44e36d02-a7b4-11e2-97d7-080027bcf912">specimen</value>
18056
              <value type="string" key="44e38f6c-a7b4-11e2-97d7-080027bcf912">fk_specimen_observation_specimen1_idx</value>
18057
              <value type="string" key="45a3f404-ad0f-11e2-b309-080027bcf912">name</value>
18058
              <value type="string" key="47b3b670-0076-11e3-906b-080027bcf912">diameter_max_m</value>
18059
              <value type="string" key="4824526a-a791-11e2-84c3-080027bcf912">area_m2</value>
18060
              <value type="string" key="489c177a-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
18061
              <value type="string" key="489c19be-a6ea-11e2-98a6-080027bcf912">id</value>
18062
              <value type="string" key="489c1b62-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
18063
              <value type="string" key="489c1e64-a6ea-11e2-98a6-080027bcf912">fk_example_record10</value>
18064
              <value type="string" key="489c25e4-a6ea-11e2-98a6-080027bcf912">base_class</value>
18065
              <value type="string" key="489c281e-a6ea-11e2-98a6-080027bcf912">id</value>
18066
              <value type="string" key="489c29c2-a6ea-11e2-98a6-080027bcf912">referenced_class</value>
18067
              <value type="string" key="489c2b34-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
18068
              <value type="string" key="489c2e22-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1_idx</value>
18069
              <value type="string" key="489c325a-a6ea-11e2-98a6-080027bcf912">fk_base_class_referenced_class1</value>
18070
              <value type="string" key="489c3958-a6ea-11e2-98a6-080027bcf912">derived_class</value>
18071
              <value type="string" key="489c3b9c-a6ea-11e2-98a6-080027bcf912">id</value>
18072
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
18073
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
18074
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
18075
              <value type="string" key="48c4e182-1dff-11e3-9d67-080027bcf912">event_unique_within_place</value>
18076
              <value type="string" key="49a23428-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2</value>
18077
              <value type="string" key="49a235d6-f9c5-11e2-9af4-080027bcf912">parent</value>
18078
              <value type="string" key="49a26722-f9c5-11e2-9af4-080027bcf912">fk_subplot_plot2_idx</value>
18079
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
18080
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
18081
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
18082
              <value type="string" key="4c4005b0-a741-11e2-9fbf-080027bcf912">PRIMARY</value>
18083
              <value type="string" key="4e34b204-f9c5-11e2-9af4-080027bcf912">fk_subplot_rel_place1</value>
18084
              <value type="string" key="4ee0a0e2-a794-11e2-84c3-080027bcf912">info</value>
18085
              <value type="string" key="4f2d2f86-f986-11e2-8a2e-080027bcf912">info</value>
18086
              <value type="string" key="5077e4de-a748-11e2-9fbf-080027bcf912">taxon</value>
18087
              <value type="string" key="523d417c-f96b-11e2-9fb4-080027bcf912">parent</value>
18088
              <value type="string" key="5256ac76-f983-11e2-8a2e-080027bcf912">azimuth_deg_N</value>
18089
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
18090
              <value type="string" key="58b0d99a-ad00-11e2-b309-080027bcf912">collector_number</value>
18091
              <value type="string" key="59b33ca8-f6ba-11e2-aebb-080027bcf912">taxon_absence</value>
18092
              <value type="string" key="59b33fe6-f6ba-11e2-aebb-080027bcf912">id</value>
18093
              <value type="string" key="59b34b30-f6ba-11e2-aebb-080027bcf912">PRIMARY</value>
18094
              <value type="string" key="5a0331b2-f96d-11e2-9fb4-080027bcf912">name</value>
18095
              <value type="string" key="5a8a530a-1dca-11e3-b98c-080027bcf912">fk_reobservable_taxon_determination1</value>
18096
              <value type="string" key="5a8a54cc-1dca-11e3-b98c-080027bcf912">orig_observation</value>
18097
              <value type="string" key="5b345f5e-f957-11e2-8597-080027bcf912">fk_taxon_determination_taxon_observation1</value>
18098
              <value type="string" key="5e41c0d2-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1</value>
18099
              <value type="string" key="5e41cb90-a778-11e2-92a3-080027bcf912">fk_taxon_assertion_taxon_name1_idx</value>
18100
              <value type="string" key="61c193a8-1dee-11e3-b571-080027bcf912">fk_source_party_list1</value>
18101
              <value type="string" key="61c1b04a-1dee-11e3-b571-080027bcf912">fk_source_party_list1_idx</value>
18102
              <value type="string" key="648b8c10-0075-11e3-906b-080027bcf912">fk_layer_stratum1</value>
18103
              <value type="string" key="65752312-0119-11e3-b872-080027bcf912">cover_percent</value>
18104
              <value type="string" key="66675a70-f970-11e2-9f36-080027bcf912">fk_geoplace_place1</value>
18105
              <value type="string" key="66c25c1c-a791-11e2-84c3-080027bcf912">length_m</value>
18106
              <value type="string" key="67fa5b28-f6c1-11e2-af44-080027bcf912">fk_taxon_observation_sampling_event1</value>
18107
              <value type="string" key="686ec05a-f9bc-11e2-a599-080027bcf912">fk_subplot_plot1</value>
18108
              <value type="string" key="687f12b8-a780-11e2-afd5-080027bcf912">taxon_name</value>
18109
              <value type="string" key="687f1542-a780-11e2-afd5-080027bcf912">id</value>
18110
              <value type="string" key="687f1718-a780-11e2-afd5-080027bcf912">unique_name</value>
18111
              <value type="string" key="687f18b2-a780-11e2-afd5-080027bcf912">formal_name</value>
18112
              <value type="string" key="687f1a6a-a780-11e2-afd5-080027bcf912">taxon_name</value>
18113
              <value type="string" key="687f1c2c-a780-11e2-afd5-080027bcf912">author</value>
18114
              <value type="string" key="687f1dda-a780-11e2-afd5-080027bcf912">rank</value>
18115
              <value type="string" key="687f1f92-a780-11e2-afd5-080027bcf912">PRIMARY</value>
18116
              <value type="string" key="687f22b2-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10_idx</value>
18117
              <value type="string" key="687f25a0-a780-11e2-afd5-080027bcf912">fk_taxon_record10</value>
18118
              <value type="string" key="687f26f4-a780-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_string10</value>
18119
              <value type="string" key="687f2f28-a780-11e2-afd5-080027bcf912">taxon_path</value>
18120
              <value type="string" key="687f31c6-a780-11e2-afd5-080027bcf912">id</value>
18121
              <value type="string" key="687f339c-a780-11e2-afd5-080027bcf912">family</value>
18122
              <value type="string" key="687f3590-a780-11e2-afd5-080027bcf912">genus</value>
18123
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
18124
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
18125
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
18126
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
18127
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">parent</value>
18128
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>
18129
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
18130
              <value type="string" key="6a2c268a-1dfc-11e3-bbb6-080027bcf912">fk_record_source2</value>
18131
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>
18132
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>
18133
              <value type="string" key="6b43c264-f979-11e2-9f36-080027bcf912">fk_place_geopath1_idx</value>
18134
              <value type="string" key="6b54505e-ad0f-11e2-b309-080027bcf912">collection_unique</value>
18135
              <value type="string" key="6c2bb9d2-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1</value>
18136
              <value type="string" key="6c2bbbb2-0083-11e3-ac06-080027bcf912">size_class</value>
18137
              <value type="string" key="6c2bd08e-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_size_class1_idx</value>
18138
              <value type="string" key="713ff706-2998-11e3-a80d-080027bcf912">taxon_observation_id_fkey1</value>
18139
              <value type="string" key="713ff8dc-2998-11e3-a80d-080027bcf912">primary_collector</value>
18140
              <value type="string" key="714100ce-2998-11e3-a80d-080027bcf912">taxon_observation_id_fkey1_idx</value>
18141
              <value type="string" key="7255cc48-1beb-11e3-8de9-080027bcf912">specimen_unique_in_individual_observation</value>
18142
              <value type="string" key="74709b22-a795-11e2-84c3-080027bcf912">slope_incline_deg</value>
18143
              <value type="string" key="760751d2-2324-11e3-a5a2-080027bcf912">fk_dataset_traceable1</value>
18144
              <value type="string" key="77c740cc-1de8-11e3-b571-080027bcf912">role</value>
18145
              <value type="string" key="782db00a-a782-11e2-afd5-080027bcf912">match_info</value>
18146
              <value type="string" key="7afebdc8-0075-11e3-906b-080027bcf912">size_class</value>
18147
              <value type="string" key="7afec156-0075-11e3-906b-080027bcf912">id</value>
18148
              <value type="string" key="7afec49e-0075-11e3-906b-080027bcf912">diameter_min_m</value>
18149
              <value type="string" key="7afec93a-0075-11e3-906b-080027bcf912">fk_layer_stratum10</value>
18150
              <value type="string" key="7afecb88-0075-11e3-906b-080027bcf912">PRIMARY</value>
18151
              <value type="string" key="7c31a514-f96f-11e2-9f36-080027bcf912">boundary_WKT</value>
18152
              <value type="string" key="7cd351c8-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1</value>
18153
              <value type="string" key="7cd35394-1168-11e3-8d7f-080027bcf912">individual_observation</value>
18154
              <value type="string" key="7cd372b6-1168-11e3-8d7f-080027bcf912">fk_specimen_individual_observation1_idx</value>
18155
              <value type="string" key="7d6806c8-f95e-11e2-8597-080027bcf912">description</value>
18156
              <value type="string" key="7e2aa84c-1dfb-11e3-bbb6-080027bcf912">fk_dataset_source1</value>
18157
              <value type="string" key="7f176964-f6c0-11e2-af44-080027bcf912">taxa_sampling_event</value>
18158
              <value type="string" key="7f176d06-f6c0-11e2-af44-080027bcf912">id</value>
18159
              <value type="string" key="7f177512-f6c0-11e2-af44-080027bcf912">fk_project_event10</value>
18160
              <value type="string" key="7f177760-f6c0-11e2-af44-080027bcf912">PRIMARY</value>
18161
              <value type="string" key="7f3654cc-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_barcode</value>
18162
              <value type="string" key="801a596e-3128-11e3-ac9d-080027bcf912">record_id_fkey2</value>
18163
              <value type="string" key="801a5b44-3128-11e3-ac9d-080027bcf912">attribution_dataset</value>
18164
              <value type="string" key="801b49d2-3128-11e3-ac9d-080027bcf912">record_id_fkey2_idx</value>
18165
              <value type="string" key="803980c8-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1</value>
18166
              <value type="string" key="8039828a-f6d1-11e2-a35e-080027bcf912">input_string</value>
18167
              <value type="string" key="80399806-f6d1-11e2-a35e-080027bcf912">fk_taxon_scrub_taxon_string1_idx</value>
18168
              <value type="string" key="813d59c4-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1</value>
18169
              <value type="string" key="813d5bfe-1de9-11e3-b571-080027bcf912">list</value>
18170
              <value type="string" key="813e36c8-1de9-11e3-b571-080027bcf912">fk_party_list_entry_party_list1_idx</value>
18171
              <value type="string" key="81937b1c-ad12-11e2-b309-080027bcf912">fk_collection_source1_idx</value>
18172
              <value type="string" key="83cc6526-236c-11e3-a6f3-080027bcf912">name</value>
18173
              <value type="string" key="83dbd4da-f6e8-11e2-9cf1-080027bcf912">georeferencing</value>
18174
              <value type="string" key="83dbd8ae-f6e8-11e2-9cf1-080027bcf912">id</value>
18175
              <value type="string" key="83dbdbec-f6e8-11e2-9cf1-080027bcf912">input_place</value>
18176
              <value type="string" key="83dbe060-f6e8-11e2-9cf1-080027bcf912">fk_geovalidation_record100</value>
18177
              <value type="string" key="83dbe6aa-f6e8-11e2-9cf1-080027bcf912">PRIMARY</value>
18178
              <value type="string" key="83f063b8-29d4-11e3-a673-080027bcf912">url</value>
18179
              <value type="string" key="84258cd0-3129-11e3-ac9d-080027bcf912">traceable_id_fkey1</value>
18180
              <value type="string" key="84258ee2-3129-11e3-ac9d-080027bcf912">authors</value>
18181
              <value type="string" key="8425b926-3129-11e3-ac9d-080027bcf912">traceable_id_fkey1_idx</value>
18182
              <value type="string" key="8535dbc2-006c-11e3-895c-080027bcf912">stratum_event</value>
18183
              <value type="string" key="8535dfbe-006c-11e3-895c-080027bcf912">id</value>
18184
              <value type="string" key="8535e306-006c-11e3-895c-080027bcf912">stratum</value>
18185
              <value type="string" key="8535e982-006c-11e3-895c-080027bcf912">PRIMARY</value>
18186
              <value type="string" key="8542fbb8-a793-11e2-84c3-080027bcf912">info</value>
18187
              <value type="string" key="86be7be2-29ad-11e3-a980-080027bcf912">id_by_source</value>
18188
              <value type="string" key="86e5a7d8-23ec-11e3-ab7c-080027bcf912">organization_unique</value>
18189
              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>
18190
              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>
18191
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
18192
              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>
18193
              <value type="string" key="8cef30ce-3119-11e3-84d1-080027bcf912">data_owner</value>
18194
              <value type="string" key="8cef351a-3119-11e3-84d1-080027bcf912">id</value>
18195
              <value type="string" key="8cef4780-3119-11e3-84d1-080027bcf912">fk_party_list_entry_record10</value>
18196
              <value type="string" key="8cef496a-3119-11e3-84d1-080027bcf912">PRIMARY</value>
18197
              <value type="string" key="8e39e482-23eb-11e3-ab7c-080027bcf912">name</value>
18198
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
18199
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
18200
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
18201
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
18202
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
18203
              <value type="string" key="9535924c-29b6-11e3-a024-080027bcf912">party_list_id_fkey1</value>
18204
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
18205
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
18206
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
18207
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
18208
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
18209
              <value type="string" key="9d6c9e9a-f678-11e2-9716-080027bcf912">party_list_entry</value>
18210
              <value type="string" key="9d6ca570-f678-11e2-9716-080027bcf912">id</value>
18211
              <value type="string" key="9d6ca7aa-f678-11e2-9716-080027bcf912">PRIMARY</value>
18212
              <value type="string" key="9d6cb042-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1</value>
18213
              <value type="string" key="9d6cb150-f678-11e2-9716-080027bcf912">party</value>
18214
              <value type="string" key="9d6cb812-f678-11e2-9716-080027bcf912">fk_party_list_has_party_party1_idx</value>
18215
              <value type="string" key="9f4bd98c-a6fb-11e2-9461-080027bcf912">plot</value>
18216
              <value type="string" key="9f4bdd10-a6fb-11e2-9461-080027bcf912">id</value>
18217
              <value type="string" key="9f4be008-a6fb-11e2-9461-080027bcf912">fk_subplot_place1</value>
18218
              <value type="string" key="9f4be256-a6fb-11e2-9461-080027bcf912">PRIMARY</value>
18219
              <value type="string" key="9f58576a-a792-11e2-84c3-080027bcf912">name</value>
18220
              <value type="string" key="9ff2d244-1dfe-11e3-9d67-080027bcf912">event_unique_within_parent</value>
18221
              <value type="string" key="a01e225c-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1</value>
18222
              <value type="string" key="a01e269e-a741-11e2-9fbf-080027bcf912">string</value>
18223
              <value type="string" key="a01e47fa-a741-11e2-9fbf-080027bcf912">fk_taxon_assertion_taxon_string1_idx</value>
18224
              <value type="string" key="a0266c92-a92a-11e2-93c8-080027bcf912">latitude_deg</value>
18225
              <value type="string" key="a1698796-29b4-11e3-a980-080027bcf912">taxon_determination_id_fkey1</value>
18226
              <value type="string" key="a1698958-29b4-11e3-a980-080027bcf912">voucher</value>
18227
              <value type="string" key="a16a4988-29b4-11e3-a980-080027bcf912">taxon_determination_id_fkey1_idx</value>
18228
              <value type="string" key="a2c503c8-299a-11e3-a80d-080027bcf912">taxon_observation__unique</value>
18229
              <value type="string" key="a3e070f8-a77c-11e2-afd5-080027bcf912">fk_parsed_taxon_assertion_taxon_name1</value>
18230
              <value type="string" key="a45bf56a-f980-11e2-8a2e-080027bcf912">fk_subplot_place2</value>
18231
              <value type="string" key="a60e3a24-ad15-11e2-9617-080027bcf912">specimen_unique_in_collection_by_accession_number</value>
18232
              <value type="string" key="a76e6760-23ec-11e3-ab7c-080027bcf912">person_unique</value>
18233
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
18234
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
18235
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">subsetting_method</value>
18236
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
18237
              <value type="string" key="a882f398-0117-11e3-b872-080027bcf912">count</value>
18238
              <value type="string" key="a8a2bcc2-311a-11e3-84d1-080027bcf912">use_conditions</value>
18239
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</value>
18240
              <value type="string" key="ab3ef4b0-1dc8-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3</value>
18241
              <value type="string" key="ab3ef6ae-1dc8-11e3-b98c-080027bcf912">current_observation</value>
18242
              <value type="string" key="ad91aad6-23eb-11e3-ab7c-080027bcf912">dataset_unique</value>
18243
              <value type="string" key="ae7761fe-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1</value>
18244
              <value type="string" key="ae7763ca-008a-11e3-9629-080027bcf912">measurement_spot</value>
18245
              <value type="string" key="ae777b3a-008a-11e3-9629-080027bcf912">fk_soil_observation_subplace1_idx</value>
18246
              <value type="string" key="aed5d5c4-a769-11e2-92a3-080027bcf912">cf_aff</value>
18247
              <value type="string" key="afc401d4-1df9-11e3-bbb6-080027bcf912">source</value>
18248
              <value type="string" key="afc4053a-1df9-11e3-bbb6-080027bcf912">id</value>
18249
              <value type="string" key="afc40c10-1df9-11e3-bbb6-080027bcf912">name</value>
18250
              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>
18251
              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>
18252
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
18253
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
18254
              <value type="string" key="b7749c3a-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1</value>
18255
              <value type="string" key="b7749e74-2985-11e3-a80d-080027bcf912">place_observation</value>
18256
              <value type="string" key="b774c534-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1_idx</value>
18257
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
18258
              <value type="string" key="b922e5ba-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1</value>
18259
              <value type="string" key="b922fa5a-006c-11e3-895c-080027bcf912">fk_stratum_event_stratum1_idx</value>
18260
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
18261
              <value type="string" key="b9695d2e-a793-11e2-84c3-080027bcf912">info</value>
18262
              <value type="string" key="b9be8c42-acff-11e2-b309-080027bcf912">all_collectors</value>
18263
              <value type="string" key="bae73e3e-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1</value>
18264
              <value type="string" key="bae73ff6-2996-11e3-a80d-080027bcf912">current_collection</value>
18265
              <value type="string" key="bae812be-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey1_idx</value>
18266
              <value type="string" key="bb86336c-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1</value>
18267
              <value type="string" key="bb863556-2992-11e3-a80d-080027bcf912">specimenholder_institutions</value>
18268
              <value type="string" key="bb865680-2992-11e3-a80d-080027bcf912">individual_observation_id_fkey1_idx</value>
18269
              <value type="string" key="bbbbdd9c-ad09-11e2-b309-080027bcf912">id_within_individual</value>
18270
              <value type="string" key="bd75deda-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey2</value>
18271
              <value type="string" key="bd75e0a6-2996-11e3-a80d-080027bcf912">owner_collection</value>
18272
              <value type="string" key="bd76aaea-2996-11e3-a80d-080027bcf912">specimen_observation_id_fkey2_idx</value>
18273
              <value type="string" key="be8cb246-a6e0-11e2-95e9-080027bcf912">VegCore</value>
18274
              <value type="string" key="be8cc04c-a6e0-11e2-95e9-080027bcf912">dataset</value>
18275
              <value type="string" key="be8cc362-a6e0-11e2-95e9-080027bcf912">id</value>
18276
              <value type="string" key="be8cc75e-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18277
              <value type="string" key="be8cd56e-a6e0-11e2-95e9-080027bcf912">traceable</value>
18278
              <value type="string" key="be8cd7b2-a6e0-11e2-95e9-080027bcf912">id</value>
18279
              <value type="string" key="be8cd956-a6e0-11e2-95e9-080027bcf912">source</value>
18280
              <value type="string" key="be8cdac8-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18281
              <value type="string" key="be8ce0b8-a6e0-11e2-95e9-080027bcf912">fk_record_source1</value>
18282
              <value type="string" key="be8d17d6-a6e0-11e2-95e9-080027bcf912">taxon_assertion</value>
18283
              <value type="string" key="be8d1ac4-a6e0-11e2-95e9-080027bcf912">id</value>
18284
              <value type="string" key="be8d1de4-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18285
              <value type="string" key="be8d249c-a6e0-11e2-95e9-080027bcf912">fk_qualified_taxon_record1</value>
18286
              <value type="string" key="be8d4a58-a6e0-11e2-95e9-080027bcf912">geoplace</value>
18287
              <value type="string" key="be8d4cd8-a6e0-11e2-95e9-080027bcf912">id</value>
18288
              <value type="string" key="be8d4eae-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18289
              <value type="string" key="be8d8c2a-a6e0-11e2-95e9-080027bcf912">method</value>
18290
              <value type="string" key="be8d8ea0-a6e0-11e2-95e9-080027bcf912">id</value>
18291
              <value type="string" key="be8d906c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18292
              <value type="string" key="be8d93c8-a6e0-11e2-95e9-080027bcf912">fk_method_record1</value>
18293
              <value type="string" key="be8df962-a6e0-11e2-95e9-080027bcf912">collection</value>
18294
              <value type="string" key="be8dfbf6-a6e0-11e2-95e9-080027bcf912">id</value>
18295
              <value type="string" key="be8e0240-a6e0-11e2-95e9-080027bcf912">fk_collection_source1</value>
18296
              <value type="string" key="be8e3ecc-a6e0-11e2-95e9-080027bcf912">individual</value>
18297
              <value type="string" key="be8e4142-a6e0-11e2-95e9-080027bcf912">id</value>
18298
              <value type="string" key="be8e4322-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18299
              <value type="string" key="be8e4688-a6e0-11e2-95e9-080027bcf912">fk_individual_record1</value>
18300
              <value type="string" key="be8e6514-a6e0-11e2-95e9-080027bcf912">stem</value>
18301
              <value type="string" key="be8e679e-a6e0-11e2-95e9-080027bcf912">id</value>
18302
              <value type="string" key="be8e6974-a6e0-11e2-95e9-080027bcf912">individual</value>
18303
              <value type="string" key="be8e6b22-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18304
              <value type="string" key="be8e6e7e-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1_idx</value>
18305
              <value type="string" key="be8e7360-a6e0-11e2-95e9-080027bcf912">fk_stem_individual1</value>
18306
              <value type="string" key="be8e7cde-a6e0-11e2-95e9-080027bcf912">stem_observation</value>
18307
              <value type="string" key="be8e7f5e-a6e0-11e2-95e9-080027bcf912">id</value>
18308
              <value type="string" key="be8e8134-a6e0-11e2-95e9-080027bcf912">individual_observation</value>
18309
              <value type="string" key="be8e82ce-a6e0-11e2-95e9-080027bcf912">stem</value>
18310
              <value type="string" key="be8e8472-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18311
              <value type="string" key="be8e87d8-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1_idx</value>
18312
              <value type="string" key="be8e8b20-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1_idx</value>
18313
              <value type="string" key="be8e8fe4-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_individual_observation1</value>
18314
              <value type="string" key="be8e9156-a6e0-11e2-95e9-080027bcf912">fk_stem_observation_stem1</value>
18315
              <value type="string" key="be8e9930-a6e0-11e2-95e9-080027bcf912">individual_count</value>
18316
              <value type="string" key="be8e9bba-a6e0-11e2-95e9-080027bcf912">id</value>
18317
              <value type="string" key="be8e9d90-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18318
              <value type="string" key="be8ea786-a6e0-11e2-95e9-080027bcf912">taxon_presence</value>
18319
              <value type="string" key="be8eaa06-a6e0-11e2-95e9-080027bcf912">id</value>
18320
              <value type="string" key="be8f1784-a6e0-11e2-95e9-080027bcf912">community</value>
18321
              <value type="string" key="be8f1a36-a6e0-11e2-95e9-080027bcf912">id</value>
18322
              <value type="string" key="be8f1c2a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18323
              <value type="string" key="be8f1fc2-a6e0-11e2-95e9-080027bcf912">fk_community_record1</value>
18324
              <value type="string" key="be8f272e-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18325
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
18326
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18327
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
18328
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
18329
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
18330
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">place</value>
18331
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
18332
              <value type="string" key="be8f3fd4-a6e0-11e2-95e9-080027bcf912">community</value>
18333
              <value type="string" key="be8f416e-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1_idx</value>
18334
              <value type="string" key="be8f4524-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1_idx</value>
18335
              <value type="string" key="be8f483a-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1_idx</value>
18336
              <value type="string" key="be8f4b64-a6e0-11e2-95e9-080027bcf912">fk_place_observation_place1</value>
18337
              <value type="string" key="be8f4d08-a6e0-11e2-95e9-080027bcf912">fk_place_observation_geological_context1</value>
18338
              <value type="string" key="be8f4e98-a6e0-11e2-95e9-080027bcf912">fk_place_observation_community1</value>
18339
              <value type="string" key="be8f58b6-a6e0-11e2-95e9-080027bcf912">soil_observation</value>
18340
              <value type="string" key="be8f5b5e-a6e0-11e2-95e9-080027bcf912">id</value>
18341
              <value type="string" key="be8f5d5c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18342
              <value type="string" key="be8f67e8-a6e0-11e2-95e9-080027bcf912">subplace</value>
18343
              <value type="string" key="be8f6a86-a6e0-11e2-95e9-080027bcf912">id</value>
18344
              <value type="string" key="be8f6c7a-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18345
              <value type="string" key="be8f78aa-a6e0-11e2-95e9-080027bcf912">geovalidatable_place</value>
18346
              <value type="string" key="be8f7b0c-a6e0-11e2-95e9-080027bcf912">id</value>
18347
              <value type="string" key="be8f8084-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18348
              <value type="string" key="be8fa0fa-a6e0-11e2-95e9-080027bcf912">project</value>
18349
              <value type="string" key="be8fa398-a6e0-11e2-95e9-080027bcf912">id</value>
18350
              <value type="string" key="be8fa58c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18351
              <value type="string" key="be8fa91a-a6e0-11e2-95e9-080027bcf912">fk_project_event1</value>
18352
              <value type="string" key="be8fb202-a6e0-11e2-95e9-080027bcf912">taxon_scrub</value>
18353
              <value type="string" key="be8fb5ae-a6e0-11e2-95e9-080027bcf912">id</value>
18354
              <value type="string" key="be8fb7a2-a6e0-11e2-95e9-080027bcf912">matched_taxon_concept</value>
18355
              <value type="string" key="be8fb98c-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18356
              <value type="string" key="be8fe70e-a6e0-11e2-95e9-080027bcf912">party</value>
18357
              <value type="string" key="be8fe97a-a6e0-11e2-95e9-080027bcf912">id</value>
18358
              <value type="string" key="be8feb50-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18359
              <value type="string" key="be8fee8e-a6e0-11e2-95e9-080027bcf912">fk_collection_source10</value>
18360
              <value type="string" key="c3760d74-a7b3-11e2-8ba6-080027bcf912">specimen_observation</value>
18361
              <value type="string" key="c376109e-a7b3-11e2-8ba6-080027bcf912">id</value>
18362
              <value type="string" key="c3762570-a7b3-11e2-8ba6-080027bcf912">fk_specimen_taxon_occurrence10</value>
18363
              <value type="string" key="c37629b2-a7b3-11e2-8ba6-080027bcf912">PRIMARY</value>
18364
              <value type="string" key="c4391d16-006c-11e3-895c-080027bcf912">fk_stratum_event_sampling_event1</value>
18365
              <value type="string" key="c6722390-a7a0-11e2-b667-080027bcf912">geopath</value>
18366
              <value type="string" key="c67225de-a7a0-11e2-b667-080027bcf912">id</value>
18367
              <value type="string" key="c6722782-a7a0-11e2-b667-080027bcf912">continent</value>
18368
              <value type="string" key="c6722912-a7a0-11e2-b667-080027bcf912">country</value>
18369
              <value type="string" key="c6722a98-a7a0-11e2-b667-080027bcf912">state_province</value>
18370
              <value type="string" key="c6722c1e-a7a0-11e2-b667-080027bcf912">county</value>
18371
              <value type="string" key="c6722da4-a7a0-11e2-b667-080027bcf912">municipality</value>
18372
              <value type="string" key="c6722f2a-a7a0-11e2-b667-080027bcf912">ranks</value>
18373
              <value type="string" key="c67230d8-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18374
              <value type="string" key="c6723d8a-a7a0-11e2-b667-080027bcf912">place</value>
18375
              <value type="string" key="c6724000-a7a0-11e2-b667-080027bcf912">id</value>
18376
              <value type="string" key="c67241b8-a7a0-11e2-b667-080027bcf912">parent</value>
18377
              <value type="string" key="c672467c-a7a0-11e2-b667-080027bcf912">locality</value>
18378
              <value type="string" key="c6724820-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18379
              <value type="string" key="c6724e7e-a7a0-11e2-b667-080027bcf912">fk_place1_idx</value>
18380
              <value type="string" key="c67254b4-a7a0-11e2-b667-080027bcf912">fk_place_record1</value>
18381
              <value type="string" key="c6725784-a7a0-11e2-b667-080027bcf912">fk_place1</value>
18382
              <value type="string" key="c672743a-a7a0-11e2-b667-080027bcf912">event</value>
18383
              <value type="string" key="c67276b0-a7a0-11e2-b667-080027bcf912">id</value>
18384
              <value type="string" key="c672785e-a7a0-11e2-b667-080027bcf912">parent</value>
18385
              <value type="string" key="c6727a2a-a7a0-11e2-b667-080027bcf912">name</value>
18386
              <value type="string" key="c6727bce-a7a0-11e2-b667-080027bcf912">date_range</value>
18387
              <value type="string" key="c6727d54-a7a0-11e2-b667-080027bcf912">place</value>
18388
              <value type="string" key="c67280b0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18389
              <value type="string" key="c67283da-a7a0-11e2-b667-080027bcf912">fk_event_place1_idx</value>
18390
              <value type="string" key="c6728830-a7a0-11e2-b667-080027bcf912">fk_event1_idx</value>
18391
              <value type="string" key="c6729578-a7a0-11e2-b667-080027bcf912">fk_event_record1</value>
18392
              <value type="string" key="c672971c-a7a0-11e2-b667-080027bcf912">fk_event_place1</value>
18393
              <value type="string" key="c672994c-a7a0-11e2-b667-080027bcf912">fk_event1</value>
18394
              <value type="string" key="c672a8d8-a7a0-11e2-b667-080027bcf912">reobservable</value>
18395
              <value type="string" key="c672abda-a7a0-11e2-b667-080027bcf912">id</value>
18396
              <value type="string" key="c672bda0-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18397
              <value type="string" key="c672f914-a7a0-11e2-b667-080027bcf912">specimen</value>
18398
              <value type="string" key="c672fb6c-a7a0-11e2-b667-080027bcf912">id</value>
18399
              <value type="string" key="c6730896-a7a0-11e2-b667-080027bcf912">orig_collection</value>
18400
              <value type="string" key="c6730b98-a7a0-11e2-b667-080027bcf912">barcode</value>
18401
              <value type="string" key="c6730d78-a7a0-11e2-b667-080027bcf912">accession_number</value>
18402
              <value type="string" key="c6731048-a7a0-11e2-b667-080027bcf912">PRIMARY</value>
18403
              <value type="string" key="c6731534-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1_idx</value>
18404
              <value type="string" key="c6731a52-a7a0-11e2-b667-080027bcf912">fk_specimen_taxon_occurrence1</value>
18405
              <value type="string" key="c6731c28-a7a0-11e2-b667-080027bcf912">fk_specimen_collection1</value>
18406
              <value type="string" key="c7a57ce0-a92a-11e2-93c8-080027bcf912">lat_long_in_place_ranks</value>
18407
              <value type="string" key="c7c1e6aa-a91b-11e2-bdec-080027bcf912">fk_source_party2</value>
18408
              <value type="string" key="c7c1e862-a91b-11e2-bdec-080027bcf912">first_publisher</value>
18409
              <value type="string" key="c8552b14-a7bc-11e2-8af2-080027bcf912">data_owners</value>
18410
              <value type="string" key="cb38187e-29d4-11e3-a673-080027bcf912">source__unique</value>
18411
              <value type="string" key="cfea1514-a790-11e2-84c3-080027bcf912">x_m</value>
18412
              <value type="string" key="d009232a-f671-11e2-9716-080027bcf912">tag_history</value>
18413
              <value type="string" key="d0d97d8a-f6c7-11e2-a35e-080027bcf912">coords</value>
18414
              <value type="string" key="d2081100-f959-11e2-8597-080027bcf912">fk_taxon_presence_taxon_determination1</value>
18415
              <value type="string" key="d2855d46-1df2-11e3-bbb6-080027bcf912">fk_source_party1_idx</value>
18416
              <value type="string" key="d2b2ccf6-a794-11e2-84c3-080027bcf912">elevation_m</value>
18417
              <value type="string" key="d6b1b62e-a7a7-11e2-8ba6-080027bcf912">PRIMARY</value>
18418
              <value type="string" key="d7177350-298a-11e3-a80d-080027bcf912">place_observation_id_fkey1</value>
18419
              <value type="string" key="d717759e-298a-11e3-a80d-080027bcf912">project</value>
18420
              <value type="string" key="d7179362-298a-11e3-a80d-080027bcf912">place_observation_id_fkey1_idx</value>
18421
              <value type="string" key="db4e8988-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1</value>
18422
              <value type="string" key="db4e8bea-1dc6-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18423
              <value type="string" key="db4ea800-1dc6-11e3-838b-410b6ef2c3ca">fk_taxon_observation_taxon_occurrence1_idx</value>
18424
              <value type="string" key="dbe10c36-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1</value>
18425
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
18426
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">aggregating_traits</value>
18427
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>
18428
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent</value>
18429
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18430
              <value type="string" key="e4cb84c4-29b1-11e3-a980-080027bcf912">taxon_observation_id_fkey2</value>
18431
              <value type="string" key="e4cb86c2-29b1-11e3-a980-080027bcf912">parent</value>
18432
              <value type="string" key="e4cba2d8-29b1-11e3-a980-080027bcf912">taxon_observation_id_fkey2_idx</value>
18433
              <value type="string" key="e7922292-311f-11e3-9d49-080027bcf912">array</value>
18434
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18435
              <value type="string" key="e96e2084-23eb-11e3-ab7c-080027bcf912">name</value>
18436
              <value type="string" key="ec1f6aa2-f6c5-11e2-a35e-080027bcf912">shape</value>
18437
              <value type="string" key="ed1eb2a6-ad0e-11e2-b309-080027bcf912">fk_collection_organization1</value>
18438
              <value type="string" key="ed1eb468-ad0e-11e2-b309-080027bcf912">institution</value>
18439
              <value type="string" key="ed1ec98a-ad0e-11e2-b309-080027bcf912">fk_collection_organization1_idx</value>
18440
              <value type="string" key="f15726c2-011f-11e3-9f3a-080027bcf912">aggregate_observation</value>
18441
              <value type="string" key="f1572a5a-011f-11e3-9f3a-080027bcf912">id</value>
18442
              <value type="string" key="f1572d5c-011f-11e3-9f3a-080027bcf912">occurrence_status</value>
18443
              <value type="string" key="f157336a-011f-11e3-9f3a-080027bcf912">fk_taxon_presence_taxon_determination10</value>
18444
              <value type="string" key="f1573748-011f-11e3-9f3a-080027bcf912">PRIMARY</value>
18445
              <value type="string" key="f62bfaf6-a797-11e2-8681-080027bcf912">fk_stem_observation_individual_observation2</value>
18446
              <value type="string" key="f9d23e32-1dc5-11e3-838b-410b6ef2c3ca">taxon_occurrence</value>
18447
              <value type="string" key="f9d241ca-1dc5-11e3-838b-410b6ef2c3ca">id</value>
18448
              <value type="string" key="f9d255c0-1dc5-11e3-838b-410b6ef2c3ca">PRIMARY</value>
18449
              <value type="string" key="f9d963a4-2326-11e3-a5a2-080027bcf912">id_within_source</value>
18450
              <value type="string" key="fbf69d1e-a79d-11e2-a346-080027bcf912">traceable_unique</value>
18451
              <value type="string" key="fc6fbbae-f96e-11e2-9f36-080027bcf912">geoplace</value>
18452
              <value type="string" key="feccdf38-311a-11e3-84d1-080027bcf912">access_rights</value>
18453
            </value>
18454
            <value type="string" key="lastSyncDate"></value>
18455
            <value type="string" key="name"></value>
18456
          </value>
18457
        </value>
17902 18458
        <value _ptr_="0xaeb84e0" type="list" content-type="object" content-struct-name="GrtObject" key="tagCategories"/>
17903 18459
        <value _ptr_="0xaeb8510" type="list" content-type="object" content-struct-name="meta.Tag" key="tags"/>
17904 18460
        <link type="object" struct-name="model.Diagram" key="currentDiagram">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
17981 18537
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17982 18538
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17983 18539
      <value type="string" key="caption">New Model</value>
17984
      <value type="string" key="dateChanged">2013-10-09 14:22</value>
18540
      <value type="string" key="dateChanged">2013-10-09 14:29</value>
17985 18541
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17986 18542
      <value type="string" key="description"></value>
17987 18543
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
756 756
  `scoping_dataset` varbinary(767) NOT NULL COMMENT 'the dataset that scopes the id_within_dataset',
757 757
  `id_within_dataset` varbinary(767) NOT NULL,
758 758
  `attribution_dataset` varbinary(767) NOT NULL COMMENT 'the dataset that provides attribution information. defaults to the scoping_dataset.',
759
  `authors` varbinary(767) DEFAULT NULL COMMENT 'the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author',
760 759
  PRIMARY KEY (`id`),
761 760
  UNIQUE KEY `record_unique` (`scoping_dataset`,`id_within_dataset`),
762 761
  KEY `fk_record_source1_idx` (`scoping_dataset`),
763
  KEY `record_id_fkey1_idx` (`authors`),
764 762
  KEY `record_id_fkey2_idx` (`attribution_dataset`),
763
  CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
765 764
  CONSTRAINT `fk_record_source10` FOREIGN KEY (`scoping_dataset`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
766
  CONSTRAINT `record_id_fkey2` FOREIGN KEY (`attribution_dataset`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
767
  CONSTRAINT `fk_record_source2` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
768
  CONSTRAINT `record_id_fkey1` FOREIGN KEY (`authors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
765
  CONSTRAINT `record_id_fkey2` FOREIGN KEY (`attribution_dataset`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
769 766
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be a row in a table, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.';
770 767
/*!40101 SET character_set_client = @saved_cs_client */;
771 768

  
......
1438 1435
  `id_by_source` varbinary(767) DEFAULT NULL COMMENT 'allows referencing a traceable by its source information even when the subclass chose a different value for the pkey',
1439 1436
  `source` varbinary(767) NOT NULL,
1440 1437
  `id_within_source` varbinary(767) DEFAULT NULL COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination). this can also identify e.g. a dataset within the source that it came from.',
1438
  `authors` varbinary(767) DEFAULT NULL COMMENT 'the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author',
1441 1439
  PRIMARY KEY (`id`),
1442 1440
  UNIQUE KEY `traceable_unique` (`source`,`id_within_source`),
1443 1441
  UNIQUE KEY `traceable__id_by_source` (`id_by_source`),
1442
  KEY `traceable_id_fkey1_idx` (`authors`),
1443
  CONSTRAINT `traceable_id_fkey1` FOREIGN KEY (`authors`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1444 1444
  CONSTRAINT `fk_record_source1` FOREIGN KEY (`source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1445 1445
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information';
1446 1446
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
758 758
  "scoping_dataset" text NOT NULL /*COMMENT 'the dataset that scopes the id_within_dataset'*/,
759 759
  "id_within_dataset" text NOT NULL,
760 760
  "attribution_dataset" text NOT NULL /*COMMENT 'the dataset that provides attribution information. defaults to the scoping_dataset.'*/,
761
  "authors" text DEFAULT NULL /*COMMENT 'the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author'*/,
762 761
  PRIMARY KEY ("id"),
763 762
  /*CONSTRAINT "record_unique" */UNIQUE ("scoping_dataset","id_within_dataset"),
764 763
  /*KEY "fk_record_source1_idx" ("scoping_dataset")*/CHECK (true),
765
  /*KEY "record_id_fkey1_idx" ("authors")*/CHECK (true),
766 764
  /*KEY "record_id_fkey2_idx" ("attribution_dataset")*/CHECK (true),
765
  /*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
767 766
  /*CONSTRAINT "fk_record_source10" FOREIGN KEY ("scoping_dataset") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
768
  /*CONSTRAINT "record_id_fkey2" FOREIGN KEY ("attribution_dataset") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
769
  /*CONSTRAINT "fk_record_source2" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
770
  /*CONSTRAINT "record_id_fkey1" FOREIGN KEY ("authors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
767
  /*CONSTRAINT "record_id_fkey2" FOREIGN KEY ("attribution_dataset") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
771 768
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of data relating to the same entity. this doesn''t have to be a row in a table, it can also be a paragraph of text relating to the same thing (e.g. a method description in a PDF). note that this is the record in the *source* data.'*/;
772 769
/*!40101 SET character_set_client = @saved_cs_client */;
773 770

  
......
1440 1437
  "id_by_source" text DEFAULT NULL /*COMMENT 'allows referencing a traceable by its source information even when the subclass chose a different value for the pkey'*/,
1441 1438
  "source" text NOT NULL,
1442 1439
  "id_within_source" text DEFAULT NULL /*COMMENT 'the portion of the source that this traceable refers to. when specified, this must *uniquely identify* the traceable within the source. denormalized source data often contains data for many VegCore tables in the same row, and the traceables for each of these table entries must be distinguished *from each other* since they share the same source. this is usually just the VegCore table name, sometimes with a distinguishing prefix (e.g. collector.party/identified_by.party; current_observation.taxon_determination/orig_observation.taxon_determination). this can also identify e.g. a dataset within the source that it came from.'*/,
1440
  "authors" text DEFAULT NULL /*COMMENT 'the people who created the information in the data record. this is *different* from dataset.data_owners, and refers *only* to original data creators such as collectors and identifiers. note that in vegetation data, these record-specific authors generally do not receive attribution. = Brad.vegpath.org?attribution.data_author'*/,
1443 1441
  PRIMARY KEY ("id"),
1444 1442
  /*CONSTRAINT "traceable_unique" */UNIQUE ("source","id_within_source"),
1445 1443
  /*CONSTRAINT "traceable__id_by_source" */UNIQUE ("id_by_source"),
1444
  /*KEY "traceable_id_fkey1_idx" ("authors")*/CHECK (true),
1445
  /*CONSTRAINT "traceable_id_fkey1" FOREIGN KEY ("authors") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1446 1446
  /*CONSTRAINT "fk_record_source1" FOREIGN KEY ("source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1447 1447
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a row that can have associated source information'*/;
1448 1448
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff