Project

General

Profile

« Previous | Next » 

Revision 10492

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: stem, stem_observation: made associated individual/individual_observation optional, because some stems (e.g. in VegBank) are not grouped together into individuals. note that a stem is still considered to BE-AN individual, but it is a type of individual which may be grouped under another, plant-level individual.

View differences:

schemas/VegCore/document.mwb.xml
7018 7018 
                      <value type="string" key="collationName"></value>
7019 7019 
                      <value type="string" key="datatypeExplicitParams"></value>
7020 7020 
                      <value type="string" key="defaultValue"></value>
7021 
                      <value type="int" key="defaultValueIsNull">0</value>
7021 
                      <value type="int" key="defaultValueIsNull">1</value>
7022 7022 
                      <value _ptr_="0xab0c598" type="list" content-type="string" key="flags"/>
7023 
                      <value type="int" key="isNotNull">1</value>
7023 
                      <value type="int" key="isNotNull">0</value>
7024 7024 
                      <value type="int" key="length">767</value>
7025 7025 
                      <value type="int" key="precision">-1</value>
7026 7026 
                      <value type="int" key="scale">-1</value>
......
7051 7051 
                      <value _ptr_="0xab0ca78" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7052 7052 
                        <link type="object">be8e4142-a6e0-11e2-95e9-080027bcf912</link>
7053 7053 
                      </value>
7054 
                      <value type="int" key="referencedMandatory">1</value>
7054 
                      <value type="int" key="referencedMandatory">0</value>
7055 7055 
                      <value type="string" key="updateRule">CASCADE</value>
7056 7056 
                      <value type="string" key="comment"></value>
7057 7057 
                      <value type="string" key="name">fk_stem_individual1</value>
......
7156 7156 
                  <value type="int" key="commentedOut">0</value>
7157 7157 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
7158 7158 
                  <value _ptr_="0xab0b8c0" type="dict" key="customData"/>
7159 
                  <value type="string" key="lastChangeDate">2013-04-24 14:34</value>
7159 
                  <value type="string" key="lastChangeDate">2013-07-30 14:58</value>
7160 7160 
                  <value type="int" key="modelOnly">0</value>
7161 7161 
                  <value type="string" key="name">stem</value>
7162 7162 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
7194 7194 
                      <value type="string" key="collationName"></value>
7195 7195 
                      <value type="string" key="datatypeExplicitParams"></value>
7196 7196 
                      <value type="string" key="defaultValue"></value>
7197 
                      <value type="int" key="defaultValueIsNull">0</value>
7197 
                      <value type="int" key="defaultValueIsNull">1</value>
7198 7198 
                      <value _ptr_="0xab0ed20" type="list" content-type="string" key="flags"/>
7199 
                      <value type="int" key="isNotNull">1</value>
7199 
                      <value type="int" key="isNotNull">0</value>
7200 7200 
                      <value type="int" key="length">767</value>
7201 7201 
                      <value type="int" key="precision">-1</value>
7202 7202 
                      <value type="int" key="scale">-1</value>
......
7286 7286 
                      <value _ptr_="0xab0ff98" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7287 7287 
                        <link type="object">0ab98a66-a7a1-11e2-b667-080027bcf912</link>
7288 7288 
                      </value>
7289 
                      <value type="int" key="referencedMandatory">1</value>
7289 
                      <value type="int" key="referencedMandatory">0</value>
7290 7290 
                      <value type="string" key="updateRule">CASCADE</value>
7291 7291 
                      <value type="string" key="comment"></value>
7292 7292 
                      <value type="string" key="name">fk_stem_observation_individual_observation1</value>
......
7445 7445 
                  <value type="int" key="commentedOut">0</value>
7446 7446 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
7447 7447 
                  <value _ptr_="0xab0e048" type="dict" key="customData"/>
7448 
                  <value type="string" key="lastChangeDate">2013-04-24 14:34</value>
7448 
                  <value type="string" key="lastChangeDate">2013-07-30 14:58</value>
7449 7449 
                  <value type="int" key="modelOnly">0</value>
7450 7450 
                  <value type="string" key="name">stem_observation</value>
7451 7451 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12844 12844 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12845 12845 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12846 12846 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">67fa5b28-f6c1-11e2-af44-080027bcf912</link>
12847 
                <value type="real" key="middleSegmentOffset">1.6777087258452417017906554974615573883056640625e+02</value>
12847 
                <value type="real" key="middleSegmentOffset">1.3700131056863932599299005232751369476318359375e+02</value>
12848 12848 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12849 12849 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12850 12850 
                <value type="int" key="drawSplit">0</value>
......
14742 14742 
              <value type="string" key="name"></value>
14743 14743 
            </value>
14744 14744 
            <value _ptr_="0xab48c90" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14745 
              <link type="object">c3763ff6-a7b3-11e2-8ba6-080027bcf912</link>
14745 
              <link type="object">87489D14-A806-4921-9DDF-5E3FC42EF45C</link>
14746 14746 
            </value>
14747 14747 
            <value type="int" key="updateBlocked">0</value>
14748 14748 
            <value type="real" key="width">1.6215e+03</value>
......
14756 14756 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14757 14757 
        <value _ptr_="0xaab1d90" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14758 14758 
        <value _ptr_="0x9d366e8" type="dict" key="syncProfiles">
14759 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6ce91dd0-f960-11e2-8597-080027bcf912" struct-checksum="0xc64972c2" key="">
14760 
            <value _ptr_="0xbcd7438" type="dict" key="lastKnownDBNames">
14759 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="5142b066-f963-11e2-8597-080027bcf912" struct-checksum="0xc64972c2" key="">
14760 
            <value _ptr_="0xc11fc90" type="dict" key="lastKnownDBNames">
14761 14761 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14762 14762 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14763 14763 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
15298 15298 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
15299 15299 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
15300 15300 
      <value type="string" key="caption">New Model</value>
15301 
      <value type="string" key="dateChanged">2013-07-30 14:42</value>
15301 
      <value type="string" key="dateChanged">2013-07-30 14:59</value>
15302 15302 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
15303 15303 
      <value type="string" key="description"></value>
15304 15304 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
833 833 
/*!40101 SET character_set_client = utf8 */;
834 834 
CREATE TABLE `stem` (
835 835 
  `id` varbinary(767) NOT NULL,
836 
  `individual` varbinary(767) NOT NULL,
836 
  `individual` varbinary(767) DEFAULT NULL,
837 837 
  PRIMARY KEY (`id`),
838 838 
  KEY `fk_stem_individual1_idx` (`individual`),
839 839 
  CONSTRAINT `fk_stem_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
......
856 856 
/*!40101 SET character_set_client = utf8 */;
857 857 
CREATE TABLE `stem_observation` (
858 858 
  `id` varbinary(767) NOT NULL,
859 
  `individual_observation` varbinary(767) NOT NULL,
859 
  `individual_observation` varbinary(767) DEFAULT NULL,
860 860 
  `stem` varbinary(767) DEFAULT NULL,
861 861 
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,
862 862 
  PRIMARY KEY (`id`),
schemas/VegCore/VegCore.pg.sql
835 835 
/*!40101 SET character_set_client = utf8 */;
836 836 
CREATE TABLE "stem" (
837 837 
  "id" text NOT NULL,
838 
  "individual" text NOT NULL,
838 
  "individual" text DEFAULT NULL,
839 839 
  PRIMARY KEY ("id"),
840 840 
  /*KEY "fk_stem_individual1_idx" ("individual")*/CHECK (true),
841 841 
  /*CONSTRAINT "fk_stem_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
......
858 858 
/*!40101 SET character_set_client = utf8 */;
859 859 
CREATE TABLE "stem_observation" (
860 860 
  "id" text NOT NULL,
861 
  "individual_observation" text NOT NULL,
861 
  "individual_observation" text DEFAULT NULL,
862 862 
  "stem" text DEFAULT NULL,
863 863 
  "traits" hstore DEFAULT NULL,
864 864 
  PRIMARY KEY ("id"),

Also available in: Unified diff