Project

General

Profile

« Previous | Next » 

Revision 11125

schemas/VegCore/ERD/VegCore.ERD.mwb: stratum_event.parent_event: renamed to parent so it will merge with the inherited parent field

View differences:

schemas/VegCore/ERD/document.mwb.xml
11187 11187
                      <value type="int" key="precision">-1</value>
11188 11188
                      <value type="int" key="scale">-1</value>
11189 11189
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
11190
                      <value type="string" key="comment"></value>
11191
                      <value type="string" key="name">parent_event</value>
11190
                      <value type="string" key="comment">the parent sampling_event</value>
11191
                      <value type="string" key="name">parent</value>
11192 11192
                      <value type="string" key="oldName">parent_event</value>
11193 11193
                      <link type="object" struct-name="GrtObject" key="owner">8535dbc2-006c-11e3-895c-080027bcf912</link>
11194 11194
                    </value>
......
11381 11381
                  <value type="int" key="commentedOut">0</value>
11382 11382
                  <value type="string" key="createDate">2013-04-16 14:58</value>
11383 11383
                  <value _ptr_="0xa9aba70" type="dict" key="customData"/>
11384
                  <value type="string" key="lastChangeDate">2013-09-22 02:04</value>
11384
                  <value type="string" key="lastChangeDate">2013-09-30 02:04</value>
11385 11385
                  <value type="int" key="modelOnly">0</value>
11386 11386
                  <value type="string" key="name">stratum_event</value>
11387 11387
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17618 17618
              <value type="string" key="name"></value>
17619 17619
            </value>
17620 17620
            <value _ptr_="0xa9c9950" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17621
              <link type="object">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
17621
              <link type="object">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
17622 17622
            </value>
17623 17623
            <value type="int" key="updateBlocked">0</value>
17624 17624
            <value type="real" key="width">1.6215e+03</value>
......
17632 17632
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17633 17633
        <value _ptr_="0xa91b830" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17634 17634
        <value _ptr_="0x9de1448" type="dict" key="syncProfiles">
17635
          <value type="object" struct-name="db.mgmt.SyncProfile" id="27c1bb1c-29ae-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xbefce70" type="dict" key="lastKnownDBNames">
17635
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5328e8de-29ae-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xbd0a748" type="dict" key="lastKnownDBNames">
17637 17637
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17638 17638
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17639 17639
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18261 18261
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18262 18262
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18263 18263
      <value type="string" key="caption">New Model</value>
18264
      <value type="string" key="dateChanged">2013-09-30 01:57</value>
18264
      <value type="string" key="dateChanged">2013-09-30 02:04</value>
18265 18265
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18266 18266
      <value type="string" key="description"></value>
18267 18267
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1028 1028
/*!40101 SET character_set_client = utf8 */;
1029 1029
CREATE TABLE `stratum_event` (
1030 1030
  `id` varbinary(767) NOT NULL,
1031
  `parent_event` varbinary(767) NOT NULL,
1031
  `parent` varbinary(767) NOT NULL COMMENT 'the parent sampling_event',
1032 1032
  `stratum` varbinary(767) NOT NULL,
1033 1033
  PRIMARY KEY (`id`),
1034 1034
  KEY `fk_stratum_event_stratum1_idx` (`stratum`),
1035
  KEY `fk_stratum_event_sampling_event2_idx` (`parent_event`),
1036
  CONSTRAINT `fk_stratum_event_stratum1` FOREIGN KEY (`stratum`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1035
  KEY `fk_stratum_event_sampling_event2_idx` (`parent`),
1036
  CONSTRAINT `fk_stratum_event_sampling_event2` FOREIGN KEY (`parent`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1037 1037
  CONSTRAINT `fk_stratum_event_sampling_event1` FOREIGN KEY (`id`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1038
  CONSTRAINT `fk_stratum_event_sampling_event2` FOREIGN KEY (`parent_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1038
  CONSTRAINT `fk_stratum_event_stratum1` FOREIGN KEY (`stratum`) REFERENCES `stratum` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1039 1039
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)';
1040 1040
/*!40101 SET character_set_client = @saved_cs_client */;
1041 1041

  
schemas/VegCore/VegCore.pg.sql
1030 1030
/*!40101 SET character_set_client = utf8 */;
1031 1031
CREATE TABLE "stratum_event" (
1032 1032
  "id" text NOT NULL,
1033
  "parent_event" text NOT NULL,
1033
  "parent" text NOT NULL /*COMMENT 'the parent sampling_event'*/,
1034 1034
  "stratum" text NOT NULL,
1035 1035
  PRIMARY KEY ("id"),
1036 1036
  /*KEY "fk_stratum_event_stratum1_idx" ("stratum")*/CHECK (true),
1037
  /*KEY "fk_stratum_event_sampling_event2_idx" ("parent_event")*/CHECK (true),
1038
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1037
  /*KEY "fk_stratum_event_sampling_event2_idx" ("parent")*/CHECK (true),
1038
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1039 1039
  /*CONSTRAINT "fk_stratum_event_sampling_event1" FOREIGN KEY ("id") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1040
  /*CONSTRAINT "fk_stratum_event_sampling_event2" FOREIGN KEY ("parent_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1040
  /*CONSTRAINT "fk_stratum_event_stratum1" FOREIGN KEY ("stratum") REFERENCES "stratum" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1041 1041
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?stratum (which was confusingly named)'*/;
1042 1042
/*!40101 SET character_set_client = @saved_cs_client */;
1043 1043

  

Also available in: Unified diff