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')