Project

General

Profile

« Previous | Next » 

Revision 11380

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: place.rank: made it required, because every place should have some kind of rank indicating what type of place it is, including lower ranks (e.g. plot, individual)

View differences:

schemas/VegCore/ERD/document.mwb.xml
6056 6056 
                      <value type="string" key="oldName">id</value>
6057 6057 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6058 6058 
                    </value>
6059 
                    <value type="object" struct-name="db.mysql.Column" id="c67241b8-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6059 
                    <value type="object" struct-name="db.mysql.Column" id="8f0c3678-f978-11e2-9f36-080027bcf912" struct-checksum="0x783b5183">
6060 6060 
                      <value type="int" key="autoIncrement">0</value>
6061 6061 
                      <value type="string" key="characterSetName"></value>
6062 
                      <value _ptr_="0xac98648" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6062 
                      <value _ptr_="0xac98af8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6063 6063 
                      <value type="string" key="collationName"></value>
6064 6064 
                      <value type="string" key="datatypeExplicitParams"></value>
6065 6065 
                      <value type="string" key="defaultValue"></value>
6066 
                      <value type="int" key="defaultValueIsNull">1</value>
6067 
                      <value _ptr_="0xac989a8" type="list" content-type="string" key="flags"/>
6068 
                      <value type="int" key="isNotNull">0</value>
6066 
                      <value type="int" key="defaultValueIsNull">0</value>
6067 
                      <value _ptr_="0xac98e78" type="list" content-type="string" key="flags"/>
6068 
                      <value type="int" key="isNotNull">1</value>
6069 6069 
                      <value type="int" key="length">767</value>
6070 6070 
                      <value type="int" key="precision">-1</value>
6071 6071 
                      <value type="int" key="scale">-1</value>
6072 6072 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6073 
                      <value type="string" key="comment"></value>
6074 
                      <value type="string" key="name">parent</value>
6075 
                      <value type="string" key="oldName">parent</value>
6073 
                      <value type="string" key="comment">every place should have some kind of rank indicating what type of place it is, including lower ranks (e.g. plot, individual)</value>
6074 
                      <value type="string" key="name">rank</value>
6075 
                      <value type="string" key="oldName">rank</value>
6076 6076 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6077 6077 
                    </value>
6078 
                    <value type="object" struct-name="db.mysql.Column" id="8f0c3678-f978-11e2-9f36-080027bcf912" struct-checksum="0x783b5183">
6078 
                    <value type="object" struct-name="db.mysql.Column" id="c67241b8-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6079 6079 
                      <value type="int" key="autoIncrement">0</value>
6080 6080 
                      <value type="string" key="characterSetName"></value>
6081 
                      <value _ptr_="0xac98af8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6081 
                      <value _ptr_="0xac98648" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6082 6082 
                      <value type="string" key="collationName"></value>
6083 6083 
                      <value type="string" key="datatypeExplicitParams"></value>
6084 6084 
                      <value type="string" key="defaultValue"></value>
6085 6085 
                      <value type="int" key="defaultValueIsNull">1</value>
6086 
                      <value _ptr_="0xac98e78" type="list" content-type="string" key="flags"/>
6086 
                      <value _ptr_="0xac989a8" type="list" content-type="string" key="flags"/>
6087 6087 
                      <value type="int" key="isNotNull">0</value>
6088 6088 
                      <value type="int" key="length">767</value>
6089 6089 
                      <value type="int" key="precision">-1</value>
6090 6090 
                      <value type="int" key="scale">-1</value>
6091 6091 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6092 6092 
                      <value type="string" key="comment"></value>
6093 
                      <value type="string" key="name">rank</value>
6094 
                      <value type="string" key="oldName">rank</value>
6093 
                      <value type="string" key="name">parent</value>
6094 
                      <value type="string" key="oldName">parent</value>
6095 6095 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6096 6096 
                    </value>
6097 6097 
                    <value type="object" struct-name="db.mysql.Column" id="5a0331b2-f96d-11e2-9fb4-080027bcf912" struct-checksum="0x783b5183">
......
6327 6327 
                      <value type="int" key="isPrimary">0</value>
6328 6328 
                      <value type="string" key="name">place__unique</value>
6329 6329 
                      <value type="int" key="unique">1</value>
6330 
                      <value type="string" key="oldName"></value>
6330 
                      <value type="string" key="oldName">place__unique</value>
6331 6331 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6332 6332 
                    </value>
6333 6333 
                  </value>
......
6361 6361 
                  <value type="int" key="commentedOut">0</value>
6362 6362 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6363 6363 
                  <value _ptr_="0xac97cd0" type="dict" key="customData"/>
6364 
                  <value type="string" key="lastChangeDate">2013-10-20 14:17</value>
6364 
                  <value type="string" key="lastChangeDate">2013-10-20 14:28</value>
6365 6365 
                  <value type="int" key="modelOnly">0</value>
6366 6366 
                  <value type="string" key="name">place</value>
6367 6367 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17845 17845 
              <value type="int" key="visible">1</value>
17846 17846 
              <value type="string" key="name"></value>
17847 17847 
            </value>
17848 
            <value _ptr_="0xad043d8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17848 
            <value _ptr_="0xad043d8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17849 
              <link type="object">39fe67ca-011e-11e3-9f3a-080027bcf912</link>
17850 
            </value>
17849 17851 
            <value type="int" key="updateBlocked">0</value>
17850 17852 
            <value type="real" key="width">1.6215e+03</value>
17851 17853 
            <value type="real" key="x">0.e+00</value>
......
17858 17860 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17859 17861 
        <value _ptr_="0xac51240" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17860 17862 
        <value _ptr_="0xa49c310" type="dict" key="syncProfiles">
17861 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="3e536a92-39cb-11e3-96cb-080027bcf912" struct-checksum="0xc64972c2" key="">
17862 
            <value _ptr_="0xbce70f8" type="dict" key="lastKnownDBNames">
17863 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9ad9cfa2-39cd-11e3-96cb-080027bcf912" struct-checksum="0xc64972c2" key="">
17864 
            <value _ptr_="0xb55efa8" type="dict" key="lastKnownDBNames">
17863 17865 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17864 17866 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17865 17867 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17892 17894 
              <value type="string" key="0de3b22c-1dec-11e3-b571-080027bcf912">PRIMARY</value>
17893 17895 
              <value type="string" key="0de3b510-1dec-11e3-b571-080027bcf912">record_unique</value>
17894 17896 
              <value type="string" key="0de3ba38-1dec-11e3-b571-080027bcf912">fk_record_source1_idx</value>
17897 
              <value type="string" key="0f10b300-39cd-11e3-96cb-080027bcf912">place__unique</value>
17895 17898 
              <value type="string" key="10b01930-1dcb-11e3-b98c-080027bcf912">fk_taxon_occurrence_taxon_determination3_idx</value>
17896 17899 
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
17897 17900 
              <value type="string" key="1156cf50-2393-11e3-a6f3-080027bcf912">fk_dataset_dataset1</value>
......
18498 18501 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18499 18502 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18500 18503 
      <value type="string" key="caption">New Model</value>
18501 
      <value type="string" key="dateChanged">2013-10-20 14:20</value>
18504 
      <value type="string" key="dateChanged">2013-10-20 14:28</value>
18502 18505 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18503 18506 
      <value type="string" key="description"></value>
18504 18507 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
616 616 
/*!40101 SET character_set_client = utf8 */;
617 617 
CREATE TABLE `place` (
618 618 
  `id` varbinary(767) NOT NULL,
619 
  `rank` varbinary(767) NOT NULL COMMENT 'every place should have some kind of rank indicating what type of place it is, including lower ranks (e.g. plot, individual)',
619 620 
  `parent` varbinary(767) DEFAULT NULL,
620 
  `rank` varbinary(767) DEFAULT NULL,
621 621 
  `name` varbinary(767) DEFAULT NULL,
622 622 
  `geopath` varbinary(767) DEFAULT NULL,
623 623 
  `verbatim` set('hstore') COLLATE utf8_bin DEFAULT NULL COMMENT 'for verbatim coordinates, etc.',
schemas/VegCore/VegCore.pg.sql
618 618 
/*!40101 SET character_set_client = utf8 */;
619 619 
CREATE TABLE "place" (
620 620 
  "id" text NOT NULL,
621 
  "rank" text NOT NULL /*COMMENT 'every place should have some kind of rank indicating what type of place it is, including lower ranks (e.g. plot, individual)'*/,
621 622 
  "parent" text DEFAULT NULL,
622 
  "rank" text DEFAULT NULL,
623 623 
  "name" text DEFAULT NULL,
624 624 
  "geopath" text DEFAULT NULL,
625 625 
  "verbatim" hstore DEFAULT NULL /*COMMENT 'for verbatim coordinates, etc.'*/,

Also available in: Unified diff