Geodb intdata: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
Zeile 1: Zeile 1:
 
==Fields==
 
==Fields==
  
−
<table>
+
<table {{prettytable}}>
  
 
<tr>
 
<tr>
Zeile 20: Zeile 20:
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
 
<td>loc_id</td>
 
<td>loc_id</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
−
<td><></td>
+
<td></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>level</td>
+
<td>level</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
−
<td><></td>
+
<td></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl1</td>
+
<td>id_lvl1</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
−
<td><></td>
+
<td></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl2</td>
+
<td>id_lvl2</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl3</td>
+
<td>id_lvl3</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl4</td>
+
<td>id_lvl4</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl5</td>
+
<td>id_lvl5</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl6</td>
+
<td>id_lvl6</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl7</td>
+
<td>id_lvl7</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl8</td>
+
<td>id_lvl8</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>id_lvl9</td>
+
<td>id_lvl9</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>valid_since</td>
+
<td>valid_since</td>
−
<td><>DATE</td>
+
<td>DATE</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>date_type_since</td>
+
<td>date_type_since</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></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>
−
<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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>valid_until</td>
+
<td>valid_until</td>
−
<td><>DATE</td>
+
<td>DATE</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
−
<td><></td>
+
<td></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</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>
  
 
<tr>
 
<tr>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>date_type_until</td>
+
<td>date_type_until</td>
−
<td><>INTEGER</td>
+
<td>INTEGER</td>
−
<td><>11</td>
+
<td>11</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
−
<td><></td>
+
<td></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</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>
  
Zeile 263: Zeile 263:
 
==Indices==
 
==Indices==
  
−
<table>
+
<table {{prettytable}}>
  
 
<tr>
 
<tr>
Zeile 274: Zeile 274:
  
 
<tr>
 
<tr>
−
<td><>hierarchy_loc_id_idx</td>
+
<td>hierarchy_loc_id_idx</td>
−
<td><>loc_id</td>
+
<td>loc_id</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_level_idx</td>
+
<td>hierarchy_level_idx</td>
−
<td><>level</td>
+
<td>level</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl1_idx</td>
+
<td>hierarchy_lvl1_idx</td>
−
<td><>id_lvl1</td>
+
<td>id_lvl1</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl2_idx</td>
+
<td>hierarchy_lvl2_idx</td>
−
<td><>id_lvl2</td>
+
<td>id_lvl2</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl3_idx</td>
+
<td>hierarchy_lvl3_idx</td>
−
<td><>id_lvl3</td>
+
<td>id_lvl3</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl4_idx</td>
+
<td>hierarchy_lvl4_idx</td>
−
<td><>id_lvl4</td>
+
<td>id_lvl4</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl5_idx</td>
+
<td>hierarchy_lvl5_idx</td>
−
<td><>id_lvl5</td>
+
<td>id_lvl5</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl6_idx</td>
+
<td>hierarchy_lvl6_idx</td>
−
<td><>id_lvl6</td>
+
<td>id_lvl6</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl7_idx</td>
+
<td>hierarchy_lvl7_idx</td>
−
<td><>id_lvl7</td>
+
<td>id_lvl7</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl8_idx</td>
+
<td>hierarchy_lvl8_idx</td>
−
<td><>id_lvl8</td>
+
<td>id_lvl8</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_lvl9_idx</td>
+
<td>hierarchy_lvl9_idx</td>
−
<td><>id_lvl9</td>
+
<td>id_lvl9</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_since_idx</td>
+
<td>hierarchy_since_idx</td>
−
<td><>valid_since</td>
+
<td>valid_since</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
−
<td><>hierarchy_until_idx</td>
+
<td>hierarchy_until_idx</td>
−
<td><>valid_until</td>
+
<td>valid_until</td>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>Ascending</td>
+
<td>Ascending</td>
−
<td align="center"><></td>
+
<td align="center"></td>
 
</tr>
 
</tr>
  
Zeile 387: Zeile 387:
 
==Options==
 
==Options==
  
−
<table>
+
<table {{prettytable}}>
  
 
<tr>
 
<tr>
Zeile 403: Zeile 403:
  
 
<tr>
 
<tr>
−
<td align="center"><>[[Image:Yes.gif]]</td>
+
<td align="center">[[Image:Yes.gif]]</td>
−
<td><>InnoDB</td>
+
<td>InnoDB</td>
−
<td><>Ascending</td>
+
<td>Ascending</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>
−
<td align="center"><></td>
+
<td align="center"></td>
−
<td><>0</td>
+
<td>0</td>
−
<td><>0</td>
+
<td>0</td>
−
<td><></td>
+
<td></td>
 
</tr>
 
</tr>
  

Version vom 9. März 2007, 15:56 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 

 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;

Von „http://opengeodb.giswiki.org/index.php?title=Geodb_intdata&oldid=13350“