Project

General

Profile

« Previous | Next » 

Revision 10496

Added by Aaron Marcuse-Kubitza almost 11 years ago

schemas/VegCore/VegCore.ERD.mwb: taxon_path: converted to an auxiliary table of taxon_name instead of a subclass of it (like geopath for the place table). this causes distinct taxon_paths to be stored only once, instead of repeatedly for each taxon_name.

View differences:

schemas/VegCore/document.mwb.xml
1215 1215 
                      <value type="string" key="oldName">rank</value>
1216 1216 
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1217 1217 
                    </value>
1218 
                    <value type="object" struct-name="db.mysql.Column" id="11b489bc-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x783b5183">
1219 
                      <value type="int" key="autoIncrement">0</value>
1220 
                      <value type="string" key="characterSetName"></value>
1221 
                      <value _ptr_="0xb46e338" type="list" content-type="object" content-struct-name="db.CheckConstraint" key="checks"/>
1222 
                      <value type="string" key="collationName"></value>
1223 
                      <value type="string" key="datatypeExplicitParams"></value>
1224 
                      <value type="string" key="defaultValue"></value>
1225 
                      <value type="int" key="defaultValueIsNull">1</value>
1226 
                      <value _ptr_="0xb841288" type="list" content-type="string" key="flags"/>
1227 
                      <value type="int" key="isNotNull">0</value>
1228 
                      <value type="int" key="length">767</value>
1229 
                      <value type="int" key="precision">-1</value>
1230 
                      <value type="int" key="scale">-1</value>
1231 
                      <link type="object" struct-name="db.SimpleDatatype" key="simpleType">com.mysql.rdbms.mysql.datatype.varbinary</link>
1232 
                      <value type="string" key="comment"></value>
1233 
                      <value type="string" key="name">taxon_path</value>
1234 
                      <value type="string" key="oldName">taxon_path</value>
1235 
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1236 
                    </value>
1218 1237 
                  </value>
1219 1238 
                  <value type="string" key="connectionString"></value>
1220 1239 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
......
1263 1282 
                      <value type="string" key="name">fk_taxon_concept_taxon_string10</value>
1264 1283 
                      <value type="string" key="oldName">fk_taxon_concept_taxon_string10</value>
1265 1284 
                    </value>
1285 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="11b487b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x70a8fc40">
1286 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f2f28-a780-11e2-afd5-080027bcf912</link>
1287 
                      <value _ptr_="0xa0b59a8" type="list" content-type="object" content-struct-name="db.Column" key="columns">
1288 
                        <link type="object">11b489bc-f97f-11e2-8a2e-080027bcf912</link>
1289 
                      </value>
1290 
                      <value type="int" key="deferability">0</value>
1291 
                      <value type="string" key="deleteRule">CASCADE</value>
1292 
                      <link type="object" struct-name="db.Index" key="index">11b49e5c-f97f-11e2-8a2e-080027bcf912</link>
1293 
                      <value type="int" key="mandatory">1</value>
1294 
                      <value type="int" key="many">1</value>
1295 
                      <value type="int" key="modelOnly">0</value>
1296 
                      <link type="object" struct-name="db.Table" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1297 
                      <value _ptr_="0xbdbb600" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
1298 
                        <link type="object">687f31c6-a780-11e2-afd5-080027bcf912</link>
1299 
                      </value>
1300 
                      <value type="int" key="referencedMandatory">0</value>
1301 
                      <value type="string" key="updateRule">CASCADE</value>
1302 
                      <value type="string" key="comment"></value>
1303 
                      <value type="string" key="name">fk_taxon_name_taxon_path1</value>
1304 
                      <value type="string" key="oldName">fk_taxon_name_taxon_path1</value>
1305 
                    </value>
1266 1306 
                  </value>
1267 1307 
                  <value _ptr_="0xab94fb0" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
1268 1308 
                    <value type="object" struct-name="db.mysql.Index" id="687f1f92-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
......
1311 1351 
                      <value type="string" key="oldName">fk_taxon_concept_taxon_string10_idx</value>
1312 1352 
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1313 1353 
                    </value>
1354 
                    <value type="object" struct-name="db.mysql.Index" id="11b49e5c-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x309b847a">
1355 
                      <value _ptr_="0xb533380" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
1356 
                        <value type="object" struct-name="db.mysql.IndexColumn" id="11b4a000-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x62630b3c">
1357 
                          <value type="int" key="columnLength">0</value>
1358 
                          <value type="string" key="comment"></value>
1359 
                          <value type="int" key="descend">0</value>
1360 
                          <link type="object" struct-name="db.Column" key="referencedColumn">11b489bc-f97f-11e2-8a2e-080027bcf912</link>
1361 
                          <value type="string" key="name"></value>
1362 
                          <link type="object" struct-name="GrtObject" key="owner">11b49e5c-f97f-11e2-8a2e-080027bcf912</link>
1363 
                        </value>
1364 
                      </value>
1365 
                      <value type="string" key="indexKind"></value>
1366 
                      <value type="int" key="keyBlockSize">0</value>
1367 
                      <value type="string" key="withParser"></value>
1368 
                      <value type="string" key="comment"></value>
1369 
                      <value type="int" key="deferability">0</value>
1370 
                      <value type="string" key="indexType">INDEX</value>
1371 
                      <value type="int" key="isPrimary">0</value>
1372 
                      <value type="string" key="name">fk_taxon_name_taxon_path1_idx</value>
1373 
                      <value type="int" key="unique">0</value>
1374 
                      <value type="string" key="oldName">fk_taxon_name_taxon_path1_idx</value>
1375 
                      <link type="object" struct-name="GrtObject" key="owner">687f12b8-a780-11e2-afd5-080027bcf912</link>
1376 
                    </value>
1314 1377 
                  </value>
1315 1378 
                  <value type="string" key="maxRows"></value>
1316 1379 
                  <value type="string" key="mergeInsert"></value>
......
1342 1405 
                  <value type="int" key="commentedOut">0</value>
1343 1406 
                  <value type="string" key="createDate">2013-04-17 10:01</value>
1344 1407 
                  <value _ptr_="0xa229018" type="dict" key="customData"/>
1345 
                  <value type="string" key="lastChangeDate">2013-04-17 14:17</value>
1408 
                  <value type="string" key="lastChangeDate">2013-07-30 18:20</value>
1346 1409 
                  <value type="int" key="modelOnly">0</value>
1347 1410 
                  <value type="string" key="name">taxon_name</value>
1348 1411 
                  <link type="object" struct-name="GrtNamedObject" key="owner">be8cb246-a6e0-11e2-95e9-080027bcf912</link>
......
9099 9162 
                  <value type="string" key="defaultCharacterSetName">utf8</value>
9100 9163 
                  <value type="string" key="defaultCollationName">utf8_bin</value>
9101 9164 
                  <value type="int" key="delayKeyWrite">0</value>
9102 
                  <value _ptr_="0xabfabe0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys">
9103 
                    <value type="object" struct-name="db.mysql.ForeignKey" id="687f3e3c-a780-11e2-afd5-080027bcf912" struct-checksum="0x70a8fc40">
9104 
                      <link type="object" struct-name="db.mysql.Table" key="referencedTable">687f12b8-a780-11e2-afd5-080027bcf912</link>
9105 
                      <value _ptr_="0xabfc678" type="list" content-type="object" content-struct-name="db.Column" key="columns">
9106 
                        <link type="object">687f31c6-a780-11e2-afd5-080027bcf912</link>
9107 
                      </value>
9108 
                      <value type="int" key="deferability">0</value>
9109 
                      <value type="string" key="deleteRule">CASCADE</value>
9110 
                      <link type="object" struct-name="db.Index" key="index">687f3ae0-a780-11e2-afd5-080027bcf912</link>
9111 
                      <value type="int" key="mandatory">0</value>
9112 
                      <value type="int" key="many">0</value>
9113 
                      <value type="int" key="modelOnly">0</value>
9114 
                      <link type="object" struct-name="db.Table" key="owner">687f2f28-a780-11e2-afd5-080027bcf912</link>
9115 
                      <value _ptr_="0xabfc9e0" type="list" content-type="object" content-struct-name="db.Column" key="referencedColumns">
9116 
                        <link type="object">687f1542-a780-11e2-afd5-080027bcf912</link>
9117 
                      </value>
9118 
                      <value type="int" key="referencedMandatory">1</value>
9119 
                      <value type="string" key="updateRule">CASCADE</value>
9120 
                      <value type="string" key="comment"></value>
9121 
                      <value type="string" key="name">fk_taxon_path_taxon_name1</value>
9122 
                      <value type="string" key="oldName">fk_taxon_path_taxon_name1</value>
9123 
                    </value>
9124 
                  </value>
9165 
                  <value _ptr_="0xabfabe0" type="list" content-type="object" content-struct-name="db.mysql.ForeignKey" key="foreignKeys"/>
9125 9166 
                  <value _ptr_="0xabfac30" type="list" content-type="object" content-struct-name="db.mysql.Index" key="indices">
9126 9167 
                    <value type="object" struct-name="db.mysql.Index" id="687f3ae0-a780-11e2-afd5-080027bcf912" struct-checksum="0x309b847a">
9127 9168 
                      <value _ptr_="0xabfca70" type="list" content-type="object" content-struct-name="db.mysql.IndexColumn" key="columns">
......
11121 11162 
                <value type="int" key="visible">1</value>
11122 11163 
                <value type="string" key="name"></value>
11123 11164 
              </value>
11124 
              <value type="object" struct-name="workbench.physical.Connection" id="81793906-a780-11e2-9f99-080027bcf912" struct-checksum="0x9baebc92">
11125 
                <value type="string" key="caption">fk_taxon_path_taxon_name1</value>
11126 
                <value type="real" key="captionXOffs">0.e+00</value>
11127 
                <value type="real" key="captionYOffs">0.e+00</value>
11128 
                <value type="string" key="comment"></value>
11129 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
11130 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
11131 
                <value type="string" key="extraCaption"></value>
11132 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
11133 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
11134 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">687f3e3c-a780-11e2-afd5-080027bcf912</link>
11135 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
11136 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
11137 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
11138 
                <value type="int" key="drawSplit">0</value>
11139 
                <link type="object" struct-name="model.Figure" key="endFigure">00ee9e8a-a775-11e2-92a3-080027bcf912</link>
11140 
                <link type="object" struct-name="model.Figure" key="startFigure">81792d3a-a780-11e2-9f99-080027bcf912</link>
11141 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
11142 
                <value type="int" key="visible">1</value>
11143 
                <value type="string" key="name"></value>
11144 
              </value>
11145 11165 
              <value type="object" struct-name="workbench.physical.Connection" id="b8ce52c6-a797-11e2-8681-080027bcf912" struct-checksum="0x9baebc92">
11146 11166 
                <value type="string" key="caption">fk_stem_individual2</value>
11147 11167 
                <value type="real" key="captionXOffs">0.e+00</value>
......
12633 12653 
                <value type="int" key="visible">1</value>
12634 12654 
                <value type="string" key="name"></value>
12635 12655 
              </value>
12656 
              <value type="object" struct-name="workbench.physical.Connection" id="11b4a668-f97f-11e2-8a2e-080027bcf912" struct-checksum="0x9baebc92">
12657 
                <value type="string" key="caption">fk_taxon_name_taxon_path1</value>
12658 
                <value type="real" key="captionXOffs">0.e+00</value>
12659 
                <value type="real" key="captionYOffs">0.e+00</value>
12660 
                <value type="string" key="comment"></value>
12661 
                <value type="real" key="endCaptionXOffs">0.e+00</value>
12662 
                <value type="real" key="endCaptionYOffs">0.e+00</value>
12663 
                <value type="string" key="extraCaption"></value>
12664 
                <value type="real" key="extraCaptionXOffs">0.e+00</value>
12665 
                <value type="real" key="extraCaptionYOffs">0.e+00</value>
12666 
                <link type="object" struct-name="db.ForeignKey" key="foreignKey">11b487b4-f97f-11e2-8a2e-080027bcf912</link>
12667 
                <value type="real" key="middleSegmentOffset">0.e+00</value>
12668 
                <value type="real" key="startCaptionXOffs">0.e+00</value>
12669 
                <value type="real" key="startCaptionYOffs">0.e+00</value>
12670 
                <value type="int" key="drawSplit">0</value>
12671 
                <link type="object" struct-name="model.Figure" key="endFigure">81792d3a-a780-11e2-9f99-080027bcf912</link>
12672 
                <link type="object" struct-name="model.Figure" key="startFigure">00ee9e8a-a775-11e2-92a3-080027bcf912</link>
12673 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
12674 
                <value type="int" key="visible">1</value>
12675 
                <value type="string" key="name"></value>
12676 
              </value>
12636 12677 
            </value>
12637 12678 
            <value type="string" key="description"></value>
12638 12679 
            <value _ptr_="0xac124f0" type="list" content-type="object" content-struct-name="model.Figure" key="figures">
......
13606 13647 
                <value type="int" key="triggersExpanded">0</value>
13607 13648 
                <value type="string" key="color">#00ee00</value>
13608 13649 
                <value type="int" key="expanded">1</value>
13609 
                <value type="real" key="height">1.92e+02</value>
13650 
                <value type="real" key="height">2.15e+02</value>
13610 13651 
                <link type="object" struct-name="model.Layer" key="layer">88F9E582-B992-43CC-B7D6-A42E190DCB13</link>
13611 13652 
                <value type="real" key="left">1.358e+03</value>
13612 13653 
                <value type="int" key="locked">0</value>
13613 13654 
                <value type="int" key="manualSizing">0</value>
13614 
                <value type="real" key="top">8.73e+02</value>
13655 
                <value type="real" key="top">8.55e+02</value>
13615 13656 
                <value type="real" key="width">1.2e+02</value>
13616 13657 
                <link type="object" struct-name="model.Diagram" key="owner">3915EB3C-D507-4518-BE3A-63A8D8DD4471</link>
13617 13658 
                <value type="int" key="visible">1</value>
......
14058 14099 
              <value type="int" key="visible">1</value>
14059 14100 
              <value type="string" key="name"></value>
14060 14101 
            </value>
14061 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection">
14062 
              <link type="object">2EDCE9EA-B246-4F71-9D67-BD04855202B6</link>
14063 
            </value>
14102 
            <value _ptr_="0xac125c8" type="list" content-type="object" content-struct-name="model.Object" key="selection"/>
14064 14103 
            <value type="int" key="updateBlocked">0</value>
14065 14104 
            <value type="real" key="width">1.6215e+03</value>
14066 14105 
            <value type="real" key="x">0.e+00</value>
......
14073 14112 
        <link type="object" struct-name="db.mgmt.Rdbms" key="rdbms">com.mysql.rdbms.mysql</link>
14074 14113 
        <value _ptr_="0xab85450" type="list" content-type="object" content-struct-name="db.Script" key="scripts"/>
14075 14114 
        <value _ptr_="0xa229c20" type="dict" key="syncProfiles">
14076 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="ad61dd36-f97c-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14077 
            <value _ptr_="0xb93d320" type="dict" key="lastKnownDBNames">
14115 
          <value type="object" struct-name="db.mgmt.SyncProfile" id="994875b4-f97f-11e2-8a2e-080027bcf912" struct-checksum="0xc64972c2" key="">
14116 
            <value _ptr_="0xbe90000" type="dict" key="lastKnownDBNames">
14078 14117 
              <value type="string" key="01b2e3fe-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1</value>
14079 14118 
              <value type="string" key="01b2e606-f6ed-11e2-9cf1-080027bcf912">georeferenced_by</value>
14080 14119 
              <value type="string" key="01b2fe70-f6ed-11e2-9cf1-080027bcf912">fk_georeferencing_party_list1_idx</value>
......
14094 14133 
              <value type="string" key="0ab99696-a7a1-11e2-b667-080027bcf912">fk_individual_observation_taxon_occurrence1</value>
14095 14134 
              <value type="string" key="0ab99812-a7a1-11e2-b667-080027bcf912">fk_individual_observation_individual1</value>
14096 14135 
              <value type="string" key="110c72d2-a73f-11e2-9fbf-080027bcf912">stem_observation_unique</value>
14136 
              <value type="string" key="11b487b4-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1</value>
14137 
              <value type="string" key="11b489bc-f97f-11e2-8a2e-080027bcf912">taxon_path</value>
14138 
              <value type="string" key="11b49e5c-f97f-11e2-8a2e-080027bcf912">fk_taxon_name_taxon_path1_idx</value>
14097 14139 
              <value type="string" key="11c10cc8-a90c-11e2-8576-080027bcf912">source_unique</value>
14098 14140 
              <value type="string" key="16537a20-a7a7-11e2-8ba6-080027bcf912">taxon_observation</value>
14099 14141 
              <value type="string" key="16537d54-a7a7-11e2-8ba6-080027bcf912">id</value>
......
14118 14160 
              <value type="string" key="18328be4-a77d-11e2-afd5-080027bcf912">fk_taxon_concept_taxon_name1</value>
14119 14161 
              <value type="string" key="184d9a4a-a793-11e2-84c3-080027bcf912">observations</value>
14120 14162 
              <value type="string" key="18e739f0-a91b-11e2-bdec-080027bcf912">fk_organization_party1</value>
14121 
              <value type="string" key="1a652744-f6da-11e2-b6d1-080027bcf912">geocoords_unique</value>
14122 14163 
              <value type="string" key="1c952e1c-a791-11e2-84c3-080027bcf912">y_m</value>
14123 14164 
              <value type="string" key="1cc7051e-f6be-11e2-af44-080027bcf912">fk_aggregate_observation_taxon_presence1</value>
14124 14165 
              <value type="string" key="21b40060-f680-11e2-aebb-080027bcf912">fk_taxon_observation_party_list1</value>
......
14239 14280 
              <value type="string" key="687f3752-a780-11e2-afd5-080027bcf912">specific_epithet</value>
14240 14281 
              <value type="string" key="687f3900-a780-11e2-afd5-080027bcf912">ranks</value>
14241 14282 
              <value type="string" key="687f3ae0-a780-11e2-afd5-080027bcf912">PRIMARY</value>
14242 
              <value type="string" key="687f3e3c-a780-11e2-afd5-080027bcf912">fk_taxon_path_taxon_name1</value>
14243 14283 
              <value type="string" key="69b7c87c-f970-11e2-9f36-080027bcf912">fk_nested_geoplace_geoplace1</value>
14244 14284 
              <value type="string" key="6b43aacc-f979-11e2-9f36-080027bcf912">fk_place_geopath1</value>
14245 14285 
              <value type="string" key="6b43ac84-f979-11e2-9f36-080027bcf912">geopath</value>
......
14595 14635 
    <value type="object" struct-name="app.DocumentInfo" id="BEE3982F-55A1-4B2C-914A-CD6953803AB9" struct-checksum="0xbba780b8" key="info">
14596 14636 
      <value type="string" key="author">Aaron Marcuse-Kubitza</value>
14597 14637 
      <value type="string" key="caption">New Model</value>
14598 
      <value type="string" key="dateChanged">2013-07-30 18:12</value>
14638 
      <value type="string" key="dateChanged">2013-07-30 18:22</value>
14599 14639 
      <value type="string" key="dateCreated">2012-01-19 14:06</value>
14600 14640 
      <value type="string" key="description"></value>
14601 14641 
      <value type="string" key="project">Name of the project</value>
schemas/VegCore/VegCore.my.sql
1041 1041 
  `author` varbinary(767) DEFAULT NULL,
1042 1042 
  `common_name` varbinary(767) DEFAULT NULL,
1043 1043 
  `rank` varbinary(767) DEFAULT NULL,
1044 
  `taxon_path` varbinary(767) DEFAULT NULL,
1044 1045 
  PRIMARY KEY (`id`),
1045 1046 
  KEY `fk_taxon_concept_taxon_string10_idx` (`unique_name`),
1047 
  KEY `fk_taxon_name_taxon_path1_idx` (`taxon_path`),
1046 1048 
  CONSTRAINT `fk_taxon_record10` FOREIGN KEY (`id`) REFERENCES `record` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1047 
  CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE
1049 
  CONSTRAINT `fk_taxon_concept_taxon_string10` FOREIGN KEY (`unique_name`) REFERENCES `taxon_string` (`string`) ON DELETE CASCADE ON UPDATE CASCADE,
1050 
  CONSTRAINT `fk_taxon_name_taxon_path1` FOREIGN KEY (`taxon_path`) REFERENCES `taxon_path` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
1048 1051 
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1049 1052 
/*!40101 SET character_set_client = @saved_cs_client */;
1050 1053 

  		




  ......




  1097
  1100
  
    
  `genus` varbinary(767) DEFAULT NULL,


  		




  1098
  1101
  
    
  `specific_epithet` varbinary(767) DEFAULT NULL,


  		




  1099
  1102
  
    
  `ranks` set('hstore') COLLATE utf8_bin DEFAULT NULL,


  		




  1100
  
  
    
  PRIMARY KEY (`id`),


  		




  1101
  
  
    
  CONSTRAINT `fk_taxon_path_taxon_name1` FOREIGN KEY (`id`) REFERENCES `taxon_name` (`id`) ON DELETE CASCADE ON UPDATE CASCADE


  		




  
  1103
  
    
  PRIMARY KEY (`id`)


  		




  1102
  1104
  
    
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"a group of one (or more) populations of organism(s), which a taxonomist adjudges to be a unit" ("Wikipedia":http://en.wikipedia.org/wiki/Taxon)';


  		




  1103
  1105
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1104
  1106
  
    

  		












  

    
      schemas/VegCore/VegCore.pg.sql
    
  





  1043
  1043
  
    
  "author" text DEFAULT NULL,


  		




  1044
  1044
  
    
  "common_name" text DEFAULT NULL,


  		




  1045
  1045
  
    
  "rank" text DEFAULT NULL,


  		




  
  1046
  
    
  "taxon_path" text DEFAULT NULL,


  		




  1046
  1047
  
    
  PRIMARY KEY ("id"),


  		




  1047
  1048
  
    
  /*KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name")*/CHECK (true),


  		




  
  1049
  
    
  /*KEY "fk_taxon_name_taxon_path1_idx" ("taxon_path")*/CHECK (true),


  		




  1048
  1050
  
    
  /*CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  1049
  
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1051
  
    
  /*CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true),


  		




  
  1052
  
    
  /*CONSTRAINT "fk_taxon_name_taxon_path1" FOREIGN KEY ("taxon_path") REFERENCES "taxon_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  1050
  1053
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin*/;


  		




  1051
  1054
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1052
  1055
  
    

  		




  ......




  1099
  1102
  
    
  "genus" text DEFAULT NULL,


  		




  1100
  1103
  
    
  "specific_epithet" text DEFAULT NULL,


  		




  1101
  1104
  
    
  "ranks" hstore DEFAULT NULL,


  		




  1102
  
  
    
  PRIMARY KEY ("id"),


  		




  1103
  
  
    
  /*CONSTRAINT "fk_taxon_path_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE*/CHECK (true)


  		




  
  1105
  
    
  PRIMARY KEY ("id")


  		




  1104
  1106
  
    
) /*ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='"a group of one (or more) populations of organism(s), which a taxonomist adjudges to be a unit" ("Wikipedia":http://en.wikipedia.org/wiki/Taxon)'*/;


  		




  1105
  1107
  
    
/*!40101 SET character_set_client = @saved_cs_client */;


  		




  1106
  1108
  
    

  		












Also available in:  Unified diff