HikerTravelMap
Tables (7)
relax_zone
- id — char — Primary key — NOT NULL
- area — polygon — NOT NULL — relax_zone area (polygon)
- type — enum — NOT NULL — SITTING ZONE / Hot place
- cnt — int — NOT NULL — travel_data count
travel
- id — char — Primary key — NOT NULL — travel id
- start_time — datetime — NOT NULL — record start time
- end_time — datetime — record end time
- status — enum — NOT NULL — RECORDING / DONE
travel_cluster
- path — linestring — NOT NULL — whole gps path of segment
- convenience_level — enum — NOT NULL
travel_data
- timestamp — datetime — Primary key — NOT NULL — collected timestamp
- travel_id — char — Foreign key → travel.id — NOT NULL — travel id
- gps — point — NOT NULL — collected gps data (lng, lat)
- activity — char — NOT NULL — activity type
- is_valid — tinyint(1) — NOT NULL — default: true
travel_gps_path
- travel_id — char — Foreign key → travel.id — NOT NULL — travel_id
- raw_path — path — NOT NULL — path with gps
- filtered_path — path — NOT NULL — path with filtered
travel_relax_zone
- id — char — Primary key — NOT NULL
- travel_id — char — Foreign key → travel.id — NOT NULL — travel id
- area — polygon
- type — enum — NOT NULL — SITTING ZONE / Hot place
- cnt — int — NOT NULL — travel_data count
travel_segment
- segment_id — char — Primary key — NOT NULL — segment_id
- travel_id — char — Foreign key → travel.id — NOT NULL — travel id
- path — path — NOT NULL — whole gps path of segment
- convenience_level — enum — NOT NULL
- line_segment — lseg — NOT NULL — line segment