Project

General

Profile

« Previous | Next » 

Revision 11135

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: individual_observation.specimenholder_institutions: documented that instead, the taxon_occurrence for the individual_observation should have an autogenerated current_observation that merges together all the individual_observations for these institutions' specimens. in this case, each institution's specimen will still have its own individual_observation containing what it believes to be the specimenholder institutions.

View differences:

schemas/VegCore/ERD/document.mwb.xml
7224 7224 
                      <value type="int" key="precision">-1</value>
7225 7225 
                      <value type="int" key="scale">-1</value>
7226 7226 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
7227 
                      <value type="string" key="comment">institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).</value>
7227 
                      <value type="string" key="comment">institutions which store specimens from this plant. when provided, the taxon_occurrence should have an autogenerated current_observation that merges together all the individual_observations for these institutions' specimens.</value>
7228 7228 
                      <value type="string" key="name">specimenholder_institutions</value>
7229 7229 
                      <value type="string" key="oldName">specimenholder_institutions</value>
7230 7230 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
......
7400 7400 
                  <value type="int" key="commentedOut">0</value>
7401 7401 
                  <value type="string" key="createDate">2013-04-17 13:54</value>
7402 7402 
                  <value _ptr_="0xad83ce8" type="dict" key="customData"/>
7403 
                  <value type="string" key="lastChangeDate">2013-09-30 03:02</value>
7403 
                  <value type="string" key="lastChangeDate">2013-09-30 03:16</value>
7404 7404 
                  <value type="int" key="modelOnly">0</value>
7405 7405 
                  <value type="string" key="name">individual_observation</value>
7406 7406 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17477 17477 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17478 17478 
        <value _ptr_="0xad2bf00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17479 17479 
        <value _ptr_="0xa5b9c88" type="dict" key="syncProfiles">
17480 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="b9a20eda-29b6-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17481 
            <value _ptr_="0xbb06738" type="dict" key="lastKnownDBNames">
17480 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="65eb6998-29b7-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17481 
            <value _ptr_="0xbe9ed10" type="dict" key="lastKnownDBNames">
17482 17482 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17483 17483 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17484 17484 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18102 18102 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18103 18103 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18104 18104 
      <value type="string" key="caption">New Model</value>
18105 
      <value type="string" key="dateChanged">2013-09-30 03:02</value>
18105 
      <value type="string" key="dateChanged">2013-09-30 03:16</value>
18106 18106 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18107 18107 
      <value type="string" key="description"></value>
18108 18108 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
420 420 
CREATE TABLE `individual_observation` (
421 421 
  `id` varbinary(767) NOT NULL,
422 422 
  `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',
423 
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).',
423 
  `specimenholder_institutions` varbinary(767) DEFAULT NULL COMMENT 'institutions which store specimens from this plant. when provided, the taxon_occurrence should have an autogenerated current_observation that merges together all the individual_observations for these institutions'' specimens.',
424 424 
  PRIMARY KEY (`id`),
425 425 
  KEY `fk_individual_observation_individual1_idx` (`individual`),
426 426 
  KEY `individual_observation_id_fkey1_idx` (`specimenholder_institutions`),
schemas/VegCore/VegCore.pg.sql
422 422 
CREATE TABLE "individual_observation" (
423 423 
  "id" text NOT NULL,
424 424 
  "individual" text DEFAULT NULL /*COMMENT 'optional because an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant'*/,
425 
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant. when provided, the source should be set to the value of this field (because these institutions together provided the data for this entity).'*/,
425 
  "specimenholder_institutions" text DEFAULT NULL /*COMMENT 'institutions which store specimens from this plant. when provided, the taxon_occurrence should have an autogenerated current_observation that merges together all the individual_observations for these institutions'' specimens.'*/,
426 426 
  PRIMARY KEY ("id"),
427 427 
  /*KEY "fk_individual_observation_individual1_idx" ("individual")*/CHECK (true),
428 428 
  /*KEY "individual_observation_id_fkey1_idx" ("specimenholder_institutions")*/CHECK (true),

Also available in: Unified diff