db_working_time
Describes the working time for a day. It supports 3 intervals for now.
Column | Type | References | Comments |
---|---|---|---|
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. |