-
Notifications
You must be signed in to change notification settings - Fork 3
Geodb_intdata
==Fields==
<table {{prettytable}}>
<tr> <th><b>PK</b></th> <th><b>Name</b></th> <th><b>Data type</b></th> <th><b>Size</b></th> <th><b>Precision</b></th> <th><b>Values</b></th> <th><b>Default</b></th> <th><b>Auto Increment</b></th> <th><b>Binary</b></th> <th><b>Not null</b></th> <th><b>Unsigned</b></th> <th><b>Zero Fill</b></th> <th><b>Unique</b></th> </tr>
<tr> <td align="center"></td> <td>loc_id</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>level</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl1</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl2</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl3</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl4</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl5</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl6</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl7</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl8</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>id_lvl9</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_since</td> <td>DATE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_since</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_until</td> <td>DATE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_until</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
</table>
==Indices==
<table {{prettytable}}>
<tr> <th><b>Name</b></th> <th><b>Fields</b></th> <th><b>Unique</b></th> <th><b>Collation</b></th> <th><b>Full Text</b></th> </tr>
<tr> <td>hierarchy_loc_id_idx</td> <td>loc_id</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_level_idx</td> <td>level</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl1_idx</td> <td>id_lvl1</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl2_idx</td> <td>id_lvl2</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl3_idx</td> <td>id_lvl3</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl4_idx</td> <td>id_lvl4</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl5_idx</td> <td>id_lvl5</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl6_idx</td> <td>id_lvl6</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl7_idx</td> <td>id_lvl7</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl8_idx</td> <td>id_lvl8</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_lvl9_idx</td> <td>id_lvl9</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_since_idx</td> <td>valid_since</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>hierarchy_until_idx</td> <td>valid_until</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
</table>
==Foreign Keys== There are no foreign keys for table geodb_hierarchies
==Triggers== There are no triggers for table geodb_hierarchies
==Options==
<table {{prettytable}}>
<tr> <th><b>TransactSafe</b></th> <th><b>TableType</b></th> <th><b>Row Format</b></th> <th><b>Check Sum</b></th> <th><b>Delay Key Write</b></th> <th><b>Pack Keys</b></th> <th><b>Temporary</b></th> <th><b>Min Rows</b></th> <th><b>Max Rows</b></th> <th><b>Union</b></th> </tr>
<tr> <td align="center">Image:Yes.gif</td> <td>InnoDB</td> <td>Ascending</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td>0</td> <td>0</td> <td></td> </tr>
</table>
==Definition==
<syntaxhighlight lang="mysql">
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;
</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 </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>