Project

General

Profile

« Previous | Next » 

Revision 11128

schemas/VegCore/ERD/VegCore.ERD.mwb: subplot.parent_plot: renamed to parent so it will merge with the inherited parent field. this is the parent plot.

View differences:

schemas/VegCore/ERD/document.mwb.xml
2149 2149
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2150 2150
                      <value type="string" key="comment">the taxon_presence for the taxon as a whole (not subdivided by size_class, etc.)</value>
2151 2151
                      <value type="string" key="name">parent</value>
2152
                      <value type="string" key="oldName">taxon_presence</value>
2152
                      <value type="string" key="oldName">parent</value>
2153 2153
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2154 2154
                    </value>
2155 2155
                    <value type="object" struct-name="db.mysql.Column" id="6c2bbbb2-0083-11e3-ac06-080027bcf912" struct-checksum="0x783b5183">
......
10991 10991
                      <value type="int" key="precision">-1</value>
10992 10992
                      <value type="int" key="scale">-1</value>
10993 10993
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10994
                      <value type="string" key="comment"></value>
10995
                      <value type="string" key="name">parent_plot</value>
10994
                      <value type="string" key="comment">the parent plot</value>
10995
                      <value type="string" key="name">parent</value>
10996 10996
                      <value type="string" key="oldName">parent_plot</value>
10997 10997
                      <link type="object" struct-name="GrtObject" key="owner">2673b9ee-f9bc-11e2-a599-080027bcf912</link>
10998 10998
                    </value>
......
11142 11142
                  <value type="int" key="commentedOut">0</value>
11143 11143
                  <value type="string" key="createDate">2013-04-16 14:58</value>
11144 11144
                  <value _ptr_="0xa9a8ef0" type="dict" key="customData"/>
11145
                  <value type="string" key="lastChangeDate">2013-07-31 02:41</value>
11145
                  <value type="string" key="lastChangeDate">2013-09-30 02:21</value>
11146 11146
                  <value type="int" key="modelOnly">0</value>
11147 11147
                  <value type="string" key="name">subplot</value>
11148 11148
                  <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">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</link>
17621
              <link type="object">2673ee0a-f9bc-11e2-a599-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="44f0253c-29b0-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xc2ce558" type="dict" key="lastKnownDBNames">
17635
          <value type="object" struct-name="db.mgmt.SyncProfile" id="e888451c-29b0-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xb822298" 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>
......
17860 17860
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
17861 17861
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
17862 17862
              <value type="string" key="68bcc4bc-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
17863
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">taxon_presence</value>
17863
              <value type="string" key="68bcc6ce-0083-11e3-ac06-080027bcf912">parent</value>
17864 17864
              <value type="string" key="68bcdca4-0083-11e3-ac06-080027bcf912">fk_aggregate_observation_taxon_presence1_idx</value>
17865 17865
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
17866 17866
              <value type="string" key="6a2c268a-1dfc-11e3-bbb6-080027bcf912">fk_record_source2</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 02:15</value>
18264
      <value type="string" key="dateChanged">2013-09-30 02:21</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
1080 1080
/*!40101 SET character_set_client = utf8 */;
1081 1081
CREATE TABLE `subplot` (
1082 1082
  `id` varbinary(767) NOT NULL,
1083
  `parent_plot` varbinary(767) NOT NULL,
1083
  `parent` varbinary(767) NOT NULL COMMENT 'the parent plot',
1084 1084
  PRIMARY KEY (`id`),
1085
  KEY `fk_subplot_plot2_idx` (`parent_plot`),
1085
  KEY `fk_subplot_plot2_idx` (`parent`),
1086
  CONSTRAINT `fk_subplot_plot2` FOREIGN KEY (`parent`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1086 1087
  CONSTRAINT `fk_subplot_plot1` FOREIGN KEY (`id`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1087
  CONSTRAINT `fk_subplot_plot2` FOREIGN KEY (`parent_plot`) REFERENCES `plot` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1088 1088
  CONSTRAINT `fk_subplot_rel_place1` FOREIGN KEY (`id`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1089 1089
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1090 1090
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
1082 1082
/*!40101 SET character_set_client = utf8 */;
1083 1083
CREATE TABLE "subplot" (
1084 1084
  "id" text NOT NULL,
1085
  "parent_plot" text NOT NULL,
1085
  "parent" text NOT NULL /*COMMENT 'the parent plot'*/,
1086 1086
  PRIMARY KEY ("id"),
1087
  /*KEY "fk_subplot_plot2_idx" ("parent_plot")*/CHECK (true),
1087
  /*KEY "fk_subplot_plot2_idx" ("parent")*/CHECK (true),
1088
  /*CONSTRAINT "fk_subplot_plot2" FOREIGN KEY ("parent") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1088 1089
  /*CONSTRAINT "fk_subplot_plot1" FOREIGN KEY ("id") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1089
  /*CONSTRAINT "fk_subplot_plot2" FOREIGN KEY ("parent_plot") REFERENCES "plot" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1090 1090
  /*CONSTRAINT "fk_subplot_rel_place1" FOREIGN KEY ("id") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1091 1091
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;
1092 1092
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff