Project

General

Profile

« Previous | Next » 

Revision 10474

Added by Aaron Marcuse-Kubitza almost 11 years ago

bugfix: schemas/VegCore/VegCore.ERD.mwb: geovalidation: HAVE-AN input geoplace rather than BEING-ONE, to allow multiple geovalidations for a geoplace by different sources

View differences:

schemas/VegCore/document.mwb.xml
4327 4327 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
4328 4328 
                      <value type="string" key="comment"></value>
4329 4329 
                      <value type="string" key="name">taxon_observation</value>
4330 
                      <value type="string" key="oldName">taxon_observation_id</value>
4330 
                      <value type="string" key="oldName">taxon_observation</value>
4331 4331 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4332 4332 
                    </value>
4333 4333 
                    <value type="object" struct-name="db.mysql.Column" id="3d9b197c-a7a1-11e2-b667-080027bcf912" struct-checksum="0x783b5183">
......
4598 4598 
                      <value type="int" key="isPrimary">0</value>
4599 4599 
                      <value type="string" key="name">fk_taxon_determination_taxon_observation1_idx</value>
4600 4600 
                      <value type="int" key="unique">0</value>
4601 
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1</value>
4601 
                      <value type="string" key="oldName">fk_taxon_determination_taxon_observation1_idx</value>
4602 4602 
                      <link type="object" struct-name="GrtObject" key="owner">3d9b10bc-a7a1-11e2-b667-080027bcf912</link>
4603 4603 
                    </value>
4604 4604 
                  </value>
......
8982 8982 
                      <value type="string" key="oldName">id</value>
8983 8983 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
8984 8984 
                    </value>
8985 
                    <value type="object" struct-name="db.mysql.Column" id="3292247a-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
8986 
                      <value type="int" key="autoIncrement">0</value>
8987 
                      <value type="string" key="characterSetName"></value>
8988 
                      <value _ptr_="0xc96a628" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
8989 
                      <value type="string" key="collationName"></value>
8990 
                      <value type="string" key="datatypeExplicitParams"></value>
8991 
                      <value type="string" key="defaultValue"></value>
8992 
                      <value type="int" key="defaultValueIsNull">0</value>
8993 
                      <value _ptr_="0xc3ea168" type="list" content-type="string" key="flags"/>
8994 
                      <value type="int" key="isNotNull">1</value>
8995 
                      <value type="int" key="length">767</value>
8996 
                      <value type="int" key="precision">-1</value>
8997 
                      <value type="int" key="scale">-1</value>
8998 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
8999 
                      <value type="string" key="comment"></value>
9000 
                      <value type="string" key="name">input_geoplace</value>
9001 
                      <value type="string" key="oldName">input_geoplace</value>
9002 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9003 
                    </value>
9004 
                    <value type="object" struct-name="db.mysql.Column" id="35cce77e-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x783b5183">
9005 
                      <value type="int" key="autoIncrement">0</value>
9006 
                      <value type="string" key="characterSetName"></value>
9007 
                      <value _ptr_="0xbacad48" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
9008 
                      <value type="string" key="collationName"></value>
9009 
                      <value type="string" key="datatypeExplicitParams"></value>
9010 
                      <value type="string" key="defaultValue"></value>
9011 
                      <value type="int" key="defaultValueIsNull">0</value>
9012 
                      <value _ptr_="0xc907b08" type="list" content-type="string" key="flags"/>
9013 
                      <value type="int" key="isNotNull">1</value>
9014 
                      <value type="int" key="length">767</value>
9015 
                      <value type="int" key="precision">-1</value>
9016 
                      <value type="int" key="scale">-1</value>
9017 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
9018 
                      <value type="string" key="comment"></value>
9019 
                      <value type="string" key="name">scrubbed_geoplace</value>
9020 
                      <value type="string" key="oldName">scrubbed_geoplace</value>
9021 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9022 
                    </value>
8985 9023 
                    <value type="object" struct-name="db.mysql.Column" id="a8348424-a78f-11e2-84c3-080027bcf912" struct-checksum="0x783b5183">
8986 9024 
                      <value type="int" key="autoIncrement">0</value>
8987 9025 
                      <value type="string" key="characterSetName"></value>
......
9045 9083 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
9046 9084 
                  <value type="int" key="delayKeyWrite">0</value>
9047 9085 
                  <value _ptr_="0xb2aca78" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
9048 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="3c2be5be-a763-11e2-aa10-080027bcf912" struct-checksum="0x70a8fc40">
9086 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="3292225e-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
9049 9087 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f78aa-a6e0-11e2-95e9-080027bcf912</link>
9050 
                      <value _ptr_="0xb2ae040" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9051 
                        <link type="object">24508724-a763-11e2-aa10-080027bcf912</link>
9088 
                      <value _ptr_="0xbf96350" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9089 
                        <link type="object">3292247a-f6df-11e2-b6d1-080027bcf912</link>
9052 9090 
                      </value>
9053 9091 
                      <value type="int" key="deferability">0</value>
9054 9092 
                      <value type="string" key="deleteRule">CASCADE</value>
9055 
                      <value type="int" key="mandatory">0</value>
9056 
                      <value type="int" key="many">0</value>
9093 
                      <link type="object" struct-name="db.Index" key="index">329238b6-f6df-11e2-b6d1-080027bcf912</link>
9094 
                      <value type="int" key="mandatory">1</value>
9095 
                      <value type="int" key="many">1</value>
9057 9096 
                      <value type="int" key="modelOnly">0</value>
9058 9097 
                      <link type="object" struct-name="db.Table" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9059 
                      <value _ptr_="0xb2ae3a8" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9098 
                      <value _ptr_="0xc43cc58" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9060 9099 
                        <link type="object">be8f7b0c-a6e0-11e2-95e9-080027bcf912</link>
9061 9100 
                      </value>
9062 9101 
                      <value type="int" key="referencedMandatory">1</value>
9063 9102 
                      <value type="string" key="updateRule">CASCADE</value>
9064 9103 
                      <value type="string" key="comment"></value>
9065 
                      <value type="string" key="name">fk_geovalidation_validatable_place1</value>
9066 
                      <value type="string" key="oldName">fk_geovalidation_validatable_place1</value>
9104 
                      <value type="string" key="name">fk_geovalidation_geoplace1</value>
9105 
                      <value type="string" key="oldName">fk_geovalidation_geoplace1</value>
9067 9106 
                    </value>
9107 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="08481eda-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x70a8fc40">
9108 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">be8f78aa-a6e0-11e2-95e9-080027bcf912</link>
9109 
                      <value _ptr_="0xce81af0" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9110 
                        <link type="object">35cce77e-f6df-11e2-b6d1-080027bcf912</link>
9111 
                      </value>
9112 
                      <value type="int" key="deferability">0</value>
9113 
                      <value type="string" key="deleteRule">CASCADE</value>
9114 
                      <link type="object" struct-name="db.Index" key="index">08483334-f6e0-11e2-b6d1-080027bcf912</link>
9115 
                      <value type="int" key="mandatory">1</value>
9116 
                      <value type="int" key="many">1</value>
9117 
                      <value type="int" key="modelOnly">0</value>
9118 
                      <link type="object" struct-name="db.Table" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9119 
                      <value _ptr_="0xc493500" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9120 
                        <link type="object">be8f7b0c-a6e0-11e2-95e9-080027bcf912</link>
9121 
                      </value>
9122 
                      <value type="int" key="referencedMandatory">1</value>
9123 
                      <value type="string" key="updateRule">CASCADE</value>
9124 
                      <value type="string" key="comment"></value>
9125 
                      <value type="string" key="name">fk_geovalidation_geoplace2</value>
9126 
                      <value type="string" key="oldName">fk_geovalidation_geoplace2</value>
9127 
                    </value>
9068 9128 
                  </value>
9069 9129 
                  <value _ptr_="0xb2acac8" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
9070 9130 
                    <value type="object" struct-name="db.mysql.Index" id="2450919c-a763-11e2-aa10-080027bcf912" struct-checksum="0x309b847a">
......
9090 9150 
                      <value type="string" key="oldName">PRIMARY</value>
9091 9151 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9092 9152 
                    </value>
9153 
                    <value type="object" struct-name="db.mysql.Index" id="329238b6-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
9154 
                      <value _ptr_="0xc2fe840" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9155 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="32923a5a-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
9156 
                          <value type="int" key="columnLength">0</value>
9157 
                          <value type="string" key="comment"></value>
9158 
                          <value type="int" key="descend">0</value>
9159 
                          <link type="object" struct-name="db.Column" key="referencedColumn">3292247a-f6df-11e2-b6d1-080027bcf912</link>
9160 
                          <value type="string" key="name"></value>
9161 
                          <link type="object" struct-name="GrtObject" key="owner">329238b6-f6df-11e2-b6d1-080027bcf912</link>
9162 
                        </value>
9163 
                      </value>
9164 
                      <value type="string" key="indexKind"></value>
9165 
                      <value type="int" key="keyBlockSize">0</value>
9166 
                      <value type="string" key="withParser"></value>
9167 
                      <value type="string" key="comment"></value>
9168 
                      <value type="int" key="deferability">0</value>
9169 
                      <value type="string" key="indexType">INDEX</value>
9170 
                      <value type="int" key="isPrimary">0</value>
9171 
                      <value type="string" key="name">fk_geovalidation_geoplace1_idx</value>
9172 
                      <value type="int" key="unique">0</value>
9173 
                      <value type="string" key="oldName">fk_geovalidation_geoplace1_idx</value>
9174 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9175 
                    </value>
9176 
                    <value type="object" struct-name="db.mysql.Index" id="08483334-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x309b847a">
9177 
                      <value _ptr_="0xca82548" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
9178 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="084835aa-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x62630b3c">
9179 
                          <value type="int" key="columnLength">0</value>
9180 
                          <value type="string" key="comment"></value>
9181 
                          <value type="int" key="descend">0</value>
9182 
                          <link type="object" struct-name="db.Column" key="referencedColumn">35cce77e-f6df-11e2-b6d1-080027bcf912</link>
9183 
                          <value type="string" key="name"></value>
9184 
                          <link type="object" struct-name="GrtObject" key="owner">08483334-f6e0-11e2-b6d1-080027bcf912</link>
9185 
                        </value>
9186 
                      </value>
9187 
                      <value type="string" key="indexKind"></value>
9188 
                      <value type="int" key="keyBlockSize">0</value>
9189 
                      <value type="string" key="withParser"></value>
9190 
                      <value type="string" key="comment"></value>
9191 
                      <value type="int" key="deferability">0</value>
9192 
                      <value type="string" key="indexType">INDEX</value>
9193 
                      <value type="int" key="isPrimary">0</value>
9194 
                      <value type="string" key="name">fk_geovalidation_geoplace2_idx</value>
9195 
                      <value type="int" key="unique">0</value>
9196 
                      <value type="string" key="oldName">fk_geovalidation_geoplace2</value>
9197 
                      <link type="object" struct-name="GrtObject" key="owner">245083fa-a763-11e2-aa10-080027bcf912</link>
9198 
                    </value>
9093 9199 
                  </value>
9094 9200 
                  <value type="string" key="maxRows"></value>
9095 9201 
                  <value type="string" key="mergeInsert"></value>
......
9121 9227 
                  <value type="int" key="commentedOut">0</value>
9122 9228 
                  <value type="string" key="createDate">2013-04-16 14:58</value>
9123 9229 
                  <value _ptr_="0xb2ac850" type="dict" key="customData"/>
9124 
                  <value type="string" key="lastChangeDate">2013-07-26 21:23</value>
9230 
                  <value type="string" key="lastChangeDate">2013-07-27 10:11</value>
9125 9231 
                  <value type="int" key="modelOnly">0</value>
9126 9232 
                  <value type="string" key="name">geovalidation</value>
9127 9233 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
11249 11355 
                <value type="int" key="visible">1</value>
11250 11356 
                <value type="string" key="name"></value>
11251 11357 
              </value>
11252 
              <value type="object" struct-name="workbench.physical.Connection" id="d16ec79e-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11253 
                <value type="string" key="caption">fk_geovalidation_validatable_place1</value>
11254 
                <value type="real" key="captionXOffs">0.e+00</value>
11255 
                <value type="real" key="captionYOffs">0.e+00</value>
11256 
                <value type="string" key="comment"></value>
11257 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11258 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11259 
                <value type="string" key="extraCaption"></value>
11260 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11261 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11262 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3c2be5be-a763-11e2-aa10-080027bcf912</link>
11263 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11264 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11265 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11266 
                <value type="int" key="drawSplit">0</value>
11267 
                <link type="object" struct-name="model.Figure" key="endFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
11268 
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
11269 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11270 
                <value type="int" key="visible">1</value>
11271 
                <value type="string" key="name"></value>
11272 
              </value>
11273 11358 
              <value type="object" struct-name="workbench.physical.Connection" id="d16f27d4-a7a0-11e2-b667-080027bcf912" struct-checksum="0x9baebc92">
11274 11359 
                <value type="string" key="caption">fk_place_observation_place1</value>
11275 11360 
                <value type="real" key="captionXOffs">0.e+00</value>
......
12467 12552 
                <value type="int" key="visible">1</value>
12468 12553 
                <value type="string" key="name"></value>
12469 12554 
              </value>
12555 
              <value type="object" struct-name="workbench.physical.Connection" id="329240cc-f6df-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12556 
                <value type="string" key="caption">fk_geovalidation_geoplace1</value>
12557 
                <value type="real" key="captionXOffs">0.e+00</value>
12558 
                <value type="real" key="captionYOffs">0.e+00</value>
12559 
                <value type="string" key="comment"></value>
12560 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12561 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12562 
                <value type="string" key="extraCaption"></value>
12563 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12564 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12565 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">3292225e-f6df-11e2-b6d1-080027bcf912</link>
12566 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12567 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12568 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12569 
                <value type="int" key="drawSplit">0</value>
12570 
                <link type="object" struct-name="model.Figure" key="endFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
12571 
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
12572 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12573 
                <value type="int" key="visible">1</value>
12574 
                <value type="string" key="name"></value>
12575 
              </value>
12576 
              <value type="object" struct-name="workbench.physical.Connection" id="08483dd4-f6e0-11e2-b6d1-080027bcf912" struct-checksum="0x9baebc92">
12577 
                <value type="string" key="caption">fk_geovalidation_geoplace2</value>
12578 
                <value type="real" key="captionXOffs">0.e+00</value>
12579 
                <value type="real" key="captionYOffs">0.e+00</value>
12580 
                <value type="string" key="comment"></value>
12581 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12582 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12583 
                <value type="string" key="extraCaption"></value>
12584 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12585 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12586 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">08481eda-f6e0-11e2-b6d1-080027bcf912</link>
12587 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12588 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12589 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12590 
                <value type="int" key="drawSplit">0</value>
12591 
                <link type="object" struct-name="model.Figure" key="endFigure">988D9E58-7324-4913-A132-BF8CAD6050C8</link>
12592 
                <link type="object" struct-name="model.Figure" key="startFigure">2450a09c-a763-11e2-aa10-080027bcf912</link>
12593 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12594 
                <value type="int" key="visible">1</value>
12595 
                <value type="string" key="name"></value>
12596 
              </value>
12470 12597 
            </value>
12471 12598 
            <value type="string" key="description"></value>
12472 12599 
            <value _ptr_="0xb2c2dd8" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
12536 12663 
                <value type="int" key="expanded">1</value>
12537 12664 
                <value type="real" key="height">1.e+02</value>
12538 12665 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12539 
                <value type="real" key="left">6.01e+02</value>
12666 
                <value type="real" key="left">4.18e+02</value>
12540 12667 
                <value type="int" key="locked">0</value>
12541 12668 
                <value type="int" key="manualSizing">0</value>
12542 
                <value type="real" key="top">5.7e+01</value>
12669 
                <value type="real" key="top">1.51e+02</value>
12543 12670 
                <value type="real" key="width">1.11e+02</value>
12544 12671 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12545 12672 
                <value type="int" key="visible">1</value>
......
12656 12783 
                <value type="int" key="expanded">1</value>
12657 12784 
                <value type="real" key="height">1.e+02</value>
12658 12785 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
12659 
                <value type="real" key="left">4.31e+02</value>
12786 
                <value type="real" key="left">4.23e+02</value>
12660 12787 
                <value type="int" key="locked">0</value>
12661 12788 
                <value type="int" key="manualSizing">0</value>
12662 
                <value type="real" key="top">1.1e+01</value>
12789 
                <value type="real" key="top">2.3e+01</value>
12663 12790 
                <value type="real" key="width">1.02e+02</value>
12664 12791 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12665 12792 
                <value type="int" key="visible">1</value>
......
13420 13547 
                <value type="int" key="triggersExpanded">0</value>
13421 13548 
                <value type="string" key="color">#ffcc33</value>
13422 13549 
                <value type="int" key="expanded">1</value>
13423 
                <value type="real" key="height">1.23e+02</value>
13550 
                <value type="real" key="height">1.69e+02</value>
13424 13551 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13425 
                <value type="real" key="left">4.12e+02</value>
13552 
                <value type="real" key="left">5.89e+02</value>
13426 13553 
                <value type="int" key="locked">0</value>
13427 13554 
                <value type="int" key="manualSizing">0</value>
13428 
                <value type="real" key="top">1.43e+02</value>
13555 
                <value type="real" key="top">2.e+01</value>
13429 13556 
                <value type="real" key="width">1.4e+02</value>
13430 13557 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13431 13558 
                <value type="int" key="visible">1</value>
......
13868 13995 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
13869 13996 
        <value _ptr_="0xb2394c0" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
13870 13997 
        <value _ptr_="0xaa26720" type="dict" key="syncProfiles">
13871 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="9e0096fa-f6db-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13872 
            <value _ptr_="0xc98c998" type="dict" key="lastKnownDBNames">
13998 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ef417d32-f6df-11e2-b6d1-080027bcf912" struct-checksum="0xc64972c2" key="">
13999 
            <value _ptr_="0xc16f6f8" type="dict" key="lastKnownDBNames">
13873 14000 
              <value type="string" key="049df920-a91b-11e2-bdec-080027bcf912">organization</value>
13874 14001 
              <value type="string" key="049dfc5e-a91b-11e2-bdec-080027bcf912">id</value>
13875 14002 
              <value type="string" key="049dff1a-a91b-11e2-bdec-080027bcf912">info</value>
......
13939 14066 
              <value type="string" key="2ed4c4d2-f680-11e2-aebb-080027bcf912">fk_taxon_determination_party_list1_idx</value>
13940 14067 
              <value type="string" key="2eedb6e2-a764-11e2-b6a9-080027bcf912">validatable_place_unique</value>
13941 14068 
              <value type="string" key="2f5fcbcc-a793-11e2-84c3-080027bcf912">observations</value>
14069 
              <value type="string" key="3292225e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1</value>
14070 
              <value type="string" key="3292247a-f6df-11e2-b6d1-080027bcf912">input_geoplace</value>
14071 
              <value type="string" key="329238b6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace1_idx</value>
14072 
              <value type="string" key="35cce59e-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2</value>
14073 
              <value type="string" key="35cce77e-f6df-11e2-b6d1-080027bcf912">scrubbed_geoplace</value>
14074 
              <value type="string" key="35ccfbf6-f6df-11e2-b6d1-080027bcf912">fk_geovalidation_geoplace2_idx</value>
13942 14075 
              <value type="string" key="3730d234-a7ab-11e2-8ba6-080027bcf912">voucher</value>
13943 14076 
              <value type="string" key="3bc7bb2e-f6d8-11e2-b6d1-080027bcf912">coords</value>
13944 
              <value type="string" key="3c2be5be-a763-11e2-aa10-080027bcf912">fk_geovalidation_validatable_place1</value>
13945 14077 
              <value type="string" key="3d9b10bc-a7a1-11e2-b667-080027bcf912">taxon_determination</value>
13946 14078 
              <value type="string" key="3d9b13d2-a7a1-11e2-b667-080027bcf912">id</value>
13947 14079 
              <value type="string" key="3d9b17ba-a7a1-11e2-b667-080027bcf912">taxon_assertion</value>
......
13951 14083 
              <value type="string" key="3d9b26c4-a7a1-11e2-b667-080027bcf912">PRIMARY</value>
13952 14084 
              <value type="string" key="3d9b2d86-a7a1-11e2-b667-080027bcf912">taxon_determination_unique</value>
13953 14085 
              <value type="string" key="3d9b3600-a7a1-11e2-b667-080027bcf912">fk_taxon_occurrence_has_qualified_taxon1</value>
13954 
              <value type="string" key="3d9b3790-a7a1-11e2-b667-080027bcf912">fk_taxon_determination_record1</value>
13955 14086 
              <value type="string" key="4001ec92-f678-11e2-9716-080027bcf912">party_list</value>
13956 14087 
              <value type="string" key="4001ef9e-f678-11e2-9716-080027bcf912">id</value>
13957 14088 
              <value type="string" key="4001f296-f678-11e2-9716-080027bcf912">count</value>
......
13989 14120 
              <value type="string" key="489c3d40-a6ea-11e2-98a6-080027bcf912">PRIMARY</value>
13990 14121 
              <value type="string" key="489c402e-a6ea-11e2-98a6-080027bcf912">fk_derived_class_base_class1</value>
13991 14122 
              <value type="string" key="48af0dca-a795-11e2-84c3-080027bcf912">slope_direction_deg_N</value>
14123 
              <value type="string" key="4a62f766-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_taxon_observation1</value>
14124 
              <value type="string" key="4a62f964-f6dd-11e2-b6d1-080027bcf912">taxon_observation</value>
14125 
              <value type="string" key="4a630f80-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_taxon_observation1_idx</value>
13992 14126 
              <value type="string" key="4c32a89c-a76a-11e2-92a3-080027bcf912">match_score</value>
13993 14127 
              <value type="string" key="4c3ffc96-a741-11e2-9fbf-080027bcf912">taxon_string</value>
13994 14128 
              <value type="string" key="4c40001a-a741-11e2-9fbf-080027bcf912">string</value>
......
13999 14133 
              <value type="string" key="54dd4bd4-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1</value>
14000 14134 
              <value type="string" key="54dd4d82-f67d-11e2-aebb-080027bcf912">specimenholder_institutions</value>
14001 14135 
              <value type="string" key="54dd6466-f67d-11e2-aebb-080027bcf912">fk_specimen_party_list1_idx</value>
14136 
              <value type="string" key="55756896-f6dd-11e2-b6d1-080027bcf912">fk_taxon_determination_sampling_event1</value>
14002 14137 
              <value type="string" key="565fd9e8-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1</value>
14003 14138 
              <value type="string" key="565fe000-a7ab-11e2-8ba6-080027bcf912">fk_taxon_observation_specimen1_idx</value>
14004 14139 
              <value type="string" key="57512c00-ac86-11e2-aa54-080027bcf912">PRIMARY</value>
......
14380 14515 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14381 14516 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14382 14517 
      <value type="string" key="caption">New Model</value>
14383 
      <value type="string" key="dateChanged">2013-07-27 09:58</value>
14518 
      <value type="string" key="dateChanged">2013-07-27 10:14</value>
14384 14519 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14385 14520 
      <value type="string" key="description"></value>
14386 14521 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
260 260 
/*!40101 SET character_set_client = utf8 */;
261 261 
CREATE TABLE `geovalidation` (
262 262 
  `id` varbinary(767) NOT NULL,
263 
  `input_geoplace` varbinary(767) NOT NULL,
264 
  `scrubbed_geoplace` varbinary(767) NOT NULL,
263 265 
  `geovalid` tinyint(1) NOT NULL,
264 266 
  `lat_long_domain_valid` tinyint(1) NOT NULL,
265 267 
  `lat_long_in_place_ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,
266 268 
  PRIMARY KEY (`id`),
267 
  CONSTRAINT `fk_geovalidation_validatable_place1` FOREIGN KEY (`id`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
269 
  KEY `fk_geovalidation_geoplace1_idx` (`input_geoplace`),
270 
  KEY `fk_geovalidation_geoplace2_idx` (`scrubbed_geoplace`),
271 
  CONSTRAINT `fk_geovalidation_geoplace1` FOREIGN KEY (`input_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
272 
  CONSTRAINT `fk_geovalidation_geoplace2` FOREIGN KEY (`scrubbed_geoplace`) REFERENCES `geoplace` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
268 273 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]';
269 274 
/*!40101 SET character_set_client = @saved_cs_client */;
270 275 

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





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


  		




  263
  263
  
    
CREATE TABLE "geovalidation" (


  		




  264
  264
  
    
  "id" text NOT NULL,


  		




  
  265
  
    
  "input_geoplace" text NOT NULL,


  		




  
  266
  
    
  "scrubbed_geoplace" text NOT NULL,


  		




  265
  267
  
    
  "geovalid" integer NOT NULL,


  		




  266
  268
  
    
  "lat_long_domain_valid" integer NOT NULL,


  		




  267
  269
  
    
  "lat_long_in_place_ranks" hstore DEFAULT NULL,


  		




  268
  270
  
    
  PRIMARY KEY ("id"),


  		




  269
  
  
    
  /*CONSTRAINT "fk_geovalidation_validatable_place1" FOREIGN KEY ("id") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  271
  
    
  /*KEY "fk_geovalidation_geoplace1_idx" ("input_geoplace")*/CHECK (true),


  		




  
  272
  
    
  /*KEY "fk_geovalidation_geoplace2_idx" ("scrubbed_geoplace")*/CHECK (true),


  		




  
  273
  
    
  /*CONSTRAINT "fk_geovalidation_geoplace1" FOREIGN KEY ("input_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  274
  
    
  /*CONSTRAINT "fk_geovalidation_geoplace2" FOREIGN KEY ("scrubbed_geoplace") REFERENCES "geoplace" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  270
  275
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='The accuracy of the [[VegCore#Coordinates|Coordinates]], taking into account the [[VegCore#Placename|Placename]]'*/;


  		




  271
  276
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  272
  277
  
    

  		












Also available in:  Unified diff