Geodb floatdata

Die Tabelle geodb floatdata soll der Speicherung von Fließkomma-Werten dienen. Sie wird bisher nicht genutzt.

Fields

PK	Name	Data type	Size	Precision	Values	Default	Auto Increment	Binary	Not null	Unsigned	Zero Fill	Unique
	loc_id	INTEGER	11	0
	float_val	DOUBLE	0	0
	float_type	INTEGER	11	0
	float_subtype	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
float_lid_idx	loc_id		Ascending
float_val_idx	float_val		Ascending
float_type_idx	float_type		Ascending
float_stype_idx	float_subtype		Ascending
float_since_idx	valid_since		Ascending
float_until_idx	valid_until		Ascending

Foreign Keys

There are no foreign keys for table geodb_floatdata

Triggers

There are no triggers for table geodb_floatdata

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_floatdata` (
  `loc_id` int(11) NOT NULL,
  `float_val` double NOT NULL,
  `float_type` int(11) NOT NULL,
  `float_subtype` 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 `float_lid_idx` (`loc_id`),
  KEY `float_val_idx` (`float_val`),
  KEY `float_type_idx` (`float_type`),
  KEY `float_stype_idx` (`float_subtype`),
  KEY `float_since_idx` (`valid_since`),
  KEY `float_until_idx` (`valid_until`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Beispieldatensätze

Die Datenbank enthält keine Datensätze.