Project

General

Profile

« Previous | Next » 

Revision 11381

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: place.name: made it required because it's needed for the unique constraint to be populated properly (including for subclasses such as geoplace, which need to generate this from the coordinates)

View differences:

schemas/VegCore/ERD/document.mwb.xml
6075 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="c67241b8-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6078 
                    <value type="object" struct-name="db.mysql.Column" id="5a0331b2-f96d-11e2-9fb4-080027bcf912" struct-checksum="0x783b5183">
6079 6079 
                      <value type="int" key="autoIncrement">0</value>
6080 6080 
                      <value type="string" key="characterSetName"></value>
6081 
                      <value _ptr_="0xac98648" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6081 
                      <value _ptr_="0xac98fc8" 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 
                      <value type="int" key="defaultValueIsNull">1</value>
6086 
                      <value _ptr_="0xac989a8" type="list" content-type="string" key="flags"/>
6087 
                      <value type="int" key="isNotNull">0</value>
6085 
                      <value type="int" key="defaultValueIsNull">0</value>
6086 
                      <value _ptr_="0xac99348" type="list" content-type="string" key="flags"/>
6087 
                      <value type="int" key="isNotNull">1</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 
                      <value type="string" key="comment"></value>
6093 
                      <value type="string" key="name">parent</value>
6094 
                      <value type="string" key="oldName">parent</value>
6092 
                      <value type="string" key="comment">for geoplace, generated from the coordinates</value>
6093 
                      <value type="string" key="name">name</value>
6094 
                      <value type="string" key="oldName">name</value>
6095 6095 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6096 6096 
                    </value>
6097 
                    <value type="object" struct-name="db.mysql.Column" id="5a0331b2-f96d-11e2-9fb4-080027bcf912" struct-checksum="0x783b5183">
6097 
                    <value type="object" struct-name="db.mysql.Column" id="c67241b8-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6098 6098 
                      <value type="int" key="autoIncrement">0</value>
6099 6099 
                      <value type="string" key="characterSetName"></value>
6100 
                      <value _ptr_="0xac98fc8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6100 
                      <value _ptr_="0xac98648" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6101 6101 
                      <value type="string" key="collationName"></value>
6102 6102 
                      <value type="string" key="datatypeExplicitParams"></value>
6103 6103 
                      <value type="string" key="defaultValue"></value>
6104 6104 
                      <value type="int" key="defaultValueIsNull">1</value>
6105 
                      <value _ptr_="0xac99348" type="list" content-type="string" key="flags"/>
6105 
                      <value _ptr_="0xac989a8" type="list" content-type="string" key="flags"/>
6106 6106 
                      <value type="int" key="isNotNull">0</value>
6107 6107 
                      <value type="int" key="length">767</value>
6108 6108 
                      <value type="int" key="precision">-1</value>
6109 6109 
                      <value type="int" key="scale">-1</value>
6110 6110 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6111 6111 
                      <value type="string" key="comment"></value>
6112 
                      <value type="string" key="name">name</value>
6113 
                      <value type="string" key="oldName">name</value>
6112 
                      <value type="string" key="name">parent</value>
6113 
                      <value type="string" key="oldName">parent</value>
6114 6114 
                      <link type="object" struct-name="GrtObject" key="owner">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
6115 6115 
                    </value>
6116 6116 
                    <value type="object" struct-name="db.mysql.Column" id="6b43ac84-f979-11e2-9f36-080027bcf912" struct-checksum="0x783b5183">
......
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:28</value>
6364 
                  <value type="string" key="lastChangeDate">2013-10-20 14:38</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>
......
17846 17846 
              <value type="string" key="name"></value>
17847 17847 
            </value>
17848 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>
17849 
              <link type="object">286AE59E-913E-4F00-A662-693F828EFB6F</link>
17850 17850 
            </value>
17851 17851 
            <value type="int" key="updateBlocked">0</value>
17852 17852 
            <value type="real" key="width">1.6215e+03</value>
......
17860 17860 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17861 17861 
        <value _ptr_="0xac51240" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17862 17862 
        <value _ptr_="0xa49c310" type="dict" key="syncProfiles">
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 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9912941e-39ce-11e3-96cb-080027bcf912" struct-checksum="0xc64972c2" key="">
17864 
            <value _ptr_="0xa232930" type="dict" key="lastKnownDBNames">
17865 17865 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17866 17866 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17867 17867 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18501 18501 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18502 18502 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18503 18503 
      <value type="string" key="caption">New Model</value>
18504 
      <value type="string" key="dateChanged">2013-10-20 14:28</value>
18504 
      <value type="string" key="dateChanged">2013-10-20 14:38</value>
18505 18505 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18506 18506 
      <value type="string" key="description"></value>
18507 18507 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
617 617 
CREATE TABLE `place` (
618 618 
  `id` varbinary(767) NOT NULL,
619 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)',
620 
  `name` varbinary(767) NOT NULL COMMENT 'for geoplace, generated from the coordinates',
620 621 
  `parent` varbinary(767) DEFAULT NULL,
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.',
624 624 
  PRIMARY KEY (`id`),
schemas/VegCore/VegCore.pg.sql
619 619 
CREATE TABLE "place" (
620 620 
  "id" text NOT NULL,
621 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)'*/,
622 
  "name" text NOT NULL /*COMMENT 'for geoplace, generated from the coordinates'*/,
622 623 
  "parent" text DEFAULT NULL,
623 
  "name" text DEFAULT NULL,
624 624 
  "geopath" text DEFAULT NULL,
625 625 
  "verbatim" hstore DEFAULT NULL /*COMMENT 'for verbatim coordinates, etc.'*/,
626 626 
  PRIMARY KEY ("id"),

Also available in: Unified diff