db_working_time

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

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
calendar_idIntegerdb_working_calendar.idID of the working calendar this record belongs to
s1_fromInteger Start time in minutes of the 1st interval.
s1_toInteger Finish time in minutes of the 1st interval.
s2_fromInteger Start time in minutes of the 2nd interval.
s2_toInteger Finish time in minutes of the 2nd interval.
s3_fromInteger Start time in minutes of the 3rd interval.
s3_toInteger Finish time in minutes of the 3rd interval.
dowInteger Day of week this working time refers to. 1 for Sunday, 2 for Monday, etc.