Geodb intdata: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
(Definition)
 
(5 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 417: Zeile 417:
 
</table>
 
</table>
  
<code sql>
+
==Definition==
 +
 
 +
<syntaxhighlight lang="mysql">
 
   CREATE TABLE `geodb_hierarchies` (
 
   CREATE TABLE `geodb_hierarchies` (
 
   `loc_id` int(11) NOT NULL,
 
   `loc_id` int(11) NOT NULL,
Zeile 449: Zeile 451:
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
</code>
+
</syntaxhighlight>
 +
 
 +
==Beispieldatensätze==
 +
<table {{prettytable}}>
 +
  <tr>
 +
    <th>loc_id</th>
 +
    <th>int_val</th>
 +
    <th>int_type</th>
 +
    <th>int_subtype</th>
 +
    <th>valid_since</th>
 +
    <th>date_type_since</th>
 +
    <th>valid_until</th>
 +
    <th>date_type_until</th>
 +
  </tr>
 +
  <tr>
 +
    <td>19544&nbsp;</td>
 +
    <td>15594&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>2001-12-31&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
    <td>2001-12-31&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14755&nbsp;</td>
 +
    <td>311303&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>2003-06-30&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
    <td>2003-06-30&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13929&nbsp;</td>
 +
    <td>52763&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>2003-06-30&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
    <td>2003-06-30&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16601&nbsp;</td>
 +
    <td>649933&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>2002-12-31&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
    <td>2002-12-31&nbsp;</td>
 +
    <td>300100000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13352&nbsp;</td>
 +
    <td>245778&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13353&nbsp;</td>
 +
    <td>66559&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13558&nbsp;</td>
 +
    <td>40559&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13649&nbsp;</td>
 +
    <td>44217&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13735&nbsp;</td>
 +
    <td>77396&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13756&nbsp;</td>
 +
    <td>68361&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13795&nbsp;</td>
 +
    <td>19124&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13810&nbsp;</td>
 +
    <td>257836&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13902&nbsp;</td>
 +
    <td>53084&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13943&nbsp;</td>
 +
    <td>43265&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13961&nbsp;</td>
 +
    <td>30459&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>13965&nbsp;</td>
 +
    <td>49850&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14072&nbsp;</td>
 +
    <td>69396&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14163&nbsp;</td>
 +
    <td>42688&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14170&nbsp;</td>
 +
    <td>74519&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14356&nbsp;</td>
 +
    <td>3388434&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14477&nbsp;</td>
 +
    <td>323373&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14632&nbsp;</td>
 +
    <td>72701&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14755&nbsp;</td>
 +
    <td>306016&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14871&nbsp;</td>
 +
    <td>245516&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14937&nbsp;</td>
 +
    <td>540950&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>14938&nbsp;</td>
 +
    <td>118701&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15118&nbsp;</td>
 +
    <td>28771&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15288&nbsp;</td>
 +
    <td>71949&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15292&nbsp;</td>
 +
    <td>255798&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15311&nbsp;</td>
 +
    <td>42798&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15331&nbsp;</td>
 +
    <td>105954&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15358&nbsp;</td>
 +
    <td>53168&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15443&nbsp;</td>
 +
    <td>138457&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15535&nbsp;</td>
 +
    <td>80965&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15539&nbsp;</td>
 +
    <td>73771&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15626&nbsp;</td>
 +
    <td>25017&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15827&nbsp;</td>
 +
    <td>478631&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15868&nbsp;</td>
 +
    <td>92292&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>15879&nbsp;</td>
 +
    <td>570765&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16069&nbsp;</td>
 +
    <td>44242&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16077&nbsp;</td>
 +
    <td>40180&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16172&nbsp;</td>
 +
    <td>51185&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16263&nbsp;</td>
 +
    <td>200126&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16348&nbsp;</td>
 +
    <td>591889&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16394&nbsp;</td>
 +
    <td>54047&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16534&nbsp;</td>
 +
    <td>84480&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16602&nbsp;</td>
 +
    <td>70308&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16630&nbsp;</td>
 +
    <td>45228&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16713&nbsp;</td>
 +
    <td>57538&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
  <tr>
 +
    <td>16772&nbsp;</td>
 +
    <td>62819&nbsp;</td>
 +
    <td>600700000&nbsp;</td>
 +
    <td>650700002&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>&nbsp;</td>
 +
    <td>3000-01-01&nbsp;</td>
 +
    <td>300600000&nbsp;</td>
 +
  </tr>
 +
</table>
 +
 
 +
[[Kategorie:Datenbank]]

Aktuelle Version vom 3. Januar 2012, 03:47 Uhr

Fields

PK Name Data type Size Precision Values Default Auto Increment Binary Not null Unsigned Zero Fill Unique
loc_id INTEGER 11 0 Yes.gif
level INTEGER 11 0 Yes.gif
id_lvl1 INTEGER 11 0 Yes.gif
id_lvl2 INTEGER 11 0
id_lvl3 INTEGER 11 0
id_lvl4 INTEGER 11 0
id_lvl5 INTEGER 11 0
id_lvl6 INTEGER 11 0
id_lvl7 INTEGER 11 0
id_lvl8 INTEGER 11 0
id_lvl9 INTEGER 11 0
valid_since DATE 0 0
date_type_since INTEGER 11 0
valid_until DATE 0 0 Yes.gif
date_type_until INTEGER 11 0 Yes.gif

Indices

Name Fields Unique Collation Full Text
hierarchy_loc_id_idx loc_id Ascending
hierarchy_level_idx level Ascending
hierarchy_lvl1_idx id_lvl1 Ascending
hierarchy_lvl2_idx id_lvl2 Ascending
hierarchy_lvl3_idx id_lvl3 Ascending
hierarchy_lvl4_idx id_lvl4 Ascending
hierarchy_lvl5_idx id_lvl5 Ascending
hierarchy_lvl6_idx id_lvl6 Ascending
hierarchy_lvl7_idx id_lvl7 Ascending
hierarchy_lvl8_idx id_lvl8 Ascending
hierarchy_lvl9_idx id_lvl9 Ascending
hierarchy_since_idx valid_since Ascending
hierarchy_until_idx valid_until Ascending

Foreign Keys

There are no foreign keys for table geodb_hierarchies

Triggers

There are no triggers for table geodb_hierarchies

Options

TransactSafe TableType Row Format Check Sum Delay Key Write Pack Keys Temporary Min Rows Max Rows Union
Yes.gif InnoDB Ascending 0 0

Definition

  CREATE TABLE `geodb_hierarchies` (
  `loc_id` int(11) NOT NULL,
  `level` int(11) NOT NULL,
  `id_lvl1` int(11) NOT NULL,
  `id_lvl2` int(11) default NULL,
  `id_lvl3` int(11) default NULL,
  `id_lvl4` int(11) default NULL,
  `id_lvl5` int(11) default NULL,
  `id_lvl6` int(11) default NULL,
  `id_lvl7` int(11) default NULL,
  `id_lvl8` int(11) default NULL,
  `id_lvl9` int(11) default NULL,
  `valid_since` date default NULL,
  `date_type_since` int(11) default NULL,
  `valid_until` date NOT NULL,
  `date_type_until` int(11) NOT NULL,
  KEY `hierarchy_loc_id_idx` (`loc_id`),
  KEY `hierarchy_level_idx` (`level`),
  KEY `hierarchy_lvl1_idx` (`id_lvl1`),
  KEY `hierarchy_lvl2_idx` (`id_lvl2`),
  KEY `hierarchy_lvl3_idx` (`id_lvl3`),
  KEY `hierarchy_lvl4_idx` (`id_lvl4`),
  KEY `hierarchy_lvl5_idx` (`id_lvl5`),
  KEY `hierarchy_lvl6_idx` (`id_lvl6`),
  KEY `hierarchy_lvl7_idx` (`id_lvl7`),
  KEY `hierarchy_lvl8_idx` (`id_lvl8`),
  KEY `hierarchy_lvl9_idx` (`id_lvl9`),
  KEY `hierarchy_since_idx` (`valid_since`),
  KEY `hierarchy_until_idx` (`valid_until`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Beispieldatensätze

loc_id int_val int_type int_subtype valid_since date_type_since valid_until date_type_until
19544  15594  600700000  650700002  2001-12-31  300100000  2001-12-31  300100000 
14755  311303  600700000  650700002  2003-06-30  300100000  2003-06-30  300100000 
13929  52763  600700000  650700002  2003-06-30  300100000  2003-06-30  300100000 
16601  649933  600700000  650700002  2002-12-31  300100000  2002-12-31  300100000 
13352  245778  600700000  650700002      3000-01-01  300600000 
13353  66559  600700000  650700002      3000-01-01  300600000 
13558  40559  600700000  650700002      3000-01-01  300600000 
13649  44217  600700000  650700002      3000-01-01  300600000 
13735  77396  600700000  650700002      3000-01-01  300600000 
13756  68361  600700000  650700002      3000-01-01  300600000 
13795  19124  600700000  650700002      3000-01-01  300600000 
13810  257836  600700000  650700002      3000-01-01  300600000 
13902  53084  600700000  650700002      3000-01-01  300600000 
13943  43265  600700000  650700002      3000-01-01  300600000 
13961  30459  600700000  650700002      3000-01-01  300600000 
13965  49850  600700000  650700002      3000-01-01  300600000 
14072  69396  600700000  650700002      3000-01-01  300600000 
14163  42688  600700000  650700002      3000-01-01  300600000 
14170  74519  600700000  650700002      3000-01-01  300600000 
14356  3388434  600700000  650700002      3000-01-01  300600000 
14477  323373  600700000  650700002      3000-01-01  300600000 
14632  72701  600700000  650700002      3000-01-01  300600000 
14755  306016  600700000  650700002      3000-01-01  300600000 
14871  245516  600700000  650700002      3000-01-01  300600000 
14937  540950  600700000  650700002      3000-01-01  300600000 
14938  118701  600700000  650700002      3000-01-01  300600000 
15118  28771  600700000  650700002      3000-01-01  300600000 
15288  71949  600700000  650700002      3000-01-01  300600000 
15292  255798  600700000  650700002      3000-01-01  300600000 
15311  42798  600700000  650700002      3000-01-01  300600000 
15331  105954  600700000  650700002      3000-01-01  300600000 
15358  53168  600700000  650700002      3000-01-01  300600000 
15443  138457  600700000  650700002      3000-01-01  300600000 
15535  80965  600700000  650700002      3000-01-01  300600000 
15539  73771  600700000  650700002      3000-01-01  300600000 
15626  25017  600700000  650700002      3000-01-01  300600000 
15827  478631  600700000  650700002      3000-01-01  300600000 
15868  92292  600700000  650700002      3000-01-01  300600000 
15879  570765  600700000  650700002      3000-01-01  300600000 
16069  44242  600700000  650700002      3000-01-01  300600000 
16077  40180  600700000  650700002      3000-01-01  300600000 
16172  51185  600700000  650700002      3000-01-01  300600000 
16263  200126  600700000  650700002      3000-01-01  300600000 
16348  591889  600700000  650700002      3000-01-01  300600000 
16394  54047  600700000  650700002      3000-01-01  300600000 
16534  84480  600700000  650700002      3000-01-01  300600000 
16602  70308  600700000  650700002      3000-01-01  300600000 
16630  45228  600700000  650700002      3000-01-01  300600000 
16713  57538  600700000  650700002      3000-01-01  300600000 
16772  62819  600700000  650700002      3000-01-01  300600000