Fields
PK |
Name |
Data type |
Size |
Precision |
Values |
Default |
Auto Increment |
Binary |
Not null |
Unsigned |
Zero Fill |
Unique |
Test
|
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</p> |
<th>Fields</p></th>
<th>Unique</p></th>
<th>Collation</p></th>
<th>Full Text</p></th>
<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</p>
There are no triggers for table geodb_floatdata==
Options
TransactSafe</p> |
<th>TableType</p></th>
<th>Row Format</p></th>
<th>Check Sum</p></th>
<th>Delay Key Write</p></th>
<th>Pack Keys</p></th>
<th>Temporary</p></th>
<th>Min Rows</p></th>
<th>Max Rows</p></th>
<th>Union</p></th>
<tr>
<td align="center">
</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
CREATE</b> 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;