Project

General

Profile

« Previous | Next » 

Revision 8673

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: individual/stem_observation: made individual/stem nullable because there is not always enough identifying information (stem tag, etc.) to actually associate an identifiable individual with an observation

View differences:

schemas/VegCore/document.mwb.xml
6417 6417 
                      <value type="string" key="defaultValue"></value>
6418 6418 
                      <value type="int" key="defaultValueIsNull">0</value>
6419 6419 
                      <value _ptr_="0xa753e70" type="list" content-type="string" key="flags"/>
6420 
                      <value type="int" key="isNotNull">1</value>
6420 
                      <value type="int" key="isNotNull">0</value>
6421 6421 
                      <value type="int" key="length">767</value>
6422 6422 
                      <value type="int" key="precision">-1</value>
6423 6423 
                      <value type="int" key="scale">-1</value>
......
6443 6443 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6444 6444 
                      <value type="string" key="comment"></value>
6445 6445 
                      <value type="string" key="name">code</value>
6446 
                      <value type="string" key="oldName"></value>
6446 
                      <value type="string" key="oldName">code</value>
6447 6447 
                      <link type="object" struct-name="GrtObject" key="owner">0ab9880e-a7a1-11e2-b667-080027bcf912</link>
6448 6448 
                    </value>
6449 6449 
                    <value type="object" struct-name="db.mysql.Column" id="0ab98e12-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
......
6507 6507 
                      <value _ptr_="0xa754c18" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6508 6508 
                        <link type="object">be8e4142-a6e0-11e2-95e9-080027bcf912</link>
6509 6509 
                      </value>
6510 
                      <value type="int" key="referencedMandatory">1</value>
6510 
                      <value type="int" key="referencedMandatory">0</value>
6511 6511 
                      <value type="string" key="updateRule">CASCADE</value>
6512 6512 
                      <value type="string" key="comment"></value>
6513 6513 
                      <value type="string" key="name">fk_individual_observation_individual1</value>
......
6592 6592 
                  <value type="int" key="commentedOut">0</value>
6593 6593 
                  <value type="string" key="createDate">2013-04-17 13:54</value>
6594 6594 
                  <value _ptr_="0xa753198" type="dict" key="customData"/>
6595 
                  <value type="string" key="lastChangeDate">2013-04-24 10:21</value>
6595 
                  <value type="string" key="lastChangeDate">2013-04-24 10:27</value>
6596 6596 
                  <value type="int" key="modelOnly">0</value>
6597 6597 
                  <value type="string" key="name">individual_observation</value>
6598 6598 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
6827 6827 
                      <value type="string" key="defaultValue"></value>
6828 6828 
                      <value type="int" key="defaultValueIsNull">0</value>
6829 6829 
                      <value _ptr_="0xa759720" type="list" content-type="string" key="flags"/>
6830 
                      <value type="int" key="isNotNull">1</value>
6830 
                      <value type="int" key="isNotNull">0</value>
6831 6831 
                      <value type="int" key="length">767</value>
6832 6832 
                      <value type="int" key="precision">-1</value>
6833 6833 
                      <value type="int" key="scale">-1</value>
......
6898 6898 
                      <value _ptr_="0xa75a4c8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6899 6899 
                        <link type="object">be8e679e-a6e0-11e2-95e9-080027bcf912</link>
6900 6900 
                      </value>
6901 
                      <value type="int" key="referencedMandatory">1</value>
6901 
                      <value type="int" key="referencedMandatory">0</value>
6902 6902 
                      <value type="string" key="updateRule">CASCADE</value>
6903 6903 
                      <value type="string" key="comment"></value>
6904 6904 
                      <value type="string" key="name">fk_stem_observation_stem1</value>
......
7057 7057 
                  <value type="int" key="commentedOut">0</value>
7058 7058 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
7059 7059 
                  <value _ptr_="0xa758578" type="dict" key="customData"/>
7060 
                  <value type="string" key="lastChangeDate">2013-04-17 12:38</value>
7060 
                  <value type="string" key="lastChangeDate">2013-04-24 10:28</value>
7061 7061 
                  <value type="int" key="modelOnly">0</value>
7062 7062 
                  <value type="string" key="name">stem_observation</value>
7063 7063 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12891 12891 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12892 12892 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12893 12893 
      <value type="string" key="caption">New Model</value>
12894 
      <value type="string" key="dateChanged">2013-04-24 10:22</value>
12894 
      <value type="string" key="dateChanged">2013-04-24 10:28</value>
12895 12895 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
12896 12896 
      <value type="string" key="description"></value>
12897 12897 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
858 858 

  		




  859
  859
  
    
CREATE  TABLE IF NOT EXISTS `individual_observation` (


  		




  860
  860
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  861
  
  
    
  `individual` VARBINARY(767) NOT NULL ,


  		




  
  861
  
    
  `individual` VARBINARY(767) NULL ,


  		




  862
  862
  
    
  `code` VARBINARY(767) NULL ,


  		




  863
  863
  
    
  `traits` SET('hstore') NULL ,


  		




  864
  864
  
    
  PRIMARY KEY (`id`) ,


  		




  ......




  911
  911
  
    
CREATE  TABLE IF NOT EXISTS `stem_observation` (


  		




  912
  912
  
    
  `id` VARBINARY(767) NOT NULL ,


  		




  913
  913
  
    
  `individual_observation` VARBINARY(767) NOT NULL ,


  		




  914
  
  
    
  `stem` VARBINARY(767) NOT NULL ,


  		




  
  914
  
    
  `stem` VARBINARY(767) NULL ,


  		




  915
  915
  
    
  `traits` SET('hstore') NULL ,


  		




  916
  916
  
    
  PRIMARY KEY (`id`) ,


  		




  917
  917
  
    
  INDEX `fk_stem_observation_individual_observation1_idx` (`individual_observation` ASC) ,


  		












Also available in:  Unified diff