Extension:GeoData/geo_tags table

Translate this page

Languages:

FieldsEdit

gt_idEdit

Primary key.

gt_page_idEdit

gt_globeEdit

gt_primaryEdit

gt_lat_intEdit

gt_lon_intEdit

gt_latEdit

gt_lonEdit

gt_dimEdit

gt_typeEdit

gt_nameEdit

gt_countryEdit

gt_regionEdit

Schema summaryEdit

mysql> describe geo_tags;
+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| gt_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| gt_page_id | int(10) unsigned | NO   | MUL | NULL    |                |
| gt_globe   | varbinary(32)    | NO   |     | NULL    |                |
| gt_primary | tinyint(1)       | NO   |     | NULL    |                |
| gt_lat_int | smallint(6)      | NO   | MUL | NULL    |                |
| gt_lon_int | smallint(6)      | NO   |     | NULL    |                |
| gt_lat     | decimal(11,8)    | NO   |     | NULL    |                |
| gt_lon     | decimal(11,8)    | NO   |     | NULL    |                |
| gt_dim     | int(11)          | YES  |     | NULL    |                |
| gt_type    | varbinary(32)    | YES  |     | NULL    |                |
| gt_name    | varbinary(255)   | YES  |     | NULL    |                |
| gt_country | binary(2)        | YES  |     | NULL    |                |
| gt_region  | varbinary(3)     | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+