Project

General

Profile

« Previous | Next » 

Revision 8680

schemas/VegCore/VegCore.ERD.mwb: collection: don't inherit from source, because a collection is a scoping entity, not a dataset. a collection may also be used as a dataset, but need not be for the purposes of scoping a specimen's accession_number.

View differences:

schemas/VegCore/document.mwb.xml
833 833
                  <value type="int" key="delayKeyWrite">0</value>
834 834
                  <value _ptr_="0xa70f430" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
835 835
                    <value type="object" struct-name="db.mysql.ForeignKey" id="be8e0240-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x70a8fc40">
836
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
836
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cd56e-a6e0-11e2-95e9-080027bcf912</link>
837 837
                      <value _ptr_="0xa70fb30" type="list" content-type="object" content-struct-name="db.Column" key="columns">
838 838
                        <link type="object">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
839 839
                      </value>
840 840
                      <value type="int" key="deferability">0</value>
841 841
                      <value type="string" key="deleteRule">CASCADE</value>
842
                      <link type="object" struct-name="db.Index" key="index">be8dfdd6-a6e0-11e2-95e9-080027bcf912</link>
842
                      <link type="object" struct-name="db.Index" key="index">81937b1c-ad12-11e2-b309-080027bcf912</link>
843 843
                      <value type="int" key="mandatory">0</value>
844 844
                      <value type="int" key="many">0</value>
845 845
                      <value type="int" key="modelOnly">0</value>
846 846
                      <link type="object" struct-name="db.Table" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
847 847
                      <value _ptr_="0xa70fe20" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
848
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
848
                        <link type="object">be8cd7b2-a6e0-11e2-95e9-080027bcf912</link>
849 849
                      </value>
850 850
                      <value type="int" key="referencedMandatory">1</value>
851 851
                      <value type="string" key="updateRule">CASCADE</value>
......
876 876
                    </value>
877 877
                  </value>
878 878
                  <value _ptr_="0xa70f460" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
879
                    <value type="object" struct-name="db.mysql.Index" id="be8dfdd6-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
880
                      <value _ptr_="0xa70fe90" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
881
                        <value type="object" struct-name="db.mysql.IndexColumn" id="be8dffde-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x62630b3c">
882
                          <value type="int" key="columnLength">0</value>
883
                          <value type="string" key="comment"></value>
884
                          <value type="int" key="descend">0</value>
885
                          <link type="object" struct-name="db.Column" key="referencedColumn">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
886
                          <value type="string" key="name"></value>
887
                          <link type="object" struct-name="GrtObject" key="owner">be8dfdd6-a6e0-11e2-95e9-080027bcf912</link>
888
                        </value>
889
                      </value>
890
                      <value type="string" key="indexKind"></value>
891
                      <value type="int" key="keyBlockSize">0</value>
892
                      <value type="string" key="withParser"></value>
893
                      <value type="string" key="comment"></value>
894
                      <value type="int" key="deferability">0</value>
895
                      <value type="string" key="indexType">PRIMARY</value>
896
                      <value type="int" key="isPrimary">1</value>
897
                      <value type="string" key="name">PRIMARY</value>
898
                      <value type="int" key="unique">0</value>
899
                      <value type="string" key="oldName">PRIMARY</value>
900
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
901
                    </value>
902 879
                    <value type="object" struct-name="db.mysql.Index" id="ed1ec98a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
903 880
                      <value _ptr_="0xb20a1b0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
904 881
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ed1ecb1a-ad0e-11e2-b309-080027bcf912" struct-checksum="0x62630b3c">
......
953 930
                      <value type="string" key="oldName">collection_unique</value>
954 931
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
955 932
                    </value>
933
                    <value type="object" struct-name="db.mysql.Index" id="81937b1c-ad12-11e2-b309-080027bcf912" struct-checksum="0x309b847a">
934
                      <value _ptr_="0xbe4f7a0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
935
                        <value type="object" struct-name="db.mysql.IndexColumn" id="8194729c-ad12-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">be8dfbf6-a6e0-11e2-95e9-080027bcf912</link>
940
                          <value type="string" key="name"></value>
941
                          <link type="object" struct-name="GrtObject" key="owner">81937b1c-ad12-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">INDEX</value>
950
                      <value type="int" key="isPrimary">0</value>
951
                      <value type="string" key="name">fk_collection_source1_idx</value>
952
                      <value type="int" key="unique">0</value>
953
                      <value type="string" key="oldName">fk_collection_source1</value>
954
                      <link type="object" struct-name="GrtObject" key="owner">be8df962-a6e0-11e2-95e9-080027bcf912</link>
955
                    </value>
956 956
                  </value>
957 957
                  <value type="string" key="maxRows"></value>
958 958
                  <value type="string" key="mergeInsert"></value>
......
984 984
                  <value type="int" key="commentedOut">0</value>
985 985
                  <value type="string" key="createDate">2013-04-16 14:58</value>
986 986
                  <value _ptr_="0xa2107d0" type="dict" key="customData"/>
987
                  <value type="string" key="lastChangeDate">2013-04-24 11:47</value>
987
                  <value type="string" key="lastChangeDate">2013-04-24 12:09</value>
988 988
                  <value type="int" key="modelOnly">0</value>
989 989
                  <value type="string" key="name">collection</value>
990 990
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
9923 9923
                <value type="int" key="visible">1</value>
9924 9924
                <value type="string" key="name"></value>
9925 9925
              </value>
9926
              <value type="object" struct-name="workbench.physical.Connection" id="c17ec78c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x9baebc92">
9927
                <value type="string" key="caption">fk_collection_source1</value>
9928
                <value type="real" key="captionXOffs">0.e+00</value>
9929
                <value type="real" key="captionYOffs">0.e+00</value>
9930
                <value type="string" key="comment"></value>
9931
                <value type="real" key="endCaptionXOffs">0.e+00</value>
9932
                <value type="real" key="endCaptionYOffs">0.e+00</value>
9933
                <value type="string" key="extraCaption"></value>
9934
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
9935
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
9936
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e0240-a6e0-11e2-95e9-080027bcf912</link>
9937
                <value type="real" key="middleSegmentOffset">0.e+00</value>
9938
                <value type="real" key="startCaptionXOffs">0.e+00</value>
9939
                <value type="real" key="startCaptionYOffs">0.e+00</value>
9940
                <value type="int" key="drawSplit">1</value>
9941
                <link type="object" struct-name="model.Figure" key="endFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
9942
                <link type="object" struct-name="model.Figure" key="startFigure">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
9943
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
9944
                <value type="int" key="visible">1</value>
9945
                <value type="string" key="name"></value>
9946
              </value>
9947 9926
              <value type="object" struct-name="workbench.physical.Connection" id="c17f391a-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x9baebc92">
9948 9927
                <value type="string" key="caption">fk_relationship_record1</value>
9949 9928
                <value type="real" key="captionXOffs">0.e+00</value>
......
11603 11582
                <value type="int" key="visible">1</value>
11604 11583
                <value type="string" key="name"></value>
11605 11584
              </value>
11585
              <value type="object" struct-name="workbench.physical.Connection" id="819370d6-ad12-11e2-b309-080027bcf912" struct-checksum="0x9baebc92">
11586
                <value type="string" key="caption">fk_collection_source1</value>
11587
                <value type="real" key="captionXOffs">0.e+00</value>
11588
                <value type="real" key="captionYOffs">0.e+00</value>
11589
                <value type="string" key="comment"></value>
11590
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11591
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11592
                <value type="string" key="extraCaption"></value>
11593
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11594
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11595
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">be8e0240-a6e0-11e2-95e9-080027bcf912</link>
11596
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11597
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11598
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11599
                <value type="int" key="drawSplit">1</value>
11600
                <link type="object" struct-name="model.Figure" key="endFigure">5600079C-23BA-4A27-BDB6-87D19B80AF56</link>
11601
                <link type="object" struct-name="model.Figure" key="startFigure">CC059D8C-291E-4748-A685-7668D0CFA36C</link>
11602
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11603
                <value type="int" key="visible">1</value>
11604
                <value type="string" key="name"></value>
11605
              </value>
11606 11606
            </value>
11607 11607
            <value type="string" key="description"></value>
11608 11608
            <value _ptr_="0xa781890" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12949 12949
              <value type="int" key="visible">1</value>
12950 12950
              <value type="string" key="name"></value>
12951 12951
            </value>
12952
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection">
12953
              <link type="object">793D3016-8986-43EC-A4BD-1926D93F12C5</link>
12954
            </value>
12952
            <value _ptr_="0xa781968" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
12955 12953
            <value type="int" key="updateBlocked">0</value>
12956 12954
            <value type="real" key="width">1.6215e+03</value>
12957 12955
            <value type="real" key="x">0.e+00</value>
......
13046 13044
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
13047 13045
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
13048 13046
      <value type="string" key="caption">New Model</value>
13049
      <value type="string" key="dateChanged">2013-04-24 12:03</value>
13047
      <value type="string" key="dateChanged">2013-04-24 12:09</value>
13050 13048
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
13051 13049
      <value type="string" key="description"></value>
13052 13050
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
145 145
  `id` VARBINARY(767) NOT NULL ,
146 146
  `institution` VARBINARY(767) NOT NULL ,
147 147
  `name` VARBINARY(767) NOT NULL ,
148
  PRIMARY KEY (`id`) ,
149 148
  INDEX `fk_collection_organization1_idx` (`institution` ASC) ,
150 149
  UNIQUE INDEX `collection_unique` (`institution` ASC, `name` ASC) ,
150
  INDEX `fk_collection_source1_idx` (`id` ASC) ,
151 151
  CONSTRAINT `fk_collection_source1`
152 152
    FOREIGN KEY (`id` )
153
    REFERENCES `source` (`id` )
153
    REFERENCES `record` (`id` )
154 154
    ON DELETE CASCADE
155 155
    ON UPDATE CASCADE,
156 156
  CONSTRAINT `fk_collection_organization1`

Also available in: Unified diff