schema - nrice95/Strive GitHub Wiki

Database Schema

users

column name data type details
id integer not null, primary key
username string not null, indexed
email string not null, indexed, unique
password_digest string not null
session_token string not null, indexed, unique
created_at datetime not null
updated_at datetime not null
  • index on username, unique: true
  • index on session_token, unique: true

routes

column name data type details
id integer not null, primary key
user_id integer not null, foreign key
route_map_data ??? not null,
created_at datetime not null
updated_at datetime not null

workouts

column name data type details
id integer not null, primary key
user_id integer not null, foreign key
route_id integer not null, foreign key
created_at datetime not null
updated_at datetime not null

wourkout stats

column name data type details
id integer not null, primary key
workout_id integer not null, foreign key
description string not null
created_at datetime not null
updated_at datetime not null