Project

General

Profile

« Previous | Next » 

Revision 11120

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: event: reordered date_range, participants, place in the order of how likely they are to be provided. (place was considered more optional than the other two because a project does not usually have a place.)

View differences:

schemas/VegCore/ERD/document.mwb.xml
4927 4927 
                      <value type="string" key="oldName">date_range</value>
4928 4928 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4929 4929 
                    </value>
4930 
                    <value type="object" struct-name="db.mysql.Column" id="c6727d54-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4930 
                    <value type="object" struct-name="db.mysql.Column" id="251c2b92-f67b-11e2-aebb-080027bcf912" struct-checksum="0x783b5183">
4931 4931 
                      <value type="int" key="autoIncrement">0</value>
4932 4932 
                      <value type="string" key="characterSetName"></value>
4933 
                      <value _ptr_="0xbb0f360" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4933 
                      <value _ptr_="0xbb0f830" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4934 4934 
                      <value type="string" key="collationName"></value>
4935 4935 
                      <value type="string" key="datatypeExplicitParams"></value>
4936 4936 
                      <value type="string" key="defaultValue"></value>
4937 4937 
                      <value type="int" key="defaultValueIsNull">1</value>
4938 
                      <value _ptr_="0xbb0f6e0" type="list" content-type="string" key="flags"/>
4938 
                      <value _ptr_="0xbb0fbb0" type="list" content-type="string" key="flags"/>
4939 4939 
                      <value type="int" key="isNotNull">0</value>
4940 4940 
                      <value type="int" key="length">767</value>
4941 4941 
                      <value type="int" key="precision">-1</value>
4942 4942 
                      <value type="int" key="scale">-1</value>
4943 4943 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4944 4944 
                      <value type="string" key="comment"></value>
4945 
                      <value type="string" key="name">place</value>
4946 
                      <value type="string" key="oldName">place</value>
4945 
                      <value type="string" key="name">participants</value>
4946 
                      <value type="string" key="oldName">participants</value>
4947 4947 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4948 4948 
                    </value>
4949 
                    <value type="object" struct-name="db.mysql.Column" id="251c2b92-f67b-11e2-aebb-080027bcf912" struct-checksum="0x783b5183">
4949 
                    <value type="object" struct-name="db.mysql.Column" id="c6727d54-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
4950 4950 
                      <value type="int" key="autoIncrement">0</value>
4951 4951 
                      <value type="string" key="characterSetName"></value>
4952 
                      <value _ptr_="0xbb0f830" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4952 
                      <value _ptr_="0xbb0f360" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
4953 4953 
                      <value type="string" key="collationName"></value>
4954 4954 
                      <value type="string" key="datatypeExplicitParams"></value>
4955 4955 
                      <value type="string" key="defaultValue"></value>
4956 4956 
                      <value type="int" key="defaultValueIsNull">1</value>
4957 
                      <value _ptr_="0xbb0fbb0" type="list" content-type="string" key="flags"/>
4957 
                      <value _ptr_="0xbb0f6e0" type="list" content-type="string" key="flags"/>
4958 4958 
                      <value type="int" key="isNotNull">0</value>
4959 4959 
                      <value type="int" key="length">767</value>
4960 4960 
                      <value type="int" key="precision">-1</value>
4961 4961 
                      <value type="int" key="scale">-1</value>
4962 4962 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4963 4963 
                      <value type="string" key="comment"></value>
4964 
                      <value type="string" key="name">participants</value>
4965 
                      <value type="string" key="oldName">participants</value>
4964 
                      <value type="string" key="name">place</value>
4965 
                      <value type="string" key="oldName">place</value>
4966 4966 
                      <link type="object" struct-name="GrtObject" key="owner">c672743a-a7a0-11e2-b667-080027bcf912</link>
4967 4967 
                    </value>
4968 4968 
                  </value>
......
5182 5182 
                    </value>
5183 5183 
                    <value type="object" struct-name="db.mysql.Index" id="48c4e182-1dff-11e3-9d67-080027bcf912" struct-checksum="0x309b847a">
5184 5184 
                      <value _ptr_="0xbb12c68" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
5185 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="4f2b178a-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
5185 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="bef93ce6-29a7-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
5186 5186 
                          <value type="int" key="columnLength">0</value>
5187 5187 
                          <value type="string" key="comment"></value>
5188 5188 
                          <value type="int" key="descend">0</value>
5189 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727d54-a7a0-11e2-b667-080027bcf912</link>
5189 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727bce-a7a0-11e2-b667-080027bcf912</link>
5190 5190 
                          <value type="string" key="name"></value>
5191 5191 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
5192 5192 
                        </value>
5193 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="5e3664aa-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
5193 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="bf4b5878-29a7-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
5194 5194 
                          <value type="int" key="columnLength">0</value>
5195 5195 
                          <value type="string" key="comment"></value>
5196 5196 
                          <value type="int" key="descend">0</value>
5197 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727bce-a7a0-11e2-b667-080027bcf912</link>
5197 
                          <link type="object" struct-name="db.Column" key="referencedColumn">251c2b92-f67b-11e2-aebb-080027bcf912</link>
5198 5198 
                          <value type="string" key="name"></value>
5199 5199 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
5200 5200 
                        </value>
5201 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="5ecc96e6-1dff-11e3-9d67-080027bcf912" struct-checksum="0x62630b3c">
5201 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="bfb1a5e2-29a7-11e3-a80d-080027bcf912" struct-checksum="0x62630b3c">
5202 5202 
                          <value type="int" key="columnLength">0</value>
5203 5203 
                          <value type="string" key="comment"></value>
5204 5204 
                          <value type="int" key="descend">0</value>
5205 
                          <link type="object" struct-name="db.Column" key="referencedColumn">251c2b92-f67b-11e2-aebb-080027bcf912</link>
5205 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6727d54-a7a0-11e2-b667-080027bcf912</link>
5206 5206 
                          <value type="string" key="name"></value>
5207 5207 
                          <link type="object" struct-name="GrtObject" key="owner">48c4e182-1dff-11e3-9d67-080027bcf912</link>
5208 5208 
                        </value>
......
5250 5250 
                  <value type="int" key="commentedOut">0</value>
5251 5251 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
5252 5252 
                  <value _ptr_="0xbb0db98" type="dict" key="customData"/>
5253 
                  <value type="string" key="lastChangeDate">2013-09-15 05:07</value>
5253 
                  <value type="string" key="lastChangeDate">2013-09-30 01:10</value>
5254 5254 
                  <value type="int" key="modelOnly">0</value>
5255 5255 
                  <value type="string" key="name">event</value>
5256 5256 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
17743 17743 
              <value type="int" key="visible">1</value>
17744 17744 
              <value type="string" key="name"></value>
17745 17745 
            </value>
17746 
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17746 
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17747 
              <link type="object">C43D5355-2E9C-4315-BA47-B9741D1BB3B9</link>
17748 
            </value>
17747 17749 
            <value type="int" key="updateBlocked">0</value>
17748 17750 
            <value type="real" key="width">1.6215e+03</value>
17749 17751 
            <value type="real" key="x">0.e+00</value>
......
17756 17758 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17757 17759 
        <value _ptr_="0xbadb488" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17758 17760 
        <value _ptr_="0xb078db0" type="dict" key="syncProfiles">
17759 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="734aac04-29a6-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17760 
            <value _ptr_="0xd8691c8" type="dict" key="lastKnownDBNames">
17761 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="46dd99aa-29a7-11e3-a80d-080027bcf912" struct-checksum="0xc64972c2" key="">
17762 
            <value _ptr_="0xe060c50" type="dict" key="lastKnownDBNames">
17761 17763 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17762 17764 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17763 17765 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18389 18391 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18390 18392 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18391 18393 
      <value type="string" key="caption">New Model</value>
18392 
      <value type="string" key="dateChanged">2013-09-30 01:06</value>
18394 
      <value type="string" key="dateChanged">2013-09-30 01:10</value>
18393 18395 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18394 18396 
      <value type="string" key="description"></value>
18395 18397 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
186 186 
  `parent` varbinary(767) DEFAULT NULL,
187 187 
  `name` varbinary(767) DEFAULT NULL,
188 188 
  `date_range` varbinary(767) DEFAULT NULL,
189 
  `participants` varbinary(767) DEFAULT NULL,
189 190 
  `place` varbinary(767) DEFAULT NULL,
190 
  `participants` varbinary(767) DEFAULT NULL,
191 191 
  PRIMARY KEY (`id`),
192 192 
  UNIQUE KEY `event_unique_within_parent` (`parent`,`name`),
193 
  UNIQUE KEY `event_unique_within_place` (`place`,`date_range`,`participants`),
193 
  UNIQUE KEY `event_unique_within_place` (`date_range`,`participants`,`place`),
194 194 
  KEY `fk_event_place1_idx` (`place`),
195 195 
  KEY `fk_event1_idx` (`parent`),
196 196 
  KEY `fk_event_party_list1_idx` (`participants`),
197 
  CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
197 198 
  CONSTRAINT `fk_event_party_list1` FOREIGN KEY (`participants`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
198 
  CONSTRAINT `fk_event1` FOREIGN KEY (`parent`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
199 199 
  CONSTRAINT `fk_event_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
200 200 
  CONSTRAINT `fk_event_record1` FOREIGN KEY (`id`) REFERENCES `traceable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
201 201 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of time" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)';
schemas/VegCore/VegCore.pg.sql
188 188 
  "parent" text DEFAULT NULL,
189 189 
  "name" text DEFAULT NULL,
190 190 
  "date_range" text DEFAULT NULL,
191 
  "participants" text DEFAULT NULL,
191 192 
  "place" text DEFAULT NULL,
192 
  "participants" text DEFAULT NULL,
193 193 
  PRIMARY KEY ("id"),
194 194 
  /*CONSTRAINT "event_unique_within_parent" */UNIQUE ("parent","name"),
195 
  /*CONSTRAINT "event_unique_within_place" */UNIQUE ("place","date_range","participants"),
195 
  /*CONSTRAINT "event_unique_within_place" */UNIQUE ("date_range","participants","place"),
196 196 
  /*KEY "fk_event_place1_idx" ("place")*/CHECK (true),
197 197 
  /*KEY "fk_event1_idx" ("parent")*/CHECK (true),
198 198 
  /*KEY "fk_event_party_list1_idx" ("participants")*/CHECK (true),
199 
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
199 200 
  /*CONSTRAINT "fk_event_party_list1" FOREIGN KEY ("participants") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
200 
  /*CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
201 201 
  /*CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
202 202 
  /*CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "traceable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
203 203 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"an action that occurs at a place and during a period of text/*time*/" ("DwC":http://rs.tdwg.org/dwc/terms/#Event)'*/;

Also available in: Unified diff