Geodb coordinates

OpenGeoDB & GISWiki - Das freie Portal für Geoinformatik (GIS)
Version vom 9. März 2007, 10:25 Uhr von HeinzJ (Diskussion | Beiträge)

(Unterschied) ← Nächstältere Version | Aktuelle Version ansehen (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

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
lon DOUBLE 0 0
lat DOUBLE 0 0
coord_type INTEGER 11 0 Yes.gif
coord_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
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
Yes.gif 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;