Project

General

Profile

« Previous | Next » 

Revision 8675

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen: added code_in_individual column

View differences:

schemas/VegCore/document.mwb.xml
5717 5717 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5718 5718 
                      <value type="string" key="comment"></value>
5719 5719 
                      <value type="string" key="name">individual</value>
5720 
                      <value type="string" key="oldName">individual_id</value>
5720 
                      <value type="string" key="oldName">individual</value>
5721 5721 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5722 5722 
                    </value>
5723 
                    <value type="object" struct-name="db.mysql.Column" id="bbbbdd9c-ad09-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5724 
                      <value type="int" key="autoIncrement">0</value>
5725 
                      <value type="string" key="characterSetName"></value>
5726 
                      <value _ptr_="0xb709ea0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5727 
                      <value type="string" key="collationName"></value>
5728 
                      <value type="string" key="datatypeExplicitParams"></value>
5729 
                      <value type="string" key="defaultValue"></value>
5730 
                      <value type="int" key="defaultValueIsNull">0</value>
5731 
                      <value _ptr_="0xb70cfa8" type="list" content-type="string" key="flags"/>
5732 
                      <value type="int" key="isNotNull">0</value>
5733 
                      <value type="int" key="length">767</value>
5734 
                      <value type="int" key="precision">-1</value>
5735 
                      <value type="int" key="scale">-1</value>
5736 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5737 
                      <value type="string" key="comment"></value>
5738 
                      <value type="string" key="name">code_in_individual</value>
5739 
                      <value type="string" key="oldName">code</value>
5740 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5741 
                    </value>
5723 5742 
                    <value type="object" struct-name="db.mysql.Column" id="eb778aac-ad01-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5724 5743 
                      <value type="int" key="autoIncrement">0</value>
5725 5744 
                      <value type="string" key="characterSetName"></value>
......
6200 6219 
                  <value type="int" key="commentedOut">0</value>
6201 6220 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6202 6221 
                  <value _ptr_="0xa747628" type="dict" key="customData"/>
6203 
                  <value type="string" key="lastChangeDate">2013-04-24 10:38</value>
6222 
                  <value type="string" key="lastChangeDate">2013-04-24 11:08</value>
6204 6223 
                  <value type="int" key="modelOnly">0</value>
6205 6224 
                  <value type="string" key="name">specimen</value>
6206 6225 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12061 12080 
                <value type="int" key="triggersExpanded">0</value>
12062 12081 
                <value type="string" key="color">#CCCC33</value>
12063 12082 
                <value type="int" key="expanded">1</value>
12064 
                <value type="real" key="height">2.38e+02</value>
12083 
                <value type="real" key="height">2.61e+02</value>
12065 12084 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12066 12085 
                <value type="real" key="left">1.482e+03</value>
12067 12086 
                <value type="int" key="locked">0</value>
......
12083 12102 
                <value type="int" key="expanded">1</value>
12084 12103 
                <value type="real" key="height">5.4e+01</value>
12085 12104 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12086 
                <value type="real" key="left">1.278e+03</value>
12105 
                <value type="real" key="left">1.277e+03</value>
12087 12106 
                <value type="int" key="locked">0</value>
12088 12107 
                <value type="int" key="manualSizing">0</value>
12089 
                <value type="real" key="top">6.25e+02</value>
12108 
                <value type="real" key="top">6.35e+02</value>
12090 12109 
                <value type="real" key="width">1.06e+02</value>
12091 12110 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12092 12111 
                <value type="int" key="visible">1</value>
......
12569 12588 
                <value type="int" key="expanded">1</value>
12570 12589 
                <value type="real" key="height">7.7e+01</value>
12571 12590 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12572 
                <value type="real" key="left">1.028e+03</value>
12591 
                <value type="real" key="left">1.027e+03</value>
12573 12592 
                <value type="int" key="locked">0</value>
12574 12593 
                <value type="int" key="manualSizing">0</value>
12575 
                <value type="real" key="top">6.52e+02</value>
12594 
                <value type="real" key="top">6.62e+02</value>
12576 12595 
                <value type="real" key="width">1.8e+02</value>
12577 12596 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12578 12597 
                <value type="int" key="visible">1</value>
......
12629 12648 
                <value type="int" key="expanded">1</value>
12630 12649 
                <value type="real" key="height">1.e+02</value>
12631 12650 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12632 
                <value type="real" key="left">1.223e+03</value>
12651 
                <value type="real" key="left">1.222e+03</value>
12633 12652 
                <value type="int" key="locked">0</value>
12634 12653 
                <value type="int" key="manualSizing">0</value>
12635 
                <value type="real" key="top">7.06e+02</value>
12654 
                <value type="real" key="top">7.16e+02</value>
12636 12655 
                <value type="real" key="width">2.13e+02</value>
12637 12656 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12638 12657 
                <value type="int" key="visible">1</value>
......
12880 12899 
              <value type="int" key="visible">1</value>
12881 12900 
              <value type="string" key="name"></value>
12882 12901 
            </value>
12883 
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
12902 
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12903 
              <link type="object">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
12904 
            </value>
12884 12905 
            <value type="int" key="updateBlocked">0</value>
12885 12906 
            <value type="real" key="width">1.6215e+03</value>
12886 12907 
            <value type="real" key="x">0.e+00</value>
......
12975 12996 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12976 12997 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12977 12998 
      <value type="string" key="caption">New Model</value>
12978 
      <value type="string" key="dateChanged">2013-04-24 10:40</value>
12999 
      <value type="string" key="dateChanged">2013-04-24 11:08</value>
12979 13000 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
12980 13001 
      <value type="string" key="description"></value>
12981 13002 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
414 414 
CREATE  TABLE IF NOT EXISTS `specimen` (
415 415 
  `id` VARBINARY(767) NOT NULL ,
416 416 
  `individual` VARBINARY(767) NULL ,
417 
  `code_in_individual` VARBINARY(767) NULL ,
417 418 
  `collection_event` VARBINARY(767) NULL ,
418 419 
  `collection` VARBINARY(767) NULL DEFAULT NULL ,
419 420 
  `stamping_institution` VARBINARY(767) NULL DEFAULT NULL ,

Also available in: Unified diff