Table arcasys.rosters 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 int 10  √ 
monday date 10
employee_id int 10  √  null
employees.id FK_rosters_employees C
start_0 time 8  √  null
end_0 time 8  √  null
break_0 int 10  √  null
hours_0 decimal 3,2  √  null
task_0 varchar 10  √  null
start_1 time 8  √  null
end_1 time 8  √  null
break_1 int 10  √  null
hours_1 decimal 3,2  √  null
task_1 varchar 10  √  null
start_2 time 8  √  null
end_2 time 8  √  null
break_2 int 10  √  null
hours_2 decimal 3,2  √  null
task_2 varchar 10  √  null
start_3 time 8  √  null
end_3 time 8  √  null
break_3 int 10  √  null
hours_3 decimal 3,2  √  null
task_3 varchar 10  √  null
start_4 time 8  √  null
end_4 time 8  √  null
break_4 int 10  √  null
hours_4 decimal 3,2  √  null
task_4 varchar 10  √  null
start_5 time 8  √  null
end_5 time 8  √  null
break_5 int 10  √  null
hours_5 decimal 3,2  √  null
task_5 varchar 10  √  null
start_6 time 8  √  null
end_6 time 8  √  null
break_6 int 10  √  null
hours_6 decimal 3,2  √  null
task_6 varchar 10  √  null

Table contained 0 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
employee_id Performance Asc employee_id_idx
monday + employee_id Must be unique Asc/Asc monday_empid_idx
monday Performance Asc rosters_monday_idx

Close relationships  within of separation: