Project

General

Profile

« Previous | Next » 

Revision 10970

schemas/VegCore/VegCore.ERD.mwb: source: allow multiple data owners

View differences:

schemas/VegCore/VegCore.pg.sql
813 813
  "parent" text DEFAULT NULL,
814 814
  "name" text NOT NULL,
815 815
  "first_publisher" text DEFAULT NULL,
816
  "owner" text DEFAULT NULL,
816
  "owners" text DEFAULT NULL,
817 817
  "info" hstore DEFAULT NULL,
818 818
  PRIMARY KEY ("id"),
819 819
  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),
820 820
  /*KEY "fk_source1_idx" ("parent")*/CHECK (true),
821
  /*KEY "fk_source_party1_idx" ("owner")*/CHECK (true),
822 821
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
822
  /*KEY "fk_source_party_list1_idx" ("owners")*/CHECK (true),
823
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
823 824
  /*CONSTRAINT "fk_source1" FOREIGN KEY ("parent") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
824
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("owner") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
825 825
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
826 826
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=reference&entity=dba_tabledescription&where=where_tablename)'*/;
827 827
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/document.mwb.xml
313 313
                      <value type="int" key="scale">-1</value>
314 314
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
315 315
                      <value type="string" key="comment"></value>
316
                      <value type="string" key="name">owner</value>
316
                      <value type="string" key="name">owners</value>
317 317
                      <value type="string" key="oldName">owner</value>
318 318
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
319 319
                    </value>
......
363 363
                      <value type="string" key="name">fk_source1</value>
364 364
                      <value type="string" key="oldName">fk_source1</value>
365 365
                    </value>
366
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c8552934-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x70a8fc40">
366
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
367 367
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
368
                      <value _ptr_="0xafb0e00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
369
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
368
                      <value _ptr_="0xafb1160" type="list" content-type="object" content-struct-name="db.Column" key="columns">
369
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
370 370
                      </value>
371 371
                      <value type="int" key="deferability">0</value>
372 372
                      <value type="string" key="deleteRule">CASCADE</value>
373
                      <link type="object" struct-name="db.Index" key="index">c8554edc-a7bc-11e2-8af2-080027bcf912</link>
373
                      <link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
374 374
                      <value type="int" key="mandatory">1</value>
375 375
                      <value type="int" key="many">1</value>
376 376
                      <value type="int" key="modelOnly">0</value>
377 377
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
378
                      <value _ptr_="0xafb10f0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
378
                      <value _ptr_="0xafb1450" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
379 379
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
380 380
                      </value>
381 381
                      <value type="int" key="referencedMandatory">0</value>
382 382
                      <value type="string" key="updateRule">CASCADE</value>
383 383
                      <value type="string" key="comment"></value>
384
                      <value type="string" key="name">fk_source_party1</value>
385
                      <value type="string" key="oldName">fk_source_party1</value>
384
                      <value type="string" key="name">fk_source_party2</value>
385
                      <value type="string" key="oldName">fk_source_party2</value>
386 386
                    </value>
387
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c7c1e6aa-a91b-11e2-bdec-080027bcf912" struct-checksum="0x70a8fc40">
388
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
389
                      <value _ptr_="0xafb1160" type="list" content-type="object" content-struct-name="db.Column" key="columns">
390
                        <link type="object">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
387
                    <value type="object" struct-name="db.mysql.ForeignKey" id="61c193a8-1dee-11e3-b571-080027bcf912" struct-checksum="0x70a8fc40">
388
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
389
                      <value _ptr_="0xc4c0500" type="list" content-type="object" content-struct-name="db.Column" key="columns">
390
                        <link type="object">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
391 391
                      </value>
392 392
                      <value type="int" key="deferability">0</value>
393 393
                      <value type="string" key="deleteRule">CASCADE</value>
394
                      <link type="object" struct-name="db.Index" key="index">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
394
                      <link type="object" struct-name="db.Index" key="index">61c1b04a-1dee-11e3-b571-080027bcf912</link>
395 395
                      <value type="int" key="mandatory">1</value>
396 396
                      <value type="int" key="many">1</value>
397 397
                      <value type="int" key="modelOnly">0</value>
398 398
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
399
                      <value _ptr_="0xafb1450" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
400
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
399
                      <value _ptr_="0xc2ff5e0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
400
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
401 401
                      </value>
402
                      <value type="int" key="referencedMandatory">0</value>
402
                      <value type="int" key="referencedMandatory">1</value>
403 403
                      <value type="string" key="updateRule">CASCADE</value>
404 404
                      <value type="string" key="comment"></value>
405
                      <value type="string" key="name">fk_source_party2</value>
406
                      <value type="string" key="oldName">fk_source_party2</value>
405
                      <value type="string" key="name">fk_source_party_list1</value>
406
                      <value type="string" key="oldName">fk_source_party_list1</value>
407 407
                    </value>
408 408
                  </value>
409 409
                  <value _ptr_="0xafaed78" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
484 484
                      <value type="string" key="oldName">fk_source1_idx</value>
485 485
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
486 486
                    </value>
487
                    <value type="object" struct-name="db.mysql.Index" id="c8554edc-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x309b847a">
488
                      <value _ptr_="0xafb2768" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
489
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c85550b2-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x62630b3c">
487
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
488
                      <value _ptr_="0xafb2d98" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
489
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
490 490
                          <value type="int" key="columnLength">0</value>
491 491
                          <value type="string" key="comment"></value>
492 492
                          <value type="int" key="descend">0</value>
493
                          <link type="object" struct-name="db.Column" key="referencedColumn">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
493
                          <link type="object" struct-name="db.Column" key="referencedColumn">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
494 494
                          <value type="string" key="name"></value>
495
                          <link type="object" struct-name="GrtObject" key="owner">c8554edc-a7bc-11e2-8af2-080027bcf912</link>
495
                          <link type="object" struct-name="GrtObject" key="owner">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
496 496
                        </value>
497 497
                      </value>
498 498
                      <value type="string" key="indexKind"></value>
......
502 502
                      <value type="int" key="deferability">0</value>
503 503
                      <value type="string" key="indexType">INDEX</value>
504 504
                      <value type="int" key="isPrimary">0</value>
505
                      <value type="string" key="name">fk_source_party1_idx</value>
505
                      <value type="string" key="name">fk_source_party2_idx</value>
506 506
                      <value type="int" key="unique">0</value>
507
                      <value type="string" key="oldName">fk_source_party1_idx</value>
507
                      <value type="string" key="oldName">fk_source_party2_idx</value>
508 508
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
509 509
                    </value>
510
                    <value type="object" struct-name="db.mysql.Index" id="c7c2089c-a91b-11e2-bdec-080027bcf912" struct-checksum="0x309b847a">
511
                      <value _ptr_="0xafb2d98" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
512
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c7c20a4a-a91b-11e2-bdec-080027bcf912" struct-checksum="0x62630b3c">
510
                    <value type="object" struct-name="db.mysql.Index" id="61c1b04a-1dee-11e3-b571-080027bcf912" struct-checksum="0x309b847a">
511
                      <value _ptr_="0xc536c00" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
512
                        <value type="object" struct-name="db.mysql.IndexColumn" id="61c1e9d4-1dee-11e3-b571-080027bcf912" struct-checksum="0x62630b3c">
513 513
                          <value type="int" key="columnLength">0</value>
514 514
                          <value type="string" key="comment"></value>
515 515
                          <value type="int" key="descend">0</value>
516
                          <link type="object" struct-name="db.Column" key="referencedColumn">c7c1e862-a91b-11e2-bdec-080027bcf912</link>
516
                          <link type="object" struct-name="db.Column" key="referencedColumn">c8552b14-a7bc-11e2-8af2-080027bcf912</link>
517 517
                          <value type="string" key="name"></value>
518
                          <link type="object" struct-name="GrtObject" key="owner">c7c2089c-a91b-11e2-bdec-080027bcf912</link>
518
                          <link type="object" struct-name="GrtObject" key="owner">61c1b04a-1dee-11e3-b571-080027bcf912</link>
519 519
                        </value>
520 520
                      </value>
521 521
                      <value type="string" key="indexKind"></value>
......
525 525
                      <value type="int" key="deferability">0</value>
526 526
                      <value type="string" key="indexType">INDEX</value>
527 527
                      <value type="int" key="isPrimary">0</value>
528
                      <value type="string" key="name">fk_source_party2_idx</value>
528
                      <value type="string" key="name">fk_source_party_list1_idx</value>
529 529
                      <value type="int" key="unique">0</value>
530
                      <value type="string" key="oldName">fk_source_party2_idx</value>
530
                      <value type="string" key="oldName">fk_source_party_list1</value>
531 531
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
532 532
                    </value>
533 533
                  </value>
......
561 561
                  <value type="int" key="commentedOut">0</value>
562 562
                  <value type="string" key="createDate">2013-04-16 14:58</value>
563 563
                  <value _ptr_="0xafa3078" type="dict" key="customData"/>
564
                  <value type="string" key="lastChangeDate">2013-07-30 18:38</value>
564
                  <value type="string" key="lastChangeDate">2013-09-15 03:05</value>
565 565
                  <value type="int" key="modelOnly">0</value>
566 566
                  <value type="string" key="name">source</value>
567 567
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
13702 13702
                <value type="int" key="visible">1</value>
13703 13703
                <value type="string" key="name"></value>
13704 13704
              </value>
13705
              <value type="object" struct-name="workbench.physical.Connection" id="c855694e-a7bc-11e2-8af2-080027bcf912" struct-checksum="0x9baebc92">
13706
                <value type="string" key="caption">fk_source_party1</value>
13707
                <value type="real" key="captionXOffs">0.e+00</value>
13708
                <value type="real" key="captionYOffs">0.e+00</value>
13709
                <value type="string" key="comment"></value>
13710
                <value type="real" key="endCaptionXOffs">0.e+00</value>
13711
                <value type="real" key="endCaptionYOffs">0.e+00</value>
13712
                <value type="string" key="extraCaption"></value>
13713
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13714
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13715
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c8552934-a7bc-11e2-8af2-080027bcf912</link>
13716
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13717
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13718
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13719
                <value type="int" key="drawSplit">0</value>
13720
                <link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
13721
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
13722
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13723
                <value type="int" key="visible">1</value>
13724
                <value type="string" key="name"></value>
13725
              </value>
13726 13705
              <value type="object" struct-name="workbench.physical.Connection" id="18e780f4-a91b-11e2-bdec-080027bcf912" struct-checksum="0x9baebc92">
13727 13706
                <value type="string" key="caption">fk_organization_party1</value>
13728 13707
                <value type="real" key="captionXOffs">0.e+00</value>
......
15445 15424
                <value type="int" key="visible">1</value>
15446 15425
                <value type="string" key="name"></value>
15447 15426
              </value>
15427
              <value type="object" struct-name="workbench.physical.Connection" id="61c21efe-1dee-11e3-b571-080027bcf912" struct-checksum="0x9baebc92">
15428
                <value type="string" key="caption">fk_source_party_list1</value>
15429
                <value type="real" key="captionXOffs">0.e+00</value>
15430
                <value type="real" key="captionYOffs">0.e+00</value>
15431
                <value type="string" key="comment"></value>
15432
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15433
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15434
                <value type="string" key="extraCaption"></value>
15435
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15436
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15437
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">61c193a8-1dee-11e3-b571-080027bcf912</link>
15438
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15439
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15440
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15441
                <value type="int" key="drawSplit">1</value>
15442
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
15443
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15444
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15445
                <value type="int" key="visible">1</value>
15446
                <value type="string" key="name"></value>
15447
              </value>
15448 15448
            </value>
15449 15449
            <value type="string" key="description"></value>
15450 15450
            <value _ptr_="0xb052618" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15474 15474
                <value type="int" key="expanded">1</value>
15475 15475
                <value type="real" key="height">1.69e+02</value>
15476 15476
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15477
                <value type="real" key="left">1.9e+01</value>
15477
                <value type="real" key="left">2.e+01</value>
15478 15478
                <value type="int" key="locked">0</value>
15479 15479
                <value type="int" key="manualSizing">0</value>
15480
                <value type="real" key="top">5.53e+02</value>
15480
                <value type="real" key="top">5.65e+02</value>
15481 15481
                <value type="real" key="width">9.e+01</value>
15482 15482
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15483 15483
                <value type="int" key="visible">1</value>
......
16017 16017
                <value type="real" key="left">3.8e+01</value>
16018 16018
                <value type="int" key="locked">0</value>
16019 16019
                <value type="int" key="manualSizing">0</value>
16020
                <value type="real" key="top">9.97e+02</value>
16020
                <value type="real" key="top">8.85e+02</value>
16021 16021
                <value type="real" key="width">8.1e+01</value>
16022 16022
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16023 16023
                <value type="int" key="visible">1</value>
......
16480 16480
                <value type="int" key="expanded">1</value>
16481 16481
                <value type="real" key="height">7.7e+01</value>
16482 16482
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16483
                <value type="real" key="left">3.4e+01</value>
16483
                <value type="real" key="left">2.4e+01</value>
16484 16484
                <value type="int" key="locked">0</value>
16485 16485
                <value type="int" key="manualSizing">0</value>
16486
                <value type="real" key="top">1.143e+03</value>
16486
                <value type="real" key="top">1.031e+03</value>
16487 16487
                <value type="real" key="width">1.21e+02</value>
16488 16488
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16489 16489
                <value type="int" key="visible">1</value>
......
16623 16623
                <value type="real" key="left">1.82e+02</value>
16624 16624
                <value type="int" key="locked">0</value>
16625 16625
                <value type="int" key="manualSizing">0</value>
16626
                <value type="real" key="top">8.75e+02</value>
16626
                <value type="real" key="top">7.58e+02</value>
16627 16627
                <value type="real" key="width">1.03e+02</value>
16628 16628
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16629 16629
                <value type="int" key="visible">1</value>
......
16643 16643
                <value type="real" key="left">1.41e+02</value>
16644 16644
                <value type="int" key="locked">0</value>
16645 16645
                <value type="int" key="manualSizing">0</value>
16646
                <value type="real" key="top">9.74e+02</value>
16646
                <value type="real" key="top">8.62e+02</value>
16647 16647
                <value type="real" key="width">1.39e+02</value>
16648 16648
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16649 16649
                <value type="int" key="visible">1</value>
......
17179 17179
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17180 17180
        <value _ptr_="0xafa7770" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17181 17181
        <value _ptr_="0xa484468" type="dict" key="syncProfiles">
17182
          <value type="object" struct-name="db.mgmt.SyncProfile" id="22ae8c30-1ded-11e3-b571-080027bcf912" struct-checksum="0xc64972c2" key="">
17183
            <value _ptr_="0xae06388" type="dict" key="lastKnownDBNames">
17182
          <value type="object" struct-name="db.mgmt.SyncProfile" id="0a8552f0-1dee-11e3-b571-080027bcf912" struct-checksum="0xc64972c2" key="">
17183
            <value _ptr_="0xc6de820" type="dict" key="lastKnownDBNames">
17184 17184
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17185 17185
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
17186 17186
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
17799 17799
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17800 17800
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17801 17801
      <value type="string" key="caption">New Model</value>
17802
      <value type="string" key="dateChanged">2013-09-15 03:03</value>
17802
      <value type="string" key="dateChanged">2013-09-15 03:08</value>
17803 17803
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17804 17804
      <value type="string" key="description"></value>
17805 17805
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
811 811
  `parent` varbinary(767) DEFAULT NULL,
812 812
  `name` varbinary(767) NOT NULL,
813 813
  `first_publisher` varbinary(767) DEFAULT NULL,
814
  `owner` varbinary(767) DEFAULT NULL,
814
  `owners` varbinary(767) DEFAULT NULL,
815 815
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
816 816
  PRIMARY KEY (`id`),
817 817
  UNIQUE KEY `source_unique` (`parent`,`name`),
818 818
  KEY `fk_source1_idx` (`parent`),
819
  KEY `fk_source_party1_idx` (`owner`),
820 819
  KEY `fk_source_party2_idx` (`first_publisher`),
820
  KEY `fk_source_party_list1_idx` (`owners`),
821
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
821 822
  CONSTRAINT `fk_source1` FOREIGN KEY (`parent`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
822
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`owner`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
823 823
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
824 824
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='a "reference [...] cited within the database" ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=reference&entity=dba_tabledescription&where=where_tablename)';
825 825
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff