Project

General

Profile

« Previous | Next » 

Revision 11114

schemas/VegCore/ERD/VegCore.ERD.mwb: individual_observation: removed code because this duplicates taxon_observation.collector_number and record.id_within_dataset

View differences:

schemas/VegCore/ERD/document.mwb.xml
7148 7148
                      <value type="string" key="oldName">individual</value>
7149 7149
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7150 7150
                    </value>
7151
                    <value type="object" struct-name="db.mysql.Column" id="5c62b4f2-ad03-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
7152
                      <value type="int" key="autoIncrement">0</value>
7153
                      <value type="string" key="characterSetName"></value>
7154
                      <value _ptr_="0xbb35aa8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
7155
                      <value type="string" key="collationName"></value>
7156
                      <value type="string" key="datatypeExplicitParams"></value>
7157
                      <value type="string" key="defaultValue"></value>
7158
                      <value type="int" key="defaultValueIsNull">1</value>
7159
                      <value _ptr_="0xbb35e28" type="list" content-type="string" key="flags"/>
7160
                      <value type="int" key="isNotNull">0</value>
7161
                      <value type="int" key="length">767</value>
7162
                      <value type="int" key="precision">-1</value>
7163
                      <value type="int" key="scale">-1</value>
7164
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
7165
                      <value type="string" key="comment"></value>
7166
                      <value type="string" key="name">code</value>
7167
                      <value type="string" key="oldName">code</value>
7168
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7169
                    </value>
7170 7151
                    <value type="object" struct-name="db.mysql.Column" id="bb863556-2992-11e3-a80d-080027bcf912" struct-checksum="0x783b5183">
7171 7152
                      <value type="int" key="autoIncrement">0</value>
7172 7153
                      <value type="string" key="characterSetName"></value>
......
13871 13852
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13872 13853
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13873 13854
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e8fe4-a6e0-11e2-95e9-080027bcf912</link>
13874
                <value type="real" key="middleSegmentOffset">3.90771711451158125782967545092105865478515625e+01</value>
13855
                <value type="real" key="middleSegmentOffset">4.800034148877801953858579508960247039794921875e+01</value>
13875 13856
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13876 13857
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13877 13858
                <value type="int" key="drawSplit">0</value>
......
13913 13894
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13914 13895
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13915 13896
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">f62bfaf6-a797-11e2-8681-080027bcf912</link>
13916
                <value type="real" key="middleSegmentOffset">4.7385129099081240156010608188807964324951171875e+01</value>
13897
                <value type="real" key="middleSegmentOffset">5.7000641529401292473266948945820331573486328125e+01</value>
13917 13898
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13918 13899
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13919 13900
                <value type="int" key="drawSplit">0</value>
......
16328 16309
                <value type="real" key="left">1.292e+03</value>
16329 16310
                <value type="int" key="locked">0</value>
16330 16311
                <value type="int" key="manualSizing">0</value>
16331
                <value type="real" key="top">7.6e+01</value>
16312
                <value type="real" key="top">6.5e+01</value>
16332 16313
                <value type="real" key="width">1.06e+02</value>
16333 16314
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16334 16315
                <value type="int" key="visible">1</value>
......
16343 16324
                <value type="int" key="triggersExpanded">0</value>
16344 16325
                <value type="string" key="color">#CCFFCC</value>
16345 16326
                <value type="int" key="expanded">1</value>
16346
                <value type="real" key="height">1.46e+02</value>
16327
                <value type="real" key="height">1.23e+02</value>
16347 16328
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16348 16329
                <value type="real" key="left">1.068e+03</value>
16349 16330
                <value type="int" key="locked">0</value>
......
17639 17620
              <value type="int" key="visible">1</value>
17640 17621
              <value type="string" key="name"></value>
17641 17622
            </value>
17642
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17623
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17624
              <link type="object">D1965EDA-481F-496B-9C24-79553E7891E8</link>
17625
            </value>
17643 17626
            <value type="int" key="updateBlocked">0</value>
17644 17627
            <value type="real" key="width">1.6215e+03</value>
17645 17628
            <value type="real" key="x">0.e+00</value>
......
18282 18265
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18283 18266
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18284 18267
      <value type="string" key="caption">New Model</value>
18285
      <value type="string" key="dateChanged">2013-09-29 22:46</value>
18268
      <value type="string" key="dateChanged">2013-09-29 22:54</value>
18286 18269
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18287 18270
      <value type="string" key="description"></value>
18288 18271
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
424 424
  `id` varbinary(767) NOT NULL,
425 425
  `place_observed_at` varbinary(767) DEFAULT NULL,
426 426
  `individual` varbinary(767) DEFAULT NULL COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant',
427
  `code` varbinary(767) DEFAULT NULL,
428 427
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant',
429 428
  PRIMARY KEY (`id`),
430 429
  KEY `fk_individual_observation_individual1_idx` (`individual`),
431 430
  KEY `fk_individual_observation_place1_idx` (`place_observed_at`),
432 431
  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),
433
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
434 432
  CONSTRAINT `fk_individual_observation_individual1` FOREIGN KEY (`individual`) REFERENCES `individual` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
435 433
  CONSTRAINT `fk_individual_observation_place1` FOREIGN KEY (`place_observed_at`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
436
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
434
  CONSTRAINT `fk_individual_observation_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
435
  CONSTRAINT `individual_observation_id_fkey1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
437 436
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]';
438 437
/*!40101 SET character_set_client = @saved_cs_client */;
439 438

  
schemas/VegCore/VegCore.pg.sql
426 426
  "id" text NOT NULL,
427 427
  "place_observed_at" text DEFAULT NULL,
428 428
  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
429
  "code" text DEFAULT NULL,
430 429
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant'*/,
431 430
  PRIMARY KEY ("id"),
432 431
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
433 432
  /*KEY "fk_individual_observation_place1_idx" ("place_observed_at")*/CHECK (true),
434 433
  /*KEY "individual_observation_id_fkey1_idx" ("specimenholder_institutions")*/CHECK (true),
435
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
436 434
  /*CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
437 435
  /*CONSTRAINT "fk_individual_observation_place1" FOREIGN KEY ("place_observed_at") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
438
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
436
  /*CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
437
  /*CONSTRAINT "individual_observation_id_fkey1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
439 438
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='An observation of an [[VegCore#Individual|Individual]]'*/;
440 439
/*!40101 SET character_set_client = @saved_cs_client */;
441 440

  

Also available in: Unified diff