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 |
---|---|---|---|---|---|---|---|
active_admin_comments | author_id | int4 | 10 | √ | null | ||
active_admin_comments | author_type | varchar | 2147483647 | √ | null | ||
active_admin_comments | body | text | 2147483647 | √ | null | ||
active_admin_comments | created_at | timestamp | 29,6 | √ | null | ||
active_admin_comments | id | serial | 10 | √ | nextval('active_admin_comments_id_seq'::regclass) | ||
active_admin_comments | namespace | varchar | 2147483647 | √ | null | ||
active_admin_comments | resource_id | varchar | 2147483647 | ||||
active_admin_comments | resource_type | varchar | 2147483647 | ||||
active_admin_comments | updated_at | timestamp | 29,6 | √ | null | ||
admin_users | created_at | timestamp | 29,6 | ||||
admin_users | current_sign_in_at | timestamp | 29,6 | √ | null | ||
admin_users | current_sign_in_ip | inet | 2147483647 | √ | null | ||
admin_users | varchar | 2147483647 | ''::character varying | ||||
admin_users | encrypted_password | varchar | 2147483647 | ''::character varying | |||
admin_users | id | serial | 10 | √ | nextval('admin_users_id_seq'::regclass) | ||
admin_users | last_sign_in_at | timestamp | 29,6 | √ | null | ||
admin_users | last_sign_in_ip | inet | 2147483647 | √ | null | ||
admin_users | remember_created_at | timestamp | 29,6 | √ | null | ||
admin_users | reset_password_sent_at | timestamp | 29,6 | √ | null | ||
admin_users | reset_password_token | varchar | 2147483647 | √ | null | ||
admin_users | sign_in_count | int4 | 10 | 0 | |||
admin_users | updated_at | timestamp | 29,6 | ||||
ar_internal_metadata | created_at | timestamp | 29,6 | ||||
ar_internal_metadata | key | varchar | 2147483647 | ||||
ar_internal_metadata | updated_at | timestamp | 29,6 | ||||
ar_internal_metadata | value | varchar | 2147483647 | √ | null | ||
five_by_five_setups | barbelrow | numeric | 15,2 | √ | null | ||
five_by_five_setups | benchpress | numeric | 15,2 | √ | null | ||
five_by_five_setups | created_at | timestamp | 29,6 | ||||
five_by_five_setups | deadlift | numeric | 15,2 | √ | null | ||
five_by_five_setups | id | serial | 10 | √ | nextval('five_by_five_setups_id_seq'::regclass) | ||
five_by_five_setups | include_warmup | bool | 1 | √ | null | ||
five_by_five_setups | next_workout | varchar | 2147483647 | √ | null | ||
five_by_five_setups | overheadpress | numeric | 15,2 | √ | null | ||
five_by_five_setups | squat | numeric | 15,2 | √ | null | ||
five_by_five_setups | updated_at | timestamp | 29,6 | ||||
five_by_five_setups | user_id | int4 | 10 | √ | null | ||
schema_migrations | version | varchar | 2147483647 | ||||
users | active_development_user | bool | 1 | √ | false | ||
users | connected_mobile | bool | 1 | √ | false | ||
users | created_at | timestamp | 29,6 | ||||
users | current_sign_in_at | timestamp | 29,6 | √ | null | ||
users | current_sign_in_ip | inet | 2147483647 | √ | null | ||
users | varchar | 2147483647 | √ | null | |||
users | encrypted_password | varchar | 2147483647 | √ | null | ||
users | encrypted_token | bpchar | 12 | √ | null | ||
users | id | serial | 10 | √ | nextval('users_id_seq'::regclass) | ||
users | last_sign_in_at | timestamp | 29,6 | √ | null | ||
users | last_sign_in_ip | inet | 2147483647 | √ | null | ||
users | opened_from_mobile | bool | 1 | √ | false | ||
users | password | varchar | 2147483647 | √ | null | ||
users | remember_created_at | timestamp | 29,6 | √ | null | ||
users | reset_password_sent_at | timestamp | 29,6 | √ | null | ||
users | reset_password_token | varchar | 2147483647 | √ | null | ||
users | salt | varchar | 2147483647 | √ | null | ||
users | seq_num | varchar | 2147483647 | √ | null | ||
users | sign_in_count | int4 | 10 | 0 | |||
users | units | varchar | 2147483647 | √ | null | ||
users | updated_at | timestamp | 29,6 | ||||
workout_history_logs | created_at | timestamp | 29,6 | ||||
workout_history_logs | id | serial | 10 | √ | nextval('workout_history_logs_id_seq'::regclass) | ||
workout_history_logs | status | varchar | 2147483647 | √ | null | ||
workout_history_logs | updated_at | timestamp | 29,6 | ||||
workout_history_logs | user_id | int4 | 10 | √ | null | ||
workout_history_logs | workout_id | int4 | 10 | √ | null | ||
workout_history_logs | workout_set_group_id | int4 | 10 | √ | null | ||
workout_history_logs | workout_set_group_name | varchar | 2147483647 | √ | null | ||
workout_items | created_at | timestamp | 29,6 | ||||
workout_items | id | serial | 10 | √ | nextval('workout_items_id_seq'::regclass) | ||
workout_items | is_warmup | bool | 1 | √ | false | ||
workout_items | logged | bool | 1 | √ | false | ||
workout_items | logged_at | timestamp | 29,6 | √ | null | ||
workout_items | logged_reps | int4 | 10 | √ | null | ||
workout_items | logged_weight | numeric | 15,2 | √ | null | ||
workout_items | sequence | int4 | 10 | √ | null | ||
workout_items | set_group_id | int4 | 10 | √ | 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 | ||
workout_items | updated_at | timestamp | 29,6 | ||||
workout_items | user_id | int4 | 10 | √ | null | ||
workout_items | workout_id | int4 | 10 | √ | null | ||
workout_set_groups | created_at | timestamp | 29,6 | ||||
workout_set_groups | id | serial | 10 | √ | nextval('workout_set_groups_id_seq'::regclass) | ||
workout_set_groups | is_warmup | bool | 1 | √ | false | ||
workout_set_groups | sequence | int4 | 10 | √ | null | ||
workout_set_groups | set_group_name | varchar | 2147483647 | √ | null | ||
workout_set_groups | status | varchar | 2147483647 | √ | null | ||
workout_set_groups | updated_at | timestamp | 29,6 | ||||
workout_set_groups | workout_id | int4 | 10 | √ | null | ||
workout_set_repetition_templates | created_at | timestamp | 29,6 | ||||
workout_set_repetition_templates | id | serial | 10 | √ | nextval('workout_set_repetition_templates_id_seq'::regclass) | ||
workout_set_repetition_templates | repetitions | int4 | 10 | √ | null | ||
workout_set_repetition_templates | sequence | int4 | 10 | √ | null | ||
workout_set_repetition_templates | updated_at | timestamp | 29,6 | ||||
workout_set_repetition_templates | weight | numeric | 15,2 | √ | null | ||
workout_set_repetition_templates | workout_set_template_id | int4 | 10 | √ | null | ||
workout_set_templates | created_at | timestamp | 29,6 | ||||
workout_set_templates | id | serial | 10 | √ | nextval('workout_set_templates_id_seq'::regclass) | ||
workout_set_templates | name | varchar | 2147483647 | √ | null | ||
workout_set_templates | sequence | int4 | 10 | √ | null | ||
workout_set_templates | updated_at | timestamp | 29,6 | ||||
workout_set_templates | workout_variant_template_id | int4 | 10 | √ | null | ||
workout_templates | created_at | timestamp | 29,6 | ||||
workout_templates | id | serial | 10 | √ | nextval('workout_templates_id_seq'::regclass) | ||
workout_templates | name | varchar | 2147483647 | √ | null | ||
workout_templates | updated_at | timestamp | 29,6 | ||||
workout_templates | user_id | int4 | 10 | √ | null | ||
workout_variant_templates | created_at | timestamp | 29,6 | ||||
workout_variant_templates | id | serial | 10 | √ | nextval('workout_variant_templates_id_seq'::regclass) | ||
workout_variant_templates | name | varchar | 2147483647 | √ | null | ||
workout_variant_templates | sequence | int4 | 10 | √ | null | ||
workout_variant_templates | updated_at | timestamp | 29,6 | ||||
workout_variant_templates | workout_template_id | int4 | 10 | √ | null | ||
workouts | created_at | timestamp | 29,6 | ||||
workouts | finished_at | timestamp | 29,6 | √ | null | ||
workouts | id | serial | 10 | √ | nextval('workouts_id_seq'::regclass) | ||
workouts | status | varchar | 2147483647 | √ | null | ||
workouts | updated_at | timestamp | 29,6 | ||||
workouts | user_id | int4 | 10 | √ | null | ||
workouts | workout_name | varchar | 2147483647 | √ | null | ||
workouts | workout_total_weight | numeric | 131089 | √ | null |