Skip to content
langerkirill edited this page Jul 9, 2018 · 8 revisions
Users
Column Name Data Detail
user_id integer not null presence true unique true
username string not null presence true unique true
session_token string not null presence true
password_digest string not null presence true unique true
workout_id integer not null presence true unique true foreign key for workouts
integer has many challenge registers
integer user has many comments
img_url string user has an image
follow_id integer belongs_to user, also user has_many follows
Saving Workouts
Column Name Data Detail
workout_id integer not null presence true unique true foreign key for users
type string string representing biking or running or skiing
duration integer total time represented in minutes
miles integer total miles traveled
friend_workout_id integer belongs_to workouts
workout_date date date representing workouts
integer has_many comments
route_id integer belongs_to routes
Bonus Challenges
Column Name Data Detail
challenge_id integer integer not null unique true
title string string describing the challenge
body string string describing the challenge
register_id integer belongs_to user
Workout Stats/Totals
Column Name Data Detail
workout_stats_id integer integer not null unique true
Bonus: Friends
Column Name Data Detail
connection_id integer integer of friend that on a joins table
user_id integer belongs_to user
Workout Comments
Column Name Data Detail
comment_id integer integer not null unique true
title string description of workout
body string description of workout
user_comment integer belongs_to user
workout_id integer belongs_to workout
Routes
Column Name Data Detail
start location decimal decimal representation of start coordinates
end location decimal decimal representation of end coordinates
a route has many workouts

Clone this wiki locally