Geodb floatdata: Unterschied zwischen den Versionen

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Wechseln zu: Navigation, Suche
 
(Beispieldatensätze)
 
(12 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
 +
Die Tabelle '''geodb floatdata''' soll der Speicherung von Fließkomma-Werten dienen. Sie wird bisher nicht genutzt.
 +
 
==Fields==
 
==Fields==
 
<table {{prettytable}}>
 
<table {{prettytable}}>
<tr>
+
 
<th><b>PK</b></p></th>
+
<tr><th><b>PK</b></th>
<th><b>Name</b></p></th>
+
<th><b>Name</b></th>
<th><b>Data type</b></p></th>
+
<th><b>Data type</b></th>
<th><b>Size</b></p></th>
+
<th><b>Size</b></th>
<th><b>Precision</b></p></th>
+
<th><b>Precision</b></th>
<th><b>Values</b></p></th>
+
<th><b>Values</b></th>
<th><b>Default</b></p></th>
+
<th><b>Default</b></th>
<th><b>Auto Increment</b></p></th>
+
<th><b>Auto Increment</b></th>
<th><b>Binary</b></p></th>
+
<th><b>Binary</b></th>
<th><b>Not null</b></p></th>
+
<th><b>Not null</b></th>
<th><b>Unsigned</b></p></th>
+
<th><b>Unsigned</b></th>
<th><b>Zero Fill</b></p></th>
+
<th><b>Zero Fill</b></th>
<th><b>Unique</b></p></th>
+
<th><b>Unique</b></th>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>loc_id</p></td>
+
<td>loc_id</td>
<td><p>INTEGER</p></td>
+
<td>INTEGER</td>
<td><p>11</p></td>
+
<td>11</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
Zeile 35: Zeile 37:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>float_val</p></td>
+
<td>float_val</td>
<td><p>DOUBLE</p></td>
+
<td>DOUBLE</td>
<td><p>0</p></td>
+
<td>0</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
Zeile 51: Zeile 53:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>float_type</p></td>
+
<td>float_type</td>
<td><p>INTEGER</p></td>
+
<td>INTEGER</td>
<td><p>11</p></td>
+
<td>11</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
Zeile 67: Zeile 69:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>float_subtype</p></td>
+
<td>float_subtype</td>
<td><p>INTEGER</p></td>
+
<td>INTEGER</td>
<td><p>11</p></td>
+
<td>11</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
Zeile 83: Zeile 85:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>valid_since</p></td>
+
<td>valid_since</td>
<td><p>DATE</p></td>
+
<td>DATE</td>
<td><p>0</p></td>
+
<td>0</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
Zeile 99: Zeile 101:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>date_type_since</p></td>
+
<td>date_type_since</td>
<td><p>INTEGER</p></td>
+
<td>INTEGER</td>
<td><p>11</p></td>
+
<td>11</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
Zeile 115: Zeile 117:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>valid_until</p></td>
+
<td>valid_until</td>
<td><p>DATE</p></td>
+
<td>DATE</td>
<td><p>0</p></td>
+
<td>0</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
Zeile 131: Zeile 133:
 
<tr>
 
<tr>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>date_type_until</p></td>
+
<td>date_type_until</td>
<td><p>INTEGER</p></td>
+
<td>INTEGER</td>
<td><p>11</p></td>
+
<td>11</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
Zeile 149: Zeile 151:
  
 
==Indices==
 
==Indices==
<table>
+
<table {{prettytable}}>
  
 
<tr>
 
<tr>
<th><b>Name</b></p></th>
+
<th><b>Name</b></th>
<th><b>Fields</b></p></th>
+
<th><b>Fields</b></th>
<th><b>Unique</b></p></th>
+
<th><b>Unique</b></th>
<th><b>Collation</b></p></th>
+
<th><b>Collation</b></th>
<th><b>Full Text</b></p></th>
+
<th><b>Full Text</b></th>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_lid_idx</p></td>
+
<td>float_lid_idx</td>
<td><p>loc_id</p></td>
+
<td>loc_id</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_val_idx</p></td>
+
<td>float_val_idx</td>
<td><p>float_val</p></td>
+
<td>float_val</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_type_idx</p></td>
+
<td>float_type_idx</td>
<td><p>float_type</p></td>
+
<td>float_type</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_stype_idx</p></td>
+
<td>float_stype_idx</td>
<td><p>float_subtype</p></td>
+
<td>float_subtype</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_since_idx</p></td>
+
<td>float_since_idx</td>
<td><p>valid_since</p></td>
+
<td>valid_since</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td><p>float_until_idx</p></td>
+
<td>float_until_idx</td>
<td><p>valid_until</p></td>
+
<td>valid_until</td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
</tr>
 
</tr>
Zeile 212: Zeile 214:
 
There are no foreign keys for table geodb_floatdata
 
There are no foreign keys for table geodb_floatdata
  
==Triggers</p>==
+
==Triggers==
There are no triggers for table geodb_floatdata==
+
There are no triggers for table geodb_floatdata
  
 
==Options==
 
==Options==
Zeile 219: Zeile 221:
  
 
<tr>
 
<tr>
<th><b>TransactSafe</b></p></th>
+
<th><b>TransactSafe</b></th>
<th><b>TableType</b></p></th>
+
<th><b>TableType</b></th>
<th><b>Row Format</b></p></th>
+
<th><b>Row Format</b></th>
<th><b>Check Sum</b></p></th>
+
<th><b>Check Sum</b></th>
<th><b>Delay Key Write</b></p></th>
+
<th><b>Delay Key Write</b></th>
<th><b>Pack Keys</b></p></th>
+
<th><b>Pack Keys</b></th>
<th><b>Temporary</b></p></th>
+
<th><b>Temporary</b></th>
<th><b>Min Rows</b></p></th>
+
<th><b>Min Rows</b></th>
<th><b>Max Rows</b></p></th>
+
<th><b>Max Rows</b></th>
<th><b>Union</b></p></th>
+
<th><b>Union</b></th>
 
</tr>
 
</tr>
  
 
<tr>
 
<tr>
<td align="center"><p>[[Image:Yes.gif]]</p></td>
+
<td align="center">[[Image:Yes.gif]]</td>
<td><p>InnoDB</p></td>
+
<td>InnoDB</td>
<td><p>Ascending</p></td>
+
<td>Ascending</td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
 
<td align="center"></td>
<td><p>0</p></td>
+
<td>0</td>
<td><p>0</p></td>
+
<td>0</td>
 
<td></td>
 
<td></td>
 
</tr>
 
</tr>
Zeile 248: Zeile 250:
  
 
==Definition==
 
==Definition==
<code sql>
+
<source lang="mysql">
   CREATE</b> TABLE `geodb_floatdata` (
+
   CREATE TABLE `geodb_floatdata` (
   `loc_id` <b>int</b>(11) <b>NOT</b> NULL,
+
   `loc_id` int(11) NOT NULL,
   `float_val` <b>double</b> NOT NULL,
+
   `float_val` double NOT NULL,
   `float_type` <b>int</b>(11) <b>NOT</b> NULL,
+
   `float_type` int(11) NOT NULL,
   `float_subtype` <b>int</b>(11) <b>default</b> NULL,
+
   `float_subtype` int(11) default NULL,
   `valid_since` <b>date</b> default NULL,
+
   `valid_since` date default NULL,
   `date_type_since` <b>int</b>(11) <b>default</b> NULL,
+
   `date_type_since` int(11) default NULL,
   `valid_until` <b>date</b> NOT NULL,
+
   `valid_until` date NOT NULL,
   `date_type_until` <b>int</b>(11) <b>NOT</b> NULL,
+
   `date_type_until` int(11) NOT NULL,
   <b>KEY</b> `float_lid_idx` (`loc_id`),
+
   KEY `float_lid_idx` (`loc_id`),
   <b>KEY</b> `float_val_idx` (`float_val`),
+
   KEY `float_val_idx` (`float_val`),
   <b>KEY</b> `float_type_idx` (`float_type`),
+
   KEY `float_type_idx` (`float_type`),
   <b>KEY</b> `float_stype_idx` (`float_subtype`),
+
   KEY `float_stype_idx` (`float_subtype`),
   <b>KEY</b> `float_since_idx` (`valid_since`),
+
   KEY `float_since_idx` (`valid_since`),
   <b>KEY</b> `float_until_idx` (`valid_until`)
+
   KEY `float_until_idx` (`valid_until`)
) <b>ENGINE</b>=<b>InnoDB</b> DEFAULT CHARSET=utf8;
+
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
</code>
+
</source>
 +
 
 +
==Beispieldatensätze==
 +
 
 +
Die Datenbank enthält keine Datensätze.
 +
 
 +
[[Kategorie:Datenbank]]

Aktuelle Version vom 28. März 2008, 22:10 Uhr

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 Yes.gif
float_val DOUBLE 0 0 Yes.gif
float_type INTEGER 11 0 Yes.gif
float_subtype 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
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
Yes.gif 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.