Geodb intdata: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) |
HeinzJ (Diskussion | Beiträge) |
||
Zeile 21: | Zeile 21: | ||
<tr> | <tr> | ||
<td align="center"><></td> | <td align="center"><></td> | ||
− | <td | + | <td>loc_id</td> |
<td><>INTEGER</td> | <td><>INTEGER</td> | ||
<td><>11</td> | <td><>11</td> |
Version vom 9. März 2007, 15:50 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 | <> |
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;