Workouts

schema.sql 14 lines

CREATE TABLE activities (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT NOT NULL,
  sport_type TEXT NOT NULL,
  start_date TEXT,
  start_date_local TEXT NOT NULL,
  timezone TEXT,
  distance REAL NOT NULL DEFAULT 0 CHECK (distance >= 0),
  elapsed_time INTEGER NOT NULL CHECK (elapsed_time >= 0),
  moving_time INTEGER CHECK (moving_time >= 0),
  total_elevation_gain REAL CHECK (total_elevation_gain >= 0),
  description TEXT,
  commute INTEGER NOT NULL DEFAULT 0 CHECK (commute IN (0, 1))
);