Project

General

Profile

« Previous | Next » 

Revision 11385

schemas/VegCore/ERD/VegCore.ERD.mwb: person: allow to have multiple organizations

View differences:

schemas/VegCore/ERD/document.mwb.xml
12567 12567
                      <value type="int" key="scale">-1</value>
12568 12568
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12569 12569
                      <value type="string" key="comment"></value>
12570
                      <value type="string" key="name">organization</value>
12570
                      <value type="string" key="name">organizations</value>
12571 12571
                      <value type="string" key="oldName">organization</value>
12572 12572
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12573 12573
                    </value>
......
12577 12577
                  <value type="string" key="defaultCollationName">utf8_bin</value>
12578 12578
                  <value type="int" key="delayKeyWrite">0</value>
12579 12579
                  <value _ptr_="0xb48f4e0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
12580
                    <value type="object" struct-name="db.mysql.ForeignKey" id="26132be0-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x70a8fc40">
12581
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
12582
                      <value _ptr_="0xb4905d8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12583
                        <link type="object">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12584
                      </value>
12585
                      <value type="int" key="deferability">0</value>
12586
                      <value type="string" key="deleteRule">CASCADE</value>
12587
                      <link type="object" struct-name="db.Index" key="index">26134602-23e9-11e3-ab7c-080027bcf912</link>
12588
                      <value type="int" key="mandatory">1</value>
12589
                      <value type="int" key="many">1</value>
12590
                      <value type="int" key="modelOnly">0</value>
12591
                      <link type="object" struct-name="db.Table" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12592
                      <value _ptr_="0xb490940" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12593
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
12594
                      </value>
12595
                      <value type="int" key="referencedMandatory">0</value>
12596
                      <value type="string" key="updateRule">CASCADE</value>
12597
                      <value type="string" key="comment"></value>
12598
                      <value type="string" key="name">fk_person_organization1</value>
12599
                      <value type="string" key="oldName">fk_person_organization1</value>
12600
                    </value>
12601 12580
                    <value type="object" struct-name="db.mysql.ForeignKey" id="174e216e-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x70a8fc40">
12602 12581
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8fe70e-a6e0-11e2-95e9-080027bcf912</link>
12603 12582
                      <value _ptr_="0xb4909b0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
12618 12597
                      <value type="string" key="name">fk_organization_party10</value>
12619 12598
                      <value type="string" key="oldName">fk_organization_party10</value>
12620 12599
                    </value>
12600
                    <value type="object" struct-name="db.mysql.ForeignKey" id="10532324-39d7-11e3-93b8-080027bcf912" struct-checksum="0x70a8fc40">
12601
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">4001ec92-f678-11e2-9716-080027bcf912</link>
12602
                      <value _ptr_="0xc98d2d8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12603
                        <link type="object">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12604
                      </value>
12605
                      <value type="int" key="deferability">0</value>
12606
                      <value type="string" key="deleteRule">CASCADE</value>
12607
                      <link type="object" struct-name="db.Index" key="index">1054c72e-39d7-11e3-93b8-080027bcf912</link>
12608
                      <value type="int" key="mandatory">1</value>
12609
                      <value type="int" key="many">1</value>
12610
                      <value type="int" key="modelOnly">0</value>
12611
                      <link type="object" struct-name="db.Table" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12612
                      <value _ptr_="0xc98a908" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12613
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
12614
                      </value>
12615
                      <value type="int" key="referencedMandatory">1</value>
12616
                      <value type="string" key="updateRule">CASCADE</value>
12617
                      <value type="string" key="comment"></value>
12618
                      <value type="string" key="name">person_organization_fkey1</value>
12619
                      <value type="string" key="oldName">person_organization_fkey1</value>
12620
                    </value>
12621 12621
                  </value>
12622 12622
                  <value _ptr_="0xb48f530" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
12623 12623
                    <value type="object" struct-name="db.mysql.Index" id="174e238a-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
......
12643 12643
                      <value type="string" key="oldName">PRIMARY</value>
12644 12644
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12645 12645
                    </value>
12646
                    <value type="object" struct-name="db.mysql.Index" id="26134602-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
12647
                      <value _ptr_="0xb4911a8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12648
                        <value type="object" struct-name="db.mysql.IndexColumn" id="2613479c-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
12649
                          <value type="int" key="columnLength">0</value>
12650
                          <value type="string" key="comment"></value>
12651
                          <value type="int" key="descend">0</value>
12652
                          <link type="object" struct-name="db.Column" key="referencedColumn">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12653
                          <value type="string" key="name"></value>
12654
                          <link type="object" struct-name="GrtObject" key="owner">26134602-23e9-11e3-ab7c-080027bcf912</link>
12655
                        </value>
12656
                      </value>
12657
                      <value type="string" key="indexKind"></value>
12658
                      <value type="int" key="keyBlockSize">0</value>
12659
                      <value type="string" key="withParser"></value>
12660
                      <value type="string" key="comment"></value>
12661
                      <value type="int" key="deferability">0</value>
12662
                      <value type="string" key="indexType">INDEX</value>
12663
                      <value type="int" key="isPrimary">0</value>
12664
                      <value type="string" key="name">fk_person_organization1_idx</value>
12665
                      <value type="int" key="unique">0</value>
12666
                      <value type="string" key="oldName">fk_person_organization1_idx</value>
12667
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12668
                    </value>
12669 12646
                    <value type="object" struct-name="db.mysql.Index" id="a76e6760-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x309b847a">
12670 12647
                      <value _ptr_="0xb491888" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12671 12648
                        <value type="object" struct-name="db.mysql.IndexColumn" id="a76e68e6-23ec-11e3-ab7c-080027bcf912" struct-checksum="0x62630b3c">
......
12697 12674
                      <value type="string" key="oldName">person_unique</value>
12698 12675
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12699 12676
                    </value>
12677
                    <value type="object" struct-name="db.mysql.Index" id="1054c72e-39d7-11e3-93b8-080027bcf912" struct-checksum="0x309b847a">
12678
                      <value _ptr_="0xc1ee4d0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12679
                        <value type="object" struct-name="db.mysql.IndexColumn" id="1054c94a-39d7-11e3-93b8-080027bcf912" struct-checksum="0x62630b3c">
12680
                          <value type="int" key="columnLength">0</value>
12681
                          <value type="string" key="comment"></value>
12682
                          <value type="int" key="descend">0</value>
12683
                          <link type="object" struct-name="db.Column" key="referencedColumn">26132e1a-23e9-11e3-ab7c-080027bcf912</link>
12684
                          <value type="string" key="name"></value>
12685
                          <link type="object" struct-name="GrtObject" key="owner">1054c72e-39d7-11e3-93b8-080027bcf912</link>
12686
                        </value>
12687
                      </value>
12688
                      <value type="string" key="indexKind"></value>
12689
                      <value type="int" key="keyBlockSize">0</value>
12690
                      <value type="string" key="withParser"></value>
12691
                      <value type="string" key="comment"></value>
12692
                      <value type="int" key="deferability">0</value>
12693
                      <value type="string" key="indexType">INDEX</value>
12694
                      <value type="int" key="isPrimary">0</value>
12695
                      <value type="string" key="name">person_organization_fkey1_idx</value>
12696
                      <value type="int" key="unique">0</value>
12697
                      <value type="string" key="oldName">person_organization_fkey1</value>
12698
                      <link type="object" struct-name="GrtObject" key="owner">174e1b4c-23e9-11e3-ab7c-080027bcf912</link>
12699
                    </value>
12700 12700
                  </value>
12701 12701
                  <value type="string" key="maxRows"></value>
12702 12702
                  <value type="string" key="mergeInsert"></value>
......
12728 12728
                  <value type="int" key="commentedOut">0</value>
12729 12729
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12730 12730
                  <value _ptr_="0xb48f2b8" type="dict" key="customData"/>
12731
                  <value type="string" key="lastChangeDate">2013-09-22 18:08</value>
12731
                  <value type="string" key="lastChangeDate">2013-10-20 15:29</value>
12732 12732
                  <value type="int" key="modelOnly">0</value>
12733 12733
                  <value type="string" key="name">person</value>
12734 12734
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
13921 13921
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13922 13922
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13923 13923
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">18e739f0-a91b-11e2-bdec-080027bcf912</link>
13924
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13924
                <value type="real" key="middleSegmentOffset">5.8538153851515971837216056883335113525390625e+01</value>
13925 13925
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13926 13926
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13927 13927
                <value type="int" key="drawSplit">0</value>
......
15058 15058
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15059 15059
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15060 15060
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15061
                <value type="int" key="drawSplit">1</value>
15061
                <value type="int" key="drawSplit">0</value>
15062 15062
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
15063 15063
                <link type="object" struct-name="model.Figure" key="startFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15064 15064
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
......
15202 15202
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15203 15203
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15204 15204
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">174e216e-23e9-11e3-ab7c-080027bcf912</link>
15205
                <value type="real" key="middleSegmentOffset">-1.384432916803916668868623673915863037109375e+00</value>
15205
                <value type="real" key="middleSegmentOffset">-6.15256405436184650170616805553436279296875e-01</value>
15206 15206
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15207 15207
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15208 15208
                <value type="int" key="drawSplit">0</value>
......
15212 15212
                <value type="int" key="visible">1</value>
15213 15213
                <value type="string" key="name"></value>
15214 15214
              </value>
15215
              <value type="object" struct-name="workbench.physical.Connection" id="26134e54-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x9baebc92">
15216
                <value type="string" key="caption">fk_person_organization1</value>
15217
                <value type="real" key="captionXOffs">0.e+00</value>
15218
                <value type="real" key="captionYOffs">0.e+00</value>
15219
                <value type="string" key="comment"></value>
15220
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15221
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15222
                <value type="string" key="extraCaption"></value>
15223
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15224
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15225
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">26132be0-23e9-11e3-ab7c-080027bcf912</link>
15226
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15227
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15228
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15229
                <value type="int" key="drawSplit">0</value>
15230
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
15231
                <link type="object" struct-name="model.Figure" key="startFigure">174e3636-23e9-11e3-ab7c-080027bcf912</link>
15232
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15233
                <value type="int" key="visible">1</value>
15234
                <value type="string" key="name"></value>
15235
              </value>
15236 15215
              <value type="object" struct-name="workbench.physical.Connection" id="39e42e9e-23e9-11e3-ab7c-080027bcf912" struct-checksum="0x9baebc92">
15237 15216
                <value type="string" key="caption">fk_organization_organization1</value>
15238 15217
                <value type="real" key="captionXOffs">0.e+00</value>
......
15716 15695
                <value type="int" key="visible">1</value>
15717 15696
                <value type="string" key="name"></value>
15718 15697
              </value>
15698
              <value type="object" struct-name="workbench.physical.Connection" id="1054d02a-39d7-11e3-93b8-080027bcf912" struct-checksum="0x9baebc92">
15699
                <value type="string" key="caption">person_organization_fkey1</value>
15700
                <value type="real" key="captionXOffs">0.e+00</value>
15701
                <value type="real" key="captionYOffs">0.e+00</value>
15702
                <value type="string" key="comment"></value>
15703
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15704
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15705
                <value type="string" key="extraCaption"></value>
15706
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15707
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15708
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">10532324-39d7-11e3-93b8-080027bcf912</link>
15709
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15710
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15711
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15712
                <value type="int" key="drawSplit">1</value>
15713
                <link type="object" struct-name="model.Figure" key="endFigure">40021096-f678-11e2-9716-080027bcf912</link>
15714
                <link type="object" struct-name="model.Figure" key="startFigure">174e3636-23e9-11e3-ab7c-080027bcf912</link>
15715
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15716
                <value type="int" key="visible">1</value>
15717
                <value type="string" key="name"></value>
15718
              </value>
15719 15719
            </value>
15720 15720
            <value type="string" key="description"></value>
15721 15721
            <value _ptr_="0xb498b78" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
16731 16731
                <value type="int" key="expanded">1</value>
16732 16732
                <value type="real" key="height">1.e+02</value>
16733 16733
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16734
                <value type="real" key="left">4.e+00</value>
16734
                <value type="real" key="left">1.1e+01</value>
16735 16735
                <value type="int" key="locked">0</value>
16736 16736
                <value type="int" key="manualSizing">0</value>
16737
                <value type="real" key="top">1.175e+03</value>
16737
                <value type="real" key="top">1.173e+03</value>
16738 16738
                <value type="real" key="width">1.21e+02</value>
16739 16739
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16740 16740
                <value type="int" key="visible">1</value>
......
16871 16871
                <value type="int" key="expanded">1</value>
16872 16872
                <value type="real" key="height">1.e+02</value>
16873 16873
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16874
                <value type="real" key="left">1.93e+02</value>
16874
                <value type="real" key="left">1.76e+02</value>
16875 16875
                <value type="int" key="locked">0</value>
16876 16876
                <value type="int" key="manualSizing">0</value>
16877 16877
                <value type="real" key="top">8.48e+02</value>
......
17218 17218
                <value type="real" key="left">5.3e+01</value>
17219 17219
                <value type="int" key="locked">0</value>
17220 17220
                <value type="int" key="manualSizing">0</value>
17221
                <value type="real" key="top">1.051e+03</value>
17221
                <value type="real" key="top">1.054e+03</value>
17222 17222
                <value type="real" key="width">9.e+01</value>
17223 17223
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17224 17224
                <value type="int" key="visible">1</value>
......
18040 18040
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18041 18041
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18042 18042
      <value type="string" key="caption">New Model</value>
18043
      <value type="string" key="dateChanged">2013-10-20 15:27</value>
18043
      <value type="string" key="dateChanged">2013-10-20 15:33</value>
18044 18044
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18045 18045
      <value type="string" key="description"></value>
18046 18046
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
563 563
CREATE TABLE `person` (
564 564
  `id` varbinary(767) NOT NULL,
565 565
  `name` varbinary(767) NOT NULL,
566
  `organization` varbinary(767) DEFAULT NULL,
566
  `organizations` varbinary(767) DEFAULT NULL,
567 567
  PRIMARY KEY (`id`),
568
  UNIQUE KEY `person_unique` (`organization`,`name`),
569
  KEY `fk_person_organization1_idx` (`organization`),
570
  CONSTRAINT `fk_organization_party10` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
571
  CONSTRAINT `fk_person_organization1` FOREIGN KEY (`organization`) REFERENCES `organization` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
568
  UNIQUE KEY `person_unique` (`organizations`,`name`),
569
  KEY `person_organization_fkey1_idx` (`organizations`),
570
  CONSTRAINT `person_organization_fkey1` FOREIGN KEY (`organizations`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
571
  CONSTRAINT `fk_organization_party10` FOREIGN KEY (`id`) REFERENCES `party` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
572 572
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
573 573
/*!40101 SET character_set_client = @saved_cs_client */;
574 574

  
schemas/VegCore/VegCore.pg.sql
565 565
CREATE TABLE "person" (
566 566
  "id" text NOT NULL,
567 567
  "name" text NOT NULL,
568
  "organization" text DEFAULT NULL,
568
  "organizations" text DEFAULT NULL,
569 569
  PRIMARY KEY ("id"),
570
  /*CONSTRAINT "person_unique" */UNIQUE ("organization","name"),
571
  /*KEY "fk_person_organization1_idx" ("organization")*/CHECK (true),
572
  /*CONSTRAINT "fk_organization_party10" FOREIGN KEY ("id") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
573
  /*CONSTRAINT "fk_person_organization1" FOREIGN KEY ("organization") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
570
  /*CONSTRAINT "person_unique" */UNIQUE ("organizations","name"),
571
  /*KEY "person_organization_fkey1_idx" ("organizations")*/CHECK (true),
572
  /*CONSTRAINT "person_organization_fkey1" FOREIGN KEY ("organizations") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
573
  /*CONSTRAINT "fk_organization_party10" FOREIGN KEY ("id") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
574 574
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
575 575
/*!40101 SET character_set_client = @saved_cs_client */;
576 576

  

Also available in: Unified diff