3.67. db_working_time

Describes the working time for a day. It supports 3 intervals for now.

Table 3.67. db_working_time
ColumnTypeReferencesComments
id Integer Primary key
vdb_id Integer
calendar_id Integer db_working_calendar.id ID of the working calendar this record belongs to
s1_from Integer Start time in minutes of the 1st interval.
s1_to Integer Finish time in minutes of the 1st interval.
s2_from Integer Start time in minutes of the 2nd interval.
s2_to Integer Finish time in minutes of the 2nd interval.
s3_from Integer Start time in minutes of the 3rd interval.
s3_to Integer Finish time in minutes of the 3rd interval.
dow Integer Day of week this working time refers to. 1 for Sunday, 2 for Monday, etc.