Project

General

Profile

« Previous | Next » 

Revision 11126

schemas/VegCore/ERD/VegCore.ERD.mwb: taxa_sampling_event.method: renamed to subsetting_method for clarity

View differences:

schemas/VegCore/ERD/document.mwb.xml
10450 10450
                      <value type="int" key="scale">-1</value>
10451 10451
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10452 10452
                      <value type="string" key="comment"></value>
10453
                      <value type="string" key="name">method</value>
10453
                      <value type="string" key="name">subsetting_method</value>
10454 10454
                      <value type="string" key="oldName">method</value>
10455 10455
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10456 10456
                    </value>
......
10625 10625
                  <value type="int" key="commentedOut">0</value>
10626 10626
                  <value type="string" key="createDate">2013-04-16 14:58</value>
10627 10627
                  <value _ptr_="0xa9a0c18" type="dict" key="customData"/>
10628
                  <value type="string" key="lastChangeDate">2013-09-29 21:29</value>
10628
                  <value type="string" key="lastChangeDate">2013-09-30 02:11</value>
10629 10629
                  <value type="int" key="modelOnly">0</value>
10630 10630
                  <value type="string" key="name">taxa_sampling_event</value>
10631 10631
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11189 11189
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
11190 11190
                      <value type="string" key="comment">the parent sampling_event</value>
11191 11191
                      <value type="string" key="name">parent</value>
11192
                      <value type="string" key="oldName">parent_event</value>
11192
                      <value type="string" key="oldName">parent</value>
11193 11193
                      <link type="object" struct-name="GrtObject" key="owner">8535dbc2-006c-11e3-895c-080027bcf912</link>
11194 11194
                    </value>
11195 11195
                    <value type="object" struct-name="db.mysql.Column" id="8535e306-006c-11e3-895c-080027bcf912" struct-checksum="0x783b5183">
......
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">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
17621
              <link type="object">7f17a4b0-f6c0-11e2-af44-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="5328e8de-29ae-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xbd0a748" type="dict" key="lastKnownDBNames">
17635
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6564463c-29af-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xb515e88" 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>
......
18150 18150
              <value type="string" key="dbe121f8-f6e8-11e2-9cf1-080027bcf912">fk_georef_place1_idx</value>
18151 18151
              <value type="string" key="dc8d1c42-ad19-11e2-9d85-080027bcf912">aggregating_traits</value>
18152 18152
              <value type="string" key="dda7bbf8-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2</value>
18153
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent_event</value>
18153
              <value type="string" key="dda7bdec-0072-11e3-906b-080027bcf912">parent</value>
18154 18154
              <value type="string" key="dda7d480-0072-11e3-906b-080027bcf912">fk_stratum_event_sampling_event2_idx</value>
18155 18155
              <value type="string" key="e95a1e48-1de9-11e3-b571-080027bcf912">fk_party_list_entry_record1</value>
18156 18156
              <value type="string" key="e96e2084-23eb-11e3-ab7c-080027bcf912">name</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:04</value>
18264
      <value type="string" key="dateChanged">2013-09-30 02:11</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
1105 1105
CREATE TABLE `taxa_sampling_event` (
1106 1106
  `id` varbinary(767) NOT NULL,
1107 1107
  `place_observation` varbinary(767) NOT NULL,
1108
  `method` varbinary(767) DEFAULT NULL,
1108
  `subsetting_method` varbinary(767) DEFAULT NULL,
1109 1109
  PRIMARY KEY (`id`),
1110
  KEY `fk_sampling_event_method1_idx` (`method`),
1110
  KEY `fk_sampling_event_method1_idx` (`subsetting_method`),
1111 1111
  KEY `taxa_sampling_event_id_fkey1_idx` (`place_observation`),
1112
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`subsetting_method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1112 1113
  CONSTRAINT `fk_project_event10` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1113
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1114
  CONSTRAINT `fk_sampling_event_method1` FOREIGN KEY (`method`) REFERENCES `method` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1114
  CONSTRAINT `taxa_sampling_event_id_fkey1` FOREIGN KEY (`place_observation`) REFERENCES `place_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1115 1115
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them';
1116 1116
/*!40101 SET character_set_client = @saved_cs_client */;
1117 1117

  
schemas/VegCore/VegCore.pg.sql
1107 1107
CREATE TABLE "taxa_sampling_event" (
1108 1108
  "id" text NOT NULL,
1109 1109
  "place_observation" text NOT NULL,
1110
  "method" text DEFAULT NULL,
1110
  "subsetting_method" text DEFAULT NULL,
1111 1111
  PRIMARY KEY ("id"),
1112
  /*KEY "fk_sampling_event_method1_idx" ("method")*/CHECK (true),
1112
  /*KEY "fk_sampling_event_method1_idx" ("subsetting_method")*/CHECK (true),
1113 1113
  /*KEY "taxa_sampling_event_id_fkey1_idx" ("place_observation")*/CHECK (true),
1114
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("subsetting_method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1114 1115
  /*CONSTRAINT "fk_project_event10" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1115
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
1116
  /*CONSTRAINT "fk_sampling_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1116
  /*CONSTRAINT "taxa_sampling_event_id_fkey1" FOREIGN KEY ("place_observation") REFERENCES "place_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
1117 1117
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='for plots and aggregate_observations within them'*/;
1118 1118
/*!40101 SET character_set_client = @saved_cs_client */;
1119 1119

  

Also available in: Unified diff