Project

General

Profile

« Previous | Next » 

Revision 11057

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset: added metadata_source, which stores where the information about the dataset came from (as opposed to where the dataset came from)

View differences:

schemas/VegCore/ERD/document.mwb.xml
311 311
                      <value type="string" key="oldName">id</value>
312 312
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
313 313
                    </value>
314
                    <value type="object" struct-name="db.mysql.Column" id="2ebd5a70-238c-11e3-a6f3-080027bcf912" struct-checksum="0x783b5183">
315
                      <value type="int" key="autoIncrement">0</value>
316
                      <value type="string" key="characterSetName"></value>
317
                      <value _ptr_="0xcc3b9d0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
318
                      <value type="string" key="collationName"></value>
319
                      <value type="string" key="datatypeExplicitParams"></value>
320
                      <value type="string" key="defaultValue"></value>
321
                      <value type="int" key="defaultValueIsNull">1</value>
322
                      <value _ptr_="0xc784818" type="list" content-type="string" key="flags"/>
323
                      <value type="int" key="isNotNull">0</value>
324
                      <value type="int" key="length">767</value>
325
                      <value type="int" key="precision">-1</value>
326
                      <value type="int" key="scale">-1</value>
327
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
328
                      <value type="string" key="comment">where the information *about* the dataset came from (as opposed to where the dataset came from)</value>
329
                      <value type="string" key="name">metadata_source</value>
330
                      <value type="string" key="oldName">metadata_source</value>
331
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
332
                    </value>
314 333
                    <value type="object" struct-name="db.mysql.Column" id="c7c1e862-a91b-11e2-bdec-080027bcf912" struct-checksum="0x783b5183">
315 334
                      <value type="int" key="autoIncrement">0</value>
316 335
                      <value type="string" key="characterSetName"></value>
......
393 412
                  <value type="string" key="defaultCollationName">utf8_bin</value>
394 413
                  <value type="int" key="delayKeyWrite">0</value>
395 414
                  <value _ptr_="0xbbe3120" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
396
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
397
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
398
                      <value _ptr_="0xbbe4a00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
399
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
400
                      </value>
401
                      <value type="int" key="deferability">0</value>
402
                      <value type="string" key="deleteRule">CASCADE</value>
403
                      <link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
404
                      <value type="int" key="mandatory">1</value>
405
                      <value type="int" key="many">1</value>
406
                      <value type="int" key="modelOnly">0</value>
407
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
408
                      <value _ptr_="0xbbe4cf0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
409
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
410
                      </value>
411
                      <value type="int" key="referencedMandatory">0</value>
412
                      <value type="string" key="updateRule">CASCADE</value>
413
                      <value type="string" key="comment"></value>
414
                      <value type="string" key="name">fk_source_party2</value>
415
                      <value type="string" key="oldName">fk_source_party2</value>
416
                    </value>
417
                    <value type="object" struct-name="db.mysql.ForeignKey" id="61c193a8-1dee-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">
415
                    <value type="object" struct-name="db.mysql.ForeignKey" id="873d44bc-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
418 416
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
419
                      <value _ptr_="0xbbe4d60" type="list" content-type="object" content-struct-name="db.Column" key="columns">
420
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
417
                      <value _ptr_="0xbbe50c0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
418
                        <link type="object">873d473c-1df1-11e3-bbb6-080027bcf912</link>
421 419
                      </value>
422 420
                      <value type="int" key="deferability">0</value>
423 421
                      <value type="string" key="deleteRule">CASCADE</value>
424
                      <link type="object" struct-name="db.Index" key="index">61c1b04a-1dee-11e3-b571-080027bcf912</link>
422
                      <link type="object" struct-name="db.Index" key="index">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
425 423
                      <value type="int" key="mandatory">1</value>
426 424
                      <value type="int" key="many">1</value>
427 425
                      <value type="int" key="modelOnly">0</value>
428 426
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
429
                      <value _ptr_="0xbbe5050" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
427
                      <value _ptr_="0xbbe53b0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
430 428
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
431 429
                      </value>
432 430
                      <value type="int" key="referencedMandatory">0</value>
433 431
                      <value type="string" key="updateRule">CASCADE</value>
434 432
                      <value type="string" key="comment"></value>
435
                      <value type="string" key="name">fk_source_party_list1</value>
436
                      <value type="string" key="oldName">fk_source_party_list1</value>
433
                      <value type="string" key="name">fk_source_party1</value>
434
                      <value type="string" key="oldName">fk_source_party1</value>
437 435
                    </value>
438
                    <value type="object" struct-name="db.mysql.ForeignKey" id="873d44bc-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
439
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
440
                      <value _ptr_="0xbbe50c0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
441
                        <link type="object">873d473c-1df1-11e3-bbb6-080027bcf912</link>
436
                    <value type="object" struct-name="db.mysql.ForeignKey" id="3237beb6-238c-11e3-a6f3-080027bcf912" struct-checksum="0x70a8fc40">
437
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
438
                      <value _ptr_="0xce16598" type="list" content-type="object" content-struct-name="db.Column" key="columns">
439
                        <link type="object">2ebd5a70-238c-11e3-a6f3-080027bcf912</link>
442 440
                      </value>
443 441
                      <value type="int" key="deferability">0</value>
444 442
                      <value type="string" key="deleteRule">CASCADE</value>
445
                      <link type="object" struct-name="db.Index" key="index">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
443
                      <link type="object" struct-name="db.Index" key="index">3237d356-238c-11e3-a6f3-080027bcf912</link>
446 444
                      <value type="int" key="mandatory">1</value>
447 445
                      <value type="int" key="many">1</value>
448 446
                      <value type="int" key="modelOnly">0</value>
449 447
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
450
                      <value _ptr_="0xbbe53b0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
451
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
448
                      <value _ptr_="0xcb53d48" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
449
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
452 450
                      </value>
453
                      <value type="int" key="referencedMandatory">0</value>
451
                      <value type="int" key="referencedMandatory">1</value>
454 452
                      <value type="string" key="updateRule">CASCADE</value>
455 453
                      <value type="string" key="comment"></value>
456
                      <value type="string" key="name">fk_source_party1</value>
457
                      <value type="string" key="oldName">fk_source_party1</value>
454
                      <value type="string" key="name">fk_dataset_source2</value>
455
                      <value type="string" key="oldName">fk_dataset_source2</value>
458 456
                    </value>
459 457
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7e2aa84c-1dfb-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
460 458
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
......
496 494
                      <value type="string" key="name">fk_dataset_traceable1</value>
497 495
                      <value type="string" key="oldName">fk_dataset_traceable1</value>
498 496
                    </value>
497
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
498
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
499
                      <value _ptr_="0xbbe4a00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
500
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
501
                      </value>
502
                      <value type="int" key="deferability">0</value>
503
                      <value type="string" key="deleteRule">CASCADE</value>
504
                      <link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
505
                      <value type="int" key="mandatory">1</value>
506
                      <value type="int" key="many">1</value>
507
                      <value type="int" key="modelOnly">0</value>
508
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
509
                      <value _ptr_="0xbbe4cf0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
510
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
511
                      </value>
512
                      <value type="int" key="referencedMandatory">0</value>
513
                      <value type="string" key="updateRule">CASCADE</value>
514
                      <value type="string" key="comment"></value>
515
                      <value type="string" key="name">fk_source_party2</value>
516
                      <value type="string" key="oldName">fk_source_party2</value>
517
                    </value>
518
                    <value type="object" struct-name="db.mysql.ForeignKey" id="61c193a8-1dee-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">
519
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
520
                      <value _ptr_="0xbbe4d60" type="list" content-type="object" content-struct-name="db.Column" key="columns">
521
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
522
                      </value>
523
                      <value type="int" key="deferability">0</value>
524
                      <value type="string" key="deleteRule">CASCADE</value>
525
                      <link type="object" struct-name="db.Index" key="index">61c1b04a-1dee-11e3-b571-080027bcf912</link>
526
                      <value type="int" key="mandatory">1</value>
527
                      <value type="int" key="many">1</value>
528
                      <value type="int" key="modelOnly">0</value>
529
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
530
                      <value _ptr_="0xbbe5050" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
531
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
532
                      </value>
533
                      <value type="int" key="referencedMandatory">0</value>
534
                      <value type="string" key="updateRule">CASCADE</value>
535
                      <value type="string" key="comment"></value>
536
                      <value type="string" key="name">fk_source_party_list1</value>
537
                      <value type="string" key="oldName">fk_source_party_list1</value>
538
                    </value>
499 539
                  </value>
500 540
                  <value _ptr_="0xbbe3150" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
501 541
                    <value type="object" struct-name="db.mysql.Index" id="be8cc75e-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
590 630
                      <value type="string" key="oldName">fk_source_party1_idx</value>
591 631
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
592 632
                    </value>
633
                    <value type="object" struct-name="db.mysql.Index" id="3237d356-238c-11e3-a6f3-080027bcf912" struct-checksum="0x309b847a">
634
                      <value _ptr_="0xcfe78b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
635
                        <value type="object" struct-name="db.mysql.IndexColumn" id="32380420-238c-11e3-a6f3-080027bcf912" struct-checksum="0x62630b3c">
636
                          <value type="int" key="columnLength">0</value>
637
                          <value type="string" key="comment"></value>
638
                          <value type="int" key="descend">0</value>
639
                          <link type="object" struct-name="db.Column" key="referencedColumn">2ebd5a70-238c-11e3-a6f3-080027bcf912</link>
640
                          <value type="string" key="name"></value>
641
                          <link type="object" struct-name="GrtObject" key="owner">3237d356-238c-11e3-a6f3-080027bcf912</link>
642
                        </value>
643
                      </value>
644
                      <value type="string" key="indexKind"></value>
645
                      <value type="int" key="keyBlockSize">0</value>
646
                      <value type="string" key="withParser"></value>
647
                      <value type="string" key="comment"></value>
648
                      <value type="int" key="deferability">0</value>
649
                      <value type="string" key="indexType">INDEX</value>
650
                      <value type="int" key="isPrimary">0</value>
651
                      <value type="string" key="name">fk_dataset_source2_idx</value>
652
                      <value type="int" key="unique">0</value>
653
                      <value type="string" key="oldName">fk_dataset_source2_idx</value>
654
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
655
                    </value>
593 656
                  </value>
594 657
                  <value type="string" key="maxRows"></value>
595 658
                  <value type="string" key="mergeInsert"></value>
......
621 684
                  <value type="int" key="commentedOut">0</value>
622 685
                  <value type="string" key="createDate">2013-04-16 14:58</value>
623 686
                  <value _ptr_="0xb401dc8" type="dict" key="customData"/>
624
                  <value type="string" key="lastChangeDate">2013-09-22 04:31</value>
687
                  <value type="string" key="lastChangeDate">2013-09-22 06:45</value>
625 688
                  <value type="int" key="modelOnly">0</value>
626 689
                  <value type="string" key="name">dataset</value>
627 690
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15854 15917
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15855 15918
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15856 15919
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6a2c268a-1dfc-11e3-bbb6-080027bcf912</link>
15857
                <value type="real" key="middleSegmentOffset">1.261547978531331182239227928221225738525390625e+01</value>
15920
                <value type="real" key="middleSegmentOffset">2.08463359189526045156526379287242889404296875e+01</value>
15858 15921
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15859 15922
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15860 15923
                <value type="int" key="drawSplit">0</value>
......
15906 15969
                <value type="int" key="visible">1</value>
15907 15970
                <value type="string" key="name"></value>
15908 15971
              </value>
15972
              <value type="object" struct-name="workbench.physical.Connection" id="32383a94-238c-11e3-a6f3-080027bcf912" struct-checksum="0x9baebc92">
15973
                <value type="string" key="caption">fk_dataset_source2</value>
15974
                <value type="real" key="captionXOffs">0.e+00</value>
15975
                <value type="real" key="captionYOffs">0.e+00</value>
15976
                <value type="string" key="comment"></value>
15977
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15978
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15979
                <value type="string" key="extraCaption"></value>
15980
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15981
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15982
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3237beb6-238c-11e3-a6f3-080027bcf912</link>
15983
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15984
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15985
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15986
                <value type="int" key="drawSplit">0</value>
15987
                <link type="object" struct-name="model.Figure" key="endFigure">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
15988
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15989
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15990
                <value type="int" key="visible">1</value>
15991
                <value type="string" key="name"></value>
15992
              </value>
15909 15993
            </value>
15910 15994
            <value type="string" key="description"></value>
15911 15995
            <value _ptr_="0xbc8d138" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15933 16017
                <value type="int" key="triggersExpanded">0</value>
15934 16018
                <value type="string" key="color">#99ccff</value>
15935 16019
                <value type="int" key="expanded">1</value>
15936
                <value type="real" key="height">1.46e+02</value>
16020
                <value type="real" key="height">1.69e+02</value>
15937 16021
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15938
                <value type="real" key="left">4.6e+01</value>
16022
                <value type="real" key="left">3.9e+01</value>
15939 16023
                <value type="int" key="locked">0</value>
15940 16024
                <value type="int" key="manualSizing">0</value>
15941 16025
                <value type="real" key="top">7.07e+02</value>
15942
                <value type="real" key="width">9.2e+01</value>
16026
                <value type="real" key="width">1.06e+02</value>
15943 16027
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15944 16028
                <value type="int" key="visible">1</value>
15945 16029
                <value type="string" key="name">dataset</value>
......
16475 16559
                <value type="int" key="expanded">1</value>
16476 16560
                <value type="real" key="height">1.23e+02</value>
16477 16561
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16478
                <value type="real" key="left">1.9e+01</value>
16562
                <value type="real" key="left">1.2e+01</value>
16479 16563
                <value type="int" key="locked">0</value>
16480 16564
                <value type="int" key="manualSizing">0</value>
16481 16565
                <value type="real" key="top">9.33e+02</value>
......
16941 17025
                <value type="int" key="expanded">1</value>
16942 17026
                <value type="real" key="height">7.7e+01</value>
16943 17027
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16944
                <value type="real" key="left">1.5e+01</value>
17028
                <value type="real" key="left">8.e+00</value>
16945 17029
                <value type="int" key="locked">0</value>
16946 17030
                <value type="int" key="manualSizing">0</value>
16947 17031
                <value type="real" key="top">1.098e+03</value>
......
17476 17560
                <value type="int" key="expanded">1</value>
17477 17561
                <value type="real" key="height">1.e+02</value>
17478 17562
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17479
                <value type="real" key="left">1.64e+02</value>
17563
                <value type="real" key="left">1.67e+02</value>
17480 17564
                <value type="int" key="locked">0</value>
17481 17565
                <value type="int" key="manualSizing">0</value>
17482
                <value type="real" key="top">6.7e+02</value>
17566
                <value type="real" key="top">6.74e+02</value>
17483 17567
                <value type="real" key="width">1.06e+02</value>
17484 17568
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17485 17569
                <value type="int" key="visible">1</value>
......
17661 17745
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17662 17746
        <value _ptr_="0xbbde3b8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17663 17747
        <value _ptr_="0xa949130" type="dict" key="syncProfiles">
17664
          <value type="object" struct-name="db.mgmt.SyncProfile" id="eba55122-2389-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17665
            <value _ptr_="0xcdb5c18" type="dict" key="lastKnownDBNames">
17748
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5be8da46-238d-11e3-a6f3-080027bcf912" struct-checksum="0xc64972c2" key="">
17749
            <value _ptr_="0xd3ea100" type="dict" key="lastKnownDBNames">
17666 17750
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17667 17751
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17668 17752
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
17763 17847
              <value type="string" key="2a08cd96-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1</value>
17764 17848
              <value type="string" key="2a08de6c-fa94-11e2-83d9-080027bcf912">fk_geovalidatable_place_geoplace1_idx</value>
17765 17849
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>
17850
              <value type="string" key="2ebd5a70-238c-11e3-a6f3-080027bcf912">metadata_source</value>
17766 17851
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>
17767 17852
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
17768 17853
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>
17769 17854
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>
17770 17855
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>
17771 17856
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
17857
              <value type="string" key="3237beb6-238c-11e3-a6f3-080027bcf912">fk_dataset_source2</value>
17858
              <value type="string" key="3237d356-238c-11e3-a6f3-080027bcf912">fk_dataset_source2_idx</value>
17772 17859
              <value type="string" key="323a36d4-011b-11e3-b872-080027bcf912">fk_individual_observation_place1</value>
17773 17860
              <value type="string" key="323a39a4-011b-11e3-b872-080027bcf912">place_observed_at</value>
17774 17861
              <value type="string" key="323a5f56-011b-11e3-b872-080027bcf912">fk_individual_observation_place1_idx</value>
......
17941 18028
              <value type="string" key="873d44bc-1df1-11e3-bbb6-080027bcf912">fk_source_party1</value>
17942 18029
              <value type="string" key="873d473c-1df1-11e3-bbb6-080027bcf912">contacts</value>
17943 18030
              <value type="string" key="8b8a694e-a792-11e2-84c3-080027bcf912">name</value>
18031
              <value type="string" key="8c119224-238a-11e3-a6f3-080027bcf912">fk_party_source1</value>
17944 18032
              <value type="string" key="8ed70288-ad14-11e2-9617-080027bcf912">PRIMARY</value>
17945 18033
              <value type="string" key="8f0c3678-f978-11e2-9f36-080027bcf912">rank</value>
17946 18034
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
......
18295 18383
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18296 18384
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18297 18385
      <value type="string" key="caption">New Model</value>
18298
      <value type="string" key="dateChanged">2013-09-22 06:29</value>
18386
      <value type="string" key="dateChanged">2013-09-22 06:46</value>
18299 18387
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18300 18388
      <value type="string" key="description"></value>
18301 18389
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
126 126
/*!40101 SET character_set_client = utf8 */;
127 127
CREATE TABLE `dataset` (
128 128
  `id` varbinary(767) NOT NULL,
129
  `metadata_source` varbinary(767) DEFAULT NULL COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)',
129 130
  `first_publisher` varbinary(767) DEFAULT NULL,
130 131
  `data_owners` varbinary(767) DEFAULT NULL COMMENT 'parties who must be given attribution, such as copyrightholders',
131 132
  `contacts` varbinary(767) DEFAULT NULL,
......
134 135
  KEY `fk_source_party2_idx` (`first_publisher`),
135 136
  KEY `fk_source_party_list1_idx` (`data_owners`),
136 137
  KEY `fk_source_party1_idx` (`contacts`),
138
  KEY `fk_dataset_source2_idx` (`metadata_source`),
137 139
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`metadata_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
138 141
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139 142
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 143
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
schemas/VegCore/VegCore.pg.sql
128 128
/*!40101 SET character_set_client = utf8 */;
129 129
CREATE TABLE "dataset" (
130 130
  "id" text NOT NULL,
131
  "metadata_source" text DEFAULT NULL /*COMMENT 'where the information *about* the dataset came from (as opposed to where the dataset came from)'*/,
131 132
  "first_publisher" text DEFAULT NULL,
132 133
  "data_owners" text DEFAULT NULL /*COMMENT 'parties who must be given attribution, such as copyrightholders'*/,
133 134
  "contacts" text DEFAULT NULL,
......
136 137
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
137 138
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),
138 139
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
140
  /*KEY "fk_dataset_source2_idx" ("metadata_source")*/CHECK (true),
139 141
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("metadata_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
140 143
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141 144
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142 145
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),

Also available in: Unified diff