Geodb intdata

Geodb intdata

Fields

PK	Name	Data type	Size	Precision	Values	Default	Auto Increment	Binary	Not null	Unsigned	Zero Fill	Unique
	loc_id	INTEGER	11	0
	level	INTEGER	11	0
	id_lvl1	INTEGER	11	0
	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
	date_type_until	INTEGER	11	0

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