| SchemaSpy Analysis of gym_trainer_development - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on Tue Feb 07 18:38 CET 2017 |
| ||||||
|
| |||||||
gym_trainer_development contains 123 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| admin_users | varchar | 2147483647 | ''::character varying | ||||
| admin_users | encrypted_password | varchar | 2147483647 | ''::character varying | |||
| admin_users | sign_in_count | int4 | 10 | 0 | |||
| users | sign_in_count | int4 | 10 | 0 | |||
| users | active_development_user | bool | 1 | √ | false | ||
| users | connected_mobile | bool | 1 | √ | false | ||
| workout_items | is_warmup | bool | 1 | √ | false | ||
| workout_set_groups | is_warmup | bool | 1 | √ | false | ||
| workout_items | logged | bool | 1 | √ | false | ||
| users | opened_from_mobile | bool | 1 | √ | false | ||
| active_admin_comments | id | serial | 10 | √ | nextval('active_admin_comments_id_seq'::regclass) | ||
| admin_users | id | serial | 10 | √ | nextval('admin_users_id_seq'::regclass) | ||
| five_by_five_setups | id | serial | 10 | √ | nextval('five_by_five_setups_id_seq'::regclass) | ||
| users | id | serial | 10 | √ | nextval('users_id_seq'::regclass) | ||
| workout_history_logs | id | serial | 10 | √ | nextval('workout_history_logs_id_seq'::regclass) | ||
| workout_items | id | serial | 10 | √ | nextval('workout_items_id_seq'::regclass) | ||
| workout_set_groups | id | serial | 10 | √ | nextval('workout_set_groups_id_seq'::regclass) | ||
| workout_set_repetition_templates | id | serial | 10 | √ | nextval('workout_set_repetition_templates_id_seq'::regclass) | ||
| workout_set_templates | id | serial | 10 | √ | nextval('workout_set_templates_id_seq'::regclass) | ||
| workout_templates | id | serial | 10 | √ | nextval('workout_templates_id_seq'::regclass) | ||
| workout_variant_templates | id | serial | 10 | √ | nextval('workout_variant_templates_id_seq'::regclass) | ||
| workouts | id | serial | 10 | √ | nextval('workouts_id_seq'::regclass) | ||
| active_admin_comments | author_id | int4 | 10 | √ | null | ||
| active_admin_comments | author_type | varchar | 2147483647 | √ | null | ||
| five_by_five_setups | barbelrow | numeric | 15,2 | √ | null | ||
| five_by_five_setups | benchpress | numeric | 15,2 | √ | null | ||
| active_admin_comments | body | text | 2147483647 | √ | null | ||
| active_admin_comments | created_at | timestamp | 29,6 | √ | null | ||
| admin_users | created_at | timestamp | 29,6 | ||||
| ar_internal_metadata | created_at | timestamp | 29,6 | ||||
| five_by_five_setups | created_at | timestamp | 29,6 | ||||
| users | created_at | timestamp | 29,6 | ||||
| workout_history_logs | created_at | timestamp | 29,6 | ||||
| workout_items | created_at | timestamp | 29,6 | ||||
| workout_set_groups | created_at | timestamp | 29,6 | ||||
| workout_set_repetition_templates | created_at | timestamp | 29,6 | ||||
| workout_set_templates | created_at | timestamp | 29,6 | ||||
| workout_templates | created_at | timestamp | 29,6 | ||||
| workout_variant_templates | created_at | timestamp | 29,6 | ||||
| workouts | created_at | timestamp | 29,6 | ||||
| admin_users | current_sign_in_at | timestamp | 29,6 | √ | null | ||
| users | current_sign_in_at | timestamp | 29,6 | √ | null | ||
| admin_users | current_sign_in_ip | inet | 2147483647 | √ | null | ||
| users | current_sign_in_ip | inet | 2147483647 | √ | null | ||
| five_by_five_setups | deadlift | numeric | 15,2 | √ | null | ||
| users | varchar | 2147483647 | √ | null | |||
| users | encrypted_password | varchar | 2147483647 | √ | null | ||
| users | encrypted_token | bpchar | 12 | √ | null | ||
| workouts | finished_at | timestamp | 29,6 | √ | null | ||
| five_by_five_setups | include_warmup | bool | 1 | √ | null | ||
| ar_internal_metadata | key | varchar | 2147483647 | ||||
| admin_users | last_sign_in_at | timestamp | 29,6 | √ | null | ||
| users | last_sign_in_at | timestamp | 29,6 | √ | null | ||
| admin_users | last_sign_in_ip | inet | 2147483647 | √ | null | ||
| users | last_sign_in_ip | inet | 2147483647 | √ | null | ||
| workout_items | logged_at | timestamp | 29,6 | √ | null | ||
| workout_items | logged_reps | int4 | 10 | √ | null | ||
| workout_items | logged_weight | numeric | 15,2 | √ | null | ||
| workout_set_templates | name | varchar | 2147483647 | √ | null | ||
| workout_templates | name | varchar | 2147483647 | √ | null | ||
| workout_variant_templates | name | varchar | 2147483647 | √ | null | ||
| active_admin_comments | namespace | varchar | 2147483647 | √ | null | ||
| five_by_five_setups | next_workout | varchar | 2147483647 | √ | null | ||
| five_by_five_setups | overheadpress | numeric | 15,2 | √ | null | ||
| users | password | varchar | 2147483647 | √ | null | ||
| admin_users | remember_created_at | timestamp | 29,6 | √ | null | ||
| users | remember_created_at | timestamp | 29,6 | √ | null | ||
| workout_set_repetition_templates | repetitions | int4 | 10 | √ | null | ||
| admin_users | reset_password_sent_at | timestamp | 29,6 | √ | null | ||
| users | reset_password_sent_at | timestamp | 29,6 | √ | null | ||
| admin_users | reset_password_token | varchar | 2147483647 | √ | null | ||
| users | reset_password_token | varchar | 2147483647 | √ | null | ||
| active_admin_comments | resource_id | varchar | 2147483647 | ||||
| active_admin_comments | resource_type | varchar | 2147483647 | ||||
| users | salt | varchar | 2147483647 | √ | null | ||
| users | seq_num | varchar | 2147483647 | √ | null | ||
| workout_items | sequence | int4 | 10 | √ | null | ||
| workout_set_groups | sequence | int4 | 10 | √ | null | ||
| workout_set_repetition_templates | sequence | int4 | 10 | √ | null | ||
| workout_set_templates | sequence | int4 | 10 | √ | null | ||
| workout_variant_templates | sequence | int4 | 10 | √ | null | ||
| workout_items | set_group_id | int4 | 10 | √ | null | ||
| workout_set_groups | set_group_name | varchar | 2147483647 | √ | null | ||
| five_by_five_setups | squat | numeric | 15,2 | √ | null | ||
| workout_history_logs | status | varchar | 2147483647 | √ | null | ||
| workout_set_groups | status | varchar | 2147483647 | √ | null | ||
| workouts | status | varchar | 2147483647 | √ | null | ||
| workout_items | success | bool | 1 | √ | null | ||
| workout_items | target_reps | int4 | 10 | √ | null | ||
| workout_items | target_weight | numeric | 15,2 | √ | null | ||
| workout_items | unit | varchar | 2147483647 | √ | null | ||
| users | units | varchar | 2147483647 | √ | null | ||
| active_admin_comments | updated_at | timestamp | 29,6 | √ | null | ||
| admin_users | updated_at | timestamp | 29,6 | ||||
| ar_internal_metadata | updated_at | timestamp | 29,6 | ||||
| five_by_five_setups | updated_at | timestamp | 29,6 | ||||
| users | updated_at | timestamp | 29,6 | ||||
| workout_history_logs | updated_at | timestamp | 29,6 | ||||
| workout_items | updated_at | timestamp | 29,6 | ||||
| workout_set_groups | updated_at | timestamp | 29,6 | ||||
| workout_set_repetition_templates | updated_at | timestamp | 29,6 | ||||
| workout_set_templates | updated_at | timestamp | 29,6 | ||||
| workout_templates | updated_at | timestamp | 29,6 | ||||
| workout_variant_templates | updated_at | timestamp | 29,6 | ||||
| workouts | updated_at | timestamp | 29,6 | ||||
| five_by_five_setups | user_id | int4 | 10 | √ | null | ||
| workout_history_logs | user_id | int4 | 10 | √ | null | ||
| workout_items | user_id | int4 | 10 | √ | null | ||
| workout_templates | user_id | int4 | 10 | √ | null | ||
| workouts | user_id | int4 | 10 | √ | null | ||
| ar_internal_metadata | value | varchar | 2147483647 | √ | null | ||
| schema_migrations | version | varchar | 2147483647 | ||||
| workout_set_repetition_templates | weight | numeric | 15,2 | √ | null | ||
| workout_history_logs | workout_id | int4 | 10 | √ | null | ||
| workout_items | workout_id | int4 | 10 | √ | null | ||
| workout_set_groups | workout_id | int4 | 10 | √ | null | ||
| workouts | workout_name | varchar | 2147483647 | √ | null | ||
| workout_history_logs | workout_set_group_id | int4 | 10 | √ | null | ||
| workout_history_logs | workout_set_group_name | varchar | 2147483647 | √ | null | ||
| workout_set_repetition_templates | workout_set_template_id | int4 | 10 | √ | null | ||
| workout_variant_templates | workout_template_id | int4 | 10 | √ | null | ||
| workouts | workout_total_weight | numeric | 131089 | √ | null | ||
| workout_set_templates | workout_variant_template_id | int4 | 10 | √ | null |