Geodb intdata: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) (→Options) |
HeinzJ (Diskussion | Beiträge) (→Definition) |
||
(2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
Zeile 419: | Zeile 419: | ||
==Definition== | ==Definition== | ||
− | < | + | <syntaxhighlight lang="mysql"> |
CREATE TABLE `geodb_hierarchies` ( | CREATE TABLE `geodb_hierarchies` ( | ||
`loc_id` int(11) NOT NULL, | `loc_id` int(11) NOT NULL, | ||
Zeile 451: | Zeile 451: | ||
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | ||
− | </ | + | </syntaxhighlight> |
==Beispieldatensätze== | ==Beispieldatensätze== | ||
Zeile 966: | Zeile 966: | ||
</tr> | </tr> | ||
</table> | </table> | ||
+ | |||
+ | [[Kategorie:Datenbank]] |
Aktuelle Version vom 3. Januar 2012, 04:47 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 |
Definition
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;
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 |