Project

General

Profile

« Previous | Next » 

Revision 11197

schemas/VegCore/ERD/VegCore.ERD.mwb.run: record.id_within_dataset: removed instruction to also put this in source.name, because source.name is now optional, and this would not make sense because source does not have a parent pointer

View differences:

schemas/VegCore/ERD/document.mwb.xml
12264 12264
                      <value type="int" key="precision">-1</value>
12265 12265
                      <value type="int" key="scale">-1</value>
12266 12266
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12267
                      <value type="string" key="comment">also put this in source.name</value>
12267
                      <value type="string" key="comment"></value>
12268 12268
                      <value type="string" key="name">id_within_dataset</value>
12269 12269
                      <value type="string" key="oldName">id_within_dataset</value>
12270 12270
                      <link type="object" struct-name="GrtObject" key="owner">0de39e86-1dec-11e3-b571-080027bcf912</link>
......
12489 12489
                  <value type="int" key="commentedOut">0</value>
12490 12490
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12491 12491
                  <value _ptr_="0xb4f14b8" type="dict" key="customData"/>
12492
                  <value type="string" key="lastChangeDate">2013-10-09 11:55</value>
12492
                  <value type="string" key="lastChangeDate">2013-10-09 12:06</value>
12493 12493
                  <value type="int" key="modelOnly">0</value>
12494 12494
                  <value type="string" key="name">record</value>
12495 12495
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17569 17569
              <value type="int" key="visible">1</value>
17570 17570
              <value type="string" key="name"></value>
17571 17571
            </value>
17572
            <value _ptr_="0xb5000e0" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17572
            <value _ptr_="0xb5000e0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17573
              <link type="object">0de3d5b8-1dec-11e3-b571-080027bcf912</link>
17574
            </value>
17573 17575
            <value type="int" key="updateBlocked">0</value>
17574 17576
            <value type="real" key="width">1.6215e+03</value>
17575 17577
            <value type="real" key="x">0.e+00</value>
......
17582 17584
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17583 17585
        <value _ptr_="0xb451698" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17584 17586
        <value _ptr_="0xaa1d6d8" type="dict" key="syncProfiles">
17585
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6ddd12c8-3114-11e3-995a-080027bcf912" struct-checksum="0xc64972c2" key="">
17586
            <value _ptr_="0xc50ab00" type="dict" key="lastKnownDBNames">
17587
          <value type="object" struct-name="db.mgmt.SyncProfile" id="75fe30f4-3114-11e3-995a-080027bcf912" struct-checksum="0xc64972c2" key="">
17588
            <value _ptr_="0xcae7708" type="dict" key="lastKnownDBNames">
17587 17589
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17588 17590
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17589 17591
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18211 18213
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18212 18214
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18213 18215
      <value type="string" key="caption">New Model</value>
18214
      <value type="string" key="dateChanged">2013-10-09 11:56</value>
18216
      <value type="string" key="dateChanged">2013-10-09 12:06</value>
18215 18217
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18216 18218
      <value type="string" key="description"></value>
18217 18219
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
730 730
CREATE TABLE `record` (
731 731
  `id` varbinary(767) NOT NULL,
732 732
  `dataset` varbinary(767) NOT NULL,
733
  `id_within_dataset` varbinary(767) NOT NULL COMMENT 'also put this in source.name',
733
  `id_within_dataset` varbinary(767) NOT NULL,
734 734
  `authors` varbinary(767) DEFAULT NULL COMMENT 'people who helped create the data record. in vegetation data, they generally do not receive attribution. = Brad.vegpath.org?attribution.data_author',
735 735
  PRIMARY KEY (`id`),
736 736
  UNIQUE KEY `record_unique` (`dataset`,`id_within_dataset`),
schemas/VegCore/VegCore.pg.sql
732 732
CREATE TABLE "record" (
733 733
  "id" text NOT NULL,
734 734
  "dataset" text NOT NULL,
735
  "id_within_dataset" text NOT NULL /*COMMENT 'also put this in source.name'*/,
735
  "id_within_dataset" text NOT NULL,
736 736
  "authors" text DEFAULT NULL /*COMMENT 'people who helped create the data record. in vegetation data, they generally do not receive attribution. = Brad.vegpath.org?attribution.data_author'*/,
737 737
  PRIMARY KEY ("id"),
738 738
  /*CONSTRAINT "record_unique" */UNIQUE ("dataset","id_within_dataset"),

Also available in: Unified diff