Project

General

Profile

« Previous | Next » 

Revision 10808

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual_observation.place_observed_at: made it optional because some individual_observations (e.g. of the plant a specimen was collected from) may be missing location information. however, an individual_observation cannot have an associated individual unless the individual is traceable to a specific plant.

View differences:

schemas/VegCore/VegCore.pg.sql
386 386 
/*!40101 SET character_set_client = utf8 */;
387 387 
CREATE TABLE "individual_observation" (
388 388 
  "id" text NOT NULL,
389 
  "place_observed_at" text NOT NULL,
389 
  "place_observed_at" text DEFAULT NULL,
390 390 
  "individual" text DEFAULT NULL,
391 391 
  "code" text DEFAULT NULL,
392 392 
  "traits" hstore DEFAULT NULL,
schemas/VegCore/document.mwb.xml
7360 7360 
                      <value type="string" key="collationName"></value>
7361 7361 
                      <value type="string" key="datatypeExplicitParams"></value>
7362 7362 
                      <value type="string" key="defaultValue"></value>
7363 
                      <value type="int" key="defaultValueIsNull">0</value>
7363 
                      <value type="int" key="defaultValueIsNull">1</value>
7364 7364 
                      <value _ptr_="0xada7268" type="list" content-type="string" key="flags"/>
7365 
                      <value type="int" key="isNotNull">1</value>
7365 
                      <value type="int" key="isNotNull">0</value>
7366 7366 
                      <value type="int" key="length">767</value>
7367 7367 
                      <value type="int" key="precision">-1</value>
7368 7368 
                      <value type="int" key="scale">-1</value>
......
7456 7456 
                      <value type="string" key="name">fk_individual_observation_individual1</value>
7457 7457 
                      <value type="string" key="oldName">fk_individual_observation_individual1</value>
7458 7458 
                    </value>
7459 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="323a36d4-011b-11e3-b872-080027bcf912" struct-checksum="0x70a8fc40">
7460 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
7461 
                      <value _ptr_="0xada8a20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7462 
                        <link type="object">323a39a4-011b-11e3-b872-080027bcf912</link>
7463 
                      </value>
7464 
                      <value type="int" key="deferability">0</value>
7465 
                      <value type="string" key="deleteRule">CASCADE</value>
7466 
                      <link type="object" struct-name="db.Index" key="index">323a5f56-011b-11e3-b872-080027bcf912</link>
7467 
                      <value type="int" key="mandatory">1</value>
7468 
                      <value type="int" key="many">1</value>
7469 
                      <value type="int" key="modelOnly">0</value>
7470 
                      <link type="object" struct-name="db.Table" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7471 
                      <value _ptr_="0xada8da8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7472 
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
7473 
                      </value>
7474 
                      <value type="int" key="referencedMandatory">0</value>
7475 
                      <value type="string" key="updateRule">CASCADE</value>
7476 
                      <value type="string" key="comment"></value>
7477 
                      <value type="string" key="name">fk_individual_observation_place1</value>
7478 
                      <value type="string" key="oldName">fk_individual_observation_place1</value>
7479 
                    </value>
7459 7480 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="0ab99696-a7a1-11e2-b667-080027bcf912" struct-checksum="0x70a8fc40">
7460 7481 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
7461 7482 
                      <value _ptr_="0xada8628" type="list" content-type="object" content-struct-name="db.Column" key="columns">
......
7477 7498 
                      <value type="string" key="name">fk_individual_observation_taxon_occurrence1</value>
7478 7499 
                      <value type="string" key="oldName">fk_individual_observation_taxon_occurrence1</value>
7479 7500 
                    </value>
7480 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="323a36d4-011b-11e3-b872-080027bcf912" struct-checksum="0x70a8fc40">
7481 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
7482 
                      <value _ptr_="0xada8a20" type="list" content-type="object" content-struct-name="db.Column" key="columns">
7483 
                        <link type="object">323a39a4-011b-11e3-b872-080027bcf912</link>
7484 
                      </value>
7485 
                      <value type="int" key="deferability">0</value>
7486 
                      <value type="string" key="deleteRule">CASCADE</value>
7487 
                      <link type="object" struct-name="db.Index" key="index">323a5f56-011b-11e3-b872-080027bcf912</link>
7488 
                      <value type="int" key="mandatory">1</value>
7489 
                      <value type="int" key="many">1</value>
7490 
                      <value type="int" key="modelOnly">0</value>
7491 
                      <link type="object" struct-name="db.Table" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
7492 
                      <value _ptr_="0xada8da8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
7493 
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
7494 
                      </value>
7495 
                      <value type="int" key="referencedMandatory">1</value>
7496 
                      <value type="string" key="updateRule">CASCADE</value>
7497 
                      <value type="string" key="comment"></value>
7498 
                      <value type="string" key="name">fk_individual_observation_place1</value>
7499 
                      <value type="string" key="oldName">fk_individual_observation_place1</value>
7500 
                    </value>
7501 7501 
                  </value>
7502 7502 
                  <value _ptr_="0xada6808" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
7503 7503 
                    <value type="object" struct-name="db.mysql.Index" id="0ab99006-a7a1-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
7600 7600 
                  <value type="int" key="commentedOut">0</value>
7601 7601 
                  <value type="string" key="createDate">2013-04-17 13:54</value>
7602 7602 
                  <value _ptr_="0xada6590" type="dict" key="customData"/>
7603 
                  <value type="string" key="lastChangeDate">2013-08-09 10:44</value>
7603 
                  <value type="string" key="lastChangeDate">2013-08-30 05:03</value>
7604 7604 
                  <value type="int" key="modelOnly">0</value>
7605 7605 
                  <value type="string" key="name">individual_observation</value>
7606 7606 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
16736 16736 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
16737 16737 
        <value _ptr_="0xad4bdd8" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
16738 16738 
        <value _ptr_="0xa3d7058" type="dict" key="syncProfiles">
16739 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="a812a700-116b-11e3-b08a-080027bcf912" struct-checksum="0xc64972c2" key="">
16740 
            <value _ptr_="0xc16fc78" type="dict" key="lastKnownDBNames">
16739 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="a6468b48-116c-11e3-b08a-080027bcf912" struct-checksum="0xc64972c2" key="">
16740 
            <value _ptr_="0xc1c6478" type="dict" key="lastKnownDBNames">
16741 16741 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
16742 16742 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
16743 16743 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
17341 17341 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
17342 17342 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
17343 17343 
      <value type="string" key="caption">New Model</value>
17344 
      <value type="string" key="dateChanged">2013-08-30 04:59</value>
17344 
      <value type="string" key="dateChanged">2013-08-30 05:06</value>
17345 17345 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
17346 17346 
      <value type="string" key="description"></value>
17347 17347 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
384 384 
/*!40101 SET character_set_client = utf8 */;
385 385 
CREATE TABLE `individual_observation` (
386 386 
  `id` varbinary(767) NOT NULL,
387 
  `place_observed_at` varbinary(767) NOT NULL,
387 
  `place_observed_at` varbinary(767) DEFAULT NULL,
388 388 
  `individual` varbinary(767) DEFAULT NULL,
389 389 
  `code` varbinary(767) DEFAULT NULL,
390 390 
  `traits` set('hstore') COLLATE utf8_bin DEFAULT NULL,

Also available in: Unified diff