Project

General

Profile

« Previous | Next » 

Revision 10660

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual: added identifying_place since some individuals may be identified by their coordinates rather than a tag

View differences:

schemas/VegCore/VegCore.pg.sql
331 331 
CREATE TABLE "individual" (
332 332 
  "id" text NOT NULL,
333 333 
  "within_place" text NOT NULL,
334 
  "identifying_place" text DEFAULT NULL,
334 335 
  "tag" text DEFAULT NULL,
335 336 
  "tag_history" hstore DEFAULT NULL,
336 337 
  PRIMARY KEY ("id"),
337 338 
  /*KEY "fk_individual_place1_idx" ("within_place")*/CHECK (true),
339 
  /*KEY "fk_individual_subplace1_idx" ("identifying_place")*/CHECK (true),
338 340 
  /*CONSTRAINT "fk_individual_record1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
339 
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
341 
  /*CONSTRAINT "fk_individual_place1" FOREIGN KEY ("within_place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
342 
  /*CONSTRAINT "fk_individual_subplace1" FOREIGN KEY ("identifying_place") REFERENCES "subplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
340 343 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism'*/;
341 344 
/*!40101 SET character_set_client = @saved_cs_client */;
342 345 

  		












  

    
      schemas/VegCore/document.mwb.xml
    
  





  1707
  1707
  
    
                      <value type="string" key="oldName">within_place</value>


  		




  1708
  1708
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>


  		




  1709
  1709
  
    
                    </value>


  		




  
  1710
  
    
                    <value type="object" struct-name="db.mysql.Column" id="2f07bade-0127-11e3-9f3a-080027bcf912" struct-checksum="0x783b5183">


  		




  
  1711
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  
  1712
  
    
                      <value type="string" key="characterSetName"></value>


  		




  
  1713
  
    
                      <value _ptr_="0xc17e998" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>


  		




  
  1714
  
    
                      <value type="string" key="collationName"></value>


  		




  
  1715
  
    
                      <value type="string" key="datatypeExplicitParams"></value>


  		




  
  1716
  
    
                      <value type="string" key="defaultValue"></value>


  		




  
  1717
  
    
                      <value type="int" key="defaultValueIsNull">1</value>


  		




  
  1718
  
    
                      <value _ptr_="0xc0e4210" type="list" content-type="string" key="flags"/>


  		




  
  1719
  
    
                      <value type="int" key="isNotNull">0</value>


  		




  
  1720
  
    
                      <value type="int" key="length">767</value>


  		




  
  1721
  
    
                      <value type="int" key="precision">-1</value>


  		




  
  1722
  
    
                      <value type="int" key="scale">-1</value>


  		




  
  1723
  
    
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>


  		




  
  1724
  
    
                      <value type="string" key="comment"></value>


  		




  
  1725
  
    
                      <value type="string" key="name">identifying_place</value>


  		




  
  1726
  
    
                      <value type="string" key="oldName">identifying_place</value>


  		




  
  1727
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  1728
  
    
                    </value>


  		




  1710
  1729
  
    
                    <value type="object" struct-name="db.mysql.Column" id="273737e8-a796-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">


  		




  1711
  1730
  
    
                      <value type="int" key="autoIncrement">0</value>


  		




  1712
  1731
  
    
                      <value type="string" key="characterSetName"></value>


  		




  ......




  1793
  1812
  
    
                      <value type="string" key="name">fk_individual_place1</value>


  		




  1794
  1813
  
    
                      <value type="string" key="oldName">fk_individual_place1</value>


  		




  1795
  1814
  
    
                    </value>


  		




  
  1815
  
    
                    <value type="object" struct-name="db.mysql.ForeignKey" id="2f07b8cc-0127-11e3-9f3a-080027bcf912" struct-checksum="0x70a8fc40">


  		




  
  1816
  
    
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f67e8-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  1817
  
    
                      <value _ptr_="0xc6fb028" type="list" content-type="object" content-struct-name="db.Column" key="columns">


  		




  
  1818
  
    
                        <link type="object">2f07bade-0127-11e3-9f3a-080027bcf912</link>


  		




  
  1819
  
    
                      </value>


  		




  
  1820
  
    
                      <value type="int" key="deferability">0</value>


  		




  
  1821
  
    
                      <value type="string" key="deleteRule">CASCADE</value>


  		




  
  1822
  
    
                      <link type="object" struct-name="db.Index" key="index">2f07d0b4-0127-11e3-9f3a-080027bcf912</link>


  		




  
  1823
  
    
                      <value type="int" key="mandatory">1</value>


  		




  
  1824
  
    
                      <value type="int" key="many">1</value>


  		




  
  1825
  
    
                      <value type="int" key="modelOnly">0</value>


  		




  
  1826
  
    
                      <link type="object" struct-name="db.Table" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  1827
  
    
                      <value _ptr_="0xc6a5f50" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">


  		




  
  1828
  
    
                        <link type="object">be8f6a86-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  1829
  
    
                      </value>


  		




  
  1830
  
    
                      <value type="int" key="referencedMandatory">0</value>


  		




  
  1831
  
    
                      <value type="string" key="updateRule">CASCADE</value>


  		




  
  1832
  
    
                      <value type="string" key="comment"></value>


  		




  
  1833
  
    
                      <value type="string" key="name">fk_individual_subplace1</value>


  		




  
  1834
  
    
                      <value type="string" key="oldName">fk_individual_subplace1</value>


  		




  
  1835
  
    
                    </value>


  		




  1796
  1836
  
    
                  </value>


  		




  1797
  1837
  
    
                  <value _ptr_="0xa33b038" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">


  		




  1798
  1838
  
    
                    <value type="object" struct-name="db.mysql.Index" id="be8e4322-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">


  		




  ......




  1841
  1881
  
    
                      <value type="string" key="oldName">fk_individual_place1_idx</value>


  		




  1842
  1882
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>


  		




  1843
  1883
  
    
                    </value>


  		




  
  1884
  
    
                    <value type="object" struct-name="db.mysql.Index" id="2f07d0b4-0127-11e3-9f3a-080027bcf912" struct-checksum="0x309b847a">


  		




  
  1885
  
    
                      <value _ptr_="0xc3001c0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">


  		




  
  1886
  
    
                        <value type="object" struct-name="db.mysql.IndexColumn" id="2f07d230-0127-11e3-9f3a-080027bcf912" struct-checksum="0x62630b3c">


  		




  
  1887
  
    
                          <value type="int" key="columnLength">0</value>


  		




  
  1888
  
    
                          <value type="string" key="comment"></value>


  		




  
  1889
  
    
                          <value type="int" key="descend">0</value>


  		




  
  1890
  
    
                          <link type="object" struct-name="db.Column" key="referencedColumn">2f07bade-0127-11e3-9f3a-080027bcf912</link>


  		




  
  1891
  
    
                          <value type="string" key="name"></value>


  		




  
  1892
  
    
                          <link type="object" struct-name="GrtObject" key="owner">2f07d0b4-0127-11e3-9f3a-080027bcf912</link>


  		




  
  1893
  
    
                        </value>


  		




  
  1894
  
    
                      </value>


  		




  
  1895
  
    
                      <value type="string" key="indexKind"></value>


  		




  
  1896
  
    
                      <value type="int" key="keyBlockSize">0</value>


  		




  
  1897
  
    
                      <value type="string" key="withParser"></value>


  		




  
  1898
  
    
                      <value type="string" key="comment"></value>


  		




  
  1899
  
    
                      <value type="int" key="deferability">0</value>


  		




  
  1900
  
    
                      <value type="string" key="indexType">INDEX</value>


  		




  
  1901
  
    
                      <value type="int" key="isPrimary">0</value>


  		




  
  1902
  
    
                      <value type="string" key="name">fk_individual_subplace1_idx</value>


  		




  
  1903
  
    
                      <value type="int" key="unique">0</value>


  		




  
  1904
  
    
                      <value type="string" key="oldName">fk_individual_subplace1_idx</value>


  		




  
  1905
  
    
                      <link type="object" struct-name="GrtObject" key="owner">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>


  		




  
  1906
  
    
                    </value>


  		




  1844
  1907
  
    
                  </value>


  		




  1845
  1908
  
    
                  <value type="string" key="maxRows"></value>


  		




  1846
  1909
  
    
                  <value type="string" key="mergeInsert"></value>


  		




  ......




  1872
  1935
  
    
                  <value type="int" key="commentedOut">0</value>


  		




  1873
  1936
  
    
                  <value type="string" key="createDate">2013-04-16 14:58</value>


  		




  1874
  1937
  
    
                  <value _ptr_="0xa33adc0" type="dict" key="customData"/>


  		




  1875
  
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 10:45</value>


  		




  
  1938
  
    
                  <value type="string" key="lastChangeDate">2013-08-09 12:09</value>


  		




  1876
  1939
  
    
                  <value type="int" key="modelOnly">0</value>


  		




  1877
  1940
  
    
                  <value type="string" key="name">individual</value>


  		




  1878
  1941
  
    
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>


  		




  ......




  14771
  14834
  
    
                <value type="int" key="visible">1</value>


  		




  14772
  14835
  
    
                <value type="string" key="name"></value>


  		




  14773
  14836
  
    
              </value>


  		




  
  14837
  
    
              <value type="object" struct-name="workbench.physical.Connection" id="2f07d834-0127-11e3-9f3a-080027bcf912" struct-checksum="0x9baebc92">


  		




  
  14838
  
    
                <value type="string" key="caption">fk_individual_subplace1</value>


  		




  
  14839
  
    
                <value type="real" key="captionXOffs">0.e+00</value>


  		




  
  14840
  
    
                <value type="real" key="captionYOffs">0.e+00</value>


  		




  
  14841
  
    
                <value type="string" key="comment"></value>


  		




  
  14842
  
    
                <value type="real" key="endCaptionXOffs">0.e+00</value>


  		




  
  14843
  
    
                <value type="real" key="endCaptionYOffs">0.e+00</value>


  		




  
  14844
  
    
                <value type="string" key="extraCaption"></value>


  		




  
  14845
  
    
                <value type="real" key="extraCaptionXOffs">0.e+00</value>


  		




  
  14846
  
    
                <value type="real" key="extraCaptionYOffs">0.e+00</value>


  		




  
  14847
  
    
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">2f07b8cc-0127-11e3-9f3a-080027bcf912</link>


  		




  
  14848
  
    
                <value type="real" key="middleSegmentOffset">0.e+00</value>


  		




  
  14849
  
    
                <value type="real" key="startCaptionXOffs">0.e+00</value>


  		




  
  14850
  
    
                <value type="real" key="startCaptionYOffs">0.e+00</value>


  		




  
  14851
  
    
                <value type="int" key="drawSplit">1</value>


  		




  
  14852
  
    
                <link type="object" struct-name="model.Figure" key="endFigure">B61D4BD4-43FB-4E3D-B257-6991B484B1FB</link>


  		




  
  14853
  
    
                <link type="object" struct-name="model.Figure" key="startFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>


  		




  
  14854
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  
  14855
  
    
                <value type="int" key="visible">1</value>


  		




  
  14856
  
    
                <value type="string" key="name"></value>


  		




  
  14857
  
    
              </value>


  		




  14774
  14858
  
    
            </value>


  		




  14775
  14859
  
    
            <value type="string" key="description"></value>


  		




  14776
  14860
  
    
            <value _ptr_="0xb036e80" type="list" content-type="object" content-struct-name="model.Figure" key="figures">


  		




  ......




  15218
  15302
  
    
                <value type="int" key="triggersExpanded">0</value>


  		




  15219
  15303
  
    
                <value type="string" key="color">#CCFFCC</value>


  		




  15220
  15304
  
    
                <value type="int" key="expanded">1</value>


  		




  15221
  
  
    
                <value type="real" key="height">1.23e+02</value>


  		




  
  15305
  
    
                <value type="real" key="height">1.46e+02</value>


  		




  15222
  15306
  
    
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>


  		




  15223
  15307
  
    
                <value type="real" key="left">1.302e+03</value>


  		




  15224
  15308
  
    
                <value type="int" key="locked">0</value>


  		




  15225
  15309
  
    
                <value type="int" key="manualSizing">0</value>


  		




  15226
  
  
    
                <value type="real" key="top">6.6e+01</value>


  		




  
  15310
  
    
                <value type="real" key="top">3.4e+01</value>


  		




  15227
  15311
  
    
                <value type="real" key="width">1.06e+02</value>


  		




  15228
  15312
  
    
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>


  		




  15229
  15313
  
    
                <value type="int" key="visible">1</value>


  		




  ......




  16467
  16551
  
    
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>


  		




  16468
  16552
  
    
        <value _ptr_="0xaf95e80" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>


  		




  16469
  16553
  
    
        <value _ptr_="0xa8c7ed8" type="dict" key="syncProfiles">


  		




  16470
  
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="49a6a8c0-0125-11e3-9f3a-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  16471
  
  
    
            <value _ptr_="0xc0f25a0" type="dict" key="lastKnownDBNames">


  		




  
  16554
  
    
          <value type="object" struct-name="db.mgmt.SyncProfile" id="791ca864-0127-11e3-9f3a-080027bcf912" struct-checksum="0xc64972c2" key="">


  		




  
  16555
  
    
            <value _ptr_="0xc473be8" type="dict" key="lastKnownDBNames">


  		




  16472
  16556
  
    
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>


  		




  16473
  16557
  
    
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>


  		




  16474
  16558
  
    
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>


  		




  ......




  16556
  16640
  
    
              <value type="string" key="2d3c42f6-0078-11e3-906b-080027bcf912">fk_place_observation_event1</value>


  		




  16557
  16641
  
    
              <value type="string" key="2ed4b280-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1</value>


  		




  16558
  16642
  
    
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>


  		




  
  16643
  
    
              <value type="string" key="2f07b8cc-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1</value>


  		




  
  16644
  
    
              <value type="string" key="2f07bade-0127-11e3-9f3a-080027bcf912">identifying_place</value>


  		




  
  16645
  
    
              <value type="string" key="2f07d0b4-0127-11e3-9f3a-080027bcf912">fk_individual_subplace1_idx</value>


  		




  16559
  16646
  
    
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>


  		




  16560
  16647
  
    
              <value type="string" key="323a36d4-011b-11e3-b872-080027bcf912">fk_individual_observation_place1</value>


  		




  16561
  16648
  
    
              <value type="string" key="323a39a4-011b-11e3-b872-080027bcf912">place_observed_at</value>


  		




  ......




  17063
  17150
  
    
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">


  		




  17064
  17151
  
    
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>


  		




  17065
  17152
  
    
      <value type="string" key="caption">New Model</value>


  		




  17066
  
  
    
      <value type="string" key="dateChanged">2013-08-09 12:05</value>


  		




  
  17153
  
    
      <value type="string" key="dateChanged">2013-08-09 12:11</value>


  		




  17067
  17154
  
    
      <value type="string" key="dateCreated">2012-01-19 14:06</value>


  		




  17068
  17155
  
    
      <value type="string" key="description"></value>


  		




  17069
  17156
  
    
      <value type="string" key="project">Name of the project</value>


  		












  

    
      schemas/VegCore/VegCore.my.sql
    
  





  329
  329
  
    
CREATE TABLE `individual` (


  		




  330
  330
  
    
  `id` varbinary(767) NOT NULL,


  		




  331
  331
  
    
  `within_place` varbinary(767) NOT NULL,


  		




  
  332
  
    
  `identifying_place` varbinary(767) DEFAULT NULL,


  		




  332
  333
  
    
  `tag` varbinary(767) DEFAULT NULL,


  		




  333
  334
  
    
  `tag_history` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  334
  335
  
    
  PRIMARY KEY (`id`),


  		




  335
  336
  
    
  KEY `fk_individual_place1_idx` (`within_place`),


  		




  
  337
  
    
  KEY `fk_individual_subplace1_idx` (`identifying_place`),


  		




  336
  338
  
    
  CONSTRAINT `fk_individual_record1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  337
  
  
    
  CONSTRAINT `fk_individual_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  339
  
    
  CONSTRAINT `fk_individual_place1` FOREIGN KEY (`within_place`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,


  		




  
  340
  
    
  CONSTRAINT `fk_individual_subplace1` FOREIGN KEY (`identifying_place`) REFERENCES `subplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  338
  341
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A distinct biological organism';


  		




  339
  342
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  340
  343
  
    

  		












Also available in:  Unified diff