Geodb floatdata: Unterschied zwischen den Versionen
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
HeinzJ (Diskussion | Beiträge) |
HeinzJ (Diskussion | Beiträge) (→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 | + | <tr><th><b>PK</b></th> |
− | <th><b>Name</b | + | <th><b>Name</b></th> |
− | <th><b>Data type</b | + | <th><b>Data type</b></th> |
− | <th><b>Size</b | + | <th><b>Size</b></th> |
− | <th><b>Precision</b | + | <th><b>Precision</b></th> |
− | <th><b>Values</b | + | <th><b>Values</b></th> |
− | <th><b>Default</b | + | <th><b>Default</b></th> |
− | <th><b>Auto Increment</b | + | <th><b>Auto Increment</b></th> |
− | <th><b>Binary</b | + | <th><b>Binary</b></th> |
− | <th><b>Not null</b | + | <th><b>Not null</b></th> |
− | <th><b>Unsigned</b | + | <th><b>Unsigned</b></th> |
− | <th><b>Zero Fill</b | + | <th><b>Zero Fill</b></th> |
− | <th><b>Unique</b | + | <th><b>Unique</b></th> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>loc_id</td> |
− | <td | + | <td>INTEGER</td> |
− | <td | + | <td>11</td> |
− | <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" | + | <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 | + | <td>float_val</td> |
− | <td | + | <td>DOUBLE</td> |
− | <td | + | <td>0</td> |
− | <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" | + | <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 | + | <td>float_type</td> |
− | <td | + | <td>INTEGER</td> |
− | <td | + | <td>11</td> |
− | <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" | + | <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 | + | <td>float_subtype</td> |
− | <td | + | <td>INTEGER</td> |
− | <td | + | <td>11</td> |
− | <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 | + | <td>valid_since</td> |
− | <td | + | <td>DATE</td> |
− | <td | + | <td>0</td> |
− | <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 | + | <td>date_type_since</td> |
− | <td | + | <td>INTEGER</td> |
− | <td | + | <td>11</td> |
− | <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 | + | <td>valid_until</td> |
− | <td | + | <td>DATE</td> |
− | <td | + | <td>0</td> |
− | <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" | + | <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 | + | <td>date_type_until</td> |
− | <td | + | <td>INTEGER</td> |
− | <td | + | <td>11</td> |
− | <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" | + | <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 | + | <th><b>Name</b></th> |
− | <th><b>Fields</b | + | <th><b>Fields</b></th> |
− | <th><b>Unique</b | + | <th><b>Unique</b></th> |
− | <th><b>Collation</b | + | <th><b>Collation</b></th> |
− | <th><b>Full Text</b | + | <th><b>Full Text</b></th> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_lid_idx</td> |
− | <td | + | <td>loc_id</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>Ascending</td> |
<td align="center"></td> | <td align="center"></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_val_idx</td> |
− | <td | + | <td>float_val</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>Ascending</td> |
<td align="center"></td> | <td align="center"></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_type_idx</td> |
− | <td | + | <td>float_type</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>Ascending</td> |
<td align="center"></td> | <td align="center"></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_stype_idx</td> |
− | <td | + | <td>float_subtype</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>Ascending</td> |
<td align="center"></td> | <td align="center"></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_since_idx</td> |
− | <td | + | <td>valid_since</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <td | + | <td>Ascending</td> |
<td align="center"></td> | <td align="center"></td> | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td | + | <td>float_until_idx</td> |
− | <td | + | <td>valid_until</td> |
<td align="center"></td> | <td align="center"></td> | ||
− | <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 | + | ==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 | + | <th><b>TransactSafe</b></th> |
− | <th><b>TableType</b | + | <th><b>TableType</b></th> |
− | <th><b>Row Format</b | + | <th><b>Row Format</b></th> |
− | <th><b>Check Sum</b | + | <th><b>Check Sum</b></th> |
− | <th><b>Delay Key Write</b | + | <th><b>Delay Key Write</b></th> |
− | <th><b>Pack Keys</b | + | <th><b>Pack Keys</b></th> |
− | <th><b>Temporary</b | + | <th><b>Temporary</b></th> |
− | <th><b>Min Rows</b | + | <th><b>Min Rows</b></th> |
− | <th><b>Max Rows</b | + | <th><b>Max Rows</b></th> |
− | <th><b>Union</b | + | <th><b>Union</b></th> |
</tr> | </tr> | ||
<tr> | <tr> | ||
− | <td align="center" | + | <td align="center">[[Image:Yes.gif]]</td> |
− | <td | + | <td>InnoDB</td> |
− | <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 | + | <td>0</td> |
− | <td | + | <td>0</td> |
<td></td> | <td></td> | ||
</tr> | </tr> | ||
Zeile 248: | Zeile 250: | ||
==Definition== | ==Definition== | ||
− | < | + | <source lang="mysql"> |
− | CREATE | + | CREATE TABLE `geodb_floatdata` ( |
− | `loc_id` | + | `loc_id` int(11) NOT NULL, |
− | `float_val` | + | `float_val` double NOT NULL, |
− | `float_type` | + | `float_type` int(11) NOT NULL, |
− | `float_subtype` | + | `float_subtype` int(11) default NULL, |
− | `valid_since` | + | `valid_since` date default NULL, |
− | `date_type_since` | + | `date_type_since` int(11) default NULL, |
− | `valid_until` | + | `valid_until` date NOT NULL, |
− | `date_type_until` | + | `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; |
− | </ | + | </source> |
+ | |||
+ | ==Beispieldatensätze== | ||
+ | |||
+ | Die Datenbank enthält keine Datensätze. | ||
+ | |||
+ | [[Kategorie:Datenbank]] |
Aktuelle Version vom 28. März 2008, 23:10 Uhr
Die Tabelle geodb floatdata soll der Speicherung von Fließkomma-Werten dienen. Sie wird bisher nicht genutzt.
Inhaltsverzeichnis
Fields
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.