Project

General

Profile

« Previous | Next » 

Revision 8681

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen: reordered columns to group together each method of identifying a specimen

View differences:

schemas/VegCore/document.mwb.xml
950 950 
                      <value type="int" key="isPrimary">0</value>
951 951 
                      <value type="string" key="name">fk_collection_source1_idx</value>
952 952 
                      <value type="int" key="unique">0</value>
953 
                      <value type="string" key="oldName">fk_collection_source1</value>
953 
                      <value type="string" key="oldName">fk_collection_source1_idx</value>
954 954 
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
955 955 
                    </value>
956 956 
                  </value>
......
5890 5890 
                      <value type="string" key="oldName">orig_collection</value>
5891 5891 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5892 5892 
                    </value>
5893 
                    <value type="object" struct-name="db.mysql.Column" id="bb0eaf44-ad10-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5893 
                    <value type="object" struct-name="db.mysql.Column" id="c6730b98-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5894 5894 
                      <value type="int" key="autoIncrement">0</value>
5895 5895 
                      <value type="string" key="characterSetName"></value>
5896 
                      <value _ptr_="0xc2a4dd0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5896 
                      <value _ptr_="0xa7492c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5897 5897 
                      <value type="string" key="collationName"></value>
5898 5898 
                      <value type="string" key="datatypeExplicitParams"></value>
5899 5899 
                      <value type="string" key="defaultValue"></value>
5900 
                      <value type="int" key="defaultValueIsNull">0</value>
5901 
                      <value _ptr_="0xb2245a0" type="list" content-type="string" key="flags"/>
5900 
                      <value type="int" key="defaultValueIsNull">1</value>
5901 
                      <value _ptr_="0xa749640" type="list" content-type="string" key="flags"/>
5902 5902 
                      <value type="int" key="isNotNull">0</value>
5903 5903 
                      <value type="int" key="length">767</value>
5904 5904 
                      <value type="int" key="precision">-1</value>
5905 5905 
                      <value type="int" key="scale">-1</value>
5906 5906 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5907 5907 
                      <value type="string" key="comment"></value>
5908 
                      <value type="string" key="name">current_collection</value>
5909 
                      <value type="string" key="oldName">current_collection</value>
5908 
                      <value type="string" key="name">barcode</value>
5909 
                      <value type="string" key="oldName">barcode</value>
5910 5910 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5911 5911 
                    </value>
5912 
                    <value type="object" struct-name="db.mysql.Column" id="c673038c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5912 
                    <value type="object" struct-name="db.mysql.Column" id="c6730d78-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5913 5913 
                      <value type="int" key="autoIncrement">0</value>
5914 5914 
                      <value type="string" key="characterSetName"></value>
5915 
                      <value _ptr_="0xa748df0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5915 
                      <value _ptr_="0xa749790" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5916 5916 
                      <value type="string" key="collationName"></value>
5917 5917 
                      <value type="string" key="datatypeExplicitParams"></value>
5918 5918 
                      <value type="string" key="defaultValue"></value>
5919 5919 
                      <value type="int" key="defaultValueIsNull">1</value>
5920 
                      <value _ptr_="0xa749170" type="list" content-type="string" key="flags"/>
5920 
                      <value _ptr_="0xa749b10" type="list" content-type="string" key="flags"/>
5921 5921 
                      <value type="int" key="isNotNull">0</value>
5922 5922 
                      <value type="int" key="length">767</value>
5923 5923 
                      <value type="int" key="precision">-1</value>
5924 5924 
                      <value type="int" key="scale">-1</value>
5925 5925 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5926 5926 
                      <value type="string" key="comment"></value>
5927 
                      <value type="string" key="name">owner</value>
5928 
                      <value type="string" key="oldName">owner</value>
5927 
                      <value type="string" key="name">accession_number</value>
5928 
                      <value type="string" key="oldName">accession_number</value>
5929 5929 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5930 5930 
                    </value>
5931 
                    <value type="object" struct-name="db.mysql.Column" id="c6730b98-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5931 
                    <value type="object" struct-name="db.mysql.Column" id="bb0eaf44-ad10-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
5932 5932 
                      <value type="int" key="autoIncrement">0</value>
5933 5933 
                      <value type="string" key="characterSetName"></value>
5934 
                      <value _ptr_="0xa7492c0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5934 
                      <value _ptr_="0xc2a4dd0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5935 5935 
                      <value type="string" key="collationName"></value>
5936 5936 
                      <value type="string" key="datatypeExplicitParams"></value>
5937 5937 
                      <value type="string" key="defaultValue"></value>
5938 
                      <value type="int" key="defaultValueIsNull">1</value>
5939 
                      <value _ptr_="0xa749640" type="list" content-type="string" key="flags"/>
5938 
                      <value type="int" key="defaultValueIsNull">0</value>
5939 
                      <value _ptr_="0xb2245a0" type="list" content-type="string" key="flags"/>
5940 5940 
                      <value type="int" key="isNotNull">0</value>
5941 5941 
                      <value type="int" key="length">767</value>
5942 5942 
                      <value type="int" key="precision">-1</value>
5943 5943 
                      <value type="int" key="scale">-1</value>
5944 5944 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5945 5945 
                      <value type="string" key="comment"></value>
5946 
                      <value type="string" key="name">barcode</value>
5947 
                      <value type="string" key="oldName">barcode</value>
5946 
                      <value type="string" key="name">current_collection</value>
5947 
                      <value type="string" key="oldName">current_collection</value>
5948 5948 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5949 5949 
                    </value>
5950 
                    <value type="object" struct-name="db.mysql.Column" id="c6730d78-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5950 
                    <value type="object" struct-name="db.mysql.Column" id="c673038c-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5951 5951 
                      <value type="int" key="autoIncrement">0</value>
5952 5952 
                      <value type="string" key="characterSetName"></value>
5953 
                      <value _ptr_="0xa749790" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5953 
                      <value _ptr_="0xa748df0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5954 5954 
                      <value type="string" key="collationName"></value>
5955 5955 
                      <value type="string" key="datatypeExplicitParams"></value>
5956 5956 
                      <value type="string" key="defaultValue"></value>
5957 5957 
                      <value type="int" key="defaultValueIsNull">1</value>
5958 
                      <value _ptr_="0xa749b10" type="list" content-type="string" key="flags"/>
5958 
                      <value _ptr_="0xa749170" type="list" content-type="string" key="flags"/>
5959 5959 
                      <value type="int" key="isNotNull">0</value>
5960 5960 
                      <value type="int" key="length">767</value>
5961 5961 
                      <value type="int" key="precision">-1</value>
5962 5962 
                      <value type="int" key="scale">-1</value>
5963 5963 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5964 5964 
                      <value type="string" key="comment"></value>
5965 
                      <value type="string" key="name">accession_number</value>
5966 
                      <value type="string" key="oldName">accession_number</value>
5965 
                      <value type="string" key="name">owner</value>
5966 
                      <value type="string" key="oldName">owner</value>
5967 5967 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5968 5968 
                    </value>
5969 5969 
                  </value>
......
6269 6269 
                  <value type="int" key="commentedOut">0</value>
6270 6270 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6271 6271 
                  <value _ptr_="0xa747628" type="dict" key="customData"/>
6272 
                  <value type="string" key="lastChangeDate">2013-04-24 11:57</value>
6272 
                  <value type="string" key="lastChangeDate">2013-04-24 12:15</value>
6273 6273 
                  <value type="int" key="modelOnly">0</value>
6274 6274 
                  <value type="string" key="name">specimen</value>
6275 6275 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12949 12949 
              <value type="int" key="visible">1</value>
12950 12950 
              <value type="string" key="name"></value>
12951 12951 
            </value>
12952 
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
12952 
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12953 
              <link type="object">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
12954 
            </value>
12953 12955 
            <value type="int" key="updateBlocked">0</value>
12954 12956 
            <value type="real" key="width">1.6215e+03</value>
12955 12957 
            <value type="real" key="x">0.e+00</value>
......
13044 13046 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13045 13047 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13046 13048 
      <value type="string" key="caption">New Model</value>
13047 
      <value type="string" key="dateChanged">2013-04-24 12:09</value>
13049 
      <value type="string" key="dateChanged">2013-04-24 12:15</value>
13048 13050 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13049 13051 
      <value type="string" key="description"></value>
13050 13052 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
466 466 
  `code_in_individual` VARBINARY(767) NULL ,
467 467 
  `collection_event` VARBINARY(767) NULL ,
468 468 
  `orig_collection` VARBINARY(767) NULL DEFAULT NULL ,
469 
  `barcode` VARBINARY(767) NULL DEFAULT NULL ,
470 
  `accession_number` VARBINARY(767) NULL DEFAULT NULL ,
469 471 
  `current_collection` VARBINARY(767) NULL ,
470 472 
  `owner` VARBINARY(767) NULL DEFAULT NULL ,
471 
  `barcode` VARBINARY(767) NULL DEFAULT NULL ,
472 
  `accession_number` VARBINARY(767) NULL DEFAULT NULL ,
473 473 
  PRIMARY KEY (`id`) ,
474 474 
  INDEX `fk_specimen_collection1_idx` (`orig_collection` ASC) ,
475 475 
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,

Also available in: Unified diff