Project

General

Profile

« Previous | Next » 

Revision 10525

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual.place: don't require this to be a rel_place, because some individuals will be associated with standalone specimens, which don't have a parent place

View differences:

schemas/VegCore/VegCore.pg.sql
300 300 
  "tag" text DEFAULT NULL,
301 301 
  "tag_history" hstore DEFAULT NULL,
302 302 
  PRIMARY KEY ("id"),
303 
  /*KEY "fk_individual_rel_place1_idx" ("place")*/CHECK (true),
304 
  /*CONSTRAINT "fk_individual_rel_place1" FOREIGN KEY ("place") REFERENCES "rel_place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
303 
  /*KEY "fk_individual_place1_idx" ("place")*/CHECK (true),
304 
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
305 305 
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
306 306 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;
307 307 
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/document.mwb.xml
1772 1772 
                      <value type="string" key="name">fk_individual_record1</value>
1773 1773 
                      <value type="string" key="oldName">fk_individual_record1</value>
1774 1774 
                    </value>
1775 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="978ed0d4-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x70a8fc40">
1776 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>
1777 
                      <value _ptr_="0xb405730" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1775 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="177949e8-f9c8-11e2-b815-080027bcf912" struct-checksum="0x70a8fc40">
1776 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">c6723d8a-a7a0-11e2-b667-080027bcf912</link>
1777 
                      <value _ptr_="0xc454c28" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1778 1778 
                        <link type="object">978ed2dc-f9c4-11e2-9af4-080027bcf912</link>
1779 1779 
                      </value>
1780 1780 
                      <value type="int" key="deferability">0</value>
1781 1781 
                      <value type="string" key="deleteRule">CASCADE</value>
1782 
                      <link type="object" struct-name="db.Index" key="index">978f9618-f9c4-11e2-9af4-080027bcf912</link>
1782 
                      <link type="object" struct-name="db.Index" key="index">17796428-f9c8-11e2-b815-080027bcf912</link>
1783 1783 
                      <value type="int" key="mandatory">1</value>
1784 1784 
                      <value type="int" key="many">1</value>
1785 1785 
                      <value type="int" key="modelOnly">0</value>
1786 1786 
                      <link type="object" struct-name="db.Table" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1787 
                      <value _ptr_="0xb3fc9f0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1788 
                        <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>
1787 
                      <value _ptr_="0xc48b498" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1788 
                        <link type="object">c6724000-a7a0-11e2-b667-080027bcf912</link>
1789 1789 
                      </value>
1790 1790 
                      <value type="int" key="referencedMandatory">1</value>
1791 1791 
                      <value type="string" key="updateRule">CASCADE</value>
1792 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>
1793 
                      <value type="string" key="name">fk_individual_place1</value>
1794 
                      <value type="string" key="oldName">fk_individual_place1</value>
1795 1795 
                    </value>
1796 1796 
                  </value>
1797 1797 
                  <value _ptr_="0xb405668" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
......
1818 1818 
                      <value type="string" key="oldName">PRIMARY</value>
1819 1819 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1820 1820 
                    </value>
1821 
                    <value type="object" struct-name="db.mysql.Index" id="978f9618-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x309b847a">
1822 
                      <value _ptr_="0xbcadf78" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1823 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="978fae0a-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x62630b3c">
1821 
                    <value type="object" struct-name="db.mysql.Index" id="17796428-f9c8-11e2-b815-080027bcf912" struct-checksum="0x309b847a">
1822 
                      <value _ptr_="0xc482b98" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1823 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="17796680-f9c8-11e2-b815-080027bcf912" struct-checksum="0x62630b3c">
1824 1824 
                          <value type="int" key="columnLength">0</value>
1825 1825 
                          <value type="string" key="comment"></value>
1826 1826 
                          <value type="int" key="descend">0</value>
1827 1827 
                          <link type="object" struct-name="db.Column" key="referencedColumn">978ed2dc-f9c4-11e2-9af4-080027bcf912</link>
1828 1828 
                          <value type="string" key="name"></value>
1829 
                          <link type="object" struct-name="GrtObject" key="owner">978f9618-f9c4-11e2-9af4-080027bcf912</link>
1829 
                          <link type="object" struct-name="GrtObject" key="owner">17796428-f9c8-11e2-b815-080027bcf912</link>
1830 1830 
                        </value>
1831 1831 
                      </value>
1832 1832 
                      <value type="string" key="indexKind"></value>
......
1836 1836 
                      <value type="int" key="deferability">0</value>
1837 1837 
                      <value type="string" key="indexType">INDEX</value>
1838 1838 
                      <value type="int" key="isPrimary">0</value>
1839 
                      <value type="string" key="name">fk_individual_rel_place1_idx</value>
1839 
                      <value type="string" key="name">fk_individual_place1_idx</value>
1840 1840 
                      <value type="int" key="unique">0</value>
1841 
                      <value type="string" key="oldName">fk_individual_rel_place1_idx</value>
1841 
                      <value type="string" key="oldName">fk_individual_place1</value>
1842 1842 
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
1843 1843 
                    </value>
1844 1844 
                  </value>
......
13074 13074 
                <value type="int" key="visible">1</value>
13075 13075 
                <value type="string" key="name"></value>
13076 13076 
              </value>
13077 
              <value type="object" struct-name="workbench.physical.Connection" id="978fde0c-f9c4-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13078 
                <value type="string" key="caption">fk_individual_rel_place1</value>
13077 
              <value type="object" struct-name="workbench.physical.Connection" id="13886128-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13078 
                <value type="string" key="caption">fk_rel_place_place1</value>
13079 13079 
                <value type="real" key="captionXOffs">0.e+00</value>
13080 13080 
                <value type="real" key="captionYOffs">0.e+00</value>
13081 13081 
                <value type="string" key="comment"></value>
......
13084 13084 
                <value type="string" key="extraCaption"></value>
13085 13085 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13086 13086 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13087 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">978ed0d4-f9c4-11e2-9af4-080027bcf912</link>
13087 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1388436e-f9c5-11e2-9af4-080027bcf912</link>
13088 13088 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13089 13089 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13090 13090 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13091 13091 
                <value type="int" key="drawSplit">0</value>
13092 
                <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
13093 
                <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
13092 
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
13093 
                <link type="object" struct-name="model.Figure" key="startFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
13094 13094 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13095 13095 
                <value type="int" key="visible">1</value>
13096 13096 
                <value type="string" key="name"></value>
13097 13097 
              </value>
13098 
              <value type="object" struct-name="workbench.physical.Connection" id="13886128-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13099 
                <value type="string" key="caption">fk_rel_place_place1</value>
13098 
              <value type="object" struct-name="workbench.physical.Connection" id="49a273de-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13099 
                <value type="string" key="caption">fk_subplot_plot2</value>
13100 13100 
                <value type="real" key="captionXOffs">0.e+00</value>
13101 13101 
                <value type="real" key="captionYOffs">0.e+00</value>
13102 13102 
                <value type="string" key="comment"></value>
......
13105 13105 
                <value type="string" key="extraCaption"></value>
13106 13106 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13107 13107 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13108 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">1388436e-f9c5-11e2-9af4-080027bcf912</link>
13108 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">49a23428-f9c5-11e2-9af4-080027bcf912</link>
13109 13109 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13110 13110 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13111 13111 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13112 13112 
                <value type="int" key="drawSplit">0</value>
13113 
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
13114 
                <link type="object" struct-name="model.Figure" key="startFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
13113 
                <link type="object" struct-name="model.Figure" key="endFigure">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
13114 
                <link type="object" struct-name="model.Figure" key="startFigure">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
13115 13115 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13116 13116 
                <value type="int" key="visible">1</value>
13117 13117 
                <value type="string" key="name"></value>
13118 13118 
              </value>
13119 
              <value type="object" struct-name="workbench.physical.Connection" id="49a273de-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13120 
                <value type="string" key="caption">fk_subplot_plot2</value>
13119 
              <value type="object" struct-name="workbench.physical.Connection" id="4e34d068-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13120 
                <value type="string" key="caption">fk_subplot_rel_place1</value>
13121 13121 
                <value type="real" key="captionXOffs">0.e+00</value>
13122 13122 
                <value type="real" key="captionYOffs">0.e+00</value>
13123 13123 
                <value type="string" key="comment"></value>
......
13126 13126 
                <value type="string" key="extraCaption"></value>
13127 13127 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13128 13128 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13129 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">49a23428-f9c5-11e2-9af4-080027bcf912</link>
13129 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">4e34b204-f9c5-11e2-9af4-080027bcf912</link>
13130 13130 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13131 13131 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13132 13132 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13133 13133 
                <value type="int" key="drawSplit">0</value>
13134 
                <link type="object" struct-name="model.Figure" key="endFigure">9f4be6e8-a6fb-11e2-9461-080027bcf912</link>
13134 
                <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
13135 13135 
                <link type="object" struct-name="model.Figure" key="startFigure">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
13136 13136 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13137 13137 
                <value type="int" key="visible">1</value>
13138 13138 
                <value type="string" key="name"></value>
13139 13139 
              </value>
13140 
              <value type="object" struct-name="workbench.physical.Connection" id="4e34d068-f9c5-11e2-9af4-080027bcf912" struct-checksum="0x9baebc92">
13141 
                <value type="string" key="caption">fk_subplot_rel_place1</value>
13140 
              <value type="object" struct-name="workbench.physical.Connection" id="17796d42-f9c8-11e2-b815-080027bcf912" struct-checksum="0x9baebc92">
13141 
                <value type="string" key="caption">fk_individual_place1</value>
13142 13142 
                <value type="real" key="captionXOffs">0.e+00</value>
13143 13143 
                <value type="real" key="captionYOffs">0.e+00</value>
13144 13144 
                <value type="string" key="comment"></value>
......
13147 13147 
                <value type="string" key="extraCaption"></value>
13148 13148 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
13149 13149 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
13150 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">4e34b204-f9c5-11e2-9af4-080027bcf912</link>
13150 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">177949e8-f9c8-11e2-b815-080027bcf912</link>
13151 13151 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
13152 13152 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
13153 13153 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
13154 
                <value type="int" key="drawSplit">0</value>
13155 
                <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>
13156 
                <link type="object" struct-name="model.Figure" key="startFigure">2673ee0a-f9bc-11e2-a599-080027bcf912</link>
13154 
                <value type="int" key="drawSplit">1</value>
13155 
                <link type="object" struct-name="model.Figure" key="endFigure">286AE59E-913E-4F00-A662-693F828EFB6F</link>
13156 
                <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
13157 13157 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13158 13158 
                <value type="int" key="visible">1</value>
13159 13159 
                <value type="string" key="name"></value>
......
13607 13607 
                <value type="int" key="expanded">1</value>
13608 13608 
                <value type="real" key="height">1.23e+02</value>
13609 13609 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13610 
                <value type="real" key="left">1.311e+03</value>
13610 
                <value type="real" key="left">1.302e+03</value>
13611 13611 
                <value type="int" key="locked">0</value>
13612 13612 
                <value type="int" key="manualSizing">0</value>
13613 
                <value type="real" key="top">1.7e+01</value>
13613 
                <value type="real" key="top">6.6e+01</value>
13614 13614 
                <value type="real" key="width">1.06e+02</value>
13615 13615 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13616 13616 
                <value type="int" key="visible">1</value>
......
13630 13630 
                <value type="real" key="left">1.071e+03</value>
13631 13631 
                <value type="int" key="locked">0</value>
13632 13632 
                <value type="int" key="manualSizing">0</value>
13633 
                <value type="real" key="top">6.5e+01</value>
13633 
                <value type="real" key="top">4.5e+01</value>
13634 13634 
                <value type="real" key="width">1.8e+02</value>
13635 13635 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13636 13636 
                <value type="int" key="visible">1</value>
......
14751 14751 
              <value type="int" key="visible">1</value>
14752 14752 
              <value type="string" key="name"></value>
14753 14753 
            </value>
14754 
            <value _ptr_="0xbd42430" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14755 
              <link type="object">67fa734c-f6c1-11e2-af44-080027bcf912</link>
14756 
            </value>
14754 
            <value _ptr_="0xbd42430" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
14757 14755 
            <value type="int" key="updateBlocked">0</value>
14758 14756 
            <value type="real" key="width">1.6215e+03</value>
14759 14757 
            <value type="real" key="x">0.e+00</value>
......
14848 14846 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14849 14847 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14850 14848 
      <value type="string" key="caption">New Model</value>
14851 
      <value type="string" key="dateChanged">2013-07-31 02:53</value>
14849 
      <value type="string" key="dateChanged">2013-07-31 03:02</value>
14852 14850 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14853 14851 
      <value type="string" key="description"></value>
14854 14852 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
298 298 
  `tag` varbinary(767) DEFAULT NULL,
299 299 
  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,
300 300 
  PRIMARY KEY (`id`),
301 
  KEY `fk_individual_rel_place1_idx` (`place`),
302 
  CONSTRAINT `fk_individual_rel_place1` FOREIGN KEY (`place`) REFERENCES `rel_place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
301 
  KEY `fk_individual_place1_idx` (`place`),
302 
  CONSTRAINT `fk_individual_place1` FOREIGN KEY (`place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
303 303 
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
304 304 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';
305 305 
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff