Schema

|---|---|---|----------------------|---------|-------------------------------------------------------------| | | | | 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 |