-
Notifications
You must be signed in to change notification settings - Fork 1
Schema
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 | ||||
| img_url | string | user has an image | |||
| 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 |