Project

General

Profile

« Previous | Next » 

Revision 11130

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: aggregate_observation.sampling_event: merged with inherited sampling_event field

View differences:

schemas/VegCore/ERD/document.mwb.xml
11992 11992 
                      <value type="string" key="oldName">id</value>
11993 11993 
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
11994 11994 
                    </value>
11995 
                    <value type="object" struct-name="db.mysql.Column" id="ab56bc12-1ddc-11e3-bd5f-080027bcf912" struct-checksum="0x783b5183">
11996 
                      <value type="int" key="autoIncrement">0</value>
11997 
                      <value type="string" key="characterSetName"></value>
11998 
                      <value _ptr_="0xa9b6e68" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
11999 
                      <value type="string" key="collationName"></value>
12000 
                      <value type="string" key="datatypeExplicitParams"></value>
12001 
                      <value type="string" key="defaultValue"></value>
12002 
                      <value type="int" key="defaultValueIsNull">0</value>
12003 
                      <value _ptr_="0xa9b71c8" type="list" content-type="string" key="flags"/>
12004 
                      <value type="int" key="isNotNull">1</value>
12005 
                      <value type="int" key="length">767</value>
12006 
                      <value type="int" key="precision">-1</value>
12007 
                      <value type="int" key="scale">-1</value>
12008 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12009 
                      <value type="string" key="comment"></value>
12010 
                      <value type="string" key="name">sampling_event</value>
12011 
                      <value type="string" key="oldName">sampling_event</value>
12012 
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12013 
                    </value>
12014 11995 
                    <value type="object" struct-name="db.mysql.Column" id="f1572d5c-011f-11e3-9f3a-080027bcf912" struct-checksum="0x783b5183">
12015 11996 
                      <value type="int" key="autoIncrement">0</value>
12016 11997 
                      <value type="string" key="characterSetName"></value>
......
12056 12037 
                      <value type="string" key="name">fk_taxon_presence_taxon_determination10</value>
12057 12038 
                      <value type="string" key="oldName">fk_taxon_presence_taxon_determination10</value>
12058 12039 
                    </value>
12059 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="ab56b99c-1ddc-11e3-bd5f-080027bcf912" struct-checksum="0x70a8fc40">
12060 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">7f176964-f6c0-11e2-af44-080027bcf912</link>
12061 
                      <value _ptr_="0xa9b7be8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12062 
                        <link type="object">ab56bc12-1ddc-11e3-bd5f-080027bcf912</link>
12063 
                      </value>
12064 
                      <value type="int" key="deferability">0</value>
12065 
                      <value type="string" key="deleteRule">CASCADE</value>
12066 
                      <link type="object" struct-name="db.Index" key="index">ab56d2f6-1ddc-11e3-bd5f-080027bcf912</link>
12067 
                      <value type="int" key="mandatory">1</value>
12068 
                      <value type="int" key="many">1</value>
12069 
                      <value type="int" key="modelOnly">0</value>
12070 
                      <link type="object" struct-name="db.Table" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12071 
                      <value _ptr_="0xa9b7f70" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12072 
                        <link type="object">7f176d06-f6c0-11e2-af44-080027bcf912</link>
12073 
                      </value>
12074 
                      <value type="int" key="referencedMandatory">1</value>
12075 
                      <value type="string" key="updateRule">CASCADE</value>
12076 
                      <value type="string" key="comment"></value>
12077 
                      <value type="string" key="name">fk_aggregate_observation_taxa_sampling_event1</value>
12078 
                      <value type="string" key="oldName">fk_aggregate_observation_taxa_sampling_event1</value>
12079 
                    </value>
12080 12040 
                  </value>
12081 12041 
                  <value _ptr_="0xa9b6768" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
12082 12042 
                    <value type="object" struct-name="db.mysql.Index" id="f1573748-011f-11e3-9f3a-080027bcf912" struct-checksum="0x309b847a">
......
12102 12062 
                      <value type="string" key="oldName">PRIMARY</value>
12103 12063 
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12104 12064 
                    </value>
12105 
                    <value type="object" struct-name="db.mysql.Index" id="ab56d2f6-1ddc-11e3-bd5f-080027bcf912" struct-checksum="0x309b847a">
12106 
                      <value _ptr_="0xa9b83e0" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12107 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="ab56d490-1ddc-11e3-bd5f-080027bcf912" struct-checksum="0x62630b3c">
12108 
                          <value type="int" key="columnLength">0</value>
12109 
                          <value type="string" key="comment"></value>
12110 
                          <value type="int" key="descend">0</value>
12111 
                          <link type="object" struct-name="db.Column" key="referencedColumn">ab56bc12-1ddc-11e3-bd5f-080027bcf912</link>
12112 
                          <value type="string" key="name"></value>
12113 
                          <link type="object" struct-name="GrtObject" key="owner">ab56d2f6-1ddc-11e3-bd5f-080027bcf912</link>
12114 
                        </value>
12115 
                      </value>
12116 
                      <value type="string" key="indexKind"></value>
12117 
                      <value type="int" key="keyBlockSize">0</value>
12118 
                      <value type="string" key="withParser"></value>
12119 
                      <value type="string" key="comment"></value>
12120 
                      <value type="int" key="deferability">0</value>
12121 
                      <value type="string" key="indexType">INDEX</value>
12122 
                      <value type="int" key="isPrimary">0</value>
12123 
                      <value type="string" key="name">fk_aggregate_observation_taxa_sampling_event1_idx</value>
12124 
                      <value type="int" key="unique">0</value>
12125 
                      <value type="string" key="oldName">fk_aggregate_observation_taxa_sampling_event1_idx</value>
12126 
                      <link type="object" struct-name="GrtObject" key="owner">f15726c2-011f-11e3-9f3a-080027bcf912</link>
12127 
                    </value>
12128 12065 
                  </value>
12129 12066 
                  <value type="string" key="maxRows"></value>
12130 12067 
                  <value type="string" key="mergeInsert"></value>
......
14983 14920 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
14984 14921 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
14985 14922 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">2d3c42f6-0078-11e3-906b-080027bcf912</link>
14986 
                <value type="real" key="middleSegmentOffset">1.205012540817743911247816868126392364501953125e+02</value>
14923 
                <value type="real" key="middleSegmentOffset">1.169633595563246899473597295582294464111328125e+02</value>
14987 14924 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
14988 14925 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
14989 14926 
                <value type="int" key="drawSplit">0</value>
......
15214 15151 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15215 15152 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15216 15153 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">d2081100-f959-11e2-8597-080027bcf912</link>
15217 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15154 
                <value type="real" key="middleSegmentOffset">-6.9690890667652411138988099992275238037109375e+01</value>
15218 15155 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15219 15156 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15220 15157 
                <value type="int" key="drawSplit">0</value>
......
15434 15371 
                <value type="int" key="visible">1</value>
15435 15372 
                <value type="string" key="name"></value>
15436 15373 
              </value>
15437 
              <value type="object" struct-name="workbench.physical.Connection" id="ab56db16-1ddc-11e3-bd5f-080027bcf912" struct-checksum="0x9baebc92">
15438 
                <value type="string" key="caption">fk_aggregate_observation_taxa_sampling_event1</value>
15439 
                <value type="real" key="captionXOffs">0.e+00</value>
15440 
                <value type="real" key="captionYOffs">0.e+00</value>
15441 
                <value type="string" key="comment"></value>
15442 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15443 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15444 
                <value type="string" key="extraCaption"></value>
15445 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15446 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15447 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">ab56b99c-1ddc-11e3-bd5f-080027bcf912</link>
15448 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15449 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15450 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15451 
                <value type="int" key="drawSplit">0</value>
15452 
                <link type="object" struct-name="model.Figure" key="endFigure">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
15453 
                <link type="object" struct-name="model.Figure" key="startFigure">f1574d28-011f-11e3-9f3a-080027bcf912</link>
15454 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15455 
                <value type="int" key="visible">1</value>
15456 
                <value type="string" key="name"></value>
15457 
              </value>
15458 15374 
              <value type="object" struct-name="workbench.physical.Connection" id="07e46488-1dde-11e3-bd5f-080027bcf912" struct-checksum="0x9baebc92">
15459 15375 
                <value type="string" key="caption">fk_taxon_observation_taxa_sampling_event1</value>
15460 15376 
                <value type="real" key="captionXOffs">0.e+00</value>
......
15466 15382 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15467 15383 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15468 15384 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">07e2f24c-1dde-11e3-bd5f-080027bcf912</link>
15469 
                <value type="real" key="middleSegmentOffset">-5.14591487172582446874002926051616668701171875e+01</value>
15385 
                <value type="real" key="middleSegmentOffset">-3.738190604656602999966708011925220489501953125e+01</value>
15470 15386 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15471 15387 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15472 15388 
                <value type="int" key="drawSplit">0</value>
......
16030 15946 
                <value type="real" key="left">5.57e+02</value>
16031 15947 
                <value type="int" key="locked">0</value>
16032 15948 
                <value type="int" key="manualSizing">0</value>
16033 
                <value type="real" key="top">4.34e+02</value>
15949 
                <value type="real" key="top">4.45e+02</value>
16034 15950 
                <value type="real" key="width">8.1e+01</value>
16035 15951 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16036 15952 
                <value type="int" key="visible">1</value>
......
16350 16266 
                <value type="real" key="left">8.54e+02</value>
16351 16267 
                <value type="int" key="locked">0</value>
16352 16268 
                <value type="int" key="manualSizing">0</value>
16353 
                <value type="real" key="top">4.84e+02</value>
16269 
                <value type="real" key="top">4.92e+02</value>
16354 16270 
                <value type="real" key="width">1.68e+02</value>
16355 16271 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16356 16272 
                <value type="int" key="visible">1</value>
......
17450 17366 
                <value type="int" key="triggersExpanded">0</value>
17451 17367 
                <value type="string" key="color">#FFFF00</value>
17452 17368 
                <value type="int" key="expanded">1</value>
17453 
                <value type="real" key="height">1.e+02</value>
17369 
                <value type="real" key="height">7.7e+01</value>
17454 17370 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17455 17371 
                <value type="real" key="left">9.17e+02</value>
17456 17372 
                <value type="int" key="locked">0</value>
17457 17373 
                <value type="int" key="manualSizing">0</value>
17458 
                <value type="real" key="top">6.34e+02</value>
17374 
                <value type="real" key="top">6.42e+02</value>
17459 17375 
                <value type="real" key="width">1.82e+02</value>
17460 17376 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17461 17377 
                <value type="int" key="visible">1</value>
......
18346 18262 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18347 18263 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18348 18264 
      <value type="string" key="caption">New Model</value>
18349 
      <value type="string" key="dateChanged">2013-09-30 02:27</value>
18265 
      <value type="string" key="dateChanged">2013-09-30 02:35</value>
18350 18266 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18351 18267 
      <value type="string" key="description"></value>
18352 18268 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
31 31 
/*!40101 SET character_set_client = utf8 */;
32 32 
CREATE TABLE `aggregate_observation` (
33 33 
  `id` varbinary(767) NOT NULL,
34 
  `sampling_event` varbinary(767) NOT NULL,
35 34 
  `occurrence_status` varbinary(767) DEFAULT NULL,
36 35 
  PRIMARY KEY (`id`),
37 
  KEY `fk_aggregate_observation_taxa_sampling_event1_idx` (`sampling_event`),
38 
  CONSTRAINT `fk_taxon_presence_taxon_determination10` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
39 
  CONSTRAINT `fk_aggregate_observation_taxa_sampling_event1` FOREIGN KEY (`sampling_event`) REFERENCES `taxa_sampling_event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
36 
  CONSTRAINT `fk_taxon_presence_taxon_determination10` FOREIGN KEY (`id`) REFERENCES `taxon_determination` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
40 37 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
41 38 
/*!40101 SET character_set_client = @saved_cs_client */;
42 39 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  33
  33
  
    
/*!40101 SET character_set_client = utf8 */;


  		




  34
  34
  
    
CREATE TABLE "aggregate_observation" (


  		




  35
  35
  
    
  "id" text NOT NULL,


  		




  36
  
  
    
  "sampling_event" text NOT NULL,


  		




  37
  36
  
    
  "occurrence_status" text DEFAULT NULL,


  		




  38
  37
  
    
  PRIMARY KEY ("id"),


  		




  39
  
  
    
  /*KEY "fk_aggregate_observation_taxa_sampling_event1_idx" ("sampling_event")*/CHECK (true),


  		




  40
  
  
    
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  41
  
  
    
  /*CONSTRAINT "fk_aggregate_observation_taxa_sampling_event1" FOREIGN KEY ("sampling_event") REFERENCES "taxa_sampling_event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  38
  
    
  /*CONSTRAINT "fk_taxon_presence_taxon_determination10" FOREIGN KEY ("id") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  42
  39
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  43
  40
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  44
  41
  
    

  		












Also available in:  Unified diff