Project

General

Profile

« Previous | Next » 

Revision 11188

schemas/VegCore/ERD/VegCore.ERD.mwb: dataset.first_publisher: allow this to be any kind of source, rather than just a party (i.e. an organization). this is possible now that party inherits from source.

View differences:

schemas/VegCore/ERD/document.mwb.xml
403 403
                      <value type="string" key="oldName">fk_dataset_traceable1</value>
404 404
                    </value>
405 405
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
406
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
406
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
407 407
                      <value _ptr_="0xba59e70" type="list" content-type="object" content-struct-name="db.Column" key="columns">
408 408
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
409 409
                      </value>
410 410
                      <value type="int" key="deferability">0</value>
411 411
                      <value type="string" key="deleteRule">CASCADE</value>
412
                      <link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
412
                      <link type="object" struct-name="db.Index" key="index">170b9dc8-310c-11e3-ab47-080027bcf912</link>
413 413
                      <value type="int" key="mandatory">1</value>
414 414
                      <value type="int" key="many">1</value>
415 415
                      <value type="int" key="modelOnly">0</value>
416 416
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
417 417
                      <value _ptr_="0xba5a160" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
418
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
418
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
419 419
                      </value>
420 420
                      <value type="int" key="referencedMandatory">0</value>
421 421
                      <value type="string" key="updateRule">CASCADE</value>
......
500 500
                      <value type="string" key="oldName">dataset_unique</value>
501 501
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
502 502
                    </value>
503
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
504
                      <value _ptr_="0xba5a898" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
505
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
506
                          <value type="int" key="columnLength">0</value>
507
                          <value type="string" key="comment"></value>
508
                          <value type="int" key="descend">0</value>
509
                          <link type="object" struct-name="db.Column" key="referencedColumn">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
510
                          <value type="string" key="name"></value>
511
                          <link type="object" struct-name="GrtObject" key="owner">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
512
                        </value>
513
                      </value>
514
                      <value type="string" key="indexKind"></value>
515
                      <value type="int" key="keyBlockSize">0</value>
516
                      <value type="string" key="withParser"></value>
517
                      <value type="string" key="comment"></value>
518
                      <value type="int" key="deferability">0</value>
519
                      <value type="string" key="indexType">INDEX</value>
520
                      <value type="int" key="isPrimary">0</value>
521
                      <value type="string" key="name">fk_source_party2_idx</value>
522
                      <value type="int" key="unique">0</value>
523
                      <value type="string" key="oldName">fk_source_party2_idx</value>
524
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
525
                    </value>
526 503
                    <value type="object" struct-name="db.mysql.Index" id="61c1b04a-1dee-11e3-b571-080027bcf912" struct-checksum="0x309b847a">
527 504
                      <value _ptr_="0xba5aec8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
528 505
                        <value type="object" struct-name="db.mysql.IndexColumn" id="61c1e9d4-1dee-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">
......
615 592
                      <value type="string" key="oldName">fk_dataset_dataset1_idx</value>
616 593
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
617 594
                    </value>
595
                    <value type="object" struct-name="db.mysql.Index" id="170b9dc8-310c-11e3-ab47-080027bcf912" struct-checksum="0x309b847a">
596
                      <value _ptr_="0xc776b88" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
597
                        <value type="object" struct-name="db.mysql.IndexColumn" id="170cb686-310c-11e3-ab47-080027bcf912" struct-checksum="0x62630b3c">
598
                          <value type="int" key="columnLength">0</value>
599
                          <value type="string" key="comment"></value>
600
                          <value type="int" key="descend">0</value>
601
                          <link type="object" struct-name="db.Column" key="referencedColumn">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
602
                          <value type="string" key="name"></value>
603
                          <link type="object" struct-name="GrtObject" key="owner">170b9dc8-310c-11e3-ab47-080027bcf912</link>
604
                        </value>
605
                      </value>
606
                      <value type="string" key="indexKind"></value>
607
                      <value type="int" key="keyBlockSize">0</value>
608
                      <value type="string" key="withParser"></value>
609
                      <value type="string" key="comment"></value>
610
                      <value type="int" key="deferability">0</value>
611
                      <value type="string" key="indexType">INDEX</value>
612
                      <value type="int" key="isPrimary">0</value>
613
                      <value type="string" key="name">fk_source_party2_idx</value>
614
                      <value type="int" key="unique">0</value>
615
                      <value type="string" key="oldName">fk_source_party2</value>
616
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
617
                    </value>
618 618
                  </value>
619 619
                  <value type="string" key="maxRows"></value>
620 620
                  <value type="string" key="mergeInsert"></value>
......
646 646
                  <value type="int" key="commentedOut">0</value>
647 647
                  <value type="string" key="createDate">2013-04-16 14:58</value>
648 648
                  <value _ptr_="0xba4cf98" type="dict" key="customData"/>
649
                  <value type="string" key="lastChangeDate">2013-10-09 10:45</value>
649
                  <value type="string" key="lastChangeDate">2013-10-09 10:56</value>
650 650
                  <value type="int" key="modelOnly">0</value>
651 651
                  <value type="string" key="name">dataset</value>
652 652
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
13916 13916
                <value type="int" key="visible">1</value>
13917 13917
                <value type="string" key="name"></value>
13918 13918
              </value>
13919
              <value type="object" struct-name="workbench.physical.Connection" id="c7c217ce-a91b-11e2-bdec-080027bcf912" struct-checksum="0x9baebc92">
13920
                <value type="string" key="caption">fk_source_party2</value>
13921
                <value type="real" key="captionXOffs">0.e+00</value>
13922
                <value type="real" key="captionYOffs">0.e+00</value>
13923
                <value type="string" key="comment"></value>
13924
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13925
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13926
                <value type="string" key="extraCaption"></value>
13927
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13928
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13929
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c7c1e6aa-a91b-11e2-bdec-080027bcf912</link>
13930
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13931
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13932
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13933
                <value type="int" key="drawSplit">0</value>
13934
                <link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
13935
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
13936
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13937
                <value type="int" key="visible">1</value>
13938
                <value type="string" key="name"></value>
13939
              </value>
13940 13919
              <value type="object" struct-name="workbench.physical.Connection" id="c37e75e6-ac44-11e2-820d-080027bcf912" struct-checksum="0x9baebc92">
13941 13920
                <value type="string" key="caption">fk_collection_source10</value>
13942 13921
                <value type="real" key="captionXOffs">0.e+00</value>
......
15376 15355
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15377 15356
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15378 15357
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7e2aa84c-1dfb-11e3-bbb6-080027bcf912</link>
15379
                <value type="real" key="middleSegmentOffset">3.0776094685194266276084817945957183837890625e+00</value>
15358
                <value type="real" key="middleSegmentOffset">5.6161081099920693304738961160182952880859375e+00</value>
15380 15359
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15381 15360
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15382 15361
                <value type="int" key="drawSplit">0</value>
......
15397 15376
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15398 15377
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15399 15378
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6a2c268a-1dfc-11e3-bbb6-080027bcf912</link>
15400
                <value type="real" key="middleSegmentOffset">1.923641312073272047200589440762996673583984375e+00</value>
15379
                <value type="real" key="middleSegmentOffset">-3.8402540441671817461610771715641021728515625e-01</value>
15401 15380
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15402 15381
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15403 15382
                <value type="int" key="drawSplit">0</value>
......
15460 15439
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15461 15440
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15462 15441
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3237beb6-238c-11e3-a6f3-080027bcf912</link>
15463
                <value type="real" key="middleSegmentOffset">-3.4612302949320792322396300733089447021484375e+00</value>
15442
                <value type="real" key="middleSegmentOffset">-9.99670615550030561280436813831329345703125e-01</value>
15464 15443
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15465 15444
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15466 15445
                <value type="int" key="drawSplit">0</value>
......
15743 15722
                <value type="int" key="visible">1</value>
15744 15723
                <value type="string" key="name"></value>
15745 15724
              </value>
15725
              <value type="object" struct-name="workbench.physical.Connection" id="170b929c-310c-11e3-ab47-080027bcf912" struct-checksum="0x9baebc92">
15726
                <value type="string" key="caption">fk_source_party2</value>
15727
                <value type="real" key="captionXOffs">0.e+00</value>
15728
                <value type="real" key="captionYOffs">0.e+00</value>
15729
                <value type="string" key="comment"></value>
15730
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15731
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15732
                <value type="string" key="extraCaption"></value>
15733
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15734
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15735
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c7c1e6aa-a91b-11e2-bdec-080027bcf912</link>
15736
                <value type="real" key="middleSegmentOffset">-5.9997127973000488054822199046611785888671875e+00</value>
15737
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15738
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15739
                <value type="int" key="drawSplit">0</value>
15740
                <link type="object" struct-name="model.Figure" key="endFigure">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
15741
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15742
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15743
                <value type="int" key="visible">1</value>
15744
                <value type="string" key="name"></value>
15745
              </value>
15746 15746
            </value>
15747 15747
            <value type="string" key="description"></value>
15748 15748
            <value _ptr_="0xbb01670" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15775 15775
                <value type="real" key="left">4.2e+01</value>
15776 15776
                <value type="int" key="locked">0</value>
15777 15777
                <value type="int" key="manualSizing">0</value>
15778
                <value type="real" key="top">6.96e+02</value>
15778
                <value type="real" key="top">7.e+02</value>
15779 15779
                <value type="real" key="width">9.7e+01</value>
15780 15780
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15781 15781
                <value type="int" key="visible">1</value>
......
16312 16312
                <value type="int" key="expanded">1</value>
16313 16313
                <value type="real" key="height">5.4e+01</value>
16314 16314
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16315
                <value type="real" key="left">2.1e+01</value>
16315
                <value type="real" key="left">1.8e+01</value>
16316 16316
                <value type="int" key="locked">0</value>
16317 16317
                <value type="int" key="manualSizing">0</value>
16318 16318
                <value type="real" key="top">9.67e+02</value>
......
16778 16778
                <value type="int" key="expanded">1</value>
16779 16779
                <value type="real" key="height">1.e+02</value>
16780 16780
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16781
                <value type="real" key="left">7.e+00</value>
16781
                <value type="real" key="left">4.e+00</value>
16782 16782
                <value type="int" key="locked">0</value>
16783 16783
                <value type="int" key="manualSizing">0</value>
16784 16784
                <value type="real" key="top">1.175e+03</value>
......
17296 17296
                <value type="real" key="left">1.75e+02</value>
17297 17297
                <value type="int" key="locked">0</value>
17298 17298
                <value type="int" key="manualSizing">0</value>
17299
                <value type="real" key="top">6.77e+02</value>
17299
                <value type="real" key="top">6.81e+02</value>
17300 17300
                <value type="real" key="width">1.06e+02</value>
17301 17301
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17302 17302
                <value type="int" key="visible">1</value>
......
17313 17313
                <value type="int" key="expanded">1</value>
17314 17314
                <value type="real" key="height">1.23e+02</value>
17315 17315
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17316
                <value type="real" key="left">1.9e+01</value>
17316
                <value type="real" key="left">2.3e+01</value>
17317 17317
                <value type="int" key="locked">0</value>
17318 17318
                <value type="int" key="manualSizing">0</value>
17319 17319
                <value type="real" key="top">5.41e+02</value>
......
17333 17333
                <value type="int" key="expanded">1</value>
17334 17334
                <value type="real" key="height">1.e+02</value>
17335 17335
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17336
                <value type="real" key="left">5.6e+01</value>
17336
                <value type="real" key="left">5.3e+01</value>
17337 17337
                <value type="int" key="locked">0</value>
17338 17338
                <value type="int" key="manualSizing">0</value>
17339 17339
                <value type="real" key="top">1.047e+03</value>
......
17485 17485
              <value type="int" key="visible">1</value>
17486 17486
              <value type="string" key="name"></value>
17487 17487
            </value>
17488
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17489
              <link type="object">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
17490
            </value>
17488
            <value _ptr_="0xbb01748" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17491 17489
            <value type="int" key="updateBlocked">0</value>
17492 17490
            <value type="real" key="width">1.6215e+03</value>
17493 17491
            <value type="real" key="x">0.e+00</value>
......
17500 17498
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17501 17499
        <value _ptr_="0xba53b00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17502 17500
        <value _ptr_="0xb0204c8" type="dict" key="syncProfiles">
17503
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6a827b6a-3108-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17504
            <value _ptr_="0xc24b140" type="dict" key="lastKnownDBNames">
17501
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9897e010-310a-11e3-ab47-080027bcf912" struct-checksum="0xc64972c2" key="">
17502
            <value _ptr_="0xc93b428" type="dict" key="lastKnownDBNames">
17505 17503
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17506 17504
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17507 17505
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18126 18124
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18127 18125
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18128 18126
      <value type="string" key="caption">New Model</value>
18129
      <value type="string" key="dateChanged">2013-10-09 10:45</value>
18127
      <value type="string" key="dateChanged">2013-10-09 10:59</value>
18130 18128
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18131 18129
      <value type="string" key="description"></value>
18132 18130
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
130 130
  `contacts` varbinary(767) DEFAULT NULL,
131 131
  PRIMARY KEY (`id`),
132 132
  UNIQUE KEY `dataset_unique` (`parent`,`name`),
133
  KEY `fk_source_party2_idx` (`first_publisher`),
134 133
  KEY `fk_source_party_list1_idx` (`data_owners`),
135 134
  KEY `fk_source_party1_idx` (`contacts`),
136 135
  KEY `fk_dataset_source2_idx` (`dataset_source`),
137 136
  KEY `fk_dataset_dataset1_idx` (`parent`),
138
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
137
  KEY `fk_source_party2_idx` (`first_publisher`),
138
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
139
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
140 140
  CONSTRAINT `fk_dataset_dataset1` FOREIGN KEY (`parent`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
141 141
  CONSTRAINT `fk_dataset_source1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142
  CONSTRAINT `fk_dataset_source2` FOREIGN KEY (`dataset_source`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
142 143
  CONSTRAINT `fk_dataset_traceable1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
143
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
144 144
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`data_owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
145 145
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements';
146 146
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
132 132
  "contacts" text DEFAULT NULL,
133 133
  PRIMARY KEY ("id"),
134 134
  /*CONSTRAINT "dataset_unique" */UNIQUE ("parent","name"),
135
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
136 135
  /*KEY "fk_source_party_list1_idx" ("data_owners")*/CHECK (true),
137 136
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
138 137
  /*KEY "fk_dataset_source2_idx" ("dataset_source")*/CHECK (true),
139 138
  /*KEY "fk_dataset_dataset1_idx" ("parent")*/CHECK (true),
140
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
139
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
140
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
141
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
142 142
  /*CONSTRAINT "fk_dataset_dataset1" FOREIGN KEY ("parent") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
143 143
  /*CONSTRAINT "fk_dataset_source1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144
  /*CONSTRAINT "fk_dataset_source2" FOREIGN KEY ("dataset_source") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
144 145
  /*CONSTRAINT "fk_dataset_traceable1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
145
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
146 146
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("data_owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
147 147
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a collection of records from the same place, with the same attribution requirements'*/;
148 148
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff