Geodb hierarchies
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Version vom 9. März 2007, 15:13 Uhr von HeinzJ (Diskussion | Beiträge)
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 |
Definition
CREATE</b> 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;