geodb_floatdata - ratopi/opengeodb GitHub Wiki
Die Tabelle '''geodb floatdata''' soll der Speicherung von Fließkomma-Werten dienen. Sie wird bisher nicht genutzt.
==Fields== <table {{prettytable}}>
<tr><th><b>PK</b></th> <th><b>Name</b></th> <th><b>Data type</b></th> <th><b>Size</b></th> <th><b>Precision</b></th> <th><b>Values</b></th> <th><b>Default</b></th> <th><b>Auto Increment</b></th> <th><b>Binary</b></th> <th><b>Not null</b></th> <th><b>Unsigned</b></th> <th><b>Zero Fill</b></th> <th><b>Unique</b></th> </tr>
<tr> <td align="center"></td> <td>loc_id</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>float_val</td> <td>DOUBLE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>float_type</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>float_subtype</td> <td>INTEGER</td> <td>11</td> <td>0</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> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_since</td> <td>DATE</td> <td>0</td> <td>0</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> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_since</td> <td>INTEGER</td> <td>11</td> <td>0</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> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>valid_until</td> <td>DATE</td> <td>0</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
<tr> <td align="center"></td> <td>date_type_until</td> <td>INTEGER</td> <td>11</td> <td>0</td> <td></td> <td></td> <td align="center"></td> <td align="center"></td> <td align="center">Image:Yes.gif</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> </tr>
</table>
==Indices== <table {{prettytable}}>
<tr> <th><b>Name</b></th> <th><b>Fields</b></th> <th><b>Unique</b></th> <th><b>Collation</b></th> <th><b>Full Text</b></th> </tr>
<tr> <td>float_lid_idx</td> <td>loc_id</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>float_val_idx</td> <td>float_val</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>float_type_idx</td> <td>float_type</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>float_stype_idx</td> <td>float_subtype</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>float_since_idx</td> <td>valid_since</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
<tr> <td>float_until_idx</td> <td>valid_until</td> <td align="center"></td> <td>Ascending</td> <td align="center"></td> </tr>
</table>
==Foreign Keys== There are no foreign keys for table geodb_floatdata
==Triggers== There are no triggers for table geodb_floatdata
==Options== <table {{prettytable}}>
<tr> <th><b>TransactSafe</b></th> <th><b>TableType</b></th> <th><b>Row Format</b></th> <th><b>Check Sum</b></th> <th><b>Delay Key Write</b></th> <th><b>Pack Keys</b></th> <th><b>Temporary</b></th> <th><b>Min Rows</b></th> <th><b>Max Rows</b></th> <th><b>Union</b></th> </tr>
<tr> <td align="center">Image:Yes.gif</td> <td>InnoDB</td> <td>Ascending</td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td align="center"></td> <td>0</td> <td>0</td> <td></td> </tr>
</table>
==Definition==
<source lang="mysql">
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;
</source>
==Beispieldatensätze==
Die Datenbank enthält keine Datensätze.