SchemaSpy Analysis of gym_trainer_development - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Feb 07 18:38 CET 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

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