activities

231 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, course_id, sport, sub_sport, self_eval_feel, self_eval_effort, avg_rr, max_temperature, min_temperature, avg_temperature, hrz_1_hr, hrz_2_hr, hrz_3_hr, hrz_4_hr, hrz_5_hr, start_time (date), stop_time (date)

Next page

CREATE TABLE activities (
	activity_id VARCHAR NOT NULL, 
	name VARCHAR, 
	description VARCHAR, 
	type VARCHAR, 
	course_id INTEGER, 
	laps INTEGER, 
	sport VARCHAR, 
	sub_sport VARCHAR, 
	device_serial_number INTEGER, 
	self_eval_feel VARCHAR, 
	self_eval_effort VARCHAR, 
	training_load FLOAT, 
	training_effect FLOAT, 
	anaerobic_training_effect FLOAT, 
	start_time DATETIME, 
	stop_time DATETIME, 
	elapsed_time TIME NOT NULL, 
	moving_time TIME NOT NULL, 
	distance FLOAT, 
	cycles FLOAT, 
	avg_hr INTEGER, 
	max_hr INTEGER, 
	avg_rr FLOAT, 
	max_rr FLOAT, 
	calories INTEGER, 
	avg_cadence INTEGER, 
	max_cadence INTEGER, 
	avg_speed FLOAT, 
	max_speed FLOAT, 
	ascent FLOAT, 
	descent FLOAT, 
	max_temperature FLOAT, 
	min_temperature FLOAT, 
	avg_temperature FLOAT, 
	start_lat FLOAT, 
	start_long FLOAT, 
	stop_lat FLOAT, 
	stop_long FLOAT, 
	hr_zones_method VARCHAR(18), 
	hrz_1_hr INTEGER, 
	hrz_2_hr INTEGER, 
	hrz_3_hr INTEGER, 
	hrz_4_hr INTEGER, 
	hrz_5_hr INTEGER, 
	hrz_1_time TIME NOT NULL, 
	hrz_2_time TIME NOT NULL, 
	hrz_3_time TIME NOT NULL, 
	hrz_4_time TIME NOT NULL, 
	hrz_5_time TIME NOT NULL, 
	PRIMARY KEY (activity_id)
);