Project

General

Profile

« Previous | Next » 

Revision 11127

schemas/VegCore/ERD/VegCore.ERD.mwb: individual_count.taxon_presence: renamed to parent so it will merge with the inherited parent field. this is the taxon_presence for the taxon as a whole (not subdivided by size_class, etc.).

View differences:

schemas/VegCore/ERD/document.mwb.xml
2147 2147
                      <value type="int" key="precision">-1</value>
2148 2148
                      <value type="int" key="scale">-1</value>
2149 2149
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2150
                      <value type="string" key="comment"></value>
2151
                      <value type="string" key="name">taxon_presence</value>
2150
                      <value type="string" key="comment">the taxon_presence for the taxon as a whole (not subdivided by size_class, etc.)</value>
2151
                      <value type="string" key="name">parent</value>
2152 2152
                      <value type="string" key="oldName">taxon_presence</value>
2153 2153
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2154 2154
                    </value>
......
2379 2379
                  <value type="int" key="commentedOut">0</value>
2380 2380
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2381 2381
                  <value _ptr_="0xa917438" type="dict" key="customData"/>
2382
                  <value type="string" key="lastChangeDate">2013-09-22 00:54</value>
2382
                  <value type="string" key="lastChangeDate">2013-09-30 02:15</value>
2383 2383
                  <value type="int" key="modelOnly">0</value>
2384 2384
                  <value type="string" key="name">individual_count</value>
2385 2385
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
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 10453
                      <value type="string" key="name">subsetting_method</value>
10454
                      <value type="string" key="oldName">method</value>
10454
                      <value type="string" key="oldName">subsetting_method</value>
10455 10455
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10456 10456
                    </value>
10457 10457
                  </value>
......
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">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
17621
              <link type="object">83714B90-5AC7-4F4E-9E13-ABFB9C9B0C81</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="6564463c-29af-11e3-a980-080027bcf912" struct-checksum="0xc64972c2" key="">
17636
            <value _ptr_="0xb515e88" type="dict" key="lastKnownDBNames">
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">
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>
......
17954 17954
              <value type="string" key="a76e6760-23ec-11e3-ab7c-080027bcf912">person_unique</value>
17955 17955
              <value type="string" key="a8348424-a78f-11e2-84c3-080027bcf912">geovalid</value>
17956 17956
              <value type="string" key="a841b894-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1</value>
17957
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">method</value>
17957
              <value type="string" key="a841ba7e-f6c0-11e2-af44-080027bcf912">subsetting_method</value>
17958 17958
              <value type="string" key="a842920a-f6c0-11e2-af44-080027bcf912">fk_sampling_event_method1_idx</value>
17959 17959
              <value type="string" key="a882f398-0117-11e3-b872-080027bcf912">count</value>
17960 17960
              <value type="string" key="aa191bd2-a92a-11e2-93c8-080027bcf912">longitude_deg</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:11</value>
18264
      <value type="string" key="dateChanged">2013-09-30 02:15</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
394 394
/*!40101 SET character_set_client = utf8 */;
395 395
CREATE TABLE `individual_count` (
396 396
  `id` varbinary(767) NOT NULL,
397
  `taxon_presence` varbinary(767) NOT NULL,
397
  `parent` varbinary(767) NOT NULL COMMENT 'the taxon_presence for the taxon as a whole (not subdivided by size_class, etc.)',
398 398
  `size_class` varbinary(767) DEFAULT NULL,
399 399
  `aggregating_traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
400 400
  `count` int(11) DEFAULT NULL,
401 401
  PRIMARY KEY (`id`),
402
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`taxon_presence`),
402
  KEY `fk_aggregate_observation_taxon_presence1_idx` (`parent`),
403 403
  KEY `fk_aggregate_observation_size_class1_idx` (`size_class`),
404
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`parent`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
404 405
  CONSTRAINT `fk_aggregate_observation_size_class1` FOREIGN KEY (`size_class`) REFERENCES `size_class` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
405
  CONSTRAINT `fk_aggregate_observation_taxon_presence1` FOREIGN KEY (`taxon_presence`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
406 406
  CONSTRAINT `fk_individual_count_taxon_presence1` FOREIGN KEY (`id`) REFERENCES `taxon_presence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
407 407
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegBank.vegpath.org?stemCount';
408 408
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
396 396
/*!40101 SET character_set_client = utf8 */;
397 397
CREATE TABLE "individual_count" (
398 398
  "id" text NOT NULL,
399
  "taxon_presence" text NOT NULL,
399
  "parent" text NOT NULL /*COMMENT 'the taxon_presence for the taxon as a whole (not subdivided by size_class, etc.)'*/,
400 400
  "size_class" text DEFAULT NULL,
401 401
  "aggregating_traits" hstore DEFAULT NULL,
402 402
  "count" integer DEFAULT NULL,
403 403
  PRIMARY KEY ("id"),
404
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("taxon_presence")*/CHECK (true),
404
  /*KEY "fk_aggregate_observation_taxon_presence1_idx" ("parent")*/CHECK (true),
405 405
  /*KEY "fk_aggregate_observation_size_class1_idx" ("size_class")*/CHECK (true),
406
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("parent") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
406 407
  /*CONSTRAINT "fk_aggregate_observation_size_class1" FOREIGN KEY ("size_class") REFERENCES "size_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
407
  /*CONSTRAINT "fk_aggregate_observation_taxon_presence1" FOREIGN KEY ("taxon_presence") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
408 408
  /*CONSTRAINT "fk_individual_count_taxon_presence1" FOREIGN KEY ("id") REFERENCES "taxon_presence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
409 409
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='= VegBank.vegpath.org?stemCount'*/;
410 410
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff