Project

General

Profile

« Previous | Next » 

Revision 11140

Added by Aaron Marcuse-Kubitza about 11 years ago

schemas/VegCore/ERD/VegCore.ERD.mwb: source: added canon field. when there are multiple names for a source, this points to the canonically-named source. by default, points recursively to itself.

View differences:

schemas/VegCore/ERD/document.mwb.xml
12476 12476 
                      <value type="string" key="oldName">id</value>
12477 12477 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12478 12478 
                    </value>
12479 
                    <value type="object" struct-name="db.mysql.Column" id="b4407c12-29c3-11e3-a024-080027bcf912" struct-checksum="0x783b5183">
12480 
                      <value type="int" key="autoIncrement">0</value>
12481 
                      <value type="string" key="characterSetName"></value>
12482 
                      <value _ptr_="0xbb9d5b0" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
12483 
                      <value type="string" key="collationName"></value>
12484 
                      <value type="string" key="datatypeExplicitParams"></value>
12485 
                      <value type="string" key="defaultValue"></value>
12486 
                      <value type="int" key="defaultValueIsNull">0</value>
12487 
                      <value _ptr_="0xc230218" type="list" content-type="string" key="flags"/>
12488 
                      <value type="int" key="isNotNull">1</value>
12489 
                      <value type="int" key="length">767</value>
12490 
                      <value type="int" key="precision">-1</value>
12491 
                      <value type="int" key="scale">-1</value>
12492 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
12493 
                      <value type="string" key="comment">when there are multiple names for a source, this points to the canonically-named source. by default, points recursively to itself.</value>
12494 
                      <value type="string" key="name">canon</value>
12495 
                      <value type="string" key="oldName">canon</value>
12496 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12497 
                    </value>
12479 12498 
                    <value type="object" struct-name="db.mysql.Column" id="afc40c10-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x783b5183">
12480 12499 
                      <value type="int" key="autoIncrement">0</value>
12481 12500 
                      <value type="string" key="characterSetName"></value>
......
12519 12538 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
12520 12539 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
12521 12540 
                  <value type="int" key="delayKeyWrite">0</value>
12522 
                  <value _ptr_="0xadcf968" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"/>
12541 
                  <value _ptr_="0xadcf968" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
12542 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="b4407a1e-29c3-11e3-a024-080027bcf912" struct-checksum="0x70a8fc40">
12543 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12544 
                      <value _ptr_="0xba92008" type="list" content-type="object" content-struct-name="db.Column" key="columns">
12545 
                        <link type="object">b4407c12-29c3-11e3-a024-080027bcf912</link>
12546 
                      </value>
12547 
                      <value type="int" key="deferability">0</value>
12548 
                      <value type="string" key="deleteRule">CASCADE</value>
12549 
                      <link type="object" struct-name="db.Index" key="index">b440936e-29c3-11e3-a024-080027bcf912</link>
12550 
                      <value type="int" key="mandatory">1</value>
12551 
                      <value type="int" key="many">1</value>
12552 
                      <value type="int" key="modelOnly">0</value>
12553 
                      <link type="object" struct-name="db.Table" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12554 
                      <value _ptr_="0xc221dd0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
12555 
                        <link type="object">afc4053a-1df9-11e3-bbb6-080027bcf912</link>
12556 
                      </value>
12557 
                      <value type="int" key="referencedMandatory">1</value>
12558 
                      <value type="string" key="updateRule">CASCADE</value>
12559 
                      <value type="string" key="comment"></value>
12560 
                      <value type="string" key="name">source_id_fkey1</value>
12561 
                      <value type="string" key="oldName">source_id_fkey1</value>
12562 
                    </value>
12563 
                  </value>
12523 12564 
                  <value _ptr_="0xadcf9b8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
12524 12565 
                    <value type="object" struct-name="db.mysql.Index" id="afc41fc0-1df9-11e3-bbb6-080027bcf912" struct-checksum="0x309b847a">
12525 12566 
                      <value _ptr_="0xadd0a38" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
......
12544 12585 
                      <value type="string" key="oldName">PRIMARY</value>
12545 12586 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12546 12587 
                    </value>
12588 
                    <value type="object" struct-name="db.mysql.Index" id="b440936e-29c3-11e3-a024-080027bcf912" struct-checksum="0x309b847a">
12589 
                      <value _ptr_="0xc5638a8" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
12590 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="b44094f4-29c3-11e3-a024-080027bcf912" struct-checksum="0x62630b3c">
12591 
                          <value type="int" key="columnLength">0</value>
12592 
                          <value type="string" key="comment"></value>
12593 
                          <value type="int" key="descend">0</value>
12594 
                          <link type="object" struct-name="db.Column" key="referencedColumn">b4407c12-29c3-11e3-a024-080027bcf912</link>
12595 
                          <value type="string" key="name"></value>
12596 
                          <link type="object" struct-name="GrtObject" key="owner">b440936e-29c3-11e3-a024-080027bcf912</link>
12597 
                        </value>
12598 
                      </value>
12599 
                      <value type="string" key="indexKind"></value>
12600 
                      <value type="int" key="keyBlockSize">0</value>
12601 
                      <value type="string" key="withParser"></value>
12602 
                      <value type="string" key="comment"></value>
12603 
                      <value type="int" key="deferability">0</value>
12604 
                      <value type="string" key="indexType">INDEX</value>
12605 
                      <value type="int" key="isPrimary">0</value>
12606 
                      <value type="string" key="name">source_id_fkey1_idx</value>
12607 
                      <value type="int" key="unique">0</value>
12608 
                      <value type="string" key="oldName">source_id_fkey1_idx</value>
12609 
                      <link type="object" struct-name="GrtObject" key="owner">afc401d4-1df9-11e3-bbb6-080027bcf912</link>
12610 
                    </value>
12547 12611 
                  </value>
12548 12612 
                  <value type="string" key="maxRows"></value>
12549 12613 
                  <value type="string" key="mergeInsert"></value>
......
12575 12639 
                  <value type="int" key="commentedOut">0</value>
12576 12640 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
12577 12641 
                  <value _ptr_="0xadcf740" type="dict" key="customData"/>
12578 
                  <value type="string" key="lastChangeDate">2013-09-22 18:00</value>
12642 
                  <value type="string" key="lastChangeDate">2013-09-30 04:39</value>
12579 12643 
                  <value type="int" key="modelOnly">0</value>
12580 12644 
                  <value type="string" key="name">source</value>
12581 12645 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
15353 15417 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15354 15418 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15355 15419 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">7e2aa84c-1dfb-11e3-bbb6-080027bcf912</link>
15356 
                <value type="real" key="middleSegmentOffset">3.5385914413227510522119700908660888671875e+00</value>
15420 
                <value type="real" key="middleSegmentOffset">9.232873521690407869755290448665618896484375e-01</value>
15357 15421 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15358 15422 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15359 15423 
                <value type="int" key="drawSplit">0</value>
......
15720 15784 
                <value type="int" key="visible">1</value>
15721 15785 
                <value type="string" key="name"></value>
15722 15786 
              </value>
15787 
              <value type="object" struct-name="workbench.physical.Connection" id="b4409b84-29c3-11e3-a024-080027bcf912" struct-checksum="0x9baebc92">
15788 
                <value type="string" key="caption">source_id_fkey1</value>
15789 
                <value type="real" key="captionXOffs">0.e+00</value>
15790 
                <value type="real" key="captionYOffs">0.e+00</value>
15791 
                <value type="string" key="comment"></value>
15792 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
15793 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
15794 
                <value type="string" key="extraCaption"></value>
15795 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
15796 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
15797 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">b4407a1e-29c3-11e3-a024-080027bcf912</link>
15798 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
15799 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
15800 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
15801 
                <value type="int" key="drawSplit">0</value>
15802 
                <link type="object" struct-name="model.Figure" key="endFigure">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
15803 
                <link type="object" struct-name="model.Figure" key="startFigure">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
15804 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15805 
                <value type="int" key="visible">1</value>
15806 
                <value type="string" key="name"></value>
15807 
              </value>
15723 15808 
            </value>
15724 15809 
            <value type="string" key="description"></value>
15725 15810 
            <value _ptr_="0xadd90c8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
15749 15834 
                <value type="int" key="expanded">1</value>
15750 15835 
                <value type="real" key="height">1.92e+02</value>
15751 15836 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
15752 
                <value type="real" key="left">4.5e+01</value>
15837 
                <value type="real" key="left">4.2e+01</value>
15753 15838 
                <value type="int" key="locked">0</value>
15754 15839 
                <value type="int" key="manualSizing">0</value>
15755 
                <value type="real" key="top">6.81e+02</value>
15840 
                <value type="real" key="top">7.09e+02</value>
15756 15841 
                <value type="real" key="width">9.2e+01</value>
15757 15842 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
15758 15843 
                <value type="int" key="visible">1</value>
......
16292 16377 
                <value type="real" key="left">2.1e+01</value>
16293 16378 
                <value type="int" key="locked">0</value>
16294 16379 
                <value type="int" key="manualSizing">0</value>
16295 
                <value type="real" key="top">9.56e+02</value>
16380 
                <value type="real" key="top">9.67e+02</value>
16296 16381 
                <value type="real" key="width">7.9e+01</value>
16297 16382 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16298 16383 
                <value type="int" key="visible">1</value>
......
16898 16983 
                <value type="real" key="left">1.95e+02</value>
16899 16984 
                <value type="int" key="locked">0</value>
16900 16985 
                <value type="int" key="manualSizing">0</value>
16901 
                <value type="real" key="top">8.06e+02</value>
16986 
                <value type="real" key="top">8.22e+02</value>
16902 16987 
                <value type="real" key="width">1.03e+02</value>
16903 16988 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16904 16989 
                <value type="int" key="visible">1</value>
......
16918 17003 
                <value type="real" key="left">1.54e+02</value>
16919 17004 
                <value type="int" key="locked">0</value>
16920 17005 
                <value type="int" key="manualSizing">0</value>
16921 
                <value type="real" key="top">9.1e+02</value>
17006 
                <value type="real" key="top">9.21e+02</value>
16922 17007 
                <value type="real" key="width">1.39e+02</value>
16923 17008 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
16924 17009 
                <value type="int" key="visible">1</value>
......
17270 17355 
                <value type="int" key="expanded">1</value>
17271 17356 
                <value type="real" key="height">1.e+02</value>
17272 17357 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17273 
                <value type="real" key="left">1.73e+02</value>
17358 
                <value type="real" key="left">1.72e+02</value>
17274 17359 
                <value type="int" key="locked">0</value>
17275 17360 
                <value type="int" key="manualSizing">0</value>
17276 
                <value type="real" key="top">6.62e+02</value>
17361 
                <value type="real" key="top">6.9e+02</value>
17277 17362 
                <value type="real" key="width">1.06e+02</value>
17278 17363 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17279 17364 
                <value type="int" key="visible">1</value>
......
17288 17373 
                <value type="int" key="triggersExpanded">0</value>
17289 17374 
                <value type="string" key="color">#99ccff</value>
17290 17375 
                <value type="int" key="expanded">1</value>
17291 
                <value type="real" key="height">1.e+02</value>
17376 
                <value type="real" key="height">1.23e+02</value>
17292 17377 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
17293 
                <value type="real" key="left">1.9e+01</value>
17378 
                <value type="real" key="left">1.4e+01</value>
17294 17379 
                <value type="int" key="locked">0</value>
17295 17380 
                <value type="int" key="manualSizing">0</value>
17296 
                <value type="real" key="top">5.48e+02</value>
17381 
                <value type="real" key="top">5.61e+02</value>
17297 17382 
                <value type="real" key="width">8.9e+01</value>
17298 17383 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17299 17384 
                <value type="int" key="visible">1</value>
......
17313 17398 
                <value type="real" key="left">5.6e+01</value>
17314 17399 
                <value type="int" key="locked">0</value>
17315 17400 
                <value type="int" key="manualSizing">0</value>
17316 
                <value type="real" key="top">1.042e+03</value>
17401 
                <value type="real" key="top">1.047e+03</value>
17317 17402 
                <value type="real" key="width">9.e+01</value>
17318 17403 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
17319 17404 
                <value type="int" key="visible">1</value>
......
17463 17548 
              <value type="string" key="name"></value>
17464 17549 
            </value>
17465 17550 
            <value _ptr_="0xadd91a0" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17466 
              <link type="object">1653ab3a-a7a7-11e2-8ba6-080027bcf912</link>
17551 
              <link type="object">afc4521a-1df9-11e3-bbb6-080027bcf912</link>
17467 17552 
            </value>
17468 17553 
            <value type="int" key="updateBlocked">0</value>
17469 17554 
            <value type="real" key="width">1.6215e+03</value>
......
17477 17562 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17478 17563 
        <value _ptr_="0xad2bf00" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17479 17564 
        <value _ptr_="0xa5b9c88" type="dict" key="syncProfiles">
17480 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="1ab37652-29bf-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17481 
            <value _ptr_="0xc5bb328" type="dict" key="lastKnownDBNames">
17565 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="6d75953c-29c4-11e3-a024-080027bcf912" struct-checksum="0xc64972c2" key="">
17566 
            <value _ptr_="0xb8a6708" type="dict" key="lastKnownDBNames">
17482 17567 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17483 17568 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17484 17569 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17817 17902 
              <value type="string" key="afc4158e-1df9-11e3-bbb6-080027bcf912">info</value>
17818 17903 
              <value type="string" key="afc41fc0-1df9-11e3-bbb6-080027bcf912">PRIMARY</value>
17819 17904 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
17905 
              <value type="string" key="b4407a1e-29c3-11e3-a024-080027bcf912">source_id_fkey1</value>
17906 
              <value type="string" key="b4407c12-29c3-11e3-a024-080027bcf912">canon</value>
17907 
              <value type="string" key="b440936e-29c3-11e3-a024-080027bcf912">source_id_fkey1_idx</value>
17820 17908 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
17821 17909 
              <value type="string" key="b7749c3a-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1</value>
17822 17910 
              <value type="string" key="b7749e74-2985-11e3-a80d-080027bcf912">place_observation</value>
......
18102 18190 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18103 18191 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18104 18192 
      <value type="string" key="caption">New Model</value>
18105 
      <value type="string" key="dateChanged">2013-09-30 04:02</value>
18193 
      <value type="string" key="dateChanged">2013-09-30 04:39</value>
18106 18194 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18107 18195 
      <value type="string" key="description"></value>
18108 18196 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
847 847 
/*!40101 SET character_set_client = utf8 */;
848 848 
CREATE TABLE `source` (
849 849 
  `id` varbinary(767) NOT NULL,
850 
  `canon` varbinary(767) NOT NULL COMMENT 'when there are multiple names for a source, this points to the canonically-named source. by default, points recursively to itself.',
850 851 
  `name` varbinary(767) DEFAULT NULL,
851 852 
  `info` set('hstore') COLLATE utf8_bin DEFAULT NULL,
852 
  PRIMARY KEY (`id`)
853 
  PRIMARY KEY (`id`),
854 
  KEY `source_id_fkey1_idx` (`canon`),
855 
  CONSTRAINT `source_id_fkey1` FOREIGN KEY (`canon`) REFERENCES `source` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
853 856 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference';
854 857 
/*!40101 SET character_set_client = @saved_cs_client */;
855 858 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





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


  		




  850
  850
  
    
CREATE TABLE "source" (


  		




  851
  851
  
    
  "id" text NOT NULL,


  		




  
  852
  
    
  "canon" text NOT NULL /*COMMENT 'when there are multiple names for a source, this points to the canonically-named source. by default, points recursively to itself.'*/,


  		




  852
  853
  
    
  "name" text DEFAULT NULL,


  		




  853
  854
  
    
  "info" hstore DEFAULT NULL,


  		




  854
  
  
    
  PRIMARY KEY ("id")


  		




  
  855
  
    
  PRIMARY KEY ("id"),


  		




  
  856
  
    
  /*KEY "source_id_fkey1_idx" ("canon")*/CHECK (true),


  		




  
  857
  
    
  /*CONSTRAINT "source_id_fkey1" FOREIGN KEY ("canon") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  855
  858
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='where something came from; a "reference [...] cited within the database" ("VegBank":http://reference.VegBank.vegpath.org); = VegBank.vegpath.org?reference'*/;


  		




  856
  859
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  857
  860
  
    

  		












Also available in:  Unified diff