Project

General

Profile

« Previous | Next » 

Revision 11109

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: taxa_sampling_event: merged required within_place into place_observation, which already contains a required fkey to place

View differences:

schemas/VegCore/ERD/document.mwb.xml
10503 10503 
                      <value type="string" key="oldName">id</value>
10504 10504 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10505 10505 
                    </value>
10506 
                    <value type="object" struct-name="db.mysql.Column" id="ed551376-011b-11e3-b872-080027bcf912" struct-checksum="0x783b5183">
10507 
                      <value type="int" key="autoIncrement">0</value>
10508 
                      <value type="string" key="characterSetName"></value>
10509 
                      <value _ptr_="0xbb629a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
10510 
                      <value type="string" key="collationName"></value>
10511 
                      <value type="string" key="datatypeExplicitParams"></value>
10512 
                      <value type="string" key="defaultValue"></value>
10513 
                      <value type="int" key="defaultValueIsNull">0</value>
10514 
                      <value _ptr_="0xbb62d00" type="list" content-type="string" key="flags"/>
10515 
                      <value type="int" key="isNotNull">1</value>
10516 
                      <value type="int" key="length">767</value>
10517 
                      <value type="int" key="precision">-1</value>
10518 
                      <value type="int" key="scale">-1</value>
10519 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10520 
                      <value type="string" key="comment"></value>
10521 
                      <value type="string" key="name">within_place</value>
10522 
                      <value type="string" key="oldName">within_place</value>
10523 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10524 
                    </value>
10525 10506 
                    <value type="object" struct-name="db.mysql.Column" id="b7749e74-2985-11e3-a80d-080027bcf912" struct-checksum="0x783b5183">
10526 10507 
                      <value type="int" key="autoIncrement">0</value>
10527 10508 
                      <value type="string" key="characterSetName"></value>
......
10529 10510 
                      <value type="string" key="collationName"></value>
10530 10511 
                      <value type="string" key="datatypeExplicitParams"></value>
10531 10512 
                      <value type="string" key="defaultValue"></value>
10532 
                      <value type="int" key="defaultValueIsNull">1</value>
10513 
                      <value type="int" key="defaultValueIsNull">0</value>
10533 10514 
                      <value _ptr_="0xc5b54f8" type="list" content-type="string" key="flags"/>
10534 
                      <value type="int" key="isNotNull">0</value>
10515 
                      <value type="int" key="isNotNull">1</value>
10535 10516 
                      <value type="int" key="length">767</value>
10536 10517 
                      <value type="int" key="precision">-1</value>
10537 10518 
                      <value type="int" key="scale">-1</value>
......
10606 10587 
                      <value type="string" key="name">fk_taxa_sampling_event_project1</value>
10607 10588 
                      <value type="string" key="oldName">fk_taxa_sampling_event_project1</value>
10608 10589 
                    </value>
10609 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ed551182-011b-11e3-b872-080027bcf912" struct-checksum="0x70a8fc40">
10610 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
10611 
                      <value _ptr_="0xbb63fe8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
10612 
                        <link type="object">ed551376-011b-11e3-b872-080027bcf912</link>
10613 
                      </value>
10614 
                      <value type="int" key="deferability">0</value>
10615 
                      <value type="string" key="deleteRule">CASCADE</value>
10616 
                      <link type="object" struct-name="db.Index" key="index">ed55f9e4-011b-11e3-b872-080027bcf912</link>
10617 
                      <value type="int" key="mandatory">1</value>
10618 
                      <value type="int" key="many">1</value>
10619 
                      <value type="int" key="modelOnly">0</value>
10620 
                      <link type="object" struct-name="db.Table" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10621 
                      <value _ptr_="0xbb64370" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10622 
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
10623 
                      </value>
10624 
                      <value type="int" key="referencedMandatory">1</value>
10625 
                      <value type="string" key="updateRule">CASCADE</value>
10626 
                      <value type="string" key="comment"></value>
10627 
                      <value type="string" key="name">fk_taxa_sampling_event_place1</value>
10628 
                      <value type="string" key="oldName">fk_taxa_sampling_event_place1</value>
10629 
                    </value>
10630 10590 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="7f177512-f6c0-11e2-af44-080027bcf912" struct-checksum="0x70a8fc40">
10631 10591 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c672743a-a7a0-11e2-b667-080027bcf912</link>
10632 10592 
                      <value _ptr_="0xbb63bf0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
10663 10623 
                      <value _ptr_="0xc5b4b68" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
10664 10624 
                        <link type="object">be8f3ade-a6e0-11e2-95e9-080027bcf912</link>
10665 10625 
                      </value>
10666 
                      <value type="int" key="referencedMandatory">0</value>
10626 
                      <value type="int" key="referencedMandatory">1</value>
10667 10627 
                      <value type="string" key="updateRule">CASCADE</value>
10668 10628 
                      <value type="string" key="comment"></value>
10669 10629 
                      <value type="string" key="name">taxa_sampling_event_id_fkey1</value>
......
10738 10698 
                      <value type="string" key="oldName">fk_sampling_event_method1_idx</value>
10739 10699 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10740 10700 
                    </value>
10741 
                    <value type="object" struct-name="db.mysql.Index" id="ed55f9e4-011b-11e3-b872-080027bcf912" struct-checksum="0x309b847a">
10742 
                      <value _ptr_="0xbb652b8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10743 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ed5632d8-011b-11e3-b872-080027bcf912" struct-checksum="0x62630b3c">
10744 
                          <value type="int" key="columnLength">0</value>
10745 
                          <value type="string" key="comment"></value>
10746 
                          <value type="int" key="descend">0</value>
10747 
                          <link type="object" struct-name="db.Column" key="referencedColumn">ed551376-011b-11e3-b872-080027bcf912</link>
10748 
                          <value type="string" key="name"></value>
10749 
                          <link type="object" struct-name="GrtObject" key="owner">ed55f9e4-011b-11e3-b872-080027bcf912</link>
10750 
                        </value>
10751 
                      </value>
10752 
                      <value type="string" key="indexKind"></value>
10753 
                      <value type="int" key="keyBlockSize">0</value>
10754 
                      <value type="string" key="withParser"></value>
10755 
                      <value type="string" key="comment"></value>
10756 
                      <value type="int" key="deferability">0</value>
10757 
                      <value type="string" key="indexType">INDEX</value>
10758 
                      <value type="int" key="isPrimary">0</value>
10759 
                      <value type="string" key="name">fk_taxa_sampling_event_place1_idx</value>
10760 
                      <value type="int" key="unique">0</value>
10761 
                      <value type="string" key="oldName">fk_taxa_sampling_event_place1_idx</value>
10762 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10763 
                    </value>
10764 10701 
                    <value type="object" struct-name="db.mysql.Index" id="eca94142-1de3-11e3-b950-080027bcf912" struct-checksum="0x309b847a">
10765 10702 
                      <value _ptr_="0xbb65998" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
10766 10703 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="eca942e6-1de3-11e3-b950-080027bcf912" struct-checksum="0x62630b3c">
......
10838 10775 
                  <value type="int" key="commentedOut">0</value>
10839 10776 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10840 10777 
                  <value _ptr_="0xbb62028" type="dict" key="customData"/>
10841 
                  <value type="string" key="lastChangeDate">2013-09-29 21:22</value>
10778 
                  <value type="string" key="lastChangeDate">2013-09-29 21:29</value>
10842 10779 
                  <value type="int" key="modelOnly">0</value>
10843 10780 
                  <value type="string" key="name">taxa_sampling_event</value>
10844 10781 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15416 15353 
                <value type="int" key="visible">1</value>
15417 15354 
                <value type="string" key="name"></value>
15418 15355 
              </value>
15419 
              <value type="object" struct-name="workbench.physical.Connection" id="ed566d5c-011b-11e3-b872-080027bcf912" struct-checksum="0x9baebc92">
15420 
                <value type="string" key="caption">fk_taxa_sampling_event_place1</value>
15421 
                <value type="real" key="captionXOffs">0.e+00</value>
15422 
                <value type="real" key="captionYOffs">0.e+00</value>
15423 
                <value type="string" key="comment"></value>
15424 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15425 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15426 
                <value type="string" key="extraCaption"></value>
15427 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15428 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15429 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">ed551182-011b-11e3-b872-080027bcf912</link>
15430 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15431 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15432 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15433 
                <value type="int" key="drawSplit">1</value>
15434 
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
15435 
                <link type="object" struct-name="model.Figure" key="startFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
15436 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15437 
                <value type="int" key="visible">1</value>
15438 
                <value type="string" key="name"></value>
15439 
              </value>
15440 15356 
              <value type="object" struct-name="workbench.physical.Connection" id="39fe67ca-011e-11e3-9f3a-080027bcf912" struct-checksum="0x9baebc92">
15441 15357 
                <value type="string" key="caption">fk_taxon_observation_sampling_event1</value>
15442 15358 
                <value type="real" key="captionXOffs">0.e+00</value>
......
15763 15679 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15764 15680 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15765 15681 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
15766 
                <value type="real" key="middleSegmentOffset">-5.699854527981398177871596999466419219970703125e+01</value>
15682 
                <value type="real" key="middleSegmentOffset">-6.2459972911977956755436025559902191162109375e+01</value>
15767 15683 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15768 15684 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15769 15685 
                <value type="int" key="drawSplit">0</value>
......
17384 17300 
                <value type="int" key="triggersExpanded">0</value>
17385 17301 
                <value type="string" key="color">#66ffff</value>
17386 17302 
                <value type="int" key="expanded">1</value>
17387 
                <value type="real" key="height">1.46e+02</value>
17303 
                <value type="real" key="height">1.23e+02</value>
17388 17304 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17389 17305 
                <value type="real" key="left">6.29e+02</value>
17390 17306 
                <value type="int" key="locked">0</value>
17391 17307 
                <value type="int" key="manualSizing">0</value>
17392 
                <value type="real" key="top">6.11e+02</value>
17308 
                <value type="real" key="top">6.22e+02</value>
17393 17309 
                <value type="real" key="width">1.71e+02</value>
17394 17310 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17395 17311 
                <value type="int" key="visible">1</value>
......
17915 17831 
              <value type="string" key="name"></value>
17916 17832 
            </value>
17917 17833 
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17918 
              <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
17834 
              <link type="object">07e46488-1dde-11e3-bd5f-080027bcf912</link>
17919 17835 
            </value>
17920 17836 
            <value type="int" key="updateBlocked">0</value>
17921 17837 
            <value type="real" key="width">1.6215e+03</value>
......
18569 18485 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18570 18486 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18571 18487 
      <value type="string" key="caption">New Model</value>
18572 
      <value type="string" key="dateChanged">2013-09-29 21:26</value>
18488 
      <value type="string" key="dateChanged">2013-09-29 21:30</value>
18573 18489 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18574 18490 
      <value type="string" key="description"></value>
18575 18491 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1112 1112 
/*!40101 SET character_set_client = utf8 */;
1113 1113 
CREATE TABLE `taxa_sampling_event` (
1114 1114 
  `id` varbinary(767) NOT NULL,
1115 
  `within_place` varbinary(767) NOT NULL,
1116 
  `place_observation` varbinary(767) DEFAULT NULL,
1115 
  `place_observation` varbinary(767) NOT NULL,
1117 1116 
  `project` varbinary(767) DEFAULT NULL,
1118 1117 
  `method` varbinary(767) DEFAULT NULL,
1119 1118 
  PRIMARY KEY (`id`),
1120 1119 
  KEY `fk_sampling_event_method1_idx` (`method`),
1121 
  KEY `fk_taxa_sampling_event_place1_idx` (`within_place`),
1122 1120 
  KEY `fk_taxa_sampling_event_project1_idx` (`project`),
1123 1121 
  KEY `taxa_sampling_event_id_fkey1_idx` (`place_observation`),
1124 1122 
  CONSTRAINT `fk_taxa_sampling_event_project1` FOREIGN KEY (`project`) REFERENCES `project` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1125 
  CONSTRAINT `fk_taxa_sampling_event_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1123 
  CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1126 1124 
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1127 
  CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1128 1125 
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1129 1126 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them';
1130 1127 
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
1114 1114 
/*!40101 SET character_set_client = utf8 */;
1115 1115 
CREATE TABLE "taxa_sampling_event" (
1116 1116 
  "id" text NOT NULL,
1117 
  "within_place" text NOT NULL,
1118 
  "place_observation" text DEFAULT NULL,
1117 
  "place_observation" text NOT NULL,
1119 1118 
  "project" text DEFAULT NULL,
1120 1119 
  "method" text DEFAULT NULL,
1121 1120 
  PRIMARY KEY ("id"),
1122 1121 
  /*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),
1123 
  /*KEY "fk_taxa_sampling_event_place1_idx" ("within_place")*/CHECK (true),
1124 1122 
  /*KEY "fk_taxa_sampling_event_project1_idx" ("project")*/CHECK (true),
1125 1123 
  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_observation")*/CHECK (true),
1126 1124 
  /*CONSTRAINT "fk_taxa_sampling_event_project1" FOREIGN KEY ("project") REFERENCES "project" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1127 
  /*CONSTRAINT "fk_taxa_sampling_event_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1125 
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1128 1126 
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1129 
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1130 1127 
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1131 1128 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them'*/;
1132 1129 
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff