Project

General

Profile

« Previous | Next » 

Revision 8684

Added by Aaron Marcuse-Kubitza almost 12 years ago

schemas/VegCore/VegCore.ERD.mwb: specimen: added unique constraint for each set of identifying columns

View differences:

schemas/VegCore/document.mwb.xml
6261 6261 
                      <value type="string" key="oldName">fk_specimen_organization3_idx</value>
6262 6262 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6263 6263 
                    </value>
6264 
                    <value type="object" struct-name="db.mysql.Index" id="415f1a26-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6265 
                      <value _ptr_="0xc6bac18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6266 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="45c9dca4-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6267 
                          <value type="int" key="columnLength">0</value>
6268 
                          <value type="string" key="comment"></value>
6269 
                          <value type="int" key="descend">0</value>
6270 
                          <link type="object" struct-name="db.Column" key="referencedColumn">6ec4aa86-ad05-11e2-b309-080027bcf912</link>
6271 
                          <value type="string" key="name"></value>
6272 
                          <link type="object" struct-name="GrtObject" key="owner">415f1a26-ad15-11e2-9617-080027bcf912</link>
6273 
                        </value>
6274 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="46306e38-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6275 
                          <value type="int" key="columnLength">0</value>
6276 
                          <value type="string" key="comment"></value>
6277 
                          <value type="int" key="descend">0</value>
6278 
                          <link type="object" struct-name="db.Column" key="referencedColumn">bbbbdd9c-ad09-11e2-b309-080027bcf912</link>
6279 
                          <value type="string" key="name"></value>
6280 
                          <link type="object" struct-name="GrtObject" key="owner">415f1a26-ad15-11e2-9617-080027bcf912</link>
6281 
                        </value>
6282 
                      </value>
6283 
                      <value type="string" key="indexKind"></value>
6284 
                      <value type="int" key="keyBlockSize">0</value>
6285 
                      <value type="string" key="withParser"></value>
6286 
                      <value type="string" key="comment"></value>
6287 
                      <value type="int" key="deferability">0</value>
6288 
                      <value type="string" key="indexType">UNIQUE</value>
6289 
                      <value type="int" key="isPrimary">0</value>
6290 
                      <value type="string" key="name">specimen_unique_in_individual</value>
6291 
                      <value type="int" key="unique">1</value>
6292 
                      <value type="string" key="oldName"></value>
6293 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6294 
                    </value>
6295 
                    <value type="object" struct-name="db.mysql.Index" id="4e241b94-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6296 
                      <value _ptr_="0xc3dbe50" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6297 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6bee3326-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6298 
                          <value type="int" key="columnLength">0</value>
6299 
                          <value type="string" key="comment"></value>
6300 
                          <value type="int" key="descend">0</value>
6301 
                          <link type="object" struct-name="db.Column" key="referencedColumn">eb778aac-ad01-11e2-b309-080027bcf912</link>
6302 
                          <value type="string" key="name"></value>
6303 
                          <link type="object" struct-name="GrtObject" key="owner">4e241b94-ad15-11e2-9617-080027bcf912</link>
6304 
                        </value>
6305 
                      </value>
6306 
                      <value type="string" key="indexKind"></value>
6307 
                      <value type="int" key="keyBlockSize">0</value>
6308 
                      <value type="string" key="withParser"></value>
6309 
                      <value type="string" key="comment"></value>
6310 
                      <value type="int" key="deferability">0</value>
6311 
                      <value type="string" key="indexType">UNIQUE</value>
6312 
                      <value type="int" key="isPrimary">0</value>
6313 
                      <value type="string" key="name">specimen_unique_by_collection_event</value>
6314 
                      <value type="int" key="unique">1</value>
6315 
                      <value type="string" key="oldName"></value>
6316 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6317 
                    </value>
6318 
                    <value type="object" struct-name="db.mysql.Index" id="7f3654cc-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6319 
                      <value _ptr_="0xc6c7f18" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6320 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9058b178-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6321 
                          <value type="int" key="columnLength">0</value>
6322 
                          <value type="string" key="comment"></value>
6323 
                          <value type="int" key="descend">0</value>
6324 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6730896-a7a0-11e2-b667-080027bcf912</link>
6325 
                          <value type="string" key="name"></value>
6326 
                          <link type="object" struct-name="GrtObject" key="owner">7f3654cc-ad15-11e2-9617-080027bcf912</link>
6327 
                        </value>
6328 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="99ff7270-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6329 
                          <value type="int" key="columnLength">0</value>
6330 
                          <value type="string" key="comment"></value>
6331 
                          <value type="int" key="descend">0</value>
6332 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6730b98-a7a0-11e2-b667-080027bcf912</link>
6333 
                          <value type="string" key="name"></value>
6334 
                          <link type="object" struct-name="GrtObject" key="owner">7f3654cc-ad15-11e2-9617-080027bcf912</link>
6335 
                        </value>
6336 
                      </value>
6337 
                      <value type="string" key="indexKind"></value>
6338 
                      <value type="int" key="keyBlockSize">0</value>
6339 
                      <value type="string" key="withParser"></value>
6340 
                      <value type="string" key="comment"></value>
6341 
                      <value type="int" key="deferability">0</value>
6342 
                      <value type="string" key="indexType">UNIQUE</value>
6343 
                      <value type="int" key="isPrimary">0</value>
6344 
                      <value type="string" key="name">specimen_unique_in_collection_by_barcode</value>
6345 
                      <value type="int" key="unique">1</value>
6346 
                      <value type="string" key="oldName"></value>
6347 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6348 
                    </value>
6349 
                    <value type="object" struct-name="db.mysql.Index" id="a60e3a24-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6350 
                      <value _ptr_="0xc626cc0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6351 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ab4d484a-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6352 
                          <value type="int" key="columnLength">0</value>
6353 
                          <value type="string" key="comment"></value>
6354 
                          <value type="int" key="descend">0</value>
6355 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6730896-a7a0-11e2-b667-080027bcf912</link>
6356 
                          <value type="string" key="name"></value>
6357 
                          <link type="object" struct-name="GrtObject" key="owner">a60e3a24-ad15-11e2-9617-080027bcf912</link>
6358 
                        </value>
6359 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="abbbc428-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6360 
                          <value type="int" key="columnLength">0</value>
6361 
                          <value type="string" key="comment"></value>
6362 
                          <value type="int" key="descend">0</value>
6363 
                          <link type="object" struct-name="db.Column" key="referencedColumn">c6730d78-a7a0-11e2-b667-080027bcf912</link>
6364 
                          <value type="string" key="name"></value>
6365 
                          <link type="object" struct-name="GrtObject" key="owner">a60e3a24-ad15-11e2-9617-080027bcf912</link>
6366 
                        </value>
6367 
                      </value>
6368 
                      <value type="string" key="indexKind"></value>
6369 
                      <value type="int" key="keyBlockSize">0</value>
6370 
                      <value type="string" key="withParser"></value>
6371 
                      <value type="string" key="comment"></value>
6372 
                      <value type="int" key="deferability">0</value>
6373 
                      <value type="string" key="indexType">UNIQUE</value>
6374 
                      <value type="int" key="isPrimary">0</value>
6375 
                      <value type="string" key="name">specimen_unique_in_collection_by_accession_number</value>
6376 
                      <value type="int" key="unique">1</value>
6377 
                      <value type="string" key="oldName"></value>
6378 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6379 
                    </value>
6264 6380 
                  </value>
6265 6381 
                  <value type="string" key="maxRows"></value>
6266 6382 
                  <value type="string" key="mergeInsert"></value>
......
6292 6408 
                  <value type="int" key="commentedOut">0</value>
6293 6409 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
6294 6410 
                  <value _ptr_="0xbcfff60" type="dict" key="customData"/>
6295 
                  <value type="string" key="lastChangeDate">2013-04-24 12:20</value>
6411 
                  <value type="string" key="lastChangeDate">2013-04-24 12:32</value>
6296 6412 
                  <value type="int" key="modelOnly">0</value>
6297 6413 
                  <value type="string" key="name">specimen</value>
6298 6414 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
12973 13089 
              <value type="string" key="name"></value>
12974 13090 
            </value>
12975 13091 
            <value _ptr_="0xbd397c8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12976 
              <link type="object">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
13092 
              <link type="object">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
12977 13093 
            </value>
12978 13094 
            <value type="int" key="updateBlocked">0</value>
12979 13095 
            <value type="real" key="width">1.6215e+03</value>
......
13069 13185 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13070 13186 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13071 13187 
      <value type="string" key="caption">New Model</value>
13072 
      <value type="string" key="dateChanged">2013-04-24 12:24</value>
13188 
      <value type="string" key="dateChanged">2013-04-24 12:32</value>
13073 13189 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13074 13190 
      <value type="string" key="description"></value>
13075 13191 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
477 477 
  INDEX `fk_specimen_individual1_idx` (`individual` ASC) ,
478 478 
  INDEX `fk_specimen_collection2_idx` (`current_collection` ASC) ,
479 479 
  INDEX `fk_specimen_organization3_idx` (`owner_collection` ASC) ,
480 
  UNIQUE INDEX `specimen_unique_in_individual` (`individual` ASC, `code_in_individual` ASC) ,
481 
  UNIQUE INDEX `specimen_unique_by_collection_event` (`collection_event` ASC) ,
482 
  UNIQUE INDEX `specimen_unique_in_collection_by_barcode` (`orig_collection` ASC, `barcode` ASC) ,
483 
  UNIQUE INDEX `specimen_unique_in_collection_by_accession_number` (`orig_collection` ASC, `accession_number` ASC) ,
480 484 
  CONSTRAINT `fk_specimen_taxon_occurrence1`
481 485 
    FOREIGN KEY (`id` )
482 486 
    REFERENCES `taxon_occurrence` (`id` )

Also available in: Unified diff