### province (省) | 字段 | 类型 | 长度 | 注释 | | --- | --- | --- | --- | | `id` | int | 11 | key | | `name` | varchar | 16 | 省名 | ### city (市) | 字段 | 类型 | 长度 | 注释 | | --- | --- | --- | --- | | `id` | int | 11 | key | | `name` | varchar | 16 | 市名 | | `province_id` | int | 11 | 省id | ### county (县) | 字段 | 类型 | 长度 | 注释 | | --- | --- | --- | --- | | `id` | int | 11 | key | | `name` | varchar | 16 | 县名 | | `city_id` | int | 11 | 市id | ### landmark (地标) | 字段 | 类型 | 长度 | 注释 | | --- | --- | --- | --- | | `id` | int | 11 | key | | `name` | varchar | 32 | 地标名 | | `longitude` | varchar | 32 | 所在经度 | | `latitude` | varchar | 32 | 所在纬度 | | `county_id` | int | 11 | 区id |