Geodb coordinates
OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Version vom 9. März 2007, 11:25 Uhr von HeinzJ (Diskussion | Beiträge)
Inhaltsverzeichnis
Fields
Indices
Name | Fields | Unique | Collation | Full Text |
---|---|---|---|---|
coord_loc_id_idx | loc_id | Ascending | ||
coord_lon_idx | lon | Ascending | ||
coord_lat_idx | lat | Ascending | ||
coord_type_idx | coord_type | Ascending | ||
coord_stype_idx | coord_subtype | Ascending | ||
coord_since_idx | valid_since | Ascending | ||
coord_until_idx | valid_until | Ascending |
Foreign Keys
There are no foreign keys for table geodb_coordinates
Triggers
There are no triggers for table geodb_coordinates
Options
TransactSafe | TableType | Row Format | Check Sum | Delay Key Write | Pack Keys | Temporary | Min Rows | Max Rows | Union |
---|---|---|---|---|---|---|---|---|---|
InnoDB | Ascending | 0 | 0 |
Definition
CREATE</b> TABLE `geodb_coordinates` ( `loc_id` int(11) NOT NULL, `lon` double default NULL, `lat` double default NULL, `coord_type` int(11) NOT NULL, `coord_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 `coord_loc_id_idx` (`loc_id`), KEY `coord_lon_idx` (`lon`), KEY `coord_lat_idx` (`lat`), KEY `coord_type_idx` (`coord_type`), KEY `coord_stype_idx` (`coord_subtype`), KEY `coord_since_idx` (`valid_since`), KEY `coord_until_idx` (`valid_until`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;