### 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 |