Project

General

Profile

« Previous | Next » 

Revision 11214

Added by Aaron Marcuse-Kubitza about 11 years ago

fix: schemas/VegCore/ERD/VegCore.ERD.mwb: place_visit: fixed synonyms list to "VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)"

View differences:

schemas/VegCore/ERD/document.mwb.xml
5834 5834 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
5835 5835 
                      <value type="string" key="comment"></value>
5836 5836 
                      <value type="string" key="name">place_visit</value>
5837 
                      <value type="string" key="oldName">place_observation</value>
5837 
                      <value type="string" key="oldName">place_visit</value>
5838 5838 
                      <link type="object" struct-name="GrtObject" key="owner">be8f58b6-a6e0-11e2-95e9-080027bcf912</link>
5839 5839 
                    </value>
5840 5840 
                    <value type="object" struct-name="db.mysql.Column" id="ae7763ca-008a-11e3-9629-080027bcf912" struct-checksum="0x783b5183">
......
8665 8665 
                  <value type="int" key="commentedOut">0</value>
8666 8666 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
8667 8667 
                  <value _ptr_="0xb9ee508" type="dict" key="customData"/>
8668 
                  <value type="string" key="lastChangeDate">2013-10-09 16:18</value>
8668 
                  <value type="string" key="lastChangeDate">2013-10-09 16:23</value>
8669 8669 
                  <value type="int" key="modelOnly">0</value>
8670 8670 
                  <value type="string" key="name">place_visit</value>
8671 8671 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
8672 8672 
                  <value type="string" key="temp_sql"></value>
8673 
                  <value type="string" key="comment">A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?observation (which was confusingly named) + VegBank.vegpath.org?plot (which is actually 1:1 with observation)</value>
8674 
                  <value type="string" key="oldName">place_observation</value>
8673 
                  <value type="string" key="comment">A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)</value>
8674 
                  <value type="string" key="oldName">place_visit</value>
8675 8675 
                </value>
8676 8676 
                <value type="object" struct-name="db.mysql.Table" id="489c25e4-a6ea-11e2-98a6-080027bcf912" struct-checksum="0x1a403946">
8677 8677 
                  <value type="string" key="avgRowLength"></value>
......
10691 10691 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
10692 10692 
                      <value type="string" key="comment"></value>
10693 10693 
                      <value type="string" key="name">place_visit</value>
10694 
                      <value type="string" key="oldName">place_observation</value>
10694 
                      <value type="string" key="oldName">place_visit</value>
10695 10695 
                      <link type="object" struct-name="GrtObject" key="owner">7f176964-f6c0-11e2-af44-080027bcf912</link>
10696 10696 
                    </value>
10697 10697 
                    <value type="object" struct-name="db.mysql.Column" id="a841ba7e-f6c0-11e2-af44-080027bcf912" struct-checksum="0x783b5183">
......
17584 17584 
              <value type="string" key="name"></value>
17585 17585 
            </value>
17586 17586 
            <value _ptr_="0xba36528" type="list" content-type="object" content-struct-name="model.Object" key="selection">
17587 
              <link type="object">7f17a4b0-f6c0-11e2-af44-080027bcf912</link>
17587 
              <link type="object">FF3A48D7-490E-4E77-B97B-1F51BF51FA8A</link>
17588 17588 
            </value>
17589 17589 
            <value type="int" key="updateBlocked">0</value>
17590 17590 
            <value type="real" key="width">1.6215e+03</value>
......
17598 17598 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
17599 17599 
        <value _ptr_="0xb986d58" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
17600 17600 
        <value _ptr_="0xb1a9c10" type="dict" key="syncProfiles">
17601 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="627cc12a-3138-11e3-aa43-080027bcf912" struct-checksum="0xc64972c2" key="">
17602 
            <value _ptr_="0xca6b780" type="dict" key="lastKnownDBNames">
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">
17603 17603 
              <value type="string" key="016697c0-23ec-11e3-ab7c-080027bcf912">name</value>
17604 17604 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
17605 17605 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
......
17898 17898 
              <value type="string" key="94ad6c18-f6c7-11e2-a35e-080027bcf912">dimensions</value>
17899 17899 
              <value type="string" key="9535924c-29b6-11e3-a024-080027bcf912">party_list_id_fkey1</value>
17900 17900 
              <value type="string" key="98e532e4-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1</value>
17901 
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_observation</value>
17901 
              <value type="string" key="98e534d8-008a-11e3-9629-080027bcf912">place_visit</value>
17902 17902 
              <value type="string" key="98e5491e-008a-11e3-9629-080027bcf912">fk_soil_observation_place_observation1_idx</value>
17903 17903 
              <value type="string" key="9b006114-f6d2-11e2-a35e-080027bcf912">fk_taxon_scrub_record1</value>
17904 17904 
              <value type="string" key="9b6b7d6a-ad0c-11e2-b309-080027bcf912">fk_parsed_taxon_assertion_taxon_name1_idx</value>
......
17952 17952 
              <value type="string" key="b19ab98a-a6e9-11e2-98a6-080027bcf912">PRIMARY</value>
17953 17953 
              <value type="string" key="b55f115c-a792-11e2-84c3-080027bcf912">name</value>
17954 17954 
              <value type="string" key="b7749c3a-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1</value>
17955 
              <value type="string" key="b7749e74-2985-11e3-a80d-080027bcf912">place_observation</value>
17955 
              <value type="string" key="b7749e74-2985-11e3-a80d-080027bcf912">place_visit</value>
17956 17956 
              <value type="string" key="b774c534-2985-11e3-a80d-080027bcf912">taxa_sampling_event_id_fkey1_idx</value>
17957 17957 
              <value type="string" key="b8ce339a-a797-11e2-8681-080027bcf912">fk_stem_individual2</value>
17958 17958 
              <value type="string" key="b95efb72-f982-11e2-8a2e-080027bcf912">width_m</value>
......
18023 18023 
              <value type="string" key="be8f29d6-a6e0-11e2-95e9-080027bcf912">id</value>
18024 18024 
              <value type="string" key="be8f2b98-a6e0-11e2-95e9-080027bcf912">PRIMARY</value>
18025 18025 
              <value type="string" key="be8f2ecc-a6e0-11e2-95e9-080027bcf912">fk_geological_context_record1</value>
18026 
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_observation</value>
18026 
              <value type="string" key="be8f387c-a6e0-11e2-95e9-080027bcf912">place_visit</value>
18027 18027 
              <value type="string" key="be8f3ade-a6e0-11e2-95e9-080027bcf912">id</value>
18028 18028 
              <value type="string" key="be8f3ca0-a6e0-11e2-95e9-080027bcf912">subject</value>
18029 18029 
              <value type="string" key="be8f3e30-a6e0-11e2-95e9-080027bcf912">geological_context</value>
......
18230 18230 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
18231 18231 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
18232 18232 
      <value type="string" key="caption">New Model</value>
18233 
      <value type="string" key="dateChanged">2013-10-09 16:20</value>
18233 
      <value type="string" key="dateChanged">2013-10-09 16:24</value>
18234 18234 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
18235 18235 
      <value type="string" key="description"></value>
18236 18236 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
665 665 
  CONSTRAINT `fk_place_observation_event1` FOREIGN KEY (`id`) REFERENCES `event` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
666 666 
  CONSTRAINT `fk_place_observation_geological_context1` FOREIGN KEY (`geological_context`) REFERENCES `geological_context` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
667 667 
  CONSTRAINT `fk_place_observation_place1` FOREIGN KEY (`subject`) REFERENCES `place` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
668 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?observation (which was confusingly named) + VegBank.vegpath.org?plot (which is actually 1:1 with observation)';
668 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)';
669 669 
/*!40101 SET character_set_client = @saved_cs_client */;
670 670 

  		




  671
  671
  
    
--


  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  667
  667
  
    
  /*CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  668
  668
  
    
  /*CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  669
  669
  
    
  /*CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("subject") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  670
  
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?stratumObservation, VegBank.vegpath.org?observation (which was confusingly named) + VegBank.vegpath.org?plot (which is actually 1:1 with observation)'*/;


  		




  
  670
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='A sampling of a [[VegCore#Location|Location]]. = VegX.vegpath.org?plotObservation, VegBank.vegpath.org?observation (which was confusingly named) + some of VegBank.vegpath.org?plot (which is actually 1:1 with observation)'*/;


  		




  671
  671
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  672
  672
  
    

  		




  673
  673
  
    
--


  		












Also available in:  Unified diff