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