Extension:GeoData/geo_tags table


Fields

edit

gt_id

edit

Primary key.

gt_page_id

edit

gt_globe

edit

gt_primary

edit

gt_lat_int

edit

gt_lon_int

edit

gt_lat

edit

gt_lon

edit

gt_dim

edit

gt_type

edit

gt_name

edit

gt_country

edit

gt_region

edit

Schema summary

edit
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    |                |
+------------+------------------+------+-----+---------+----------------+