Project

General

Profile

« Previous | Next » 

Revision 10450

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual: added tag_history hstore to store custom identity attributes

View differences:

schemas/VegCore/document.mwb.xml
1581 1581 
                      <value type="string" key="oldName">tag</value>
1582 1582 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1583 1583 
                    </value>
1584 
                    <value type="object" struct-name="db.mysql.Column" id="d009232a-f671-11e2-9716-080027bcf912" struct-checksum="0x783b5183">
1585 
                      <value type="int" key="autoIncrement">0</value>
1586 
                      <value type="string" key="characterSetName"></value>
1587 
                      <value _ptr_="0xbf53ac8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1588 
                      <value type="string" key="collationName"></value>
1589 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
1590 
                      <value type="string" key="defaultValue"></value>
1591 
                      <value type="int" key="defaultValueIsNull">0</value>
1592 
                      <value _ptr_="0xbfe5c30" type="list" content-type="string" key="flags"/>
1593 
                      <value type="int" key="isNotNull">0</value>
1594 
                      <value type="int" key="length">-1</value>
1595 
                      <value type="int" key="precision">-1</value>
1596 
                      <value type="int" key="scale">-1</value>
1597 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
1598 
                      <value type="string" key="comment"></value>
1599 
                      <value type="string" key="name">tag_history</value>
1600 
                      <value type="string" key="oldName"></value>
1601 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1602 
                    </value>
1584 1603 
                  </value>
1585 1604 
                  <value type="string" key="connectionString"></value>
1586 1605 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
1664 1683 
                  <value type="int" key="commentedOut">0</value>
1665 1684 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1666 1685 
                  <value _ptr_="0xb2bb358" type="dict" key="customData"/>
1667 
                  <value type="string" key="lastChangeDate">2013-04-24 14:33</value>
1686 
                  <value type="string" key="lastChangeDate">2013-07-26 21:07</value>
1668 1687 
                  <value type="int" key="modelOnly">0</value>
1669 1688 
                  <value type="string" key="name">individual</value>
1670 1689 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12138 12157 
                <value type="int" key="triggersExpanded">0</value>
12139 12158 
                <value type="string" key="color">#CCFFCC</value>
12140 12159 
                <value type="int" key="expanded">1</value>
12141 
                <value type="real" key="height">7.7e+01</value>
12160 
                <value type="real" key="height">1.e+02</value>
12142 12161 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12143 12162 
                <value type="real" key="left">1.376e+03</value>
12144 12163 
                <value type="int" key="locked">0</value>
12145 12164 
                <value type="int" key="manualSizing">0</value>
12146 
                <value type="real" key="top">3.35e+02</value>
12165 
                <value type="real" key="top">3.47e+02</value>
12147 12166 
                <value type="real" key="width">1.06e+02</value>
12148 12167 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12149 12168 
                <value type="int" key="visible">1</value>
......
12163 12182 
                <value type="real" key="left">1.032e+03</value>
12164 12183 
                <value type="int" key="locked">0</value>
12165 12184 
                <value type="int" key="manualSizing">0</value>
12166 
                <value type="real" key="top">3.12e+02</value>
12185 
                <value type="real" key="top">3.35e+02</value>
12167 12186 
                <value type="real" key="width">1.8e+02</value>
12168 12187 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12169 12188 
                <value type="int" key="visible">1</value>
......
12183 12202 
                <value type="real" key="left">1.377e+03</value>
12184 12203 
                <value type="int" key="locked">0</value>
12185 12204 
                <value type="int" key="manualSizing">0</value>
12186 
                <value type="real" key="top">4.91e+02</value>
12205 
                <value type="real" key="top">5.14e+02</value>
12187 12206 
                <value type="real" key="width">7.8e+01</value>
12188 12207 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12189 12208 
                <value type="int" key="visible">1</value>
......
12203 12222 
                <value type="real" key="left">1.05e+03</value>
12204 12223 
                <value type="int" key="locked">0</value>
12205 12224 
                <value type="int" key="manualSizing">0</value>
12206 
                <value type="real" key="top">4.68e+02</value>
12225 
                <value type="real" key="top">4.91e+02</value>
12207 12226 
                <value type="real" key="width">1.52e+02</value>
12208 12227 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12209 12228 
                <value type="int" key="visible">1</value>
......
12223 12242 
                <value type="real" key="left">1.486e+03</value>
12224 12243 
                <value type="int" key="locked">0</value>
12225 12244 
                <value type="int" key="manualSizing">0</value>
12226 
                <value type="real" key="top">5.43e+02</value>
12245 
                <value type="real" key="top">5.66e+02</value>
12227 12246 
                <value type="real" key="width">1.14e+02</value>
12228 12247 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12229 12248 
                <value type="int" key="visible">1</value>
......
12243 12262 
                <value type="real" key="left">1.277e+03</value>
12244 12263 
                <value type="int" key="locked">0</value>
12245 12264 
                <value type="int" key="manualSizing">0</value>
12246 
                <value type="real" key="top">6.08e+02</value>
12265 
                <value type="real" key="top">6.31e+02</value>
12247 12266 
                <value type="real" key="width">1.06e+02</value>
12248 12267 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12249 12268 
                <value type="int" key="visible">1</value>
......
12729 12748 
                <value type="real" key="left">1.03e+03</value>
12730 12749 
                <value type="int" key="locked">0</value>
12731 12750 
                <value type="int" key="manualSizing">0</value>
12732 
                <value type="real" key="top">6.72e+02</value>
12751 
                <value type="real" key="top">6.95e+02</value>
12733 12752 
                <value type="real" key="width">1.8e+02</value>
12734 12753 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12735 12754 
                <value type="int" key="visible">1</value>
......
12786 12805 
                <value type="int" key="expanded">1</value>
12787 12806 
                <value type="real" key="height">1.e+02</value>
12788 12807 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12789 
                <value type="real" key="left">1.225e+03</value>
12808 
                <value type="real" key="left">1.234e+03</value>
12790 12809 
                <value type="int" key="locked">0</value>
12791 12810 
                <value type="int" key="manualSizing">0</value>
12792 
                <value type="real" key="top">7.37e+02</value>
12811 
                <value type="real" key="top">7.59e+02</value>
12793 12812 
                <value type="real" key="width">2.06e+02</value>
12794 12813 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12795 12814 
                <value type="int" key="visible">1</value>
......
13037 13056 
              <value type="int" key="visible">1</value>
13038 13057 
              <value type="string" key="name"></value>
13039 13058 
            </value>
13040 
            <value _ptr_="0xb340750" type="list" content-type="object" content-struct-name="model.Object" key="selection">
13041 
              <link type="object">4c400ef2-a741-11e2-9fbf-080027bcf912</link>
13042 
            </value>
13059 
            <value _ptr_="0xb340750" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
13043 13060 
            <value type="int" key="updateBlocked">0</value>
13044 13061 
            <value type="real" key="width">1.6215e+03</value>
13045 13062 
            <value type="real" key="x">0.e+00</value>
......
13134 13151 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13135 13152 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13136 13153 
      <value type="string" key="caption">New Model</value>
13137 
      <value type="string" key="dateChanged">2013-07-26 20:32</value>
13154 
      <value type="string" key="dateChanged">2013-07-26 21:08</value>
13138 13155 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13139 13156 
      <value type="string" key="description"></value>
13140 13157 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
260 260 
CREATE TABLE `individual` (
261 261 
  `id` varbinary(767) NOT NULL,
262 262 
  `tag` varbinary(767) DEFAULT NULL,
263 
  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,
263 264 
  PRIMARY KEY (`id`),
264 265 
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `taxon_occurrence` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
265 266 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';
schemas/VegCore/VegCore.pg.sql
262 262 
CREATE TABLE "individual" (
263 263 
  "id" text NOT NULL,
264 264 
  "tag" text DEFAULT NULL,
265 
  "tag_history" hstore DEFAULT NULL,
265 266 
  PRIMARY KEY ("id"),
266 267 
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
267 268 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;

Also available in: Unified diff