Geodb intdata: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
 
Zeile 21: Zeile 21:
 
<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>

Version vom 9. März 2007, 14:50 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;