Database table

records id_record integer primary key autoincrement date date sport integer distance float [km] time varchar(200) [s], to be outdated beats float [bpm] average float [km/h] calories int [kcal] comments text gpslog varchar(200) title varchar(200) upositive float [m] total ascent unegative float [m] total descent maxspeed float [km/h] maxpace float [min/km] decimal pace float [min/km] decimal maxbeats float [bpm] date_time_utc varchar2(20) date_time_local varchar2(20) duration integer [s]	<tr> <td>name</td> <td><i>varchar(100)<i></td> <td></td> <td></td> </tr> <tr> <td>weight</td> <td><i>float<i></td> <td>[kg] extra weight</td> <td></td> </tr> <tr> <td>met</td> <td><i>float<i></td> <td></td> <td></td> </tr> <tr> <td>max_pace</td> <td><i>integer<i></td> <td>max. to be displayed </td> <td></td> </tr> sports id_sports integer primary key autoincrement laps id_lap integer primary key autoincrement elapsed_time varchar(20) record integer end_lon float start_lon float start_lat float lap_number integer end_lat float distance float [m] calories int [kcal] laptrigger varchar(9) manual/hr/time/distance/location intensity varchar(7) active/rest avg_hr int [bpm] max_hr int [bpm] max_speed float [m/s]	equipment id integer primary key autoincrement description varchar(200) active boolean life_expectancy int [km] prior_usage int [km] notes text record_equipment id integer primary key autoincrement record_id int equipment_id int
waypoints id_waypoint integer primary key autoincrement lat float lon float ele float [m] elevation comment varchar(240) time date name varchar(200) sym varchar(200)	athletestats id_athletestat integer primary key autoincrement weight float [kg] bodyfat float restinghr integer [bpm] date date maxhr integer [bpm]