Project

General

Profile

« Previous | Next » 

Revision 8680

Added by Aaron Marcuse-Kubitza over 11 years ago

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