Project

General

Profile

« Previous | Next » 

Revision 10973

schemas/VegCore/VegCore.ERD.mwb: source: allow multiple contacts

View differences:

schemas/VegCore/VegCore.pg.sql
814 814
  "name" text NOT NULL,
815 815
  "first_publisher" text DEFAULT NULL,
816 816
  "owners" text DEFAULT NULL,
817
  "contact" text DEFAULT NULL,
817
  "contacts" text DEFAULT NULL,
818 818
  "info" hstore DEFAULT NULL,
819 819
  PRIMARY KEY ("id"),
820 820
  /*CONSTRAINT "source_unique" */UNIQUE ("parent","name"),
821 821
  /*KEY "fk_source1_idx" ("parent")*/CHECK (true),
822 822
  /*KEY "fk_source_party2_idx" ("first_publisher")*/CHECK (true),
823 823
  /*KEY "fk_source_party_list1_idx" ("owners")*/CHECK (true),
824
  /*KEY "fk_source_party1_idx" ("contact")*/CHECK (true),
824
  /*KEY "fk_source_party1_idx" ("contacts")*/CHECK (true),
825
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contacts") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
825 826
  /*CONSTRAINT "fk_source1" FOREIGN KEY ("parent") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
826 827
  /*CONSTRAINT "fk_source_party2" FOREIGN KEY ("first_publisher") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
827
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
828
  /*CONSTRAINT "fk_source_party1" FOREIGN KEY ("contact") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
828
  /*CONSTRAINT "fk_source_party_list1" FOREIGN KEY ("owners") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
829 829
) /*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)'*/;
830 830
/*!40101 SET character_set_client = @saved_cs_client */;
831 831

  
schemas/VegCore/document.mwb.xml
332 332
                      <value type="int" key="scale">-1</value>
333 333
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
334 334
                      <value type="string" key="comment"></value>
335
                      <value type="string" key="name">contact</value>
335
                      <value type="string" key="name">contacts</value>
336 336
                      <value type="string" key="oldName">contact</value>
337 337
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
338 338
                    </value>
......
425 425
                      <value type="string" key="oldName">fk_source_party_list1</value>
426 426
                    </value>
427 427
                    <value type="object" struct-name="db.mysql.ForeignKey" id="873d44bc-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x70a8fc40">
428
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
428
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
429 429
                      <value _ptr_="0xbcce960" type="list" content-type="object" content-struct-name="db.Column" key="columns">
430 430
                        <link type="object">873d473c-1df1-11e3-bbb6-080027bcf912</link>
431 431
                      </value>
432 432
                      <value type="int" key="deferability">0</value>
433 433
                      <value type="string" key="deleteRule">CASCADE</value>
434
                      <link type="object" struct-name="db.Index" key="index">873e2db4-1df1-11e3-bbb6-080027bcf912</link>
434
                      <link type="object" struct-name="db.Index" key="index">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
435 435
                      <value type="int" key="mandatory">1</value>
436 436
                      <value type="int" key="many">1</value>
437 437
                      <value type="int" key="modelOnly">0</value>
438 438
                      <link type="object" struct-name="db.Table" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
439 439
                      <value _ptr_="0xbcd3068" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
440
                        <link type="object">be8fe97a-a6e0-11e2-95e9-080027bcf912</link>
440
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
441 441
                      </value>
442 442
                      <value type="int" key="referencedMandatory">0</value>
443 443
                      <value type="string" key="updateRule">CASCADE</value>
......
570 570
                      <value type="string" key="oldName">fk_source_party_list1_idx</value>
571 571
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
572 572
                    </value>
573
                    <value type="object" struct-name="db.mysql.Index" id="873e2db4-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">
574
                      <value _ptr_="0xbc15da0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
575
                        <value type="object" struct-name="db.mysql.IndexColumn" id="873e5c4e-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">
573
                    <value type="object" struct-name="db.mysql.Index" id="d2855d46-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">
574
                      <value _ptr_="0xbcb2f20" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
575
                        <value type="object" struct-name="db.mysql.IndexColumn" id="d2867b72-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x62630b3c">
576 576
                          <value type="int" key="columnLength">0</value>
577 577
                          <value type="string" key="comment"></value>
578 578
                          <value type="int" key="descend">0</value>
579 579
                          <link type="object" struct-name="db.Column" key="referencedColumn">873d473c-1df1-11e3-bbb6-080027bcf912</link>
580 580
                          <value type="string" key="name"></value>
581
                          <link type="object" struct-name="GrtObject" key="owner">873e2db4-1df1-11e3-bbb6-080027bcf912</link>
581
                          <link type="object" struct-name="GrtObject" key="owner">d2855d46-1df2-11e3-bbb6-080027bcf912</link>
582 582
                        </value>
583 583
                      </value>
584 584
                      <value type="string" key="indexKind"></value>
......
590 590
                      <value type="int" key="isPrimary">0</value>
591 591
                      <value type="string" key="name">fk_source_party1_idx</value>
592 592
                      <value type="int" key="unique">0</value>
593
                      <value type="string" key="oldName">fk_source_party1_idx</value>
593
                      <value type="string" key="oldName">fk_source_party1</value>
594 594
                      <link type="object" struct-name="GrtObject" key="owner">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
595 595
                    </value>
596 596
                  </value>
......
624 624
                  <value type="int" key="commentedOut">0</value>
625 625
                  <value type="string" key="createDate">2013-04-16 14:58</value>
626 626
                  <value _ptr_="0xb1fbb70" type="dict" key="customData"/>
627
                  <value type="string" key="lastChangeDate">2013-09-15 03:32</value>
627
                  <value type="string" key="lastChangeDate">2013-09-15 03:37</value>
628 628
                  <value type="int" key="modelOnly">0</value>
629 629
                  <value type="string" key="name">source</value>
630 630
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15508 15508
                <value type="int" key="visible">1</value>
15509 15509
                <value type="string" key="name"></value>
15510 15510
              </value>
15511
              <value type="object" struct-name="workbench.physical.Connection" id="873e8a7a-1df1-11e3-bbb6-080027bcf912" struct-checksum="0x9baebc92">
15511
              <value type="object" struct-name="workbench.physical.Connection" id="d2855292-1df2-11e3-bbb6-080027bcf912" struct-checksum="0x9baebc92">
15512 15512
                <value type="string" key="caption">fk_source_party1</value>
15513 15513
                <value type="real" key="captionXOffs">0.e+00</value>
15514 15514
                <value type="real" key="captionYOffs">0.e+00</value>
......
15519 15519
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15520 15520
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15521 15521
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">873d44bc-1df1-11e3-bbb6-080027bcf912</link>
15522
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15522
                <value type="real" key="middleSegmentOffset">6.92314210022942688738112337887287139892578125e-01</value>
15523 15523
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15524 15524
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15525
                <value type="int" key="drawSplit">0</value>
15526
                <link type="object" struct-name="model.Figure" key="endFigure">EE4765B7-0391-4132-8813-84A6E788C01D</link>
15525
                <value type="int" key="drawSplit">1</value>
15526
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
15527 15527
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15528 15528
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15529 15529
                <value type="int" key="visible">1</value>
......
15558 15558
                <value type="int" key="expanded">1</value>
15559 15559
                <value type="real" key="height">1.92e+02</value>
15560 15560
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15561
                <value type="real" key="left">1.9e+01</value>
15561
                <value type="real" key="left">2.e+01</value>
15562 15562
                <value type="int" key="locked">0</value>
15563 15563
                <value type="int" key="manualSizing">0</value>
15564
                <value type="real" key="top">5.65e+02</value>
15564
                <value type="real" key="top">5.66e+02</value>
15565 15565
                <value type="real" key="width">9.e+01</value>
15566 15566
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15567 15567
                <value type="int" key="visible">1</value>
......
17250 17250
              <value type="int" key="visible">1</value>
17251 17251
              <value type="string" key="name"></value>
17252 17252
            </value>
17253
            <value _ptr_="0xb2a88d8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17254
              <link type="object">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
17255
            </value>
17253
            <value _ptr_="0xb2a88d8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17256 17254
            <value type="int" key="updateBlocked">0</value>
17257 17255
            <value type="real" key="width">1.6215e+03</value>
17258 17256
            <value type="real" key="x">0.e+00</value>
......
17888 17886
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17889 17887
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17890 17888
      <value type="string" key="caption">New Model</value>
17891
      <value type="string" key="dateChanged">2013-09-15 03:33</value>
17889
      <value type="string" key="dateChanged">2013-09-15 03:38</value>
17892 17890
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17893 17891
      <value type="string" key="description"></value>
17894 17892
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
812 812
  `name` varbinary(767) NOT NULL,
813 813
  `first_publisher` varbinary(767) DEFAULT NULL,
814 814
  `owners` varbinary(767) DEFAULT NULL,
815
  `contact` varbinary(767) DEFAULT NULL,
815
  `contacts` varbinary(767) DEFAULT NULL,
816 816
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
817 817
  PRIMARY KEY (`id`),
818 818
  UNIQUE KEY `source_unique` (`parent`,`name`),
819 819
  KEY `fk_source1_idx` (`parent`),
820 820
  KEY `fk_source_party2_idx` (`first_publisher`),
821 821
  KEY `fk_source_party_list1_idx` (`owners`),
822
  KEY `fk_source_party1_idx` (`contact`),
822
  KEY `fk_source_party1_idx` (`contacts`),
823
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contacts`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
823 824
  CONSTRAINT `fk_source1` FOREIGN KEY (`parent`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
824 825
  CONSTRAINT `fk_source_party2` FOREIGN KEY (`first_publisher`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
825
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
826
  CONSTRAINT `fk_source_party1` FOREIGN KEY (`contact`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
826
  CONSTRAINT `fk_source_party_list1` FOREIGN KEY (`owners`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
827 827
) 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)';
828 828
/*!40101 SET character_set_client = @saved_cs_client */;
829 829

  

Also available in: Unified diff