Table gym_trainer_development.workout_items Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('workout_items_id_seq'::regclass)
workout_id int4 10  √  null
workouts.id fk_rails_e0dde338fd C
sequence int4 10  √  null
target_reps int4 10  √  null
target_weight numeric 15,2  √  null
set_group_id int4 10  √  null
workout_set_groups.id workout_items_set_group_id_fk R
logged_reps int4 10  √  null
logged_weight numeric 15,2  √  null
success bool 1  √  null
logged bool 1  √  false
created_at timestamp 29,6
updated_at timestamp 29,6
logged_at timestamp 29,6  √  null
user_id int4 10  √  null
unit varchar 2147483647  √  null
is_warmup bool 1  √  false

Table contained 53 rows at Tue Feb 07 18:38 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc workout_items_pkey

Close relationships  within of separation: