Project

General

Profile

« Previous | Next » 

Revision 11215

schemas/VegCore/ERD/VegCore.ERD.mwb: project: inherit from dataset, since projects generally confer attribution and conditions of use

View differences:

schemas/VegCore/ERD/document.mwb.xml
8103 8103
                      <value type="string" key="oldName">id</value>
8104 8104
                      <link type="object" struct-name="GrtObject" key="owner">be8fa0fa-a6e0-11e2-95e9-080027bcf912</link>
8105 8105
                    </value>
8106
                    <value type="object" struct-name="db.mysql.Column" id="8b8a694e-a792-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
8107
                      <value type="int" key="autoIncrement">0</value>
8108
                      <value type="string" key="characterSetName"></value>
8109
                      <value _ptr_="0xb9ecd00" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
8110
                      <value type="string" key="collationName"></value>
8111
                      <value type="string" key="datatypeExplicitParams"></value>
8112
                      <value type="string" key="defaultValue"></value>
8113
                      <value type="int" key="defaultValueIsNull">0</value>
8114
                      <value _ptr_="0xb9ed060" type="list" content-type="string" key="flags"/>
8115
                      <value type="int" key="isNotNull">1</value>
8116
                      <value type="int" key="length">767</value>
8117
                      <value type="int" key="precision">-1</value>
8118
                      <value type="int" key="scale">-1</value>
8119
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8120
                      <value type="string" key="comment"></value>
8121
                      <value type="string" key="name">name</value>
8122
                      <value type="string" key="oldName">name</value>
8123
                      <link type="object" struct-name="GrtObject" key="owner">be8fa0fa-a6e0-11e2-95e9-080027bcf912</link>
8124
                    </value>
8125 8106
                    <value type="object" struct-name="db.mysql.Column" id="8542fbb8-a793-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
8126 8107
                      <value type="int" key="autoIncrement">0</value>
8127 8108
                      <value type="string" key="characterSetName"></value>
......
8168 8149
                      <value type="string" key="name">fk_project_event1</value>
8169 8150
                      <value type="string" key="oldName">fk_project_event1</value>
8170 8151
                    </value>
8152
                    <value type="object" struct-name="db.mysql.ForeignKey" id="866e037e-313c-11e3-aa43-080027bcf912" struct-checksum="0x70a8fc40">
8153
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8cc04c-a6e0-11e2-95e9-080027bcf912</link>
8154
                      <value _ptr_="0xd0e7e00" type="list" content-type="object" content-struct-name="db.Column" key="columns">
8155
                        <link type="object">be8fa398-a6e0-11e2-95e9-080027bcf912</link>
8156
                      </value>
8157
                      <value type="int" key="deferability">0</value>
8158
                      <value type="string" key="deleteRule">CASCADE</value>
8159
                      <value type="int" key="mandatory">0</value>
8160
                      <value type="int" key="many">0</value>
8161
                      <value type="int" key="modelOnly">0</value>
8162
                      <link type="object" struct-name="db.Table" key="owner">be8fa0fa-a6e0-11e2-95e9-080027bcf912</link>
8163
                      <value _ptr_="0xc908b28" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
8164
                        <link type="object">be8cc362-a6e0-11e2-95e9-080027bcf912</link>
8165
                      </value>
8166
                      <value type="int" key="referencedMandatory">1</value>
8167
                      <value type="string" key="updateRule">CASCADE</value>
8168
                      <value type="string" key="comment"></value>
8169
                      <value type="string" key="name">project_id_fkey1</value>
8170
                      <value type="string" key="oldName">project_id_fkey1</value>
8171
                    </value>
8171 8172
                  </value>
8172 8173
                  <value _ptr_="0xb9ec600" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
8173 8174
                    <value type="object" struct-name="db.mysql.Index" id="be8fa58c-a6e0-11e2-95e9-080027bcf912" struct-checksum="0x309b847a">
......
14214 14215
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14215 14216
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14216 14217
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">9d6cb042-f678-11e2-9716-080027bcf912</link>
14217
                <value type="real" key="middleSegmentOffset">0.e+00</value>
14218
                <value type="real" key="middleSegmentOffset">8.46374065926767116252449341118335723876953125e-01</value>
14218 14219
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14219 14220
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14220 14221
                <value type="int" key="drawSplit">0</value>
......
15516 15517
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15517 15518
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15518 15519
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d7177350-298a-11e3-a80d-080027bcf912</link>
15519
                <value type="real" key="middleSegmentOffset">4.6730585070045208340161480009555816650390625e+01</value>
15520
                <value type="real" key="middleSegmentOffset">5.788471094955821172334253787994384765625e+01</value>
15520 15521
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15521 15522
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15522 15523
                <value type="int" key="drawSplit">0</value>
......
15862 15863
                <value type="int" key="visible">1</value>
15863 15864
                <value type="string" key="name"></value>
15864 15865
              </value>
15866
              <value type="object" struct-name="workbench.physical.Connection" id="866e55a4-313c-11e3-aa43-080027bcf912" struct-checksum="0x9baebc92">
15867
                <value type="string" key="caption">project_id_fkey1</value>
15868
                <value type="real" key="captionXOffs">0.e+00</value>
15869
                <value type="real" key="captionYOffs">0.e+00</value>
15870
                <value type="string" key="comment"></value>
15871
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15872
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15873
                <value type="string" key="extraCaption"></value>
15874
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15875
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15876
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">866e037e-313c-11e3-aa43-080027bcf912</link>
15877
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15878
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15879
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15880
                <value type="int" key="drawSplit">1</value>
15881
                <link type="object" struct-name="model.Figure" key="endFigure">39C6F66E-A650-49AE-8EDD-9D8A567EFBEA</link>
15882
                <link type="object" struct-name="model.Figure" key="startFigure">6B49544F-8630-4930-B54B-2CD6F6C0C631</link>
15883
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15884
                <value type="int" key="visible">1</value>
15885
                <value type="string" key="name"></value>
15886
              </value>
15865 15887
            </value>
15866 15888
            <value type="string" key="description"></value>
15867 15889
            <value _ptr_="0xba36450" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15951 15973
                <value type="int" key="expanded">1</value>
15952 15974
                <value type="real" key="height">1.69e+02</value>
15953 15975
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15954
                <value type="real" key="left">5.57e+02</value>
15976
                <value type="real" key="left">5.59e+02</value>
15955 15977
                <value type="int" key="locked">0</value>
15956 15978
                <value type="int" key="manualSizing">0</value>
15957 15979
                <value type="real" key="top">4.4e+02</value>
......
15989 16011
                <value type="int" key="triggersExpanded">0</value>
15990 16012
                <value type="string" key="color">#66ffff</value>
15991 16013
                <value type="int" key="expanded">1</value>
15992
                <value type="real" key="height">1.e+02</value>
16014
                <value type="real" key="height">7.7e+01</value>
15993 16015
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15994
                <value type="real" key="left">4.89e+02</value>
16016
                <value type="real" key="left">5.01e+02</value>
15995 16017
                <value type="int" key="locked">0</value>
15996 16018
                <value type="int" key="manualSizing">0</value>
15997
                <value type="real" key="top">6.35e+02</value>
16019
                <value type="real" key="top">6.34e+02</value>
15998 16020
                <value type="real" key="width">9.e+01</value>
15999 16021
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16000 16022
                <value type="int" key="visible">1</value>
......
17372 17394
                <value type="int" key="expanded">1</value>
17373 17395
                <value type="real" key="height">1.23e+02</value>
17374 17396
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17375
                <value type="real" key="left">1.82e+02</value>
17397
                <value type="real" key="left">1.86e+02</value>
17376 17398
                <value type="int" key="locked">0</value>
17377 17399
                <value type="int" key="manualSizing">0</value>
17378
                <value type="real" key="top">6.98e+02</value>
17400
                <value type="real" key="top">6.97e+02</value>
17379 17401
                <value type="real" key="width">1.12e+02</value>
17380 17402
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17381 17403
                <value type="int" key="visible">1</value>
......
17583 17605
              <value type="int" key="visible">1</value>
17584 17606
              <value type="string" key="name"></value>
17585 17607
            </value>
17586
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17587
              <link type="object">FF3A48D7-490E-4E77-B97B-1F51BF51FA8A</link>
17588
            </value>
17608
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
17589 17609
            <value type="int" key="updateBlocked">0</value>
17590 17610
            <value type="real" key="width">1.6215e+03</value>
17591 17611
            <value type="real" key="x">0.e+00</value>
......
17598 17618
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17599 17619
        <value _ptr_="0xb986d58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17600 17620
        <value _ptr_="0xb1a9c10" type="dict" key="syncProfiles">
17601
          <value type="object" struct-name="db.mgmt.SyncProfile" id="708e152e-3139-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17602
            <value _ptr_="0xcb8ffa0" type="dict" key="lastKnownDBNames">
17621
          <value type="object" struct-name="db.mgmt.SyncProfile" id="f2b17a32-3139-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17622
            <value _ptr_="0xc682418" type="dict" key="lastKnownDBNames">
17603 17623
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17604 17624
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17605 17625
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
18230 18250
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18231 18251
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18232 18252
      <value type="string" key="caption">New Model</value>
18233
      <value type="string" key="dateChanged">2013-10-09 16:24</value>
18253
      <value type="string" key="dateChanged">2013-10-09 16:45</value>
18234 18254
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18235 18255
      <value type="string" key="description"></value>
18236 18256
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
710 710
/*!40101 SET character_set_client = utf8 */;
711 711
CREATE TABLE `project` (
712 712
  `id` varbinary(767) NOT NULL,
713
  `name` varbinary(767) NOT NULL,
714 713
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
715 714
  PRIMARY KEY (`id`),
715
  CONSTRAINT `project_id_fkey1` FOREIGN KEY (`id`) REFERENCES `dataset` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
716 716
  CONSTRAINT `fk_project_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
717 717
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A "project established to collect vegetation plot data. Each plot originates as part of a project." ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=project&entity=dba_tabledescription&where=where_tablename)';
718 718
/*!40101 SET character_set_client = @saved_cs_client */;
schemas/VegCore/VegCore.pg.sql
712 712
/*!40101 SET character_set_client = utf8 */;
713 713
CREATE TABLE "project" (
714 714
  "id" text NOT NULL,
715
  "name" text NOT NULL,
716 715
  "info" hstore DEFAULT NULL,
717 716
  PRIMARY KEY ("id"),
717
  /*CONSTRAINT "project_id_fkey1" FOREIGN KEY ("id") REFERENCES "dataset" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),
718 718
  /*CONSTRAINT "fk_project_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)
719 719
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A "project established to collect vegetation plot data. Each plot originates as part of a project." ("VegBank":http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=project&entity=dba_tabledescription&where=where_tablename)'*/;
720 720
/*!40101 SET character_set_client = @saved_cs_client */;

Also available in: Unified diff