Project

General

Profile

« Previous | Next » 

Revision 11112

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: specimen: removed collection_event because this is the same as individual_observation

View differences:

schemas/VegCore/ERD/document.mwb.xml
6382 6382 
                      <value type="int" key="precision">-1</value>
6383 6383 
                      <value type="int" key="scale">-1</value>
6384 6384 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6385 
                      <value type="string" key="comment">the plant the specimen was collected from and any observations about it. the collection_event should be set to this field when provided.</value>
6385 
                      <value type="string" key="comment">the plant the specimen was collected from and any observations about it</value>
6386 6386 
                      <value type="string" key="name">individual_observation</value>
6387 6387 
                      <value type="string" key="oldName">individual_observation</value>
6388 6388 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
......
6406 6406 
                      <value type="string" key="oldName">code_in_individual</value>
6407 6407 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6408 6408 
                    </value>
6409 
                    <value type="object" struct-name="db.mysql.Column" id="eb778aac-ad01-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
6410 
                      <value type="int" key="autoIncrement">0</value>
6411 
                      <value type="string" key="characterSetName"></value>
6412 
                      <value _ptr_="0xbb27350" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
6413 
                      <value type="string" key="collationName"></value>
6414 
                      <value type="string" key="datatypeExplicitParams"></value>
6415 
                      <value type="string" key="defaultValue"></value>
6416 
                      <value type="int" key="defaultValueIsNull">1</value>
6417 
                      <value _ptr_="0xbb27380" type="list" content-type="string" key="flags"/>
6418 
                      <value type="int" key="isNotNull">0</value>
6419 
                      <value type="int" key="length">767</value>
6420 
                      <value type="int" key="precision">-1</value>
6421 
                      <value type="int" key="scale">-1</value>
6422 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
6423 
                      <value type="string" key="comment"></value>
6424 
                      <value type="string" key="name">collection_event</value>
6425 
                      <value type="string" key="oldName">collection_event</value>
6426 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6427 
                    </value>
6428 6409 
                    <value type="object" struct-name="db.mysql.Column" id="c6730896-a7a0-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
6429 6410 
                      <value type="int" key="autoIncrement">0</value>
6430 6411 
                      <value type="string" key="characterSetName"></value>
......
6690 6671 
                      <value type="string" key="name">fk_specimen_taxon_occurrence1</value>
6691 6672 
                      <value type="string" key="oldName">fk_specimen_taxon_occurrence1</value>
6692 6673 
                    </value>
6693 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="eb778868-ad01-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
6694 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">16537a20-a7a7-11e2-8ba6-080027bcf912</link>
6695 
                      <value _ptr_="0xbb2b248" type="list" content-type="object" content-struct-name="db.Column" key="columns">
6696 
                        <link type="object">eb778aac-ad01-11e2-b309-080027bcf912</link>
6697 
                      </value>
6698 
                      <value type="int" key="deferability">0</value>
6699 
                      <value type="string" key="deleteRule">CASCADE</value>
6700 
                      <link type="object" struct-name="db.Index" key="index">eb77b1da-ad01-11e2-b309-080027bcf912</link>
6701 
                      <value type="int" key="mandatory">1</value>
6702 
                      <value type="int" key="many">1</value>
6703 
                      <value type="int" key="modelOnly">0</value>
6704 
                      <link type="object" struct-name="db.Table" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6705 
                      <value _ptr_="0xbb2b5d0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
6706 
                        <link type="object">16537d54-a7a7-11e2-8ba6-080027bcf912</link>
6707 
                      </value>
6708 
                      <value type="int" key="referencedMandatory">0</value>
6709 
                      <value type="string" key="updateRule">CASCADE</value>
6710 
                      <value type="string" key="comment"></value>
6711 
                      <value type="string" key="name">fk_specimen_taxon_observation1</value>
6712 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1</value>
6713 
                    </value>
6714 6674 
                  </value>
6715 6675 
                  <value _ptr_="0xbb25aa8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
6716 6676 
                    <value type="object" struct-name="db.mysql.Index" id="c6731048-a7a0-11e2-b667-080027bcf912" struct-checksum="0x309b847a">
......
6767 6727 
                      <value type="string" key="oldName">specimen_unique_in_individual</value>
6768 6728 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6769 6729 
                    </value>
6770 
                    <value type="object" struct-name="db.mysql.Index" id="4e241b94-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6771 
                      <value _ptr_="0xbb2c120" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6772 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6bee3326-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
6773 
                          <value type="int" key="columnLength">0</value>
6774 
                          <value type="string" key="comment"></value>
6775 
                          <value type="int" key="descend">0</value>
6776 
                          <link type="object" struct-name="db.Column" key="referencedColumn">eb778aac-ad01-11e2-b309-080027bcf912</link>
6777 
                          <value type="string" key="name"></value>
6778 
                          <link type="object" struct-name="GrtObject" key="owner">4e241b94-ad15-11e2-9617-080027bcf912</link>
6779 
                        </value>
6780 
                      </value>
6781 
                      <value type="string" key="indexKind"></value>
6782 
                      <value type="int" key="keyBlockSize">0</value>
6783 
                      <value type="string" key="withParser"></value>
6784 
                      <value type="string" key="comment"></value>
6785 
                      <value type="int" key="deferability">0</value>
6786 
                      <value type="string" key="indexType">UNIQUE</value>
6787 
                      <value type="int" key="isPrimary">0</value>
6788 
                      <value type="string" key="name">specimen_unique_by_collection_event</value>
6789 
                      <value type="int" key="unique">1</value>
6790 
                      <value type="string" key="oldName">specimen_unique_by_collection_event</value>
6791 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6792 
                    </value>
6793 6730 
                    <value type="object" struct-name="db.mysql.Index" id="7f3654cc-ad15-11e2-9617-080027bcf912" struct-checksum="0x309b847a">
6794 6731 
                      <value _ptr_="0xbb2cb38" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6795 6732 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="9058b178-ad15-11e2-9617-080027bcf912" struct-checksum="0x62630b3c">
......
6875 6812 
                      <value type="string" key="oldName">fk_specimen_collection1_idx</value>
6876 6813 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6877 6814 
                    </value>
6878 
                    <value type="object" struct-name="db.mysql.Index" id="eb77b1da-ad01-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
6879 
                      <value _ptr_="0xbb2e648" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6880 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="eb77b446-ad01-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
6881 
                          <value type="int" key="columnLength">0</value>
6882 
                          <value type="string" key="comment"></value>
6883 
                          <value type="int" key="descend">0</value>
6884 
                          <link type="object" struct-name="db.Column" key="referencedColumn">eb778aac-ad01-11e2-b309-080027bcf912</link>
6885 
                          <value type="string" key="name"></value>
6886 
                          <link type="object" struct-name="GrtObject" key="owner">eb77b1da-ad01-11e2-b309-080027bcf912</link>
6887 
                        </value>
6888 
                      </value>
6889 
                      <value type="string" key="indexKind"></value>
6890 
                      <value type="int" key="keyBlockSize">0</value>
6891 
                      <value type="string" key="withParser"></value>
6892 
                      <value type="string" key="comment"></value>
6893 
                      <value type="int" key="deferability">0</value>
6894 
                      <value type="string" key="indexType">INDEX</value>
6895 
                      <value type="int" key="isPrimary">0</value>
6896 
                      <value type="string" key="name">fk_specimen_taxon_observation1_idx</value>
6897 
                      <value type="int" key="unique">0</value>
6898 
                      <value type="string" key="oldName">fk_specimen_taxon_observation1_idx</value>
6899 
                      <link type="object" struct-name="GrtObject" key="owner">c672f914-a7a0-11e2-b667-080027bcf912</link>
6900 
                    </value>
6901 6815 
                    <value type="object" struct-name="db.mysql.Index" id="c6612660-ad10-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
6902 6816 
                      <value _ptr_="0xbb2f408" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
6903 6817 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="c6615c2a-ad10-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
......
7052 6966 
                  <value type="int" key="commentedOut">0</value>
7053 6967 
                  <value type="string" key="createDate">2013-04-17 13:52</value>
7054 6968 
                  <value _ptr_="0xbb25830" type="dict" key="customData"/>
7055 
                  <value type="string" key="lastChangeDate">2013-09-29 21:59</value>
6969 
                  <value type="string" key="lastChangeDate">2013-09-29 22:16</value>
7056 6970 
                  <value type="int" key="modelOnly">0</value>
7057 6971 
                  <value type="string" key="name">specimen</value>
7058 6972 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
14041 13955 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14042 13956 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14043 13957 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">c6731a52-a7a0-11e2-b667-080027bcf912</link>
14044 
                <value type="real" key="middleSegmentOffset">-6.4537640701352842143023735843598842620849609375e+01</value>
13958 
                <value type="real" key="middleSegmentOffset">-5.9306813544742027488609892316162586212158203125e+01</value>
14045 13959 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14046 13960 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14047 13961 
                <value type="int" key="drawSplit">0</value>
......
14240 14154 
                <value type="int" key="visible">1</value>
14241 14155 
                <value type="string" key="name"></value>
14242 14156 
              </value>
14243 
              <value type="object" struct-name="workbench.physical.Connection" id="eb77bcd4-ad01-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
14244 
                <value type="string" key="caption">fk_specimen_taxon_observation1</value>
14245 
                <value type="real" key="captionXOffs">0.e+00</value>
14246 
                <value type="real" key="captionYOffs">0.e+00</value>
14247 
                <value type="string" key="comment"></value>
14248 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
14249 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
14250 
                <value type="string" key="extraCaption"></value>
14251 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14252 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14253 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">eb778868-ad01-11e2-b309-080027bcf912</link>
14254 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
14255 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14256 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14257 
                <value type="int" key="drawSplit">1</value>
14258 
                <link type="object" struct-name="model.Figure" key="endFigure">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
14259 
                <link type="object" struct-name="model.Figure" key="startFigure">627FF2A4-9311-4DBE-9DB0-1355360AACEA</link>
14260 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
14261 
                <value type="int" key="visible">1</value>
14262 
                <value type="string" key="name"></value>
14263 
              </value>
14264 14157 
              <value type="object" struct-name="workbench.physical.Connection" id="9b6b743c-ad0c-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
14265 14158 
                <value type="string" key="caption">fk_parsed_taxon_assertion_taxon_name1</value>
14266 14159 
                <value type="real" key="captionXOffs">0.e+00</value>
......
16510 16403 
                <value type="int" key="triggersExpanded">0</value>
16511 16404 
                <value type="string" key="color">#CCCC33</value>
16512 16405 
                <value type="int" key="expanded">1</value>
16513 
                <value type="real" key="height">2.84e+02</value>
16406 
                <value type="real" key="height">2.61e+02</value>
16514 16407 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
16515 16408 
                <value type="real" key="left">1.42e+03</value>
16516 16409 
                <value type="int" key="locked">0</value>
16517 16410 
                <value type="int" key="manualSizing">0</value>
16518 
                <value type="real" key="top">3.83e+02</value>
16411 
                <value type="real" key="top">4.23e+02</value>
16519 16412 
                <value type="real" key="width">1.57e+02</value>
16520 16413 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16521 16414 
                <value type="int" key="visible">1</value>
......
16535 16428 
                <value type="real" key="left">1.43e+03</value>
16536 16429 
                <value type="int" key="locked">0</value>
16537 16430 
                <value type="int" key="manualSizing">0</value>
16538 
                <value type="real" key="top">2.43e+02</value>
16431 
                <value type="real" key="top">2.83e+02</value>
16539 16432 
                <value type="real" key="width">1.06e+02</value>
16540 16433 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16541 16434 
                <value type="int" key="visible">1</value>
......
17746 17639 
              <value type="int" key="visible">1</value>
17747 17640 
              <value type="string" key="name"></value>
17748 17641 
            </value>
17749 
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17750 
              <link type="object">D1965EDA-481F-496B-9C24-79553E7891E8</link>
17751 
            </value>
17642 
            <value _ptr_="0xbb8bd18" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17752 17643 
            <value type="int" key="updateBlocked">0</value>
17753 17644 
            <value type="real" key="width">1.6215e+03</value>
17754 17645 
            <value type="real" key="x">0.e+00</value>
......
18395 18286 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18396 18287 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18397 18288 
      <value type="string" key="caption">New Model</value>
18398 
      <value type="string" key="dateChanged">2013-09-29 22:10</value>
18289 
      <value type="string" key="dateChanged">2013-09-29 22:16</value>
18399 18290 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18400 18291 
      <value type="string" key="description"></value>
18401 18292 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
895 895 
/*!40101 SET character_set_client = utf8 */;
896 896 
CREATE TABLE `specimen` (
897 897 
  `id` varbinary(767) NOT NULL,
898 
  `individual_observation` varbinary(767) DEFAULT NULL COMMENT 'the plant the specimen was collected from and any observations about it. the collection_event should be set to this field when provided.',
898 
  `individual_observation` varbinary(767) DEFAULT NULL COMMENT 'the plant the specimen was collected from and any observations about it',
899 899 
  `code_in_individual` varbinary(767) DEFAULT NULL,
900 
  `collection_event` varbinary(767) DEFAULT NULL,
901 900 
  `orig_collection` varbinary(767) DEFAULT NULL,
902 901 
  `barcode` varbinary(767) DEFAULT NULL,
903 902 
  `accession_number` varbinary(767) DEFAULT NULL,
......
906 905 
  `current_collection` varbinary(767) DEFAULT NULL,
907 906 
  `owner_collection` varbinary(767) DEFAULT NULL,
908 907 
  PRIMARY KEY (`id`),
909 
  UNIQUE KEY `specimen_unique_by_collection_event` (`collection_event`),
910 908 
  UNIQUE KEY `specimen_unique_in_collection_by_barcode` (`orig_collection`,`barcode`),
911 909 
  UNIQUE KEY `specimen_unique_in_collection_by_accession_number` (`orig_collection`,`accession_number`),
912 910 
  UNIQUE KEY `specimen_unique_in_individual_observation` (`individual_observation`,`code_in_individual`),
913 911 
  UNIQUE KEY `specimen_unique_in_individual` (`individual_observation`,`code_in_individual`),
914 912 
  KEY `fk_specimen_collection1_idx` (`orig_collection`),
915 
  KEY `fk_specimen_taxon_observation1_idx` (`collection_event`),
916 913 
  KEY `fk_specimen_collection2_idx` (`current_collection`),
917 914 
  KEY `fk_specimen_organization3_idx` (`owner_collection`),
918 915 
  KEY `fk_specimen_party_list1_idx` (`specimenholder_institutions`),
919 916 
  KEY `fk_specimen_individual_observation1_idx` (`individual_observation`),
917 
  CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
920 918 
  CONSTRAINT `fk_specimen_individual_observation1` FOREIGN KEY (`individual_observation`) REFERENCES `individual_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
921 
  CONSTRAINT `fk_specimen_collection1` FOREIGN KEY (`orig_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
919 
  CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
922 920 
  CONSTRAINT `fk_specimen_collection2` FOREIGN KEY (`current_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
923 921 
  CONSTRAINT `fk_specimen_organization3` FOREIGN KEY (`owner_collection`) REFERENCES `collection` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
924 
  CONSTRAINT `fk_specimen_party_list1` FOREIGN KEY (`specimenholder_institutions`) REFERENCES `party_list` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
925 
  CONSTRAINT `fk_specimen_taxon_observation1` FOREIGN KEY (`collection_event`) REFERENCES `taxon_observation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
926 922 
  CONSTRAINT `fk_specimen_taxon_occurrence1` FOREIGN KEY (`id`) REFERENCES `reobservable` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
927 923 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.';
928 924 
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
897 897 
/*!40101 SET character_set_client = utf8 */;
898 898 
CREATE TABLE "specimen" (
899 899 
  "id" text NOT NULL,
900 
  "individual_observation" text DEFAULT NULL /*COMMENT 'the plant the specimen was collected from and any observations about it. the collection_event should be set to this field when provided.'*/,
900 
  "individual_observation" text DEFAULT NULL /*COMMENT 'the plant the specimen was collected from and any observations about it'*/,
901 901 
  "code_in_individual" text DEFAULT NULL,
902 
  "collection_event" text DEFAULT NULL,
903 902 
  "orig_collection" text DEFAULT NULL,
904 903 
  "barcode" text DEFAULT NULL,
905 904 
  "accession_number" text DEFAULT NULL,
......
908 907 
  "current_collection" text DEFAULT NULL,
909 908 
  "owner_collection" text DEFAULT NULL,
910 909 
  PRIMARY KEY ("id"),
911 
  /*CONSTRAINT "specimen_unique_by_collection_event" */UNIQUE ("collection_event"),
912 910 
  /*CONSTRAINT "specimen_unique_in_collection_by_barcode" */UNIQUE ("orig_collection","barcode"),
913 911 
  /*CONSTRAINT "specimen_unique_in_collection_by_accession_number" */UNIQUE ("orig_collection","accession_number"),
914 912 
  /*CONSTRAINT "specimen_unique_in_individual_observation" */UNIQUE ("individual_observation","code_in_individual"),
915 913 
  /*CONSTRAINT "specimen_unique_in_individual" */UNIQUE ("individual_observation","code_in_individual"),
916 914 
  /*KEY "fk_specimen_collection1_idx" ("orig_collection")*/CHECK (true),
917 
  /*KEY "fk_specimen_taxon_observation1_idx" ("collection_event")*/CHECK (true),
918 915 
  /*KEY "fk_specimen_collection2_idx" ("current_collection")*/CHECK (true),
919 916 
  /*KEY "fk_specimen_organization3_idx" ("owner_collection")*/CHECK (true),
920 917 
  /*KEY "fk_specimen_party_list1_idx" ("specimenholder_institutions")*/CHECK (true),
921 918 
  /*KEY "fk_specimen_individual_observation1_idx" ("individual_observation")*/CHECK (true),
919 
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
922 920 
  /*CONSTRAINT "fk_specimen_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
923 
  /*CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
921 
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
924 922 
  /*CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
925 923 
  /*CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
926 
  /*CONSTRAINT "fk_specimen_party_list1" FOREIGN KEY ("specimenholder_institutions") REFERENCES "party_list" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
927 
  /*CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
928 924 
  /*CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "reobservable" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
929 925 
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='something collected from a plant. this can be a physical "part of a plant" ("Wikipedia":http://en.wikipedia.org/wiki/Specimen), or a picture or description of the plant. when there are multiple specimen replicates (copies) of a specimen, each gets its own specimen_observation pointing to the same specimen.'*/;
930 926 
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff