Skip to content
langerkirill edited this page Jul 5, 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
friend_id integer association to friends
integer has many challenge registers
integer user has many comments
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
location lat decimal decimal representation of lattitude
location long decimal decimal representation of longitude
miles integer total miles traveled
friend_workout_id integer belongs_to workouts
workout_date date date representing workouts
integer has_many comments
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
friend_id integer integer of friend that links to user
friend_name string string representing the name of the friend
integer has many workouts
Workout Comments
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

Clone this wiki locally