Project

General

Profile

« Previous | Next » 

Revision 8677

schemas/VegCore/VegCore.ERD.mwb: collection: added institution, name to identify and scope the collection

View differences:

schemas/VegCore/document.mwb.xml
788 788
                      <value type="string" key="oldName">id</value>
789 789
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
790 790
                    </value>
791
                    <value type="object" struct-name="db.mysql.Column" id="ed1eb468-ad0e-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
792
                      <value type="int" key="autoIncrement">0</value>
793
                      <value type="string" key="characterSetName"></value>
794
                      <value _ptr_="0xbd77d10" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
795
                      <value type="string" key="collationName"></value>
796
                      <value type="string" key="datatypeExplicitParams"></value>
797
                      <value type="string" key="defaultValue"></value>
798
                      <value type="int" key="defaultValueIsNull">0</value>
799
                      <value _ptr_="0xbd77d98" type="list" content-type="string" key="flags"/>
800
                      <value type="int" key="isNotNull">1</value>
801
                      <value type="int" key="length">767</value>
802
                      <value type="int" key="precision">-1</value>
803
                      <value type="int" key="scale">-1</value>
804
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
805
                      <value type="string" key="comment"></value>
806
                      <value type="string" key="name">institution</value>
807
                      <value type="string" key="oldName">organization_id</value>
808
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
809
                    </value>
810
                    <value type="object" struct-name="db.mysql.Column" id="45a3f404-ad0f-11e2-b309-080027bcf912" struct-checksum="0x783b5183">
811
                      <value type="int" key="autoIncrement">0</value>
812
                      <value type="string" key="characterSetName"></value>
813
                      <value _ptr_="0xc230190" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
814
                      <value type="string" key="collationName"></value>
815
                      <value type="string" key="datatypeExplicitParams"></value>
816
                      <value type="string" key="defaultValue"></value>
817
                      <value type="int" key="defaultValueIsNull">0</value>
818
                      <value _ptr_="0xbcafc60" type="list" content-type="string" key="flags"/>
819
                      <value type="int" key="isNotNull">1</value>
820
                      <value type="int" key="length">767</value>
821
                      <value type="int" key="precision">-1</value>
822
                      <value type="int" key="scale">-1</value>
823
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
824
                      <value type="string" key="comment"></value>
825
                      <value type="string" key="name">name</value>
826
                      <value type="string" key="oldName"></value>
827
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
828
                    </value>
791 829
                  </value>
792 830
                  <value type="string" key="connectionString"></value>
793 831
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
815 853
                      <value type="string" key="name">fk_collection_source1</value>
816 854
                      <value type="string" key="oldName">fk_collection_source1</value>
817 855
                    </value>
856
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ed1eb2a6-ad0e-11e2-b309-080027bcf912" struct-checksum="0x70a8fc40">
857
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">049df920-a91b-11e2-bdec-080027bcf912</link>
858
                      <value _ptr_="0xbf39440" type="list" content-type="object" content-struct-name="db.Column" key="columns">
859
                        <link type="object">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
860
                      </value>
861
                      <value type="int" key="deferability">0</value>
862
                      <value type="string" key="deleteRule">CASCADE</value>
863
                      <link type="object" struct-name="db.Index" key="index">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
864
                      <value type="int" key="mandatory">1</value>
865
                      <value type="int" key="many">1</value>
866
                      <value type="int" key="modelOnly">0</value>
867
                      <link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
868
                      <value _ptr_="0xbe6a288" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
869
                        <link type="object">049dfc5e-a91b-11e2-bdec-080027bcf912</link>
870
                      </value>
871
                      <value type="int" key="referencedMandatory">1</value>
872
                      <value type="string" key="updateRule">CASCADE</value>
873
                      <value type="string" key="comment"></value>
874
                      <value type="string" key="name">fk_collection_organization1</value>
875
                      <value type="string" key="oldName">fk_collection_organization1</value>
876
                    </value>
818 877
                  </value>
819 878
                  <value _ptr_="0xa70f460" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
820 879
                    <value type="object" struct-name="db.mysql.Index" id="be8dfdd6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
840 899
                      <value type="string" key="oldName">PRIMARY</value>
841 900
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
842 901
                    </value>
902
                    <value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
903
                      <value _ptr_="0xb20a1b0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
904
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
905
                          <value type="int" key="columnLength">0</value>
906
                          <value type="string" key="comment"></value>
907
                          <value type="int" key="descend">0</value>
908
                          <link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
909
                          <value type="string" key="name"></value>
910
                          <link type="object" struct-name="GrtObject" key="owner">ed1ec98a-ad0e-11e2-b309-080027bcf912</link>
911
                        </value>
912
                      </value>
913
                      <value type="string" key="indexKind"></value>
914
                      <value type="int" key="keyBlockSize">0</value>
915
                      <value type="string" key="withParser"></value>
916
                      <value type="string" key="comment"></value>
917
                      <value type="int" key="deferability">0</value>
918
                      <value type="string" key="indexType">INDEX</value>
919
                      <value type="int" key="isPrimary">0</value>
920
                      <value type="string" key="name">fk_collection_organization1_idx</value>
921
                      <value type="int" key="unique">0</value>
922
                      <value type="string" key="oldName">fk_collection_organization1</value>
923
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
924
                    </value>
925
                    <value type="object" struct-name="db.mysql.Index" id="6b54505e-ad0f-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
926
                      <value _ptr_="0xbec0eb8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
927
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6dd2beb0-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
928
                          <value type="int" key="columnLength">0</value>
929
                          <value type="string" key="comment"></value>
930
                          <value type="int" key="descend">0</value>
931
                          <link type="object" struct-name="db.Column" key="referencedColumn">ed1eb468-ad0e-11e2-b309-080027bcf912</link>
932
                          <value type="string" key="name"></value>
933
                          <link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
934
                        </value>
935
                        <value type="object" struct-name="db.mysql.IndexColumn" id="6e294b90-ad0f-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
936
                          <value type="int" key="columnLength">0</value>
937
                          <value type="string" key="comment"></value>
938
                          <value type="int" key="descend">0</value>
939
                          <link type="object" struct-name="db.Column" key="referencedColumn">45a3f404-ad0f-11e2-b309-080027bcf912</link>
940
                          <value type="string" key="name"></value>
941
                          <link type="object" struct-name="GrtObject" key="owner">6b54505e-ad0f-11e2-b309-080027bcf912</link>
942
                        </value>
943
                      </value>
944
                      <value type="string" key="indexKind"></value>
945
                      <value type="int" key="keyBlockSize">0</value>
946
                      <value type="string" key="withParser"></value>
947
                      <value type="string" key="comment"></value>
948
                      <value type="int" key="deferability">0</value>
949
                      <value type="string" key="indexType">UNIQUE</value>
950
                      <value type="int" key="isPrimary">0</value>
951
                      <value type="string" key="name">collection_unique</value>
952
                      <value type="int" key="unique">1</value>
953
                      <value type="string" key="oldName"></value>
954
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
955
                    </value>
843 956
                  </value>
844 957
                  <value type="string" key="maxRows"></value>
845 958
                  <value type="string" key="mergeInsert"></value>
......
871 984
                  <value type="int" key="commentedOut">0</value>
872 985
                  <value type="string" key="createDate">2013-04-16 14:58</value>
873 986
                  <value _ptr_="0xa2107d0" type="dict" key="customData"/>
874
                  <value type="string" key="lastChangeDate">2013-04-19 09:16</value>
987
                  <value type="string" key="lastChangeDate">2013-04-24 11:47</value>
875 988
                  <value type="int" key="modelOnly">0</value>
876 989
                  <value type="string" key="name">collection</value>
877 990
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
1712 1825
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1713 1826
                      <value type="string" key="comment"></value>
1714 1827
                      <value type="string" key="name">matched_taxon_concept</value>
1715
                      <value type="string" key="oldName">matched_taxon</value>
1828
                      <value type="string" key="oldName">matched_taxon_concept</value>
1716 1829
                      <link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1717 1830
                    </value>
1718 1831
                    <value type="object" struct-name="db.mysql.Column" id="4c32a89c-a76a-11e2-92a3-080027bcf912" struct-checksum="0x783b5183">
......
1846 1959
                      <value type="int" key="isPrimary">0</value>
1847 1960
                      <value type="string" key="name">fk_parsed_taxon_assertion_taxon_name1_idx</value>
1848 1961
                      <value type="int" key="unique">0</value>
1849
                      <value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1</value>
1962
                      <value type="string" key="oldName">fk_parsed_taxon_assertion_taxon_name1_idx</value>
1850 1963
                      <link type="object" struct-name="GrtObject" key="owner">be8fb202-a6e0-11e2-95e9-080027bcf912</link>
1851 1964
                    </value>
1852 1965
                  </value>
......
1927 2040
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1928 2041
                      <value type="string" key="comment"></value>
1929 2042
                      <value type="string" key="name">taxon_concept</value>
1930
                      <value type="string" key="oldName">taxon</value>
2043
                      <value type="string" key="oldName">taxon_concept</value>
1931 2044
                      <link type="object" struct-name="GrtObject" key="owner">be8e9930-a6e0-11e2-95e9-080027bcf912</link>
1932 2045
                    </value>
1933 2046
                  </value>
......
2104 2217
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2105 2218
                      <value type="string" key="comment"></value>
2106 2219
                      <value type="string" key="name">taxon_concept</value>
2107
                      <value type="string" key="oldName">taxon</value>
2220
                      <value type="string" key="oldName">taxon_concept</value>
2108 2221
                      <link type="object" struct-name="GrtObject" key="owner">be8ea786-a6e0-11e2-95e9-080027bcf912</link>
2109 2222
                    </value>
2110 2223
                  </value>
......
2318 2431
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
2319 2432
                      <value type="string" key="comment"></value>
2320 2433
                      <value type="string" key="name">accepted_taxon_concept</value>
2321
                      <value type="string" key="oldName">accepted_taxon</value>
2434
                      <value type="string" key="oldName">accepted_taxon_concept</value>
2322 2435
                      <link type="object" struct-name="GrtObject" key="owner">1832712c-a77d-11e2-afd5-080027bcf912</link>
2323 2436
                    </value>
2324 2437
                  </value>
......
11553 11666
                <value type="int" key="visible">1</value>
11554 11667
                <value type="string" key="name"></value>
11555 11668
              </value>
11669
              <value type="object" struct-name="workbench.physical.Connection" id="ed1ed15a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11670
                <value type="string" key="caption">fk_collection_organization1</value>
11671
                <value type="real" key="captionXOffs">0.e+00</value>
11672
                <value type="real" key="captionYOffs">0.e+00</value>
11673
                <value type="string" key="comment"></value>
11674
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11675
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11676
                <value type="string" key="extraCaption"></value>
11677
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11678
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11679
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">ed1eb2a6-ad0e-11e2-b309-080027bcf912</link>
11680
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11681
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11682
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11683
                <value type="int" key="drawSplit">1</value>
11684
                <link type="object" struct-name="model.Figure" key="endFigure">049e0d16-a91b-11e2-bdec-080027bcf912</link>
11685
                <link type="object" struct-name="model.Figure" key="startFigure">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
11686
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11687
                <value type="int" key="visible">1</value>
11688
                <value type="string" key="name"></value>
11689
              </value>
11556 11690
            </value>
11557 11691
            <value type="string" key="description"></value>
11558 11692
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12100 12234
                <value type="int" key="triggersExpanded">0</value>
12101 12235
                <value type="string" key="color">#CCCC33</value>
12102 12236
                <value type="int" key="expanded">1</value>
12103
                <value type="real" key="height">5.4e+01</value>
12237
                <value type="real" key="height">1.e+02</value>
12104 12238
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12105 12239
                <value type="real" key="left">1.277e+03</value>
12106 12240
                <value type="int" key="locked">0</value>
12107 12241
                <value type="int" key="manualSizing">0</value>
12108
                <value type="real" key="top">6.35e+02</value>
12242
                <value type="real" key="top">5.9e+02</value>
12109 12243
                <value type="real" key="width">1.06e+02</value>
12110 12244
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12111 12245
                <value type="int" key="visible">1</value>
......
12899 13033
              <value type="int" key="visible">1</value>
12900 13034
              <value type="string" key="name"></value>
12901 13035
            </value>
12902
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12903
              <link type="object">71dceeac-a780-11e2-afd5-080027bcf912</link>
12904
              <link type="object">71daccd0-a780-11e2-afd5-080027bcf912</link>
12905
            </value>
13036
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
12906 13037
            <value type="int" key="updateBlocked">0</value>
12907 13038
            <value type="real" key="width">1.6215e+03</value>
12908 13039
            <value type="real" key="x">0.e+00</value>
......
12997 13128
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
12998 13129
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
12999 13130
      <value type="string" key="caption">New Model</value>
13000
      <value type="string" key="dateChanged">2013-04-24 11:34</value>
13131
      <value type="string" key="dateChanged">2013-04-24 11:48</value>
13001 13132
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13002 13133
      <value type="string" key="description"></value>
13003 13134
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
118 118

  
119 119

  
120 120
-- -----------------------------------------------------
121
-- Table `organization`
122
-- -----------------------------------------------------
123
DROP TABLE IF EXISTS `organization` ;
124

  
125
CREATE  TABLE IF NOT EXISTS `organization` (
126
  `id` VARBINARY(767) NOT NULL ,
127
  `info` SET('hstore') NULL ,
128
  PRIMARY KEY (`id`) ,
129
  CONSTRAINT `fk_organization_party1`
130
    FOREIGN KEY (`id` )
131
    REFERENCES `party` (`id` )
132
    ON DELETE CASCADE
133
    ON UPDATE CASCADE)
134
ENGINE = InnoDB
135
DEFAULT CHARACTER SET = utf8
136
COLLATE = utf8_bin;
137

  
138

  
139
-- -----------------------------------------------------
121 140
-- Table `collection`
122 141
-- -----------------------------------------------------
123 142
DROP TABLE IF EXISTS `collection` ;
124 143

  
125 144
CREATE  TABLE IF NOT EXISTS `collection` (
126 145
  `id` VARBINARY(767) NOT NULL ,
146
  `institution` VARBINARY(767) NOT NULL ,
147
  `name` VARBINARY(767) NOT NULL ,
127 148
  PRIMARY KEY (`id`) ,
149
  INDEX `fk_collection_organization1_idx` (`institution` ASC) ,
150
  UNIQUE INDEX `collection_unique` (`institution` ASC, `name` ASC) ,
128 151
  CONSTRAINT `fk_collection_source1`
129 152
    FOREIGN KEY (`id` )
130 153
    REFERENCES `source` (`id` )
131 154
    ON DELETE CASCADE
155
    ON UPDATE CASCADE,
156
  CONSTRAINT `fk_collection_organization1`
157
    FOREIGN KEY (`institution` )
158
    REFERENCES `organization` (`id` )
159
    ON DELETE CASCADE
132 160
    ON UPDATE CASCADE)
133 161
ENGINE = InnoDB
134 162
DEFAULT CHARACTER SET = utf8
......
428 456

  
429 457

  
430 458
-- -----------------------------------------------------
431
-- Table `organization`
432
-- -----------------------------------------------------
433
DROP TABLE IF EXISTS `organization` ;
434

  
435
CREATE  TABLE IF NOT EXISTS `organization` (
436
  `id` VARBINARY(767) NOT NULL ,
437
  `info` SET('hstore') NULL ,
438
  PRIMARY KEY (`id`) ,
439
  CONSTRAINT `fk_organization_party1`
440
    FOREIGN KEY (`id` )
441
    REFERENCES `party` (`id` )
442
    ON DELETE CASCADE
443
    ON UPDATE CASCADE)
444
ENGINE = InnoDB
445
DEFAULT CHARACTER SET = utf8
446
COLLATE = utf8_bin;
447

  
448

  
449
-- -----------------------------------------------------
450 459
-- Table `specimen`
451 460
-- -----------------------------------------------------
452 461
DROP TABLE IF EXISTS `specimen` ;

Also available in: Unified diff