Project

General

Profile

« Previous | Next » 

Revision 8678

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen: split collection into orig,current_collection because the collection that scoped the accession_number (the orig_collection) is sometimes different than the collection where the specimen is now held (the current_collection, or specimen_holder_institutions), e.g. when the specimen is donated

View differences:

schemas/VegCore/document.mwb.xml
804 804 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
805 805 
                      <value type="string" key="comment"></value>
806 806 
                      <value type="string" key="name">institution</value>
807 
                      <value type="string" key="oldName">organization_id</value>
807 
                      <value type="string" key="oldName">institution</value>
808 808 
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
809 809 
                    </value>
810 810 
                    <value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
......
823 823 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
824 824 
                      <value type="string" key="comment"></value>
825 825 
                      <value type="string" key="name">name</value>
826 
                      <value type="string" key="oldName"></value>
826 
                      <value type="string" key="oldName">name</value>
827 827 
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
828 828 
                    </value>
829 829 
                  </value>
......
919 919 
                      <value type="int" key="isPrimary">0</value>
920 920 
                      <value type="string" key="name">fk_collection_organization1_idx</value>
921 921 
                      <value type="int" key="unique">0</value>
922 
                      <value type="string" key="oldName">fk_collection_organization1</value>
922 
                      <value type="string" key="oldName">fk_collection_organization1_idx</value>
923 923 
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
924 924 
                    </value>
925 925 
                    <value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
......
950 950 
                      <value type="int" key="isPrimary">0</value>
951 951 
                      <value type="string" key="name">collection_unique</value>
952 952 
                      <value type="int" key="unique">1</value>
953 
                      <value type="string" key="oldName"></value>
953 
                      <value type="string" key="oldName">collection_unique</value>
954 954 
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
955 955 
                    </value>
956 956 
                  </value>
......
5886 5886 
                      <value type="int" key="scale">-1</value>
5887 5887 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5888 5888 
                      <value type="string" key="comment"></value>
5889 
                      <value type="string" key="name">collection</value>
5889 
                      <value type="string" key="name">orig_collection</value>
5890 5890 
                      <value type="string" key="oldName">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">
5894 
                      <value type="int" key="autoIncrement">0</value>
5895 
                      <value type="string" key="characterSetName"></value>
5896 
                      <value _ptr_="0xc2a4dd0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
5897 
                      <value type="string" key="collationName"></value>
5898 
                      <value type="string" key="datatypeExplicitParams"></value>
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"/>
5902 
                      <value type="int" key="isNotNull">0</value>
5903 
                      <value type="int" key="length">767</value>
5904 
                      <value type="int" key="precision">-1</value>
5905 
                      <value type="int" key="scale">-1</value>
5906 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5907 
                      <value type="string" key="comment"></value>
5908 
                      <value type="string" key="name">current_collection</value>
5909 
                      <value type="string" key="oldName"></value>
5910 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
5911 
                    </value>
5893 5912 
                    <value type="object" struct-name="db.mysql.Column" id="c67306ac-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
5894 5913 
                      <value type="int" key="autoIncrement">0</value>
5895 5914 
                      <value type="string" key="characterSetName"></value>
......
6138 6157 
                      <value type="string" key="name">fk_specimen_individual1</value>
6139 6158 
                      <value type="string" key="oldName">fk_specimen_individual1</value>
6140 6159 
                    </value>
6160 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="c66112f6-ad10-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
6161 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8df962-a6e0-11e2-95e9-080027bcf912</link>
6162 
                      <value _ptr_="0xc10fef0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
6163 
                        <link type="object">bb0eaf44-ad10-11e2-b309-080027bcf912</link>
6164 
                      </value>
6165 
                      <value type="int" key="deferability">0</value>
6166 
                      <value type="string" key="deleteRule">CASCADE</value>
6167 
                      <link type="object" struct-name="db.Index" key="index">c6612660-ad10-11e2-b309-080027bcf912</link>
6168 
                      <value type="int" key="mandatory">1</value>
6169 
                      <value type="int" key="many">1</value>
6170 
                      <value type="int" key="modelOnly">0</value>
6171 
                      <link type="object" struct-name="db.Table" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6172 
                      <value _ptr_="0xc10ff20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6173 
                        <link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
6174 
                      </value>
6175 
                      <value type="int" key="referencedMandatory">0</value>
6176 
                      <value type="string" key="updateRule">CASCADE</value>
6177 
                      <value type="string" key="comment"></value>
6178 
                      <value type="string" key="name">fk_specimen_collection2</value>
6179 
                      <value type="string" key="oldName">fk_specimen_collection2</value>
6180 
                    </value>
6141 6181 
                  </value>
6142 6182 
                  <value _ptr_="0xa7478a0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
6143 6183 
                    <value type="object" struct-name="db.mysql.Index" id="c6731048-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
6301 6341 
                      <value type="string" key="oldName">fk_specimen_individual1_idx</value>
6302 6342 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6303 6343 
                    </value>
6344 
                    <value type="object" struct-name="db.mysql.Index" id="c6612660-ad10-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
6345 
                      <value _ptr_="0xc1136c8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6346 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6615c2a-ad10-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
6347 
                          <value type="int" key="columnLength">0</value>
6348 
                          <value type="string" key="comment"></value>
6349 
                          <value type="int" key="descend">0</value>
6350 
                          <link type="object" struct-name="db.Column" key="referencedColumn">bb0eaf44-ad10-11e2-b309-080027bcf912</link>
6351 
                          <value type="string" key="name"></value>
6352 
                          <link type="object" struct-name="GrtObject" key="owner">c6612660-ad10-11e2-b309-080027bcf912</link>
6353 
                        </value>
6354 
                      </value>
6355 
                      <value type="string" key="indexKind"></value>
6356 
                      <value type="int" key="keyBlockSize">0</value>
6357 
                      <value type="string" key="withParser"></value>
6358 
                      <value type="string" key="comment"></value>
6359 
                      <value type="int" key="deferability">0</value>
6360 
                      <value type="string" key="indexType">INDEX</value>
6361 
                      <value type="int" key="isPrimary">0</value>
6362 
                      <value type="string" key="name">fk_specimen_collection2_idx</value>
6363 
                      <value type="int" key="unique">0</value>
6364 
                      <value type="string" key="oldName">fk_specimen_collection2</value>
6365 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6366 
                    </value>
6304 6367 
                  </value>
6305 6368 
                  <value type="string" key="maxRows"></value>
6306 6369 
                  <value type="string" key="mergeInsert"></value>
......
6332 6395 
                  <value type="int" key="commentedOut">0</value>
6333 6396 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6334 6397 
                  <value _ptr_="0xa747628" type="dict" key="customData"/>
6335 
                  <value type="string" key="lastChangeDate">2013-04-24 11:08</value>
6398 
                  <value type="string" key="lastChangeDate">2013-04-24 11:57</value>
6336 6399 
                  <value type="int" key="modelOnly">0</value>
6337 6400 
                  <value type="string" key="name">specimen</value>
6338 6401 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
10375 10438 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
10376 10439 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
10377 10440 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">29ffc726-a744-11e2-9fbf-080027bcf912</link>
10378 
                <value type="real" key="middleSegmentOffset">5.4e+01</value>
10441 
                <value type="real" key="middleSegmentOffset">6.25e+01</value>
10379 10442 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
10380 10443 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
10381 10444 
                <value type="int" key="drawSplit">0</value>
......
10795 10858 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
10796 10859 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
10797 10860 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c6731c28-a7a0-11e2-b667-080027bcf912</link>
10798 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
10861 
                <value type="real" key="middleSegmentOffset">1.8e+01</value>
10799 10862 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
10800 10863 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
10801 10864 
                <value type="int" key="drawSplit">0</value>
......
11687 11750 
                <value type="int" key="visible">1</value>
11688 11751 
                <value type="string" key="name"></value>
11689 11752 
              </value>
11753 
              <value type="object" struct-name="workbench.physical.Connection" id="c6618aba-ad10-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11754 
                <value type="string" key="caption">fk_specimen_collection2</value>
11755 
                <value type="real" key="captionXOffs">0.e+00</value>
11756 
                <value type="real" key="captionYOffs">0.e+00</value>
11757 
                <value type="string" key="comment"></value>
11758 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11759 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11760 
                <value type="string" key="extraCaption"></value>
11761 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11762 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11763 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c66112f6-ad10-11e2-b309-080027bcf912</link>
11764 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11765 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11766 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11767 
                <value type="int" key="drawSplit">0</value>
11768 
                <link type="object" struct-name="model.Figure" key="endFigure">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
11769 
                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
11770 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11771 
                <value type="int" key="visible">1</value>
11772 
                <value type="string" key="name"></value>
11773 
              </value>
11690 11774 
            </value>
11691 11775 
            <value type="string" key="description"></value>
11692 11776 
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12019 12103 
                <value type="real" key="left">9.18e+02</value>
12020 12104 
                <value type="int" key="locked">0</value>
12021 12105 
                <value type="int" key="manualSizing">0</value>
12022 
                <value type="real" key="top">9.36e+02</value>
12106 
                <value type="real" key="top">9.45e+02</value>
12023 12107 
                <value type="real" key="width">1.42e+02</value>
12024 12108 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12025 12109 
                <value type="int" key="visible">1</value>
......
12099 12183 
                <value type="real" key="left">8.48e+02</value>
12100 12184 
                <value type="int" key="locked">0</value>
12101 12185 
                <value type="int" key="manualSizing">0</value>
12102 
                <value type="real" key="top">7.46e+02</value>
12186 
                <value type="real" key="top">7.55e+02</value>
12103 12187 
                <value type="real" key="width">1.68e+02</value>
12104 12188 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12105 12189 
                <value type="int" key="visible">1</value>
......
12214 12298 
                <value type="int" key="triggersExpanded">0</value>
12215 12299 
                <value type="string" key="color">#CCCC33</value>
12216 12300 
                <value type="int" key="expanded">1</value>
12217 
                <value type="real" key="height">2.61e+02</value>
12301 
                <value type="real" key="height">2.84e+02</value>
12218 12302 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12219 12303 
                <value type="real" key="left">1.482e+03</value>
12220 12304 
                <value type="int" key="locked">0</value>
12221 12305 
                <value type="int" key="manualSizing">0</value>
12222 
                <value type="real" key="top">5.85e+02</value>
12306 
                <value type="real" key="top">5.8e+02</value>
12223 12307 
                <value type="real" key="width">1.19e+02</value>
12224 12308 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12225 12309 
                <value type="int" key="visible">1</value>
......
12239 12323 
                <value type="real" key="left">1.277e+03</value>
12240 12324 
                <value type="int" key="locked">0</value>
12241 12325 
                <value type="int" key="manualSizing">0</value>
12242 
                <value type="real" key="top">5.9e+02</value>
12326 
                <value type="real" key="top">6.09e+02</value>
12243 12327 
                <value type="real" key="width">1.06e+02</value>
12244 12328 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12245 12329 
                <value type="int" key="visible">1</value>
......
12625 12709 
                <value type="real" key="left">1.091e+03</value>
12626 12710 
                <value type="int" key="locked">0</value>
12627 12711 
                <value type="int" key="manualSizing">0</value>
12628 
                <value type="real" key="top">8.49e+02</value>
12712 
                <value type="real" key="top">8.58e+02</value>
12629 12713 
                <value type="real" key="width">1.39e+02</value>
12630 12714 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12631 12715 
                <value type="int" key="visible">1</value>
......
12665 12749 
                <value type="real" key="left">1.32e+03</value>
12666 12750 
                <value type="int" key="locked">0</value>
12667 12751 
                <value type="int" key="manualSizing">0</value>
12668 
                <value type="real" key="top">8.9e+02</value>
12752 
                <value type="real" key="top">8.99e+02</value>
12669 12753 
                <value type="real" key="width">1.2e+02</value>
12670 12754 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12671 12755 
                <value type="int" key="visible">1</value>
......
12685 12769 
                <value type="real" key="left">1.481e+03</value>
12686 12770 
                <value type="int" key="locked">0</value>
12687 12771 
                <value type="int" key="manualSizing">0</value>
12688 
                <value type="real" key="top">9.6e+02</value>
12772 
                <value type="real" key="top">9.69e+02</value>
12689 12773 
                <value type="real" key="width">1.14e+02</value>
12690 12774 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12691 12775 
                <value type="int" key="visible">1</value>
......
12722 12806 
                <value type="int" key="expanded">1</value>
12723 12807 
                <value type="real" key="height">7.7e+01</value>
12724 12808 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12725 
                <value type="real" key="left">1.027e+03</value>
12809 
                <value type="real" key="left">1.03e+03</value>
12726 12810 
                <value type="int" key="locked">0</value>
12727 12811 
                <value type="int" key="manualSizing">0</value>
12728 
                <value type="real" key="top">6.62e+02</value>
12812 
                <value type="real" key="top">6.83e+02</value>
12729 12813 
                <value type="real" key="width">1.8e+02</value>
12730 12814 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12731 12815 
                <value type="int" key="visible">1</value>
......
12782 12866 
                <value type="int" key="expanded">1</value>
12783 12867 
                <value type="real" key="height">1.e+02</value>
12784 12868 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12785 
                <value type="real" key="left">1.222e+03</value>
12869 
                <value type="real" key="left">1.225e+03</value>
12786 12870 
                <value type="int" key="locked">0</value>
12787 12871 
                <value type="int" key="manualSizing">0</value>
12788 
                <value type="real" key="top">7.16e+02</value>
12872 
                <value type="real" key="top">7.37e+02</value>
12789 12873 
                <value type="real" key="width">2.13e+02</value>
12790 12874 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12791 12875 
                <value type="int" key="visible">1</value>
......
12800 12884 
                <value type="real" key="left">7.19e+02</value>
12801 12885 
                <value type="int" key="locked">0</value>
12802 12886 
                <value type="int" key="manualSizing">0</value>
12803 
                <value type="real" key="top">8.75e+02</value>
12887 
                <value type="real" key="top">8.84e+02</value>
12804 12888 
                <value type="real" key="width">2.02e+02</value>
12805 12889 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12806 12890 
                <value type="int" key="visible">1</value>
......
12815 12899 
                <value type="real" key="left">1.165e+03</value>
12816 12900 
                <value type="int" key="locked">0</value>
12817 12901 
                <value type="int" key="manualSizing">0</value>
12818 
                <value type="real" key="top">1.004e+03</value>
12902 
                <value type="real" key="top">1.013e+03</value>
12819 12903 
                <value type="real" key="width">9.1e+01</value>
12820 12904 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12821 12905 
                <value type="int" key="visible">1</value>
......
12830 12914 
                <value type="real" key="left">1.201e+03</value>
12831 12915 
                <value type="int" key="locked">0</value>
12832 12916 
                <value type="int" key="manualSizing">0</value>
12833 
                <value type="real" key="top">9.56e+02</value>
12917 
                <value type="real" key="top">9.65e+02</value>
12834 12918 
                <value type="real" key="width">1.09e+02</value>
12835 12919 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12836 12920 
                <value type="int" key="visible">1</value>
......
12845 12929 
                <value type="real" key="left">1.069e+03</value>
12846 12930 
                <value type="int" key="locked">0</value>
12847 12931 
                <value type="int" key="manualSizing">0</value>
12848 
                <value type="real" key="top">1.095e+03</value>
12932 
                <value type="real" key="top">1.109e+03</value>
12849 12933 
                <value type="real" key="width">7.4e+01</value>
12850 12934 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12851 12935 
                <value type="int" key="visible">1</value>
......
12890 12974 
                <value type="real" key="left">9.38e+02</value>
12891 12975 
                <value type="int" key="locked">0</value>
12892 12976 
                <value type="int" key="manualSizing">0</value>
12893 
                <value type="real" key="top">8.75e+02</value>
12977 
                <value type="real" key="top">8.84e+02</value>
12894 12978 
                <value type="real" key="width">9.e+01</value>
12895 12979 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12896 12980 
                <value type="int" key="visible">1</value>
......
13128 13212 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13129 13213 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13130 13214 
      <value type="string" key="caption">New Model</value>
13131 
      <value type="string" key="dateChanged">2013-04-24 11:48</value>
13215 
      <value type="string" key="dateChanged">2013-04-24 11:59</value>
13132 13216 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13133 13217 
      <value type="string" key="description"></value>
13134 13218 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
465 465 
  `individual` VARBINARY(767) NULL ,
466 466 
  `code_in_individual` VARBINARY(767) NULL ,
467 467 
  `collection_event` VARBINARY(767) NULL ,
468 
  `collection` VARBINARY(767) NULL DEFAULT NULL ,
468 
  `orig_collection` VARBINARY(767) NULL DEFAULT NULL ,
469 
  `current_collection` VARBINARY(767) NULL ,
469 470 
  `stamping_institution` VARBINARY(767) NULL DEFAULT NULL ,
470 471 
  `donor_institution` VARBINARY(767) NULL DEFAULT NULL ,
471 472 
  `owner` VARBINARY(767) NULL DEFAULT NULL ,
472 473 
  `barcode` VARBINARY(767) NULL DEFAULT NULL ,
473 474 
  `accession_number` VARBINARY(767) NULL DEFAULT NULL ,
474 475 
  PRIMARY KEY (`id`) ,
475 
  INDEX `fk_specimen_collection1_idx` (`collection` ASC) ,
476 
  INDEX `fk_specimen_collection1_idx` (`orig_collection` ASC) ,
476 477 
  INDEX `fk_specimen_organization1_idx` (`stamping_institution` ASC) ,
477 478 
  INDEX `fk_specimen_organization2_idx` (`donor_institution` ASC) ,
478 479 
  INDEX `fk_specimen_organization3_idx` (`owner` ASC) ,
479 480 
  INDEX `fk_specimen_taxon_observation1_idx` (`collection_event` ASC) ,
480 481 
  INDEX `fk_specimen_individual1_idx` (`individual` ASC) ,
482 
  INDEX `fk_specimen_collection2_idx` (`current_collection` ASC) ,
481 483 
  CONSTRAINT `fk_specimen_taxon_occurrence1`
482 484 
    FOREIGN KEY (`id` )
483 485 
    REFERENCES `taxon_occurrence` (`id` )
484 486 
    ON DELETE CASCADE
485 487 
    ON UPDATE CASCADE,
486 488 
  CONSTRAINT `fk_specimen_collection1`
487 
    FOREIGN KEY (`collection` )
489 
    FOREIGN KEY (`orig_collection` )
488 490 
    REFERENCES `collection` (`id` )
489 491 
    ON DELETE CASCADE
490 492 
    ON UPDATE CASCADE,
......
512 514 
    FOREIGN KEY (`individual` )
513 515 
    REFERENCES `individual` (`id` )
514 516 
    ON DELETE CASCADE
517 
    ON UPDATE CASCADE,
518 
  CONSTRAINT `fk_specimen_collection2`
519 
    FOREIGN KEY (`current_collection` )
520 
    REFERENCES `collection` (`id` )
521 
    ON DELETE CASCADE
515 522 
    ON UPDATE CASCADE)
516 523 
ENGINE = InnoDB
517 524 
DEFAULT CHARACTER SET = utf8

Also available in: Unified diff