Project

General

Profile

« Previous | Next » 

Revision 10500

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual: made it a plot element by optionally attaching a plot position (a rel_place whose parent is the containing plot)

View differences:

schemas/VegCore/document.mwb.xml
1688 1688 
                      <value type="string" key="oldName">id</value>
1689 1689 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1690 1690 
                    </value>
1691 
                    <value type="object" struct-name="db.mysql.Column" id="424a66d6-f985-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
1692 
                      <value type="int" key="autoIncrement">0</value>
1693 
                      <value type="string" key="characterSetName"></value>
1694 
                      <value _ptr_="0xb91c3a0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1695 
                      <value type="string" key="collationName"></value>
1696 
                      <value type="string" key="datatypeExplicitParams"></value>
1697 
                      <value type="string" key="defaultValue"></value>
1698 
                      <value type="int" key="defaultValueIsNull">1</value>
1699 
                      <value _ptr_="0xc6533d0" type="list" content-type="string" key="flags"/>
1700 
                      <value type="int" key="isNotNull">0</value>
1701 
                      <value type="int" key="length">767</value>
1702 
                      <value type="int" key="precision">-1</value>
1703 
                      <value type="int" key="scale">-1</value>
1704 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1705 
                      <value type="string" key="comment"></value>
1706 
                      <value type="string" key="name">plot_position</value>
1707 
                      <value type="string" key="oldName">plot_position</value>
1708 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1709 
                    </value>
1691 1710 
                    <value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
1692 1711 
                      <value type="int" key="autoIncrement">0</value>
1693 1712 
                      <value type="string" key="characterSetName"></value>
......
1753 1772 
                      <value type="string" key="name">fk_individual_record1</value>
1754 1773 
                      <value type="string" key="oldName">fk_individual_record1</value>
1755 1774 
                    </value>
1775 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="424a6528-f985-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">
1776 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
1777 
                      <value _ptr_="0xc6b2368" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1778 
                        <link type="object">424a66d6-f985-11e2-8a2e-080027bcf912</link>
1779 
                      </value>
1780 
                      <value type="int" key="deferability">0</value>
1781 
                      <value type="string" key="deleteRule">CASCADE</value>
1782 
                      <link type="object" struct-name="db.Index" key="index">424a79f0-f985-11e2-8a2e-080027bcf912</link>
1783 
                      <value type="int" key="mandatory">1</value>
1784 
                      <value type="int" key="many">1</value>
1785 
                      <value type="int" key="modelOnly">0</value>
1786 
                      <link type="object" struct-name="db.Table" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1787 
                      <value _ptr_="0xb33bf78" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1788 
                        <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>
1789 
                      </value>
1790 
                      <value type="int" key="referencedMandatory">0</value>
1791 
                      <value type="string" key="updateRule">CASCADE</value>
1792 
                      <value type="string" key="comment"></value>
1793 
                      <value type="string" key="name">fk_individual_rel_place1</value>
1794 
                      <value type="string" key="oldName">fk_individual_rel_place1</value>
1795 
                    </value>
1756 1796 
                  </value>
1757 1797 
                  <value _ptr_="0xa229d20" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1758 1798 
                    <value type="object" struct-name="db.mysql.Index" id="be8e4322-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
1778 1818 
                      <value type="string" key="oldName">PRIMARY</value>
1779 1819 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1780 1820 
                    </value>
1821 
                    <value type="object" struct-name="db.mysql.Index" id="424a79f0-f985-11e2-8a2e-080027bcf912" struct-checksum="0x309b847a">
1822 
                      <value _ptr_="0xbb8cb10" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1823 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="424a7b76-f985-11e2-8a2e-080027bcf912" struct-checksum="0x62630b3c">
1824 
                          <value type="int" key="columnLength">0</value>
1825 
                          <value type="string" key="comment"></value>
1826 
                          <value type="int" key="descend">0</value>
1827 
                          <link type="object" struct-name="db.Column" key="referencedColumn">424a66d6-f985-11e2-8a2e-080027bcf912</link>
1828 
                          <value type="string" key="name"></value>
1829 
                          <link type="object" struct-name="GrtObject" key="owner">424a79f0-f985-11e2-8a2e-080027bcf912</link>
1830 
                        </value>
1831 
                      </value>
1832 
                      <value type="string" key="indexKind"></value>
1833 
                      <value type="int" key="keyBlockSize">0</value>
1834 
                      <value type="string" key="withParser"></value>
1835 
                      <value type="string" key="comment"></value>
1836 
                      <value type="int" key="deferability">0</value>
1837 
                      <value type="string" key="indexType">INDEX</value>
1838 
                      <value type="int" key="isPrimary">0</value>
1839 
                      <value type="string" key="name">fk_individual_rel_place1_idx</value>
1840 
                      <value type="int" key="unique">0</value>
1841 
                      <value type="string" key="oldName">fk_individual_rel_place1_idx</value>
1842 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1843 
                    </value>
1781 1844 
                  </value>
1782 1845 
                  <value type="string" key="maxRows"></value>
1783 1846 
                  <value type="string" key="mergeInsert"></value>
......
1809 1872 
                  <value type="int" key="commentedOut">0</value>
1810 1873 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
1811 1874 
                  <value _ptr_="0xa22e0b8" type="dict" key="customData"/>
1812 
                  <value type="string" key="lastChangeDate">2013-07-26 21:07</value>
1875 
                  <value type="string" key="lastChangeDate">2013-07-30 19:03</value>
1813 1876 
                  <value type="int" key="modelOnly">0</value>
1814 1877 
                  <value type="string" key="name">individual</value>
1815 1878 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12712 12775 
                <value type="int" key="visible">1</value>
12713 12776 
                <value type="string" key="name"></value>
12714 12777 
              </value>
12778 
              <value type="object" struct-name="workbench.physical.Connection" id="424a824c-f985-11e2-8a2e-080027bcf912" struct-checksum="0x9baebc92">
12779 
                <value type="string" key="caption">fk_individual_rel_place1</value>
12780 
                <value type="real" key="captionXOffs">0.e+00</value>
12781 
                <value type="real" key="captionYOffs">0.e+00</value>
12782 
                <value type="string" key="comment"></value>
12783 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12784 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12785 
                <value type="string" key="extraCaption"></value>
12786 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12787 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12788 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">424a6528-f985-11e2-8a2e-080027bcf912</link>
12789 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12790 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12791 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12792 
                <value type="int" key="drawSplit">0</value>
12793 
                <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
12794 
                <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
12795 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12796 
                <value type="int" key="visible">1</value>
12797 
                <value type="string" key="name"></value>
12798 
              </value>
12715 12799 
            </value>
12716 12800 
            <value type="string" key="description"></value>
12717 12801 
            <value _ptr_="0xac124f0" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13041 13125 
                <value type="int" key="expanded">1</value>
13042 13126 
                <value type="real" key="height">1.46e+02</value>
13043 13127 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13044 
                <value type="real" key="left">8.56e+02</value>
13128 
                <value type="real" key="left">8.55e+02</value>
13045 13129 
                <value type="int" key="locked">0</value>
13046 13130 
                <value type="int" key="manualSizing">0</value>
13047 13131 
                <value type="real" key="top">9.19e+02</value>
......
13084 13168 
                <value type="real" key="left">1.471e+03</value>
13085 13169 
                <value type="int" key="locked">0</value>
13086 13170 
                <value type="int" key="manualSizing">0</value>
13087 
                <value type="real" key="top">3.7e+01</value>
13171 
                <value type="real" key="top">3.9e+01</value>
13088 13172 
                <value type="real" key="width">1.3e+02</value>
13089 13173 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13090 13174 
                <value type="int" key="visible">1</value>
......
13159 13243 
                <value type="int" key="triggersExpanded">0</value>
13160 13244 
                <value type="string" key="color">#CCFFCC</value>
13161 13245 
                <value type="int" key="expanded">1</value>
13162 
                <value type="real" key="height">1.e+02</value>
13246 
                <value type="real" key="height">1.23e+02</value>
13163 13247 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13164 13248 
                <value type="real" key="left">1.311e+03</value>
13165 13249 
                <value type="int" key="locked">0</value>
13166 13250 
                <value type="int" key="manualSizing">0</value>
13167 
                <value type="real" key="top">5.6e+01</value>
13251 
                <value type="real" key="top">3.1e+01</value>
13168 13252 
                <value type="real" key="width">1.06e+02</value>
13169 13253 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13170 13254 
                <value type="int" key="visible">1</value>
......
13184 13268 
                <value type="real" key="left">1.071e+03</value>
13185 13269 
                <value type="int" key="locked">0</value>
13186 13270 
                <value type="int" key="manualSizing">0</value>
13187 
                <value type="real" key="top">4.4e+01</value>
13271 
                <value type="real" key="top">7.8e+01</value>
13188 13272 
                <value type="real" key="width">1.8e+02</value>
13189 13273 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13190 13274 
                <value type="int" key="visible">1</value>
......
13782 13866 
                <value type="int" key="expanded">1</value>
13783 13867 
                <value type="real" key="height">2.7e+01</value>
13784 13868 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13785 
                <value type="real" key="left">9.33e+02</value>
13869 
                <value type="real" key="left">9.32e+02</value>
13786 13870 
                <value type="int" key="locked">0</value>
13787 13871 
                <value type="int" key="manualSizing">0</value>
13788 13872 
                <value type="real" key="top">8.58e+02</value>
......
13797 13881 
                <value type="int" key="expanded">1</value>
13798 13882 
                <value type="real" key="height">2.5e+01</value>
13799 13883 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13800 
                <value type="real" key="left">1.001e+03</value>
13884 
                <value type="real" key="left">1.e+03</value>
13801 13885 
                <value type="int" key="locked">0</value>
13802 13886 
                <value type="int" key="manualSizing">0</value>
13803 13887 
                <value type="real" key="top">9.39e+02</value>
......
13872 13956 
                <value type="int" key="expanded">1</value>
13873 13957 
                <value type="real" key="height">2.5e+01</value>
13874 13958 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13875 
                <value type="real" key="left">9.33e+02</value>
13959 
                <value type="real" key="left">9.32e+02</value>
13876 13960 
                <value type="int" key="locked">0</value>
13877 13961 
                <value type="int" key="manualSizing">0</value>
13878 13962 
                <value type="real" key="top">8.9e+02</value>
......
14035 14119 
                <value type="real" key="left">1.e+01</value>
14036 14120 
                <value _ptr_="0xac4f5b8" type="list" content-type="object" content-struct-name="model.Layer" key="subLayers"/>
14037 14121 
                <value type="real" key="top">8.e+01</value>
14038 
                <value type="real" key="width">2.15e+02</value>
14122 
                <value type="real" key="width">2.16e+02</value>
14039 14123 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14040 14124 
                <value type="int" key="visible">1</value>
14041 14125 
                <value type="string" key="name">categories</value>
......
14137 14221 
              <value type="int" key="visible">1</value>
14138 14222 
              <value type="string" key="name"></value>
14139 14223 
            </value>
14140 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14141 
              <link type="object">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
14142 
            </value>
14224 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
14143 14225 
            <value type="int" key="updateBlocked">0</value>
14144 14226 
            <value type="real" key="width">1.6215e+03</value>
14145 14227 
            <value type="real" key="x">0.e+00</value>
......
14152 14234 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14153 14235 
        <value _ptr_="0xab85450" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14154 14236 
        <value _ptr_="0xa229c20" type="dict" key="syncProfiles">
14155 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="8da696b0-f983-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14156 
            <value _ptr_="0xc52a240" type="dict" key="lastKnownDBNames">
14237 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="e1b288a2-f985-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14238 
            <value _ptr_="0xc220f00" type="dict" key="lastKnownDBNames">
14157 14239 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14158 14240 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14159 14241 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14249 14331 
              <value type="string" key="415f1a26-ad15-11e2-9617-080027bcf912">specimen_unique_in_individual</value>
14250 14332 
              <value type="string" key="42266085-54CC-4441-8553-68BBE0286A05">default</value>
14251 14333 
              <value type="string" key="42405474-a783-11e2-afd5-080027bcf912">annotations</value>
14334 
              <value type="string" key="424a6528-f985-11e2-8a2e-080027bcf912">fk_individual_rel_place1</value>
14335 
              <value type="string" key="424a66d6-f985-11e2-8a2e-080027bcf912">plot_position</value>
14336 
              <value type="string" key="424a79f0-f985-11e2-8a2e-080027bcf912">fk_individual_rel_place1_idx</value>
14252 14337 
              <value type="string" key="43cfb7dc-a790-11e2-84c3-080027bcf912">lat_long_domain_valid</value>
14253 14338 
              <value type="string" key="43f62c16-ad1a-11e2-9d85-080027bcf912">info</value>
14254 14339 
              <value type="string" key="43f70d90-f679-11e2-9716-080027bcf912">sort_order</value>
......
14677 14762 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14678 14763 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14679 14764 
      <value type="string" key="caption">New Model</value>
14680 
      <value type="string" key="dateChanged">2013-07-30 18:50</value>
14765 
      <value type="string" key="dateChanged">2013-07-30 19:07</value>
14681 14766 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14682 14767 
      <value type="string" key="description"></value>
14683 14768 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
293 293 
/*!40101 SET character_set_client = utf8 */;
294 294 
CREATE TABLE `individual` (
295 295 
  `id` varbinary(767) NOT NULL,
296 
  `plot_position` varbinary(767) DEFAULT NULL,
296 297 
  `tag` varbinary(767) DEFAULT NULL,
297 298 
  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,
298 299 
  PRIMARY KEY (`id`),
299 
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
300 
  KEY `fk_individual_rel_place1_idx` (`plot_position`),
301 
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
302 
  CONSTRAINT `fk_individual_rel_place1` FOREIGN KEY (`plot_position`) REFERENCES `rel_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
300 303 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';
301 304 
/*!40101 SET character_set_client = @saved_cs_client */;
302 305 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  295
  295
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  296
  296
  
    
CREATE TABLE "individual" (


  		




  297
  297
  
    
  "id" text NOT NULL,


  		




  
  298
  
    
  "plot_position" text DEFAULT NULL,


  		




  298
  299
  
    
  "tag" text DEFAULT NULL,


  		




  299
  300
  
    
  "tag_history" hstore DEFAULT NULL,


  		




  300
  301
  
    
  PRIMARY KEY ("id"),


  		




  301
  
  
    
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  302
  
    
  /*KEY "fk_individual_rel_place1_idx" ("plot_position")*/CHECK (true),


  		




  
  303
  
    
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  304
  
    
  /*CONSTRAINT "fk_individual_rel_place1" FOREIGN KEY ("plot_position") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  302
  305
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;


  		




  303
  306
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  304
  307
  
    

  		












Also available in:  Unified diff