Project

General

Profile

« Previous | Next » 

Revision 8674

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen: added fkey to individual for the individual the specimen was taken from

View differences:

schemas/VegCore/document.mwb.xml
5701 5701 
                      <value type="string" key="oldName">id</value>
5702 5702 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5703 5703 
                    </value>
5704 
                    <value type="object" struct-name="db.mysql.Column" id="6ec4aa86-ad05-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5705 
                      <value type="int" key="autoIncrement">0</value>
5706 
                      <value type="string" key="characterSetName"></value>
5707 
                      <value _ptr_="0xb3bbec8" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5708 
                      <value type="string" key="collationName"></value>
5709 
                      <value type="string" key="datatypeExplicitParams"></value>
5710 
                      <value type="string" key="defaultValue"></value>
5711 
                      <value type="int" key="defaultValueIsNull">0</value>
5712 
                      <value _ptr_="0xb821220" type="list" content-type="string" key="flags"/>
5713 
                      <value type="int" key="isNotNull">0</value>
5714 
                      <value type="int" key="length">767</value>
5715 
                      <value type="int" key="precision">-1</value>
5716 
                      <value type="int" key="scale">-1</value>
5717 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5718 
                      <value type="string" key="comment"></value>
5719 
                      <value type="string" key="name">individual</value>
5720 
                      <value type="string" key="oldName">individual_id</value>
5721 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5722 
                    </value>
5704 5723 
                    <value type="object" struct-name="db.mysql.Column" id="eb778aac-ad01-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5705 5724 
                      <value type="int" key="autoIncrement">0</value>
5706 5725 
                      <value type="string" key="characterSetName"></value>
......
5966 5985 
                      <value type="string" key="name">fk_specimen_taxon_observation1</value>
5967 5986 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1</value>
5968 5987 
                    </value>
5988 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="6ec4a89c-ad05-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
5989 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8e3ecc-a6e0-11e2-95e9-080027bcf912</link>
5990 
                      <value _ptr_="0xbb51200" type="list" content-type="object" content-struct-name="db.Column" key="columns">
5991 
                        <link type="object">6ec4aa86-ad05-11e2-b309-080027bcf912</link>
5992 
                      </value>
5993 
                      <value type="int" key="deferability">0</value>
5994 
                      <value type="string" key="deleteRule">CASCADE</value>
5995 
                      <link type="object" struct-name="db.Index" key="index">6ec4c2fa-ad05-11e2-b309-080027bcf912</link>
5996 
                      <value type="int" key="mandatory">1</value>
5997 
                      <value type="int" key="many">1</value>
5998 
                      <value type="int" key="modelOnly">0</value>
5999 
                      <link type="object" struct-name="db.Table" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6000 
                      <value _ptr_="0xaed7768" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6001 
                        <link type="object">be8e4142-a6e0-11e2-95e9-080027bcf912</link>
6002 
                      </value>
6003 
                      <value type="int" key="referencedMandatory">0</value>
6004 
                      <value type="string" key="updateRule">CASCADE</value>
6005 
                      <value type="string" key="comment"></value>
6006 
                      <value type="string" key="name">fk_specimen_individual1</value>
6007 
                      <value type="string" key="oldName">fk_specimen_individual1</value>
6008 
                    </value>
5969 6009 
                  </value>
5970 6010 
                  <value _ptr_="0xa7478a0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
5971 6011 
                    <value type="object" struct-name="db.mysql.Index" id="c6731048-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
6106 6146 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1_idx</value>
6107 6147 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6108 6148 
                    </value>
6149 
                    <value type="object" struct-name="db.mysql.Index" id="6ec4c2fa-ad05-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
6150 
                      <value _ptr_="0xb4530c0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6151 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6ec4c4e4-ad05-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
6152 
                          <value type="int" key="columnLength">0</value>
6153 
                          <value type="string" key="comment"></value>
6154 
                          <value type="int" key="descend">0</value>
6155 
                          <link type="object" struct-name="db.Column" key="referencedColumn">6ec4aa86-ad05-11e2-b309-080027bcf912</link>
6156 
                          <value type="string" key="name"></value>
6157 
                          <link type="object" struct-name="GrtObject" key="owner">6ec4c2fa-ad05-11e2-b309-080027bcf912</link>
6158 
                        </value>
6159 
                      </value>
6160 
                      <value type="string" key="indexKind"></value>
6161 
                      <value type="int" key="keyBlockSize">0</value>
6162 
                      <value type="string" key="withParser"></value>
6163 
                      <value type="string" key="comment"></value>
6164 
                      <value type="int" key="deferability">0</value>
6165 
                      <value type="string" key="indexType">INDEX</value>
6166 
                      <value type="int" key="isPrimary">0</value>
6167 
                      <value type="string" key="name">fk_specimen_individual1_idx</value>
6168 
                      <value type="int" key="unique">0</value>
6169 
                      <value type="string" key="oldName">fk_specimen_individual1_idx</value>
6170 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6171 
                    </value>
6109 6172 
                  </value>
6110 6173 
                  <value type="string" key="maxRows"></value>
6111 6174 
                  <value type="string" key="mergeInsert"></value>
......
6137 6200 
                  <value type="int" key="commentedOut">0</value>
6138 6201 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6139 6202 
                  <value _ptr_="0xa747628" type="dict" key="customData"/>
6140 
                  <value type="string" key="lastChangeDate">2013-04-24 10:11</value>
6203 
                  <value type="string" key="lastChangeDate">2013-04-24 10:38</value>
6141 6204 
                  <value type="int" key="modelOnly">0</value>
6142 6205 
                  <value type="string" key="name">specimen</value>
6143 6206 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11335 11398 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11336 11399 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11337 11400 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c3762570-a7b3-11e2-8ba6-080027bcf912</link>
11338 
                <value type="real" key="middleSegmentOffset">1.56e+02</value>
11401 
                <value type="real" key="middleSegmentOffset">1.7e+02</value>
11339 11402 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11340 11403 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11341 11404 
                <value type="int" key="drawSplit">0</value>
......
11450 11513 
                <value type="int" key="visible">1</value>
11451 11514 
                <value type="string" key="name"></value>
11452 11515 
              </value>
11516 
              <value type="object" struct-name="workbench.physical.Connection" id="6ec4cc14-ad05-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11517 
                <value type="string" key="caption">fk_specimen_individual1</value>
11518 
                <value type="real" key="captionXOffs">0.e+00</value>
11519 
                <value type="real" key="captionYOffs">0.e+00</value>
11520 
                <value type="string" key="comment"></value>
11521 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11522 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11523 
                <value type="string" key="extraCaption"></value>
11524 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11525 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11526 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">6ec4a89c-ad05-11e2-b309-080027bcf912</link>
11527 
                <value type="real" key="middleSegmentOffset">-6.3e+01</value>
11528 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11529 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11530 
                <value type="int" key="drawSplit">0</value>
11531 
                <link type="object" struct-name="model.Figure" key="endFigure">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
11532 
                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
11533 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11534 
                <value type="int" key="visible">1</value>
11535 
                <value type="string" key="name"></value>
11536 
              </value>
11453 11537 
            </value>
11454 11538 
            <value type="string" key="description"></value>
11455 11539 
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
11819 11903 
                <value type="int" key="expanded">1</value>
11820 11904 
                <value type="real" key="height">1.e+02</value>
11821 11905 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11822 
                <value type="real" key="left">1.404e+03</value>
11906 
                <value type="real" key="left">1.439e+03</value>
11823 11907 
                <value type="int" key="locked">0</value>
11824 11908 
                <value type="int" key="manualSizing">0</value>
11825 11909 
                <value type="real" key="top">3.9e+01</value>
......
11939 12023 
                <value type="int" key="expanded">1</value>
11940 12024 
                <value type="real" key="height">7.7e+01</value>
11941 12025 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11942 
                <value type="real" key="left">1.43e+03</value>
12026 
                <value type="real" key="left">1.412e+03</value>
11943 12027 
                <value type="int" key="locked">0</value>
11944 12028 
                <value type="int" key="manualSizing">0</value>
11945 12029 
                <value type="real" key="top">4.91e+02</value>
......
11977 12061 
                <value type="int" key="triggersExpanded">0</value>
11978 12062 
                <value type="string" key="color">#CCCC33</value>
11979 12063 
                <value type="int" key="expanded">1</value>
11980 
                <value type="real" key="height">2.15e+02</value>
12064 
                <value type="real" key="height">2.38e+02</value>
11981 12065 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
11982 
                <value type="real" key="left">1.467e+03</value>
12066 
                <value type="real" key="left">1.482e+03</value>
11983 12067 
                <value type="int" key="locked">0</value>
11984 12068 
                <value type="int" key="manualSizing">0</value>
11985 
                <value type="real" key="top">6.24e+02</value>
12069 
                <value type="real" key="top">5.85e+02</value>
11986 12070 
                <value type="real" key="width">1.19e+02</value>
11987 12071 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11988 12072 
                <value type="int" key="visible">1</value>
......
11999 12083 
                <value type="int" key="expanded">1</value>
12000 12084 
                <value type="real" key="height">5.4e+01</value>
12001 12085 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12002 
                <value type="real" key="left">1.474e+03</value>
12086 
                <value type="real" key="left">1.278e+03</value>
12003 12087 
                <value type="int" key="locked">0</value>
12004 12088 
                <value type="int" key="manualSizing">0</value>
12005 
                <value type="real" key="top">8.78e+02</value>
12089 
                <value type="real" key="top">6.25e+02</value>
12006 12090 
                <value type="real" key="width">1.06e+02</value>
12007 12091 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12008 12092 
                <value type="int" key="visible">1</value>
......
12485 12569 
                <value type="int" key="expanded">1</value>
12486 12570 
                <value type="real" key="height">7.7e+01</value>
12487 12571 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12488 
                <value type="real" key="left">1.026e+03</value>
12572 
                <value type="real" key="left">1.028e+03</value>
12489 12573 
                <value type="int" key="locked">0</value>
12490 12574 
                <value type="int" key="manualSizing">0</value>
12491 
                <value type="real" key="top">6.36e+02</value>
12575 
                <value type="real" key="top">6.52e+02</value>
12492 12576 
                <value type="real" key="width">1.8e+02</value>
12493 12577 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12494 12578 
                <value type="int" key="visible">1</value>
......
12545 12629 
                <value type="int" key="expanded">1</value>
12546 12630 
                <value type="real" key="height">1.e+02</value>
12547 12631 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12548 
                <value type="real" key="left">1.221e+03</value>
12632 
                <value type="real" key="left">1.223e+03</value>
12549 12633 
                <value type="int" key="locked">0</value>
12550 12634 
                <value type="int" key="manualSizing">0</value>
12551 
                <value type="real" key="top">6.82e+02</value>
12635 
                <value type="real" key="top">7.06e+02</value>
12552 12636 
                <value type="real" key="width">2.13e+02</value>
12553 12637 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12554 12638 
                <value type="int" key="visible">1</value>
......
12891 12975 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12892 12976 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12893 12977 
      <value type="string" key="caption">New Model</value>
12894 
      <value type="string" key="dateChanged">2013-04-24 10:28</value>
12978 
      <value type="string" key="dateChanged">2013-04-24 10:40</value>
12895 12979 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
12896 12980 
      <value type="string" key="description"></value>
12897 12981 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
413 413 

  		




  414
  414
  
    
CREATE  TABLE IF NOT EXISTS `specimen` (


  		




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


  		




  
  416
  
    
  `individual` VARBINARY(767) NULL ,


  		




  416
  417
  
    
  `collection_event` VARBINARY(767) NULL ,


  		




  417
  418
  
    
  `collection` VARBINARY(767) NULL DEFAULT NULL ,


  		




  418
  419
  
    
  `stamping_institution` VARBINARY(767) NULL DEFAULT NULL ,


  		




  ......




  426
  427
  
    
  INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) ,


  		




  427
  428
  
    
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,


  		




  428
  429
  
    
  INDEX `fk_specimen_taxon_observation1_idx` (`collection_event` ASC) ,


  		




  
  430
  
    
  INDEX `fk_specimen_individual1_idx` (`individual` ASC) ,


  		




  429
  431
  
    
  CONSTRAINT `fk_specimen_taxon_occurrence1`


  		




  430
  432
  
    
    FOREIGN KEY (`id` )


  		




  431
  433
  
    
    REFERENCES `taxon_occurrence` (`id` )


  		




  ......




  455
  457
  
    
    FOREIGN KEY (`collection_event` )


  		




  456
  458
  
    
    REFERENCES `taxon_observation` (`id` )


  		




  457
  459
  
    
    ON DELETE CASCADE


  		




  
  460
  
    
    ON UPDATE CASCADE,


  		




  
  461
  
    
  CONSTRAINT `fk_specimen_individual1`


  		




  
  462
  
    
    FOREIGN KEY (`individual` )


  		




  
  463
  
    
    REFERENCES `individual` (`id` )


  		




  
  464
  
    
    ON DELETE CASCADE


  		




  458
  465
  
    
    ON UPDATE CASCADE)


  		




  459
  466
  
    
ENGINE = InnoDB


  		




  460
  467
  
    
DEFAULT CHARACTER SET = utf8


  		












Also available in:  Unified diff