SWE

Tables (6)

Favor Trail (fav_tr)

  • Favorite Trail (fav_id) — INT — Primary key — NOT NULL
  • Create At (fav_create) — DATETIME
  • User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
  • Trail ID (tr_id) — INT — Foreign key → Trail Information.Trail ID — NOT NULL

GPS Tracking (gps_log)

  • GPS ID (gps_ip) — INT — Primary key — NOT NULL
  • Latitude (latitude) — DOUBLE
  • Longitude (longitude) — DOUBLE
  • Record Time (record_time) — DATETIME
  • Log ID (log_id) — INT — Foreign key → Hiking History.Log ID — NOT NULL

Hiking History (hiking_log)

  • Log ID (log_id) — INT — Primary key — NOT NULL
  • Success (success) — ENUM('Success', 'Fail')
  • Start time (start_time) — DATETIME
  • End Time (end_time) — DATETIME
  • Duration TIme (real_duration) — INT
  • Review (hike_review) — TEXT
  • Create At (log_create) — DATETIME
  • User ID (user_id) — INT — Foreign key → User.User ID — NOT NULL
  • Trail ID (tr_id) — INT — Foreign key → Trail Information.Trail ID — NOT NULL

Mountain Information (mt_info)

  • Mountain ID (mt_id) — INT — Primary key — NOT NULL
  • Mountain Name (mt_name) — VARCHAR(10)
  • Mountain Location (mt_location) — VARCHAR(10)
  • Description (mt_desc) — TEXT
  • Update At (mt_update) — DATETIME

Trail Information (tr_info)

  • Trail ID (tr_id) — INT — Primary key — NOT NULL
  • Trail Name (tr_name) — VARCHAR(10)
  • Difficulty (tr_diff) — ENUM('Easy', 'Normal', 'Hard')
  • Distance (distance_km) — FLOAT
  • Start Latitude (st_lat) — DOUBLE
  • Start Longitude (st_lon) — DOUBLE
  • End Latitude (ed_lat) — DOUBLE
  • End Longitude (ed_lon) — DOUBLE
  • Duration Time (expect_duration) — INT
  • Description (tr_desc) — TEXT
  • Mountain ID (mt_id) — INT — Foreign key → Mountain Information.Mountain ID — NOT NULL

User (user)

  • User ID (user_id) — INT — Primary key — NOT NULL
  • User Name (user_name) — VARCHAR(10)
  • Email (email) — VARCHAR(20)
  • Password (pw) — VARCHAR(20)
  • Create At (user_create) — INT
  • User Level (user_level) — ENUM('Beginner, 'Intermediate', 'Advanced')