Project

General

Profile

« Previous | Next » 

Revision 8686

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: added hstore expansion columns where needed

View differences:

schemas/VegCore/document.mwb.xml
1367 1367 
                      <value type="string" key="oldName">source_record_id</value>
1368 1368 
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1369 1369 
                    </value>
1370 
                    <value type="object" struct-name="db.mysql.Column" id="43f62c16-ad1a-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
1371 
                      <value type="int" key="autoIncrement">0</value>
1372 
                      <value type="string" key="characterSetName"></value>
1373 
                      <value _ptr_="0xadead80" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1374 
                      <value type="string" key="collationName"></value>
1375 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
1376 
                      <value type="string" key="defaultValue"></value>
1377 
                      <value type="int" key="defaultValueIsNull">0</value>
1378 
                      <value _ptr_="0xaea1338" type="list" content-type="string" key="flags"/>
1379 
                      <value type="int" key="isNotNull">0</value>
1380 
                      <value type="int" key="length">-1</value>
1381 
                      <value type="int" key="precision">-1</value>
1382 
                      <value type="int" key="scale">-1</value>
1383 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
1384 
                      <value type="string" key="comment"></value>
1385 
                      <value type="string" key="name">info</value>
1386 
                      <value type="string" key="oldName"></value>
1387 
                      <link type="object" struct-name="GrtObject" key="owner">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
1388 
                    </value>
1370 1389 
                  </value>
1371 1390 
                  <value type="string" key="connectionString"></value>
1372 1391 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
1512 1531 
                  <value type="int" key="commentedOut">0</value>
1513 1532 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1514 1533 
                  <value _ptr_="0x9fd1890" type="dict" key="customData"/>
1515 
                  <value type="string" key="lastChangeDate">2013-04-24 08:02</value>
1534 
                  <value type="string" key="lastChangeDate">2013-04-24 13:05</value>
1516 1535 
                  <value type="int" key="modelOnly">0</value>
1517 1536 
                  <value type="string" key="name">record</value>
1518 1537 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
2066 2085 
                      <value type="string" key="oldName">taxon_concept</value>
2067 2086 
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2068 2087 
                    </value>
2088 
                    <value type="object" struct-name="db.mysql.Column" id="dc8d1c42-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
2089 
                      <value type="int" key="autoIncrement">0</value>
2090 
                      <value type="string" key="characterSetName"></value>
2091 
                      <value _ptr_="0xaddbb68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
2092 
                      <value type="string" key="collationName"></value>
2093 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
2094 
                      <value type="string" key="defaultValue"></value>
2095 
                      <value type="int" key="defaultValueIsNull">0</value>
2096 
                      <value _ptr_="0xabc7620" type="list" content-type="string" key="flags"/>
2097 
                      <value type="int" key="isNotNull">0</value>
2098 
                      <value type="int" key="length">-1</value>
2099 
                      <value type="int" key="precision">-1</value>
2100 
                      <value type="int" key="scale">-1</value>
2101 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
2102 
                      <value type="string" key="comment"></value>
2103 
                      <value type="string" key="name">traits</value>
2104 
                      <value type="string" key="oldName"></value>
2105 
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
2106 
                    </value>
2069 2107 
                  </value>
2070 2108 
                  <value type="string" key="connectionString"></value>
2071 2109 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
2193 2231 
                  <value type="int" key="commentedOut">0</value>
2194 2232 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2195 2233 
                  <value _ptr_="0x9fd3208" type="dict" key="customData"/>
2196 
                  <value type="string" key="lastChangeDate">2013-04-24 11:25</value>
2234 
                  <value type="string" key="lastChangeDate">2013-04-24 13:02</value>
2197 2235 
                  <value type="int" key="modelOnly">0</value>
2198 2236 
                  <value type="string" key="name">aggregate_observation</value>
2199 2237 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
2243 2281 
                      <value type="string" key="oldName">taxon_concept</value>
2244 2282 
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2245 2283 
                    </value>
2284 
                    <value type="object" struct-name="db.mysql.Column" id="d72de448-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
2285 
                      <value type="int" key="autoIncrement">0</value>
2286 
                      <value type="string" key="characterSetName"></value>
2287 
                      <value _ptr_="0xae04930" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
2288 
                      <value type="string" key="collationName"></value>
2289 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
2290 
                      <value type="string" key="defaultValue"></value>
2291 
                      <value type="int" key="defaultValueIsNull">0</value>
2292 
                      <value _ptr_="0xaebaab8" type="list" content-type="string" key="flags"/>
2293 
                      <value type="int" key="isNotNull">0</value>
2294 
                      <value type="int" key="length">-1</value>
2295 
                      <value type="int" key="precision">-1</value>
2296 
                      <value type="int" key="scale">-1</value>
2297 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
2298 
                      <value type="string" key="comment"></value>
2299 
                      <value type="string" key="name">traits</value>
2300 
                      <value type="string" key="oldName"></value>
2301 
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2302 
                    </value>
2246 2303 
                  </value>
2247 2304 
                  <value type="string" key="connectionString"></value>
2248 2305 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
2369 2426 
                  <value type="int" key="commentedOut">0</value>
2370 2427 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
2371 2428 
                  <value _ptr_="0xa4ee028" type="dict" key="customData"/>
2372 
                  <value type="string" key="lastChangeDate">2013-04-24 11:25</value>
2429 
                  <value type="string" key="lastChangeDate">2013-04-24 13:02</value>
2373 2430 
                  <value type="int" key="modelOnly">0</value>
2374 2431 
                  <value type="string" key="name">taxon_presence</value>
2375 2432 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
9019 9076 
                      <value type="string" key="oldName">specimen</value>
9020 9077 
                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>
9021 9078 
                    </value>
9079 
                    <value type="object" struct-name="db.mysql.Column" id="c540c5c0-ad19-11e2-9d85-080027bcf912" struct-checksum="0x783b5183">
9080 
                      <value type="int" key="autoIncrement">0</value>
9081 
                      <value type="string" key="characterSetName"></value>
9082 
                      <value _ptr_="0xac2e3e8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9083 
                      <value type="string" key="collationName"></value>
9084 
                      <value type="string" key="datatypeExplicitParams">('hstore')</value>
9085 
                      <value type="string" key="defaultValue"></value>
9086 
                      <value type="int" key="defaultValueIsNull">0</value>
9087 
                      <value _ptr_="0xac11050" type="list" content-type="string" key="flags"/>
9088 
                      <value type="int" key="isNotNull">0</value>
9089 
                      <value type="int" key="length">-1</value>
9090 
                      <value type="int" key="precision">-1</value>
9091 
                      <value type="int" key="scale">-1</value>
9092 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.set</link>
9093 
                      <value type="string" key="comment"></value>
9094 
                      <value type="string" key="name">traits</value>
9095 
                      <value type="string" key="oldName"></value>
9096 
                      <link type="object" struct-name="GrtObject" key="owner">c3760d74-a7b3-11e2-8ba6-080027bcf912</link>
9097 
                    </value>
9022 9098 
                  </value>
9023 9099 
                  <value type="string" key="connectionString"></value>
9024 9100 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
9146 9222 
                  <value type="int" key="commentedOut">0</value>
9147 9223 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
9148 9224 
                  <value _ptr_="0xa565210" type="dict" key="customData"/>
9149 
                  <value type="string" key="lastChangeDate">2013-04-23 11:41</value>
9225 
                  <value type="string" key="lastChangeDate">2013-04-24 13:01</value>
9150 9226 
                  <value type="int" key="modelOnly">0</value>
9151 9227 
                  <value type="string" key="name">specimen_observation</value>
9152 9228 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11771 11847 
                <value type="int" key="expanded">1</value>
11772 11848 
                <value type="real" key="height">1.69e+02</value>
11773 11849 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11774 
                <value type="real" key="left">2.8e+01</value>
11850 
                <value type="real" key="left">2.9e+01</value>
11775 11851 
                <value type="int" key="locked">0</value>
11776 11852 
                <value type="int" key="manualSizing">0</value>
11777 
                <value type="real" key="top">5.46e+02</value>
11853 
                <value type="real" key="top">5.87e+02</value>
11778 11854 
                <value type="real" key="width">9.e+01</value>
11779 11855 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11780 11856 
                <value type="int" key="visible">1</value>
......
11789 11865 
                <value type="int" key="triggersExpanded">0</value>
11790 11866 
                <value type="string" key="color">#FFCCCC</value>
11791 11867 
                <value type="int" key="expanded">1</value>
11792 
                <value type="real" key="height">1.23e+02</value>
11868 
                <value type="real" key="height">1.46e+02</value>
11793 11869 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11794 
                <value type="real" key="left">1.77e+02</value>
11870 
                <value type="real" key="left">1.8e+02</value>
11795 11871 
                <value type="int" key="locked">0</value>
11796 11872 
                <value type="int" key="manualSizing">0</value>
11797 
                <value type="real" key="top">5.18e+02</value>
11873 
                <value type="real" key="top">5.23e+02</value>
11798 11874 
                <value type="real" key="width">1.06e+02</value>
11799 11875 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11800 11876 
                <value type="int" key="visible">1</value>
......
12129 12205 
                <value type="int" key="triggersExpanded">0</value>
12130 12206 
                <value type="string" key="color">#FFFF00</value>
12131 12207 
                <value type="int" key="expanded">1</value>
12132 
                <value type="real" key="height">7.7e+01</value>
12208 
                <value type="real" key="height">1.e+02</value>
12133 12209 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12134 
                <value type="real" key="left">1.198e+03</value>
12210 
                <value type="real" key="left">1.241e+03</value>
12135 12211 
                <value type="int" key="locked">0</value>
12136 12212 
                <value type="int" key="manualSizing">0</value>
12137 
                <value type="real" key="top">8.6e+01</value>
12213 
                <value type="real" key="top">8.5e+01</value>
12138 12214 
                <value type="real" key="width">1.41e+02</value>
12139 12215 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12140 12216 
                <value type="int" key="visible">1</value>
......
12169 12245 
                <value type="int" key="triggersExpanded">0</value>
12170 12246 
                <value type="string" key="color">#FFFF00</value>
12171 12247 
                <value type="int" key="expanded">1</value>
12172 
                <value type="real" key="height">7.7e+01</value>
12248 
                <value type="real" key="height">1.e+02</value>
12173 12249 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12174 
                <value type="real" key="left">1.218e+03</value>
12250 
                <value type="real" key="left">1.221e+03</value>
12175 12251 
                <value type="int" key="locked">0</value>
12176 12252 
                <value type="int" key="manualSizing">0</value>
12177 
                <value type="real" key="top">1.95e+02</value>
12253 
                <value type="real" key="top">2.1e+02</value>
12178 12254 
                <value type="real" key="width">1.82e+02</value>
12179 12255 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12180 12256 
                <value type="int" key="visible">1</value>
......
12331 12407 
                <value type="int" key="expanded">1</value>
12332 12408 
                <value type="real" key="height">7.7e+01</value>
12333 12409 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12334 
                <value type="real" key="left">3.8e+01</value>
12410 
                <value type="real" key="left">3.9e+01</value>
12335 12411 
                <value type="int" key="locked">0</value>
12336 12412 
                <value type="int" key="manualSizing">0</value>
12337 
                <value type="real" key="top">7.74e+02</value>
12413 
                <value type="real" key="top">8.15e+02</value>
12338 12414 
                <value type="real" key="width">7.9e+01</value>
12339 12415 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12340 12416 
                <value type="int" key="visible">1</value>
......
12775 12851 
                <value type="int" key="triggersExpanded">0</value>
12776 12852 
                <value type="string" key="color">#CCCC33</value>
12777 12853 
                <value type="int" key="expanded">1</value>
12778 
                <value type="real" key="height">7.7e+01</value>
12854 
                <value type="real" key="height">1.e+02</value>
12779 12855 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12780 12856 
                <value type="real" key="left">1.03e+03</value>
12781 12857 
                <value type="int" key="locked">0</value>
12782 12858 
                <value type="int" key="manualSizing">0</value>
12783 
                <value type="real" key="top">6.83e+02</value>
12859 
                <value type="real" key="top">6.72e+02</value>
12784 12860 
                <value type="real" key="width">1.8e+02</value>
12785 12861 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12786 12862 
                <value type="int" key="visible">1</value>
......
12797 12873 
                <value type="int" key="expanded">1</value>
12798 12874 
                <value type="real" key="height">7.7e+01</value>
12799 12875 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12800 
                <value type="real" key="left">1.7e+01</value>
12876 
                <value type="real" key="left">1.8e+01</value>
12801 12877 
                <value type="int" key="locked">0</value>
12802 12878 
                <value type="int" key="manualSizing">0</value>
12803 
                <value type="real" key="top">8.92e+02</value>
12879 
                <value type="real" key="top">9.33e+02</value>
12804 12880 
                <value type="real" key="width">1.21e+02</value>
12805 12881 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12806 12882 
                <value type="int" key="visible">1</value>
......
13183 13259 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13184 13260 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13185 13261 
      <value type="string" key="caption">New Model</value>
13186 
      <value type="string" key="dateChanged">2013-04-24 12:53</value>
13262 
      <value type="string" key="dateChanged">2013-04-24 13:05</value>
13187 13263 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13188 13264 
      <value type="string" key="description"></value>
13189 13265 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
52 52 
  `source` VARBINARY(767) NOT NULL ,
53 53 
  `source_id_scope` VARBINARY(767) NULL ,
54 54 
  `source_record_id` VARBINARY(767) NULL DEFAULT NULL ,
55 
  `info` SET('hstore') NULL ,
55 56 
  PRIMARY KEY (`id`) ,
56 57 
  INDEX `fk_record_source1_idx` (`source` ASC) ,
57 58 
  UNIQUE INDEX `record_unique` (`source` ASC, `source_id_scope` ASC, `source_record_id` ASC) ,
......
652 653 
CREATE  TABLE IF NOT EXISTS `aggregate_observation` (
653 654 
  `id` VARBINARY(767) NOT NULL ,
654 655 
  `taxon_concept` VARBINARY(767) NOT NULL ,
656 
  `traits` SET('hstore') NULL ,
655 657 
  PRIMARY KEY (`id`) ,
656 658 
  INDEX `fk_aggregate_observation_taxon_name1_idx` (`taxon_concept` ASC) ,
657 659 
  CONSTRAINT `fk_aggregate_observation_taxon_occurrence1`
......
677 679 
CREATE  TABLE IF NOT EXISTS `taxon_presence` (
678 680 
  `id` VARBINARY(767) NOT NULL ,
679 681 
  `taxon_concept` VARBINARY(767) NOT NULL ,
682 
  `traits` SET('hstore') NULL ,
680 683 
  PRIMARY KEY (`id`) ,
681 684 
  INDEX `fk_taxon_presence_taxon_name1_idx` (`taxon_concept` ASC) ,
682 685 
  CONSTRAINT `fk_taxon_observation_taxon_occurrence1`
......
1104 1107 
CREATE  TABLE IF NOT EXISTS `specimen_observation` (
1105 1108 
  `id` VARBINARY(767) NOT NULL ,
1106 1109 
  `specimen` VARBINARY(767) NOT NULL ,
1110 
  `traits` SET('hstore') NULL ,
1107 1111 
  PRIMARY KEY (`id`) ,
1108 1112 
  INDEX `fk_specimen_observation_specimen1_idx` (`specimen` ASC) ,
1109 1113 
  CONSTRAINT `fk_specimen_taxon_occurrence10`

Also available in: Unified diff