Project

General

Profile

« Previous | Next » 

Revision 11133

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: party_list: inherit from source so that a party_list can be used as the source for a row (e.g. a list of institutions that together provided the data for an individual_observation that has specimens at multiple institutions)

View differences:

schemas/VegCore/ERD/document.mwb.xml
10065 10065 
                      <value type="string" key="name">fk_collection_source100</value>
10066 10066 
                      <value type="string" key="oldName">fk_collection_source100</value>
10067 10067 
                    </value>
10068 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="9535924c-29b6-11e3-a024-080027bcf912" struct-checksum="0x70a8fc40">
10069 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
10070 
                      <value _ptr_="0xb7307a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10071 
                        <link type="object">4001ef9e-f678-11e2-9716-080027bcf912</link>
10072 
                      </value>
10073 
                      <value type="int" key="deferability">0</value>
10074 
                      <value type="string" key="deleteRule">CASCADE</value>
10075 
                      <value type="int" key="mandatory">1</value>
10076 
                      <value type="int" key="many">1</value>
10077 
                      <value type="int" key="modelOnly">0</value>
10078 
                      <link type="object" struct-name="db.Table" key="owner">4001ec92-f678-11e2-9716-080027bcf912</link>
10079 
                      <value _ptr_="0xb66fcb0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10080 
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
10081 
                      </value>
10082 
                      <value type="int" key="referencedMandatory">1</value>
10083 
                      <value type="string" key="updateRule">CASCADE</value>
10084 
                      <value type="string" key="comment"></value>
10085 
                      <value type="string" key="name">party_list_id_fkey1</value>
10086 
                      <value type="string" key="oldName">party_list_id_fkey1</value>
10087 
                    </value>
10068 10088 
                  </value>
10069 10089 
                  <value _ptr_="0xadaccb0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
10070 10090 
                    <value type="object" struct-name="db.mysql.Index" id="4001fa52-f678-11e2-9716-080027bcf912" struct-checksum="0x309b847a">
......
15417 15437 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15418 15438 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15419 15439 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3237beb6-238c-11e3-a6f3-080027bcf912</link>
15420 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15440 
                <value type="real" key="middleSegmentOffset">-2.923012987393803996383212506771087646484375e+00</value>
15421 15441 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15422 15442 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15423 15443 
                <value type="int" key="drawSplit">0</value>
......
15679 15699 
                <value type="int" key="visible">1</value>
15680 15700 
                <value type="string" key="name"></value>
15681 15701 
              </value>
15702 
              <value type="object" struct-name="workbench.physical.Connection" id="95370e42-29b6-11e3-a024-080027bcf912" struct-checksum="0x9baebc92">
15703 
                <value type="string" key="caption">party_list_id_fkey1</value>
15704 
                <value type="real" key="captionXOffs">0.e+00</value>
15705 
                <value type="real" key="captionYOffs">0.e+00</value>
15706 
                <value type="string" key="comment"></value>
15707 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15708 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15709 
                <value type="string" key="extraCaption"></value>
15710 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15711 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15712 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">9535924c-29b6-11e3-a024-080027bcf912</link>
15713 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15714 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15715 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15716 
                <value type="int" key="drawSplit">1</value>
15717 
                <link type="object" struct-name="model.Figure" key="endFigure">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
15718 
                <link type="object" struct-name="model.Figure" key="startFigure">40021096-f678-11e2-9716-080027bcf912</link>
15719 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15720 
                <value type="int" key="visible">1</value>
15721 
                <value type="string" key="name"></value>
15722 
              </value>
15682 15723 
            </value>
15683 15724 
            <value type="string" key="description"></value>
15684 15725 
            <value _ptr_="0xadd90c8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
17249 17290 
                <value type="int" key="expanded">1</value>
17250 17291 
                <value type="real" key="height">1.e+02</value>
17251 17292 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17252 
                <value type="real" key="left">1.4e+01</value>
17293 
                <value type="real" key="left">1.9e+01</value>
17253 17294 
                <value type="int" key="locked">0</value>
17254 17295 
                <value type="int" key="manualSizing">0</value>
17255 17296 
                <value type="real" key="top">5.48e+02</value>
......
17421 17462 
              <value type="int" key="visible">1</value>
17422 17463 
              <value type="string" key="name"></value>
17423 17464 
            </value>
17424 
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17425 
              <link type="object">ed1ed15a-ad0e-11e2-b309-080027bcf912</link>
17426 
              <link type="object">71d9ecb6-a780-11e2-afd5-080027bcf912</link>
17427 
            </value>
17465 
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17428 17466 
            <value type="int" key="updateBlocked">0</value>
17429 17467 
            <value type="real" key="width">1.6215e+03</value>
17430 17468 
            <value type="real" key="x">0.e+00</value>
......
17437 17475 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17438 17476 
        <value _ptr_="0xad2bf00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17439 17477 
        <value _ptr_="0xa5b9c88" type="dict" key="syncProfiles">
17440 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="520c4fc4-29b6-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17441 
            <value _ptr_="0xbdb7e60" type="dict" key="lastKnownDBNames">
17478 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="b9a20eda-29b6-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17479 
            <value _ptr_="0xbb06738" type="dict" key="lastKnownDBNames">
17442 17480 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17443 17481 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17444 17482 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17727 17765 
              <value type="string" key="913a6e06-008a-11e3-9629-080027bcf912">fk_soil_observation_record1</value>
17728 17766 
              <value type="string" key="92fc2776-1be6-11e3-af49-080027bcf912">defining_data</value>
17729 17767 
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
17768 
              <value type="string" key="9535924c-29b6-11e3-a024-080027bcf912">party_list_id_fkey1</value>
17730 17769 
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
17731 17770 
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
17732 17771 
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
......
18061 18100 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18062 18101 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18063 18102 
      <value type="string" key="caption">New Model</value>
18064 
      <value type="string" key="dateChanged">2013-09-30 02:54</value>
18103 
      <value type="string" key="dateChanged">2013-09-30 02:57</value>
18065 18104 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18066 18105 
      <value type="string" key="description"></value>
18067 18106 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
541 541 
  `id` varbinary(767) NOT NULL,
542 542 
  `count` int(11) NOT NULL,
543 543 
  PRIMARY KEY (`id`),
544 
  CONSTRAINT `party_list_id_fkey1` FOREIGN KEY (`id`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
544 545 
  CONSTRAINT `fk_collection_source100` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
545 546 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
546 547 
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
543 543 
  "id" text NOT NULL,
544 544 
  "count" integer NOT NULL,
545 545 
  PRIMARY KEY ("id"),
546 
  /*CONSTRAINT "party_list_id_fkey1" FOREIGN KEY ("id") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
546 547 
  /*CONSTRAINT "fk_collection_source100" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
547 548 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
548 549 
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff