Geodb intdata: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) |
HeinzJ (Diskussion | Beiträge) (→Options) |
||
Zeile 416: | Zeile 416: | ||
</table> | </table> | ||
+ | |||
+ | ==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 </td> | ||
+ | <td>15594 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td>2001-12-31 </td> | ||
+ | <td>300100000 </td> | ||
+ | <td>2001-12-31 </td> | ||
+ | <td>300100000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14755 </td> | ||
+ | <td>311303 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td>2003-06-30 </td> | ||
+ | <td>300100000 </td> | ||
+ | <td>2003-06-30 </td> | ||
+ | <td>300100000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13929 </td> | ||
+ | <td>52763 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td>2003-06-30 </td> | ||
+ | <td>300100000 </td> | ||
+ | <td>2003-06-30 </td> | ||
+ | <td>300100000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16601 </td> | ||
+ | <td>649933 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td>2002-12-31 </td> | ||
+ | <td>300100000 </td> | ||
+ | <td>2002-12-31 </td> | ||
+ | <td>300100000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13352 </td> | ||
+ | <td>245778 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13353 </td> | ||
+ | <td>66559 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13558 </td> | ||
+ | <td>40559 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13649 </td> | ||
+ | <td>44217 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13735 </td> | ||
+ | <td>77396 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13756 </td> | ||
+ | <td>68361 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13795 </td> | ||
+ | <td>19124 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13810 </td> | ||
+ | <td>257836 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13902 </td> | ||
+ | <td>53084 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13943 </td> | ||
+ | <td>43265 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13961 </td> | ||
+ | <td>30459 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>13965 </td> | ||
+ | <td>49850 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14072 </td> | ||
+ | <td>69396 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14163 </td> | ||
+ | <td>42688 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14170 </td> | ||
+ | <td>74519 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14356 </td> | ||
+ | <td>3388434 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14477 </td> | ||
+ | <td>323373 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14632 </td> | ||
+ | <td>72701 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14755 </td> | ||
+ | <td>306016 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14871 </td> | ||
+ | <td>245516 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14937 </td> | ||
+ | <td>540950 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>14938 </td> | ||
+ | <td>118701 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15118 </td> | ||
+ | <td>28771 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15288 </td> | ||
+ | <td>71949 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15292 </td> | ||
+ | <td>255798 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15311 </td> | ||
+ | <td>42798 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15331 </td> | ||
+ | <td>105954 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15358 </td> | ||
+ | <td>53168 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15443 </td> | ||
+ | <td>138457 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15535 </td> | ||
+ | <td>80965 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15539 </td> | ||
+ | <td>73771 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15626 </td> | ||
+ | <td>25017 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15827 </td> | ||
+ | <td>478631 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15868 </td> | ||
+ | <td>92292 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>15879 </td> | ||
+ | <td>570765 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16069 </td> | ||
+ | <td>44242 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16077 </td> | ||
+ | <td>40180 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16172 </td> | ||
+ | <td>51185 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16263 </td> | ||
+ | <td>200126 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16348 </td> | ||
+ | <td>591889 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16394 </td> | ||
+ | <td>54047 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16534 </td> | ||
+ | <td>84480 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16602 </td> | ||
+ | <td>70308 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16630 </td> | ||
+ | <td>45228 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16713 </td> | ||
+ | <td>57538 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | <tr> | ||
+ | <td>16772 </td> | ||
+ | <td>62819 </td> | ||
+ | <td>600700000 </td> | ||
+ | <td>650700002 </td> | ||
+ | <td> </td> | ||
+ | <td> </td> | ||
+ | <td>3000-01-01 </td> | ||
+ | <td>300600000 </td> | ||
+ | </tr> | ||
+ | </table> | ||
+ | |||
<code sql> | <code sql> |
Version vom 9. März 2007, 16:03 Uhr
Inhaltsverzeichnis
Fields
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 |
---|---|---|---|---|---|---|---|---|---|
![]() |
InnoDB | Ascending | 0 | 0 |
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 |
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;